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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
