Apache OpenOffice (AOO) Bugzilla – Issue 8812
Conditional formating
Last modified: 2016-06-15 15:07:15 UTC
Current number conditions in conditional formating is limit to three. It would nice to have unlimited number
Hi Bettina 1 4 u Frank
*** Issue 12866 has been marked as a duplicate of this issue. ***
It would be nice for each condition to have a button bringing up the Format Cells dialog box that would let users customize the cells further.
More than 3 conditions would be great! I use them a lot in tracking-lists... Any progress on this ?
Somebody couldn't wait anymore and wrote an extension: http://www.ooowiki.de/KomplexeBedingteFormatierungen
Is this topic still being worked on. I know there is an extension but LOCALE is not available for it. This is a valuable feature and been open since 2003. I appreciate opensource SW, but issues that get left in the background are also parts of the issues with OS.
any news on this topic ? thanks
As you can deduce from this issue's target milestone “unset”, there is no roadmap available for the implementation of the feature requested. Furthermore, holding discussions in issues is not productive, instead start a discussion on the discuss@ux.openoffice.org mailing list please.
*** Issue 102562 has been marked as a duplicate of this issue. ***
one of the nastiest pieces in OOO, believed to be smart, but actually useless seeing the uninspired development of the feature and the weakness of the solutions on these issues I would like to know if would help to put all of the plus 100 numbers of the issues/complaints in here, more or less solved so far. Note to the developers: Conditions that can neither be seen nor be edited nor be applied to groups of cells (copying relative with same condition for changing parameters) is nasty/useless in a serious/office environment - etcetc Martin
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
An unlimited number of styles would be great, but as a quick fix, doubling the number of rules (3 -> 6) would certainly help. An example of a spreadsheet needing more than 3 rules / cell is a project report (risk analysis from "0 - n/a" to "5 - very high"), or a report of issues from this bug tracking tool (priority P1 to P5, with different colors for each priority)
Wow, this issue is open for 8 years already … If I had time, I would do it. But I don't atm, so here my thoughts: * «Unlimited» number of rules would in fact be very easy. Very little adjustments would have to be done imho. Just use a list (of variable size) and store the conditions in there. * A bonus feature of this, coming at no cost, would be named conditions. Similar to styles: The user gives a condition a unique name, which can be used for identifying the condition in the list (HashMap e.g.), and, more important, for * Reusing existing conditions. Like, you select column B, add a new condition called «Nonzero» that marks all cells green which are not zero/empty, and apply this condition to the column B. Then select column C and apply the «Nonzero» condition here as well just by applying the already existing condition. * Priority of conditions. This could also be done via a list. The condition at the top is the most important and evaluated at last. For example, the top condition is «Divisible by 4», which colorizes the cells green, and the second condition is «Divisible by 2» which colorizes the cells yellow. Depending on the order either all cells are yellow (%2 at the top) or the ones divisible by 4 are green and the rest yellow. * Highlight cells with conditional formatting. Perhaps via a tool similar to the one that shows paragraphs, spaces, tabulators, and so on. This would be very helpful. * Other thoughts? :) Simon
*** Issue 114098 has been marked as a duplicate of this issue. ***
Any progress on this issue ? (In reply to claudiadzm from comment #5) > Somebody couldn't wait anymore and wrote an extension: > http://www.ooowiki.de/KomplexeBedingteFormatierungen Is this extension compatible with Apache License ?
I just realized this issue by receiving an excel spreadsheet with up to 6 conditional formattings for one cell. After importing to AOO, all formattings exept for the first three were gone. But in LibreOffice, the number of conditional formattings is unlimited, and after modifying the sheet in LO, saving as *.ods, and reopening in AOO, all the added conditional formattings were working as intended. Even No. 4, 5 and 6 in AOO. So I suppose, it is a matter of a) the import procedure and b) of the UI. The UI should be changed to offer access to an unlimited number of conditional formattings. Just as in LO. Or in excel.
@jeffooo: It's working. Don't know about the license. But is doesn't show the actual format/style, which makes it hard to use. LO shows a preview and changes this immediately, according to the chosen format.
*** Issue 102265 has been marked as a duplicate of this issue. ***
*** Issue 119761 has been marked as a duplicate of this issue. ***
*** Issue 125291 has been marked as a duplicate of this issue. ***
Actually marking a recent request in a 12 TWELVE YEAR OLD report is NOT a good idea. In my Enhancement request I pointed at solutions and possible code (in LO) that could be used to solve this TWELVE YEAR OLD request.
(In reply to Pedro from comment #21) > In my Enhancement request I pointed at solutions and possible code (in LO) > that could be used No, it cannot. They have explicitly chosen a license that allows them to take code from this project, but not vice versa (basically the same situation in the go-oo fork times); so the code flows from here to there, not the other way around.
(In reply to Ariel Constenla-Haile from comment #22) > (In reply to Pedro from comment #21) > > In my Enhancement request I pointed at solutions and possible code (in LO) > > that could be used > > No, it cannot. They have explicitly chosen a license that allows them to > take code from this project, but not vice versa (basically the same > situation in the go-oo fork times); so the code flows from here to there, > not the other way around. I am well aware of the license limitations. However it is possible to ask the patch creator to submit to AOO as well (under a dual license) or to use the LO fix as a starting point.
(In reply to Pedro from comment #23) > > > In my Enhancement request I pointed at solutions and possible code (in LO) > > > that could be used [..] > I am well aware of the license limitations. However it is possible to ask > the patch creator to submit to AOO as well (under a dual license) I don't find any pointers in Bug 125291 about the respective LO bug reports, commits, developers who fixed the bug. Nevertheless, in case you have that information, you are free to contact them and ask them to re-license their work > or to use the LO fix as a starting point. How could this be possible due to the license issue?
Created attachment 83730 [details] Number of conditions and choices for each condition (In reply to Marcus from comment #18) > *** Issue 102265 has been marked as a duplicate of this issue. *** In my humble opinion, issue 102265 is not a duplication of 8812, see screenshot in attachment. Best regards
(In reply to jeffooo from comment #25) > In my humble opinion, issue 102265 is not a duplication of 8812, see > screenshot in attachment. You are right. Your request is for more OPTIONS in conditional formatting, not for more CONDITIONS. Issue 102265 is NOT a DUPLICATE.
Workaround with CF+ extension: http://extensions.openoffice.org/en/project/extend-your-conditional-formatting
ahh... I figured its been 8 years since I first laughed at this for being a ancient issue with no progress. So here it is now 2016 and a bug that was reported in 2003 is still not fixed or added. Way to go you openoffice developers. Go Team. Better hurry up or the original reporter may be dead before it gets finished. Then again, maybe it is finished. I wouldn't know, I moved on "many" years ago... pease!! out.
(In reply to darknet from comment #28) > pease!! out. useless comment
(In reply to oooforum (fr) from comment #27) > Workaround with CF+ extension Thanks a lot :)