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.
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.
Rick B.
Hi Rick,
When you save your CSV file, check the box labeled 'Edit filter settings'. After
you've entered a file name and clicked 'ok', you'll get a dialogue that allows
you to set the character set, field and text delimiters. Uncheck the box labeled
'Save cell content as shown'.
tc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
