Bug 116632 - UI: Allow searching for strings/numbers in specific style
Summary: UI: Allow searching for strings/numbers in specific style
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Find-Search
  Show dependency treegraph
 
Reported: 2018-03-26 09:09 UTC by Thomas Lendo
Modified: 2020-07-21 08:25 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Lendo 2018-03-26 09:09:55 UTC
I've some big spreadsheets with much data and every data type has its own formatted cell style (prices, article numbers, dates, etc.). Now I often have the problem to search efficiently for strings/numbers that exist in a specific cell style.

But there are similar strings in other cells so that a search for a string/number results in many search results I don't care about. For example: Searching for article no. '8472' also shows results with a price of 23.8472,- Euro or a description where the same number exists.

Enhancement request:
Allow searching for strings in a specific cell style in Calc.

Maybe this is a general enhancement for also other LibO components to allow search in a text that is styled with a specific cell/paragraph/character/page(?) style.
Comment 1 V Stuart Foote 2018-03-26 16:02:37 UTC
OK => NEW enhancement
Comment 2 m.a.riosv 2018-03-27 08:44:09 UTC
(In reply to Thomas Lendo from comment #0)
> ...
> But there are similar strings in other cells so that a search for a
> string/number results in many search results I don't care about. For
> example: Searching for article no. '8472' also shows results with a price of
> 23.8472,- Euro or a description where the same number exists.
> ...
For this case there it's the option to search for the 'Entire cells'.

And for the enhancement, can be achieved with only two steps, first searching for the values, and then marking selected cells and searching for the style or viceversa.
Comment 3 TBeholder 2020-05-08 15:54:06 UTC
I'd just search the style with "Find All", then search in selection.
Comment 4 Thomas Lendo 2020-07-21 08:25:23 UTC
(In reply to m.a.riosv from comment #2)
> (In reply to Thomas Lendo from comment #0)
> > ...
> > But there are similar strings in other cells so that a search for a
> > string/number results in many search results I don't care about. For
> > example: Searching for article no. '8472' also shows results with a price of
> > 23.8472,- Euro or a description where the same number exists.
> > ...
> For this case there it's the option to search for the 'Entire cells'.
This doesn't work with cells that contain a formula where '8472' is part of.

> And for the enhancement, can be achieved with only two steps, first
> searching for the values, and then marking selected cells and searching for
> the style or viceversa.
Right, thanks.