https://bugs.freedesktop.org/show_bug.cgi?id=66507
--- Comment #14 from Michael Meeks <[email protected]> --- It is curious that switching sheets to Napokra -appears- to trigger re-calculation of the chart's source ranges each time; no idea why that would be unless there is some always-re-calc setting being provoked there. The children of TabBar::Select look interesting in that regard; it eventually calls: ScChart2DataSequence::BuildDataCache() which seems to trigger a lot of the calculation: though why it should do that repeatedly is not immediately clear to me: there are no macros in that sheet to dirty anything. Ultimately, it seems that the sheer number of SUMPRODUCTS over large ranges containing unpleasantly branchy 'YEAR', 'WEEKNUM', 'WEEKDAY' etc. methods makes the calculation somewhat slow. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
