On Tue, 2008-05-06 at 11:16 -0400, James Knott wrote: > 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. > > >
Anthony Chilco pointed me to the problem. On the csv text filter panel, "Save cell content as shown" must not be checked. (Somehow it got checked either by upgrading or changing to the Red Hat version from the official OOo version.) By not having this checked, data is always saved at the full precision which is the only option one would want for importing the data to a statistics package as a csv file. Rick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
