Bug 54977 - conditional formats: add top10 elements condition
Summary: conditional formats: add top10 elements condition
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: difficultyInteresting, easyHack, skillCpp
Depends on:
Blocks:
 
Reported: 2012-09-16 00:32 UTC by Markus Mohrhard
Modified: 2015-12-16 00:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description Markus Mohrhard 2012-09-16 00:32:46 UTC 
Excel supports a conditional format that is currently not supported by Calc. The rework of the conditional format code made it now possible to add them.

Top10 elements means that you specify how many of the top n elements should be marked and then the conditional format is automatically applied.

This task includes several individual steps:

* Adding the new conditional format to sc/inc/conditio.hxx and sc/source/core/data/conditio.cxx
* Adding import and export code from ODS, sc/source/filter/xml/xmlcondformat.cxx
* Adding OOXML import and export code in sc/source/filter/oox
* Changing the ui code in sc/source/ui/condformat/

and maybe:

* adding a test case to the hopefully soon to be added conditional format import test
Comment 1 Markus Mohrhard 2012-09-16 00:34:22 UTC 
Actually when we are at it, adding Bottom10 elements, Top10 %, Bottom10%, and maybe above and below average should share the same code with this one.
Comment 2 Markus Mohrhard 2012-11-04 18:29:48 UTC 
All done. There are some more conditional formats added.
Comment 3 Robinson Tryon (qubit) 2015-12-16 00:20:50 UTC 
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyInteresting SkillCpp)
[NinjaEdit]