https://bugs.documentfoundation.org/show_bug.cgi?id=145476
Bug ID: 145476
Summary: FILEOPEN LibreCalc is running an embedded macro while
loading the file
Product: LibreOffice
Version: 7.3.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreCalc is running an embedded macro while loading the file which leads to a
very long loading time because the macro itself takes around 3 minutes (on Core
I7-4770) to finish. This is not what Excel does. Excel loads the xlsm file and
then it is our choice to run the macro. Excel does not automatically run an
embedded macro upon file open. Once the file is loaded in LibreCalc, I have to
run the macro again to get the desired result (total calculation time for
countifs on 10,000 rows).
Steps to Reproduce:
1.Open attached xlsm file in LibreCalc
2.Calc will take minutes just to load the file.
3.
Actual Results:
Calc freezes as it is running the embedded macro upon opening xlsm file.
Expected Results:
File should take less than 30 seconds to load. The file I have without macro
(https://bugs.documentfoundation.org/attachment.cgi?id=175389) loads quickly.
The xlsm file is identical and the only difference is the embedded VBA macro
(countifs_benchmark).
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: c6af59b234e8eb8182dc7f686290524feafd6ed6
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-AE (en_AE); UI: en-US
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
