Brian Barker has written on 11/11/2008 6:03 PM:
At 14:46 11/11/2008 -0500, Ponly J Honly wrote:
OOo 3.0.0/Win XP Pro SP2
In the spreadsheet, I have most columns set for Arial/9 with cells
formatted #,##0.00;[RED]-#,##0.00. I have set the format for a
number of rows beyond my last data entry, but when I enter new data,
the format reverts to some default. How do I get the settings to "stick"?
There are a few things to say here:
o If you wish, you don't need to set the format explicitly for "a
number of rows beyond" your current entries. Instead, if
appropriate, you can select the column(s) and then set the format for
the entire column(s) - as many rows as Calc will allow you to create.
Essentially what I did.
o If you type new values into your cells, I don't think what you say
should occur. Clearly there are some values which will not display
according to your chosen format - text values, for instance - but the
format should be preserved and applied if the values are later edited
to values which can be displayed as you wish.
Duh. of course I'm entering numbers into cells that are formatted
#,##0.00;[RED]-#,##0.00! You must think I'm stupid!!
o (This is my guess as to what is happening.) If you instead paste
values into cells, note that the default is for the format of the
source to be carried over into the destination cell. So any values
you paste into your extra rows will keep the format they had wherever
they came from, not that which you have set for the new rows. If you
don't want this to happen, the solution is simple: instead of using
simple Paste, use Edit | Paste Special... (or right-click | Paste
Special... or Ctrl+Shift+V).
Ta-dah!!
In the Paste Special dialogue, remove
the tick from "Paste all" if necessary, and then ensure that Numbers
is ticked but Formats is *not* ticked.
??? My choices are "HTML format" and "unformatted text" (I'm copying
from a web page). The latter works.
Thanks.
--
Pete Holsberg
Columbus, NJ
I thought I saw an eye doctor on an Alaskan island, but it turned out to
be an optical Aleutian.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
