Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 06 Mar 2019 04:55:13 +0100[SOLVED]: (Python openpyxl does not support R1C1 syntax) Calc turns formula into lowercase, formula doesn't workhttps://ask.libreoffice.org/en/question/185483/solved-python-openpyxl-does-not-support-r1c1-syntax-calc-turns-formula-into-lowercase-formula-doesnt-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.Tue, 05 Mar 2019 02:56:22 +0100https://ask.libreoffice.org/en/question/185483/solved-python-openpyxl-does-not-support-r1c1-syntax-calc-turns-formula-into-lowercase-formula-doesnt-work/Comment by Mike Kaganski for <p>I use Python to populate .xlsx cells with a formula '=RC[-3]+RC[-2]'</p>
<p>(Formula syntax: Excel R1C1)</p>
<p>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).</p>
<p>Nothing in AutoCorrect options helps.</p>
<p>Why is it happening and how to fix it?</p>
<p>Thanks.</p>
https://ask.libreoffice.org/en/question/185483/solved-python-openpyxl-does-not-support-r1c1-syntax-calc-turns-formula-into-lowercase-formula-doesnt-work/?comment=185499#post-id-185499Well - 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.Tue, 05 Mar 2019 06:38:01 +0100https://ask.libreoffice.org/en/question/185483/solved-python-openpyxl-does-not-support-r1c1-syntax-calc-turns-formula-into-lowercase-formula-doesnt-work/?comment=185499#post-id-185499Comment by librenewbie for <p>I use Python to populate .xlsx cells with a formula '=RC[-3]+RC[-2]'</p>
<p>(Formula syntax: Excel R1C1)</p>
<p>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).</p>
<p>Nothing in AutoCorrect options helps.</p>
<p>Why is it happening and how to fix it?</p>
<p>Thanks.</p>
https://ask.libreoffice.org/en/question/185483/solved-python-openpyxl-does-not-support-r1c1-syntax-calc-turns-formula-into-lowercase-formula-doesnt-work/?comment=185638#post-id-185638Thanks Mike, as it turned out, the problem was that openpyxl module in Python does not support R1C1 syntax.Wed, 06 Mar 2019 04:55:13 +0100https://ask.libreoffice.org/en/question/185483/solved-python-openpyxl-does-not-support-r1c1-syntax-calc-turns-formula-into-lowercase-formula-doesnt-work/?comment=185638#post-id-185638