Re: [users] Excel File Import into Calc

2009-03-19 Thread JOE Conner
Brian Barker wrote: At 18:20 19/03/2009 -0700, Suzanne L. Perry wrote: 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

Re: [users] Excel File Import into Calc

2009-03-19 Thread Brian Barker
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

[users] Excel File Import into Calc

2009-03-19 Thread S Perry
  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: Ce