LibreOffice Version: 5.4.6.2 (x64)
Windows 10 Pro - 1709 - build 16299.371
-
macro definition
Function inscol()
Dim oSheet: oSheet = thisComponent.CurrentController.getActiveSheet()
oSheet.Columns.insertByIndex(1, 1)
End Function -
new file created with values ‘B’,‘C’,‘D’ populated in cells B1 thru D1
-
in cell A1 “=inscol()”
-
throws error on calculation:
BASIC runtime error.
An exception occurred
Type: com.sun.star.uno.RuntimeException
Message: . -
file “test.ods” attachedtest.ods
Please advise as to cause of error:
Thank you in advance.
(minor editing for clarity - Ratslinger)