[libreoffice-users] Help with Formulas

Dear LibreOffice team,

Thank you so much for developing this amazing tool.
I am using Python to dynamically write formulas in my LibreOffice file.
However, I am noticing when LibreOffice opens the file, it adds an extra
")" at the end of the formula which results in a bad formula:

Here is my print log from the script:
[image: image.png]

and here are the actual formulas:
[image: image.png]

=SUM($'2024'.C17))
=SUM($'2024'.C34))

and so on..

Why is that? Is there a way to overcome it?

No matter what I do via code, it doesn't work. If I open the file in Google
Sheets for example, the formula shows correctly.

Any suggestions?

Thanks a lot

Elad

-- 

*Elad Magdasi*he/him

Ghostmize@gmail.com |
*+49-17643309939*

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy