> Have you still got the sheet with the number correct in one cell and rounded > in another? If so you could have a look in the content.xml [sub-]file to see > how they are being stored. To do this, open the .ods file with something > like WinZip or gzip or 7-Zip and look at the content.xml file it contains > with a text editor like Notepad or Wordpad. It *may* give some clue as to > what is going on. >
It looks like the data is actually stored rounded, not just displayed rounded: <table:table-row table:style-name="ro1"><table:table-cell table:number-columns-repeated="2"/><table:table-cell office:value-type="float" office:value="317908000"><text:p>317908000</text:p></table:table-cell><table:table-cell table:number-columns-repeated="253"/></table:table-row> <table:table-row table:style-name="ro1"><table:table-cell table:number-columns-repeated="2"/><table:table-cell office:value-type="float" office:value="317907988"><text:p>317907988</text:p></table:table-cell><table:table-cell table:number-columns-repeated="253"/></table:table-row> > Hmmmm. Enter 317907988 in cell A1 of a new sheet. Select the cell. A little > plus sign will appear at the bottom right corner of the cell. Drag this down > to A14 and look at the value in A13. It should be 317908000, which is > exactly the example you gave above. Is this what is happening? Perhaps > someone thinks they are *copying* or *moving* the values from one cell to > another by doing this????? > That is not what happened here, I know because I wrote that spreadsheet! -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org