Download it now!
Bug 122699 - Select a style and show cells formatted with that style
Summary: Select a style and show cells formatted with that style
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2019-01-14 07:53 UTC by russell
Modified: 2019-05-23 02:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Image of enhancement - Select style highlights cells (46.54 KB, image/jpeg)
2019-01-14 07:54 UTC, russell

Note You need to log in before you can comment on or make changes to this bug.
Description russell 2019-01-14 07:53:06 UTC
With Cell Styles selected from Styles and Formatting (F11), select a style, and all cells on the current sheet that are formatted with that style are highlighted.
The highlighting could mean an overlay, different color, dashed lines.

Actual Results:
Currently it works the other way around. The user clicks a cell and the style is highlighted in the Styles and Formatting panel.

Expected Results:
Please see attached image.

It would be helpful to see, all cells using style "X", especially if converting spreadsheets from direct formatting to styles.

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 russell 2019-01-14 07:54:26 UTC
Created attachment 148300 [details]
Image of enhancement - Select style highlights cells
Comment 2 Heiko Tietze 2019-05-22 15:45:57 UTC
You do the trick per Edit > Find & Replace (Ctrl+H), check Cell Styles, select the style, and Find All. All cells with the respective style are highlighted (blue frame). => WFM

Btw, this works also in Writer.