Bug 122699 - Select a style and show cells formatted with that style
Summary: Select a style and show cells formatted with that style
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
Image of enhancement - Select style highlights cells (46.54 KB, image/jpeg)
2019-01-14 07:54 UTC, russell 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 
Description:
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.