[Libreoffice-bugs] [Bug 123764] New: Attempting to run scripts before document initialized. FILEOPEN

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123764

            Bug ID: 123764
           Summary: Attempting to run scripts before document initialized.
                    FILEOPEN
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: john.wayne.cornell at gmail.com

Description:
I receive the error "BASIC runtime error. Property or method not found: Sheets"
My sheet uses macros saved in "My Macros & Dialogs" and Libre is running the
macros before "ThisComponent.Sheets" has any value. I work around this by
repeatedly pressing OK until the spreadsheet is displayed, then I simply select
reload from the menu and everything works fine.

Steps to Reproduce:
1.Create Macro in "My Macros & Dialogs" which references ThisComponent.Sheets
2.call macro from cell in spreadsheet
3.Save. Close Calc. Load sheet from FileManager.

Actual Results:
Error reproduced

Expected Results:
Error reproduced


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.1.4.2
Build ID: 1:6.1.4-0ubuntu0.18.10.1
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group threaded

-- 
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/20190228/902c4a46/attachment.html>