<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Add an easy to use way for alternating cell coloring"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128248">128248</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Add an easy to use way for alternating cell coloring
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>postix@posteo.eu
</td>
</tr></table>
<p>
<div>
<pre>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)
<a href="https://support.office.com/en-us/article/apply-shading-to-alternate-rows-or-columns-in-a-worksheet-a443b0f5-2025-42f6-9099-5de09c05e880">https://support.office.com/en-us/article/apply-shading-to-alternate-rows-or-columns-in-a-worksheet-a443b0f5-2025-42f6-9099-5de09c05e880</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>