I have a Calc document that I created some months ago containing several messed-up styles. Now I need to fix it and I would prefer not to rebuild it from scratch but I can't remember how I created and assigned the styles. Is there an easy way to check what cells I applied each style to?
Hello,
if you really applied styles (and did not perform direct formatting) then do
Styles -> Manage Styles -- or -- F11Hierarchical is chosen in the drop down at the boot of the pane). The style applied to the selected cell will be highlighted. I don't know of any way to Show me all cells having a special style applied - if that's what you are looking for. You only could select a range of cells (and extend a current selction) and as long the styles pane shows a specific style highlighted all cells in the range have that style (If highlighting vanishes at least two styles are applied to cells within the selected range).
Hope that helps.
If the answer helped to solve your problem, please click the check mark (✔) next to the answer.
Close to "Show me all cells having a special style applied" is editing the style in question to, say, have red background. Given the rationale mentioned in question, this might be appropriate approximation.
It can be done through Search & Replace , there is an option to search for styles, and only used styles are showed for search.
Asked: 2020-01-19 21:08:27 +0100
Seen: 107 times
Last updated: Jan 20 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
