Difference between revisions of "Talk:Documentation/OOoAuthors User Manual/Migration Guide 2006/General Differences"
(Excel vs Calc formula syntax differences) |
m (Yorick moved page Talk:Documentation/OOoAuthors User Manual/Migration Guide/General Differences to Talk:Documentation/OOoAuthors User Manual/Migration Guide 2006/General Differences) |
(No difference)
|
Latest revision as of 01:50, 13 November 2013
There are some important differences between the syntax of formulae in Excel and Calc. I'm using Excel 2003 and Calc from OOo 2.4
I haven't found reference to these elsewhere despite a lot of searching.
1) When referring to a named range in Excel, I can use =MAX(0,+rangename) to force column-matching. In Calc, column matching does not occur unless I change the formula to =MAX(0;0+rangename). Calc does not warn of this difference in behaviour, and it does have a material impact on the value returned.
2) The INDEX function as I use it in Excel is of the form =INDEX(rangename,position), and because all my ranges are single-row, multi-column, this works. Opening the same file in Calc, I get an error code. To fix it, I need to write =INDEX(rangename;1;position). At least this time I get an error code.
Hope this helps someone.
Jason