https://bugs.documentfoundation.org/show_bug.cgi?id=118441
Bug ID: 118441
Summary: VBA macro unnecessarily recalculated
Product: LibreOffice
Version: 6.1.0.0.beta2+
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: perf
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108908
Created attachment 143195
--> https://bugs.documentfoundation.org/attachment.cgi?id=143195&action=edit
Sample XLSM
The attached XLSM spreadsheet contains 7000 rows with a simple summation macro
(sums values in B-Z columns, which aren't filled, so the result is always 0).
In Excel the file opens in ~1s.
In Calc it opens in ~23s.
If macros are disabled, rows 2-7000 show #VALUE! error, which means those are
the ones being calculated, when they shouldn't.
Observed using LO 6.1 beta2 / Windows 7.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108908
[Bug 108908] [META] Visual Basic for Applications (VBA) macro issues
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
