OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Border of each cell is a very thin red line

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
m b rossi
General User
General User


Joined: 25 Mar 2012
Posts: 8

PostPosted: Tue May 08, 2012 12:54 pm    Post subject: Border of each cell is a very thin red line Reply with quote

Hi there

what did I do wrong?
In one sheet I entered numerous data and I was able to add and calculate percentages. Each used cell has a border colored RED and I do not find the way to go back to the usual appearance of cells.. What can I do? Mab
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Tue May 08, 2012 1:04 pm    Post subject: Reply with quote

Can't reproduce that - you are talking about Calc, right? If so, this is in the wrong forum. I'll move it after you posted again. Please give more information - you can also sign up at the new forum and ask your question there and attach a sample file.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
m b rossi
General User
General User


Joined: 25 Mar 2012
Posts: 8

PostPosted: Tue May 08, 2012 1:57 pm    Post subject: Reply with quote

Thank you so much for your kind help.
Wish I new how to attach a sample file.


( I wanted to prepare a column chart to study the behavior of hemoglobin and platelets in a patient. I succeeded:: beautiful charts. But I am too old to study OpenOffice. In my local library I found only 1 book "OpenOffice.org" by Greg Perry, 2004. It will be a challenge but I will start to study it.....)
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Tue May 08, 2012 2:02 pm    Post subject: Reply with quote

Sent you an e-mail.
Moved the thread (and deleted the new one that you started).
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Tue May 08, 2012 2:41 pm    Post subject: Reply with quote

Red borders around used cells sounds like Record Changes has been accidentally turned on.
Go Edit|Changes|Record then click the Yes button on the dialogue with the question...
Exit change recording mode?

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
m b rossi
General User
General User


Joined: 25 Mar 2012
Posts: 8

PostPosted: Wed May 09, 2012 4:53 am    Post subject: Reply with quote

SOLVED! Thank you all.
Back to top
View user's profile Send private message
m b rossi
General User
General User


Joined: 25 Mar 2012
Posts: 8

PostPosted: Wed May 09, 2012 5:02 am    Post subject: Reply with quote

Another problem that I cannot solve (yet) from studying the Perry book.

OK. On calculating the percentage of gain from bonds I get unmanageable #.

i.e.: 1.9011572220

So, 1.90 is plenty sufficient to confirm that we are crossing a time of miserable economies. but the remaining numbers are useless. How can i get read of the them in the percentage cells?
Thanks again. Mab
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Wed May 09, 2012 6:50 am    Post subject: Reply with quote

The column (cell) is not wide enough, simply make it wider.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Wed May 09, 2012 7:24 am    Post subject: Reply with quote

m b rossi wrote:
Another problem that I cannot solve (yet) from studying the Perry book.

OK. On calculating the percentage of gain from bonds I get unmanageable #.

i.e.: 1.9011572220

So, 1.90 is plenty sufficient to confirm that we are crossing a time of miserable economies. but the remaining numbers are useless. How can i get read of the them in the percentage cells?
Thanks again. Mab


Create a new style and apply to the percentage cells.

F11 to call up the Stylist
Right click on default and select new
Go to Numbers and select the number of decimals you want desplayed.

Select the Percentage cells and apply (click on) the new style you have created.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
m b rossi
General User
General User


Joined: 25 Mar 2012
Posts: 8

PostPosted: Wed May 09, 2012 8:11 am    Post subject: Reply with quote

Thank you.

I will try your method.
In the meantime I went cell by cell and adjusedt into the preferred appearance
(format cells/numbers/1234.12/3 decimals)
(the difficulty I encounter: the Perry book is 2004, mostly outdated; the online manual is tooooo complex for a beginner. I'll persist, within limits and with help from kind people.Thank you again)
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Fri May 25, 2012 1:00 pm    Post subject: Reply with quote

I reply to your question by mail about the dates underneath tabular data I suggest that you select the dates, right click and then select Format cells - Alignment and type 90 in the Orientation box to rotate the text by 90 degrees.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
m b rossi
General User
General User


Joined: 25 Mar 2012
Posts: 8

PostPosted: Fri May 25, 2012 1:32 pm    Post subject: Reply with quote

Thank you very much for your information. I have up to now a partial success.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group