https://bugs.documentfoundation.org/show_bug.cgi?id=153766
Bug ID: 153766
Summary: Conditional formatting needs autocalculate to be
enabled to work
Product: LibreOffice
Version: 3.5.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kelem...@ubuntu.com
Blocks: 87351
Created attachment 185503
--> https://bugs.documentfoundation.org/attachment.cgi?id=185503&action=edit
Screenshot of the Products2 sheet in Excel and Calc
This is sort of a mis-feature removal request.
attachment 185496 from bug 153763 is a conditional formatting learning material
from
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
This file has several sheets where the conditional formatting does not look the
same as in Excel, such as Products2 , Banded rows , Compare to totals ,
Products3, Customers2.
1, Open attachment 185496 in Calc and Excel
2, Compare the conditional formatting of the above mentioned sheets.
This happens because the conditions are cell references/formula and the Data -
Calculate - Autocalculate option is turned OFF in the file (in Excel: Formulas
- Calculation - Calculation Options - Manual).
Enabling this option is necessary for such conditions to be evaluated, as
documented in the help:
https://help.libreoffice.org/7.5/en-US/text/scalc/01/05120000.html?&DbPAR=CALC&System=WIN
"To apply conditional formatting, AutoCalculate must be enabled. Choose Data -
Calculate - AutoCalculate (you see a check mark next to the command when
AutoCalculate is enabled)."
Enabling the Autocalculate option and scrolling a bit corrects the formatting,
so the XLSX-interop part works fine.
This is happening in current master and back to 3.5, so my guess is this could
be an old performance workaround.
Now the request is to lift this "CF needs autocalculate enabled" limitation for
conditions defined as formulae/cell references.
Excel can apply such conditional formatting with disabled autocalculate, so we
should too.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
