https://bugs.freedesktop.org/show_bug.cgi?id=75826
Priority: medium Bug ID: 75826 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Conditional Formats using STYLE(...) suck cpu when doing "nothing" Severity: normal Classification: Unclassified OS: Linux (All) Reporter: james_av...@yahoo.com Hardware: x86-64 (AMD64) Status: UNCONFIRMED Version: 4.3.0.0.alpha0+ Master Component: Spreadsheet Product: LibreOffice Created attachment 95212 --> https://bugs.freedesktop.org/attachment.cgi?id=95212&action=edit .ods spreadsheet which burns 80% CPU when "idle" LO Calc uses 80% CPU or more when sitting "idle" if Conditional Formats are used in conjunction with STYLE(...). I'm using this to style rows of data depending on a key value in one of the columns, while leading the other columns containing "plain data" the user can easliy change. The load increases with the number of cond-formatted cells... it' as if some background thread continually re-evaluates all the Cond. Fmt formulas for all the cells even though no data is changing anywhere. Attached is a demo .ods file. It contains a VLOOKUP table in A1:B3 followed by a large array of sample data. The data cells all have same conditional format with Formula: STYLE(VLOOKUP($A$1:$A$9999, $A$1:$B$3, 2, 0)) (The "apply style" is irrrelevant because STYLE() always returns false) Please try the attached demo. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs