Created attachment 142832 [details] 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
Confirm. LO Version: 4.1.0.0.alpha1+ and 6.2
source code pointer https://opengrok.libreoffice.org/xref/core/basic/source/inc/rtlproto.hxx?r=b1f6e629 true, FormatNumber is not implemented example: how the Standard Function Date is implemented https://opengrok.libreoffice.org/xref/core/basic/source/runtime/methods.cxx?r=44391aec#2307 https://opengrok.libreoffice.org/xref/core/basic/source/runtime/runtime.cxx?r=657668c3#889 https://opengrok.libreoffice.org/xref/core/basic/source/classes/sb.cxx?r=3ceb01af#1460 https://opengrok.libreoffice.org/xref/core/basic/source/classes/sb.cxx?r=3ceb01af#295 https://opengrok.libreoffice.org/xref/core/include/basic/sberrors.hxx?r=4e70d0b6#32 Error Number 35 for Option VBASupport 1 is "Sub or Function not defined"
https://gerrit.libreoffice.org/56610
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0f7a7c8e719dab6b79e24285b907b5be17f39fc8 tdf#118218: Implement FormatNumber VBA function It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7283125c563a2759f278c1caa6a7b71ade4f0101 tdf#118218: Make FormatNumber VBA-only It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.