Talk:Documentation/OOoAuthors User Manual/Migration Guide 2006/General Differences

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