[SOLVED]: (Python openpyxl does not support R1C1 syntax) Calc turns formula into lowercase, formula doesn't work

[librenewbie]

I use Python to populate .xlsx cells with a formula ‘=RC[-3]+RC[-2]’

(Formula syntax: Excel R1C1)

When I open the populated file, the formula in cells is in lowercase ‘=rc[-3]+rc[-2]’ and doesn’t work (Err:509 instead of the sum).

Nothing in AutoCorrect options helps.

Why is it happening and how to fix it?

Thanks.

[mikekaganski]

Well - you are talking about some generated file with unknown syntax errors and/or LibreOffice incompatibilities, and ask for advise - doesn’t that occur that a sample file would be good?

Also providing the Python script would be even better.

[librenewbie]

Thanks Mike, as it turned out, the problem was that openpyxl module in Python does not support R1C1 syntax.