converting xlxs to ods

[jsridhar]

On account of certain policy decisions our office has moved from excel to ods. I tried to open an excel file in open office but the formulas are not working. How do I resolve this please? Sample file attached.

[Pepe Le Mokko]

As you do not say precisely what does not work, I can only guess that you did not commit the array formulas in the Opendocument spreadsheet with Ctrl+Shift+Enter ?

[jsridhar]

I did enter with Ctrl+Shift+Alt but it reports Error508

[Pepe Le Mokko]

508 Error: Pair missing For example, closing parenthesis without opening parenthesis

or missing closing parenthesis in the middle of the formula (missing
closing parenthesis at the end of a formula is added automatically).

[jsridhar]

I could not find any parentheses missing. Could you kindly see my file and tell me where I have gone wrong. The same formula works well in excel.

[Pepe Le Mokko]

The excel file looks OK to me. Perhaps post on an openoffice or Libreoffice forum?

[jsridhar]

Thank you.