Bug 128248

Summary: Add an easy to use way for alternating cell coloring
Product: LibreOffice Reporter: postix <postix>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: enhancement CC: postix, vsfoote
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description postix 2019-10-19 10:34:58 UTC 
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
Comment 1 V Stuart Foote 2019-10-20 00:10:36 UTC 
Already available.

1. Make selection of cells
2. Format -> AutoFormat Styles...
3. select from the Format drop list
4. OK to apply