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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
