[Libreoffice-bugs] [Bug 128082] New: For large pseudo-arrays, the spreadsheet becomes slower/laggier than excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128082
           Summary: For large pseudo-arrays, the spreadsheet becomes
                    slower/laggier than excel
           Product: LibreOffice
           Version: 6.3.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: librelibre at yopmail.com

Description:
for large fake-arrays (made of cells that are made of formulas containing
absolute and relative references [ A1 , $A$1, $A1, A$1 , $A1:$A100 …]
esp since if redundant origin, e.g. rows/columns of same origin copy-paste or
drag-expanded from few cells, 

when expanded into the 10000's+ or into when in both horizontal/vertical
direction , getting complex, this happens,

using actual arrays is not convenient since they have restriction on how they
may be resized or edited, also the keyboard shortcuts are different than that
in excel

Steps to Reproduce:
i'm not sure i can post the spreadsheet, and it is not an isolated exmaple
but general gist is that it includes 
math, 
string operations (mid, &, "", search)
offset
countif's
sums
if-statements

often that spreadsheet contains clusters of cells that
are more-or-less grouped into modules, thus maybe that taken into account for
optimization

Actual Results:
when really big and complex, high latency, (click and time for UI to respond,
app hangs/freezes 0.5-several seconds occasionally), spreadshreet not redrawing
(blank occasionally during freezes and scrolling,

Expected Results:
perhaps internally calc notices that the cells are somewhat redundant or follow
a patter and therfore optimize it's execution to be more lightweight without
significantly(or at all) affecting its accuracy, 


Reproducible: Always


User Profile Reset: No



Additional Info:
i couldn't find other bug/meta-bug about this, it seems vague but the problem
might be brad , about in the way the spreadsheet processes&parses&executes the
spreadsheet

-- 
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/20191011/4fc022cf/attachment.html>