Bug 128248 - Add an easy to use way for alternating cell coloring
Summary: Add an easy to use way for alternating cell coloring
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-19 10:34 UTC by postix
Modified: 2019-10-20 00:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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