In this case, I would reformat the column in Calc. Right click
the letter at the top of the column. Select Format cells. Under the
Numbers tab, change the number of decimal places to three. This
should solve the problem.
As far as where to report this problem, I will let someone else
describe that.
Dan
On Friday March 30 2007 6:29 am, Graham Wickens wrote:
> Ok,
>
> Its a spreadsheet imported from a website.
>
> Column values as displayed in excel on the left and the same column
> values as displayed in OO Calc on the right:
>
> row 2 42.001 42
> row 3 42.002 42
> row 4 42.003 42
> row 5 42.004 42
> row 8 42.005 42.01
> row 9 42.006 42.01
> row10 42.007 42.01
> row90 42.067 42.07
>
> Dan Lewis said the following on 30/03/2007 12:11:
> > On Friday March 30 2007 5:44 am, Graham Wickens wrote:
> >> Hi All,
> >>
> >> I have had a small problem with an excel file opened with OO
> >> Calc, in that it does not display some fields properly in OO
> >> Calc but does when opened with excel.
> >>
> >> where should I report this error to?
> >
> > Would you be more specific as to what you expected vs. what
> > you got? For example, some functions are slightly different in
> > Excel and Calc. Excel uses commas for separators while Calc uses
> > a semi-colon. If the display involves a macro, the macro will
> > have to be rewritten for it to work in Calc. (VBA and StarBasic
> > are similar but there are differences also.)
> >
> > Dan
> >
> > -----------------------------------------------------------------
> >---- To unsubscribe, e-mail: [EMAIL PROTECTED] For
> > additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> > ______________________________________________
> > This email has been scanned by Netintelligence
> > http://www.netintelligence.com/email
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
