[Libreoffice-bugs] [Bug 118441] New: VBA macro unnecessarily recalculated

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180628/009c32de/attachment.html>