https://bugs.documentfoundation.org/show_bug.cgi?id=118218
Bug ID: 118218
Summary: VBA FormatNumber function is unsupported
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108908
Created attachment 142832
--> https://bugs.documentfoundation.org/attachment.cgi?id=142832&action=edit
Sample XLSM
Open the attached XLSM file. It contains a single macro call to FormatNumber
VBA function [1] inside a user function, also referenced from A1.
Recalculate the spreadsheet.
=> There's an error during macro execution. I assume FormatNumber isn't
supported.
BASIC runtime error.
'35'
FormatNumber
Observed using LO 6.1 beta1 & 4.4.0.3 / Windows 7.
[1]
https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/formatnumber-function
http://www.excelfunctions.net/vba-formatnumber-function.html
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108908
[Bug 108908] [META] Visual Basic for Applications (VBA) macro issues
--
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
