Apache OpenOffice Community Forum

Thx to all for help with solving this. Very much appreciated !!! Tom

I'm using this version...

Apache Open Office 4.1.6
AOO416m1(Build:9790) - Rev. 1844436
2018-10-23 12:57

I'm getting an ERR:509 when I try to use the following EXCEL formula in my AOO Calc spreadsheet. Could someone assist me to convert it ? Thx, Tom

=CHOOSE(MOD(COLUMNS($a:a)-1,4)+1,"1st","2nd","3rd","4th")&" Qtr "&2018+ROUNDUP(COLUMNS($a:a)/4,0)

My First tip: use semicolon ; instead of the comma , - as a parameter separator character.

The modified formula seems to work for me in my LO 6.1.5 version. I just added a semicolon between the parameters 1"1st" -> 1;"1st"

OpenOffice does not recognize referring to entire columns by just the letter. Try

You have 2 options:
1) If the formula used to work with Excel then open the xls file you have with OpenOffice. OpenOffice will do the right thing with your formulas and you can see how they differ syntactically from MS Excel.
2) Install https://libreoffice.org/ which is the legitimate successor of OpenOffice. Its Calc component is almost fully compatible with MS Excel.