[Libreoffice-bugs] [Bug 128248] New: Add an easy to use way for alternating cell coloring

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: postix at posteo.eu

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191019/70bc1d77/attachment.html>