[Libreoffice-bugs] [Bug 142711] New: VBA functions used in sheet formular lose parameters

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142711

            Bug ID: 142711
           Summary: VBA functions used in sheet formular lose parameters
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: neil.cadman at live.fr

I have a function used in worksheet cell formulars.
In excel the formular is 
   =BankAccountBalance(H10,E9,C9,G9,$H$2)
When opening the same sheet using LibreOffice the formular is
   =BankAccountBalance(E9,C9,G9,$H$2)

This means that the first parameter is lost and the function does not work
correctly.  It does not complain about a lissing parameter.
The file format is .xlsb as the file is shared between users using Excel and
LibreOffice (main editing is done in excel with viewing done in LibreOffice).

Sheet was produced sometime ago but last edited version is Excel 2019.
LibreOffice version is Version: 6.0.0.3 (x64)

This was forced by a Mac OS update killing access to an old Microsoft office
trying to force people to buy office 365 for reading a sheet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210608/3cbc165a/attachment-0001.htm>