https://bugs.documentfoundation.org/show_bug.cgi?id=160247
Bug ID: 160247
Summary: CONVERT becomes CONVERT_OOO when cell formula is set
via macro.
Product: LibreOffice
Version: 7.3.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 193167
--> https://bugs.documentfoundation.org/attachment.cgi?id=193167&action=edit
Contains macro that demonstrates bug.
I attempted to set the cell formaul to CONVERT and it becomes CONVERT_OOO and
fails.
I have included an attachment with a simple macro:
The SUM formula works fine. The CONVERT fails.
I have tested this in basic and in python. From version 7.3 to Version 24.2.
All fail the same. My testing machine is running Ubuntu 22.04.
Sub Main
doc = ThisComponent
sheet = doc.Sheets(0)
sheet.getCellByPosition(0,0).setValue(1)
sheet.getCellByPosition(1,0).setValue(2)
sheet.getCellByPosition(2,0).setFormula("=SUM(A1:B1)")
sheet.getCellByPosition(3,0).setFormula("=CONVERT(A1, ""yd"", ""m""")
End Sub
Screenshot Link:
https://github.com/Amourspirit/python-ooouno-ex/assets/4193389/cdec402a-1386-47c8-838c-6ac50a76a87e
--
You are receiving this mail because:
You are the assignee for the bug.
