Please enable the same function- call- syntax like in MS Office "modulname.functionname", so is no need to edit each formula when the user change the tool. for example (listet structure in libre office calc): LibreOffice Basic, VBA Makro "Test.xls" -> VBA Project -> Module -> ownfunction 'modulname ownfn 'functionname Option VBASupport 1 Function ownfn(x As String, y As String) ... End Function formula in the sheet: cell A1 (or any) excel: "=ownfunction.ownfn(parameter1;parameter2)" libre: "=ownfn(parameter1;parameter2)" The call like in excel with modulname.function ends in error.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 150227 [details] Small Demo xls-File with 2x VB-script to show different calls Hallo! While i create a small VB- script- demo- file, i found the cause and a workaround for the problem. I should better use different names for all script-parts and use the short call. And LibreOffice should be able for extended call with file- and modulename [file].[module].procedure - sometimes is it used. (take a look at xls-sheet) Kind regards J.S. PS. Sorry, may be double - I answer direct with e-mail before.
Reproduced in Version: 6.4.0.0.alpha0+ Build ID: a294457eb95e60028539b6783abac78b56561fe2 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded