Bug 155907 - [FR] Support alternating cell coloring
Summary: [FR] Support alternating cell coloring
Status: RESOLVED DUPLICATE of bug 66377
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2023-06-18 06:15 UTC by AvidSeeker
Modified: 2024-01-08 16:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description AvidSeeker 2023-06-18 06:15:39 UTC
Alternative cell coloring is a common table styling used in sheets to easily distinguish entries.

Current workaround is by using conditional formatting and checking if the row is even.

Google Sheet alternative coloring menu: https://i.imgur.com/Lgy6LX2.jpg

Steps to Reproduce:

Actual Results:

Expected Results:

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Stéphane Guillou (stragu) 2023-10-30 23:04:37 UTC
Thank you for the suggestion.
Have you tried Format > AutoFormat Styles?
Comment 2 AvidSeeker 2023-10-31 05:39:06 UTC
Inserting a new row or a column between the rows of the AutoStyles messes up the color pattern of even-odd.
Comment 3 QA Administrators 2023-11-01 03:14:28 UTC Comment hidden (obsolete)
Comment 4 Gabor Kelemen (allotropia) 2024-01-08 16:22:08 UTC
This is the equivalent of the "Excel tables" Excel-feature, in GDocs.

*** This bug has been marked as a duplicate of bug 66377 ***