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

asked 2019-03-05 02:56:22 +0200

librenewbie gravatar image

updated 2019-03-06 04:55:53 +0200

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?


edit retag flag offensive close merge delete


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.

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-05 06:38:01 +0200 )edit

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

librenewbie gravatar imagelibrenewbie ( 2019-03-06 04:55:13 +0200 )edit