Hi Graham,
To avoid having to format every sheet to display the data as you'd like,
go to 'tools / options / openoffice.org Calc / calculate' and set the
number of decimals to 3. It appears that OOo has a default decimal
display of 2, while in Excel (at least excel97) it's 6.
tc
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]