https://bugs.documentfoundation.org/show_bug.cgi?id=66507
--- Comment #29 from m.a.riosv <miguelange...@libreoffice.org> --- Testing the file against 5.1, I think the problem is not related to the charts, but the lot of SUMPRODUCT() functions: - more than ten thousand. - with several ranges every one for conditions comparison. - a lot of them with large ranges (five thousand cells). - the majority of them with the INDIRECT() function for every range. If I'm wrong INDIRECT() it's a volatile function, so it is recalculated every time a cell it's calculated, what makes even worse the situation. So for me there it's not too much that can be done without change the design. Maybe with all data in one sheet, so INDIRECT() can be eliminated, and perhaps using a pivot table to shorten the data. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
