2009/7/14 Dotan Cohen <[email protected]> > > 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! > > There are options in the Paste Special menu that add/subtract/multiply/divide the copied value to/from/by/by the target cell before overwriting that cell. So, if you Copy 100 and Paste Special with Subtract turned on into a cell containing 1234567 you'll end up with 1234467. Paste Special seems to remember the last such option used. Hmmm ????
The words clutching and straws bring to mind ... -- Harold Fuchs London, England Please reply *only* to [email protected]
