does anyone know how to control openoffice calc? oo seems to insist on having the number of decimal places set. Say I want to enter the numbers
oo defaults to two decimal places, and it formats the cells to be
If I set it to three decimal places, I get
But, I want it to only print exactly what I write! Anyone know how to do this? As a second question, does anyone know how to change the default cell formatting? So that I don't have to play with it every time I start a new spreadsheet?
Alternatively, is there a better spreadsheet program out there? One that lets you do what you want, instead of forcing you to do what it thinks you want?