At 18:20 19/03/2009 -0700, Suzanne L. Perry wrote:
Excel file import into OO Calc.
To perform some checks of extended figures on
the imported file, I created a new column and
inserted a formula to achieve the same result.
Since the spreadsheet is over 4500 lines long, I
wanted to compare the results quickly.
Picture this, if you will:
Cells M1 through Q1 are added together, then the
result is multiplied by a factor in R1 and placed in S1.
Cell N1 is the result of the imported version.
Visual spot inspection makes the numbers in both
columns look the same. To verify this, I
inserted SUM below each column N and S, assuring
myself that this is probably a waste of time,
but because of its importance, I did it anyway.
The sums were different by over $101,000!
Your values may display identically if they are
equal to the precision represented by your chosen
cell formatting. But if there are hidden
differences, these may show up in calculated values.
I then inserted a new column and subtracted the
second result from the first, expecting â0,â
row by row. Instead, the result was the value
that appeared in both cells... most of the time.
Then I used the formula:
if(N1<>S1,ââ,âDIFâ). Visual inspection
estimates the cells containing âDIFâ at
about 30%. However, the numbers in each column look the same in all cases.
There is a setting at Tools | Options... |
OpenOffice.org Calc | Calculate | Precision as
shown. If this is ticked, the displayed values -
rounded according to the cell formatting - are
used in your comparison rather than the actual
values stored in the cells. Again, this setting
and your choice of cell formatting may alter the results.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
