https://bugs.freedesktop.org/show_bug.cgi?id=75826
Priority: medium
Bug ID: 75826
Assignee: [email protected]
Summary: Conditional Formats using STYLE(...) suck cpu when
doing "nothing"
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
