In libre calc, I am not able to get filter by color. how can it be managed? need urgent help in this regards.
You can’t - there is no such thing in Calc.
Urgent? Find Excel and use it - this is the fastest way. Medium on speed - tell us more about why your cells are colored: is it conditional formatting, applied styles with different cell backgrounds, or direct manual formatting? If the formatting is manual, then try to explain by what principle the different colors were chosen and what they mean. Perhaps, after thinking about your specific problem, we can find an acceptable solution today or tomorrow. The longest way is to sit and wait for this functionality to be implemented in Calc - now it just isn’t there.
This is not the first question here concerning colors to be used for cell selection, range filtering, giving a condition (“criterion”) in ...IFS() functions and the like.
I cannot remember a case where the questioner told in hat way he(f/m) would identify the color to be used. There are 16777216 different colors technically, and every single one is not distinguishable for a human eye by comparison with hundreds of others.
The only halfway reasonable option to give a specific color is an example cell or a cell style having that color set/applied. Different palettes may use the same name for different colors or different names for the same one…
Trying to use colors coding for actual information is one of the worst mistakes in the design of spreadsheets.
The only reasonable question in the context is something like “I made that mistake (follows precise description of the case). How can I recover my sheets?”
Hello,
as you may have read there is no direct possibility to filter by color, however you are
not the first to ask.
You may do this by a macro, either by extracting the color-information (.cellbackcor) to a helper-cell,
which can be used to filter afterwards.
The following Macro from a forum by f3k
filters all rows of the same color as the (single) active cell when invoked
(I translated the german parts):
Sub S_hide_cells_having_selected_backgroundcolor
osel = Thiscomponent.currentselection
if not osel.supportsservice("com.sun.star.sheet.SheetCell")then
msgbox ("Select single cell",16,"Error: Color-filter")
exit sub
endif
ncolor = osel.cellbackcolor
nsheet = osel.celladdress.Sheet
ncolumn = osel.celladdress.column
osheet = thiscomponent.sheets(nsheet)
ocursor = osheet.createcursor
ocursor.gotoendofusedarea(false)
nEndrow = ocursor.RangeAddress.endrow
for i = 1 to nEndrow 'first row (0) stays
ocell = osheet.getcellbyposition(ncolumn,i)
if ocell.cellbackcolor = ncolor then
osheet.rows(i).IsVisible = true
else
osheet.rows(i).IsVisible = false
endif
next i
End Sub
Thanks dear, it’s working fine