Issue 114098 - Need unlimited conditional formatting like in Excel
Summary: Need unlimited conditional formatting like in Excel
Status: CLOSED DUPLICATE of issue 8812
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO320m9
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-25 09:35 UTC by eproust
Modified: 2010-08-25 17:13 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eproust 2010-08-25 09:35:07 UTC 
I still use Excel to update my calendar/time planner document because the is no 
limit to conditional formatting in Excel.
In OpenOffice Calc 3.2.x, a cell can only have 3 conditional formatting.

It should be important to enhance Calc on this functionality.
Comment 1 Joe Smith 2010-08-25 15:58:13 UTC 
This is covered by Issue 8812

Also, there is a workaround using the STYLE function in a conditional format to
select from an unlimited number of formats. See the discussion in Issue 71392, or
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=25035
for an example.
Comment 2 niklas.nebel 2010-08-25 17:12:46 UTC 
Using the STYLE function in conditional formats can cause problems like issue
109243 because the condition formula is evaluated again after applying the style.

This issue is in fact a duplicate of 8812.

*** This issue has been marked as a duplicate of 8812 ***
Comment 3 niklas.nebel 2010-08-25 17:13:18 UTC 
closing duplicate