I'll be quick about this; I have no idea whether a cell has an applied conditional formatting or not without having to dig into the Format > Conditional Formatting... dialog box. For me, this is unintuitive and a little annoying if I'm trying to set up more-than-simple cases of conditional formatting for columns of data.
Is there any other way, requiring less clicks, that I can find out if a cell is conditionally formatted? The ideal implementation in my mind is something like the edit state of the document on the status bar (asterisk if edited from last save, check/blank otherwise) combined with the visual cue of comments in cells (a little corner arrow).
None of which I'm personally aware. I'm a programmer type so when I needed to do a few thousand of these recently, I made a template, picked apart the ODS file, and created a new one programmatically. However, this is clearly neither ideal nor approachable for most, and I would have preferred exactly what you're suggesting.
My suggestion: spend a few minutes looking through the various enhancement requests and "crazy ideas" and if you don't see it, submit this idea.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-30 17:04:03 +0200
Seen: 118 times
Last updated: Apr 04 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
