[Libreoffice-bugs] [Bug 118218] New: VBA FormatNumber function is unsupported

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180618/6e5862ce/attachment-0001.html>