First time here? Check out the FAQ!
asked 2012-03-30 17:04:03 +0200TJ Meneses
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).
answered 2012-04-04 08:52:28 +0200hunteke
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.
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