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! My calculated result was the larger.
Returning to the top of the sheet, I checked line by line. They LOOKED the same.
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.
I've worked with spreadsheets since day one, over 25 years, and I've never
encountered anything like this before, except when a cell was formatted as
text, rather than a number. Has anyone ever encountered this situation? If so,
I'd really like some help with this. Yes, I did check that all of the numbers
were formatted as numbers, not text.
Suzanne L. Perry
