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.
OK => NEW enhancement
(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.
I'd just search the style with "Find All", then search in selection.
(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.