LinuxQuestions.org - Filter by color in Open Office Calc

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - Filter by color in Open Office Calc (https://www.linuxquestions.org/questions/linux-software-2/filter-by-color-in-open-office-calc-892969/)

ssquaretechs

07-21-2011 10:07 AM

Filter by color in Open Office Calc

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 (Post 4421310)

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

1 Attachment(s)

Quote:

Originally Posted by murugesandins (Post 6496387)

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.

All times are GMT -5. The time now is 09:51 AM.