Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc turns formula into lowercase, formula doesn't work

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.

Calc turns formula into lowercase, formula doesn't work

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.