I don't know how big your numbers are but ...
The spreadsheet in question sees rounding in two places. In one sheet,
this number 317907988 was rounded to 317908000 in one row, but in
a later row was not rounded. In another sheet, the number 330476211
was rounded to 330476000. All these fields
2009/7/14 Dotan Cohen dotanco...@gmail.com
I don't know how big your numbers are but ...
The spreadsheet in question sees rounding in two places. In one sheet,
this number 317907988 was rounded to 317908000 in one row, but in
a later row was not rounded. In another sheet, the number
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
2009/7/14 Dotan Cohen dotanco...@gmail.com
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
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
2009/7/14 Dotan Cohen dotanco...@gmail.com
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
1234567898765 1234567898765
12345678987654 12345678987654
123456789876543123456789876543
*1234567898765432 1234567898765430 *
I´ve just tried Excel (version 2002, aka MS Office XP, on a WIN XP
machine, SP3)
I got just the same result, see the blue-marked numbers.
I
On Jul 14, 2009, at 12:45 PM, Per wrote:
Is it a sort of handling the numbers in Works, Calc and Excel that
causes the round-up effect???
I think these results are more correctly called truncation and
result from the inherently limited numerical precision of digital
computers. It's not
I think these results are more correctly called truncation and result from
the inherently limited numerical precision of digital computers. It's not
surprising that Excel and Calc exhibit the same problem if they use the same
precision (i.e., single, double, whatever) for storing numbers in
My goal is not to recover the data, Harold, as I already have it. My goal is to
figure out why the numbers are rounded.
Dohan..
Is the numbers being rounded up at once when the users put them in the
spreadsheet ???
Is there any strange formats in the row to the left of the numbercolumn???
On 14/07/09 17:45, Per wrote:
1234567898765 1234567898765
12345678987654 12345678987654
123456789876543123456789876543
*1234567898765432 1234567898765430 *
I´ve just tried Excel (version 2002, aka MS Office XP, on a WIN XP
machine, SP3)
I got just the same result, see
On 14/07/09 18:32, Dave Post wrote:
On Jul 14, 2009, at 12:45 PM, Per wrote:
Is it a sort of handling the numbers in Works, Calc and Excel that
causes the round-up effect???
I think these results are more correctly called truncation and
result from the inherently limited numerical precision
Harold Fuchs wrote:
On 14/07/09 17:45, Per wrote:
1234567898765 1234567898765
12345678987654 12345678987654
123456789876543123456789876543
*1234567898765432 1234567898765430 *
I´ve just tried Excel (version 2002, aka MS Office XP, on a WIN XP
machine, SP3)
I got just
Is the numbers being rounded up at once when the users put them in the
spreadsheet ???
No, this is data that was entered somr time ago, and just now
discovered to be rounded.
Is there any strange formats in the row to the left of the numbercolumn???
If so, could this cause the round up..
I have found another case of Calc rounding numbers in spreadsheets,
this time on my own machine. That means that in two different Calc
spreadsheets, on two different operating systems, I have seen Calc
round numbers in spreadsheets. Has anyone else seen this happen?
--
Dotan Cohen
On Mon, 13 Jul 2009 19:23:45 +0300
Came this utterance formulated by Dotan Cohen to my mailbox:
I have found another case of Calc rounding numbers in spreadsheets,
this time on my own machine. That means that in two different Calc
spreadsheets, on two different operating systems, I have seen
On 13/07/09 17:23, Dotan Cohen wrote:
I have found another case of Calc rounding numbers in spreadsheets,
this time on my own machine. That means that in two different Calc
spreadsheets, on two different operating systems, I have seen Calc
round numbers in spreadsheets. Has anyone else seen this
17 matches
Mail list logo