Filter by color in Open Office Calc

ssquaretechs · 07-21-2011, 10:07 AM

Is it possible to filter data using color in Open Office Calc?? It's very easy to use this function in MS Excel.

Regards

Santhosh S

Snark1994 · 07-21-2011, 03:28 PM

Do you mean conditional formatting? http://openoffice.blogs.com/openoffi...ional_for.html

Pollux.rv · 04-15-2024, 07:04 AM

Quote:

Originally Posted by ssquaretechs

Is it possible to filter data using color in Open Office Calc?? It's very easy to use this function in MS Excel.

Regards

Santhosh S

Hello,
I do not see an answer to the question.
I have the same question.
No it is not conditional formating, just standard filtering on an auto-filter column.

Is it possible?

murugesandins · 04-16-2024, 12:50 PM

Due to your query I have installed open office at windows 11
After this I have opened scalc.exe
Typed following columns and rows

Code:

FirstName   MiddleName LastName
1           2          3
4           5          6

Press
Alt d f f
Due to this I have added filter using scalc.exe like the way we are performing
ctrl shift l at excel.exe
Learn more from:
https://help.libreoffice.org/latest/...tml?DbPAR=CALC

Pollux.rv · 04-17-2024, 07:11 AM

Quote:

Originally Posted by murugesandins

Due to your query I have installed open office at windows 11
After this I have opened scalc.exe
Typed following columns and rows

Code:

FirstName   MiddleName LastName
1           2          3
4           5          6

Press
Alt d f f
Due to this I have added filter using scalc.exe like the way we are performing
ctrl shift l at excel.exe
Learn more from:
https://help.libreoffice.org/latest/...tml?DbPAR=CALC

Thanks for your fast answer. But unfortunately does not answer my question.

See attached an example.
filtering on background color green in column C (left part of the sheet) would give the right part of the sheet (using MS-excel).
I hope this make it clearer.