Rick Bilonick wrote:
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote:
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any
options to force this.
You can set up to 20 decimal places for a number. Is that sufficient?
Also, if you're not doing calculations with that number, you could use
the text format.
The number 71.08929399 is what is actually in the .xls spreadsheet but
only 2 decimal places display in the cell. When I save the spreadsheet
to a .csv file, only 71.09 is saved. I want to always and automatically
save the full precision to the .csv file (otherwise I'm inadvertently
changing the contents). You say I can save up to 20 decimal places but
you give ABSOLUTELY NO INFORMATION on how to do it.
When you format a cell or column, you choose "number". On that panel is
a spin box, where you can select the desired number of decimal places.
When you save to CSV, it will included the specified number of decimal
places.
Using text format makes no sense. The data comes in a spreadsheet with 2
decimal places formatted for display. I want to keep ALL the real
precision when saving to .csv. I don't want to round or truncate when
saving to .csv. I can change the format for viewing but that is a real
pain plus it makes viewing the spreadsheet difficult. There must be some
way to force Calc to save all numbers with complete precision. I've
looked through all the options and tried changing some but nothing I've
done so far does the trick.
Text formatting often makes sense, depending on what you're doing with
the data. If you want to have a free form number, that would be what
you'd use. Without knowing your requirements, I have no way to know if
it would be suitable or not. I was simply offering it as a possibility.
As an experiment, try saving both as a number, with a fixed number of
decimal places and also as text. You'll find the fixed number of
decimal places will result in some trailing zeros, if you don't use all
the places. On the other hand, text will save the string exactly as you
entered it, but with the addition of quotes. Which is better for you,
depends on what you do with the data.
--
Use OpenOffice.org <http://www.openoffice.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
