https://bugs.documentfoundation.org/show_bug.cgi?id=128248
Bug ID: 128248
Summary: Add an easy to use way for alternating cell coloring
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Currently to give rows an alternating color, one can use `ISEVEN(ROW())` as a
conditional cell formatting. This is really cumbersome.
MS Excel does it the same way as well, but offers an additional and quicker
solution [1]:
1) Select the rows and columns in a rectangular block
2) Format the selection as a table
3) Give it a (pre)defined table style with alternating colors
(Also custom table styles for branded rows or columns can be defined.)
4) Clicking in the table gives an option to convert the table back to standard
regular range of cells.
This would increase the UX and the efficiency a lot.
[1] (Technique 2)
https://support.office.com/en-us/article/apply-shading-to-alternate-rows-or-columns-in-a-worksheet-a443b0f5-2025-42f6-9099-5de09c05e880
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
