On Tue, 2008-05-06 at 17:04 +0100, Lisi Reisz wrote: > On Tuesday 06 May 2008 15:56:40 Rick Bilonick wrote: > > 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. > > To change to more decimal places globally: > > Open a Calc page, then: > Tools -> Options -> OpenOffice.org Calc -> Calculate -> Decimal places -> > choose your number (between 0 and 20) > > HTH > Lisi
It was already set to 12. It thus has no effect and doesn't solve this problem. I tried increasing earlier but it has NO effect whatsoever. Output is still rounded to 2 decimal places in the .csv file. Rick B. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
