https://bugs.freedesktop.org/show_bug.cgi?id=53824
--- Comment #7 from Max Addler <[email protected]> --- > Does this still happen with 4.0.4 or 4.1.0.beta1/beta2? I still do not know. I am using LO 3.7.5.2 on Xubuntu 13.04 right now. > If so could you please open a bug report with a test case? That would probably mean to create a spreadsheet file with 100 sheets, each of which with several hundred lines and several dozen columns. I refrain from that. Or posting my original file - which I cannot do due to its content. > I sounds strange that despite auto calc being turned off we still spend a > considerable time recalculating. The only idea that I have is that somehow > your document contains a few shapes that force row height calculations. > But that would still means that in ScFormulaCell::MaybeInterpret we would > not call the interpreter so there must be something strange going on. I mentioned it earlier in one of the other bugs I filed at the same time (#53825, #53826, #53627, #53628, all of them probably not depending on this bug), but I would like to point it out here again: My sheet does lots of verification using conditional formats. Almost each of the million individual cells has a conditional format, which is mainly used to set the cell's background color depending on the cell's value. I do this as a visual validation feedback. Many of these validations use lookups (german function names "VERWEIS" or "SVERWEIS") or summation functions (german function names "ZÄHLENWENN", "SUMMEWENN"), and I suspect a heavy impact here. Furthermore, even with recalcuation off, validation seems to work partly (background colors are updated, but inconsistently - I have not investigated further). > Maybe you can open a bug report with the test file and put perf in the > whiteboard line. I am afraid I am not enough into LO debugging. Please let me know if my hint regarding the conditional formats was of any use to you. -- 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
