[Bug 160247] New: CONVERT becomes CONVERT_OOO when cell formula is set via macro.

[bugzilla-daemon]

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: libreoffice-bugs@lists.freedesktop.org
          Reporter: vibrationofl...@pm.me

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.