Apache OpenOffice (AOO) Bugzilla – Issue 125291
Conditional formatting is limited to editing 3 conditions even if more are defined in ODS
Last modified: 2014-07-21 18:33:21 UTC
If an ODS file contains conditional formatting with more than 3 conditions (e.g. created in LibreOffice), the fourth condition is applied but can not be edited because of the UI limitation. This issue is fixed in LibreOffice branch 3.5 which accepts more conditions and includes a button to Add more (unlimited?) LO branch 4.1 adds all kinds of Microsoft conditional formatting (gradients, icons, bars, etc) which might be important for supporting XLSX compatibility (see https://issues.apache.org/ooo/show_bug.cgi?id=119761).
duplicate *** This issue has been marked as a duplicate of issue 8812 ***