Bug 110991 - row colour alternation in tables (Calc and Writer)
Summary: row colour alternation in tables (Calc and Writer)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.2.7.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks:
 
Reported: 2017-08-01 13:49 UTC by Jérôme
Modified: 2017-08-08 11:44 UTC (History)
5 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 Jérôme 2017-08-01 13:49:19 UTC
I would appreciate a simple formatting feature which helps to distinguish the rows of a table. The bank statements do it for decades in order to avoid reading errors.

Of course Calc provides the automatic formatting which allows the use of versatile formula. For example, we can define the following automatic formatting : if MOD(LIGNE(A1);2)=0 then put the row background as grey.

However, the user has to know automatic formatting in Calc tables and this workaround doesn't cover the Writer tables.

For Calc, a trade-off would be a generator for the above automatic formatting. This "wizard" would be available from the automatic formatting menu (like the existing colour scale, ...).

For Writer, we can include a Calc object which has the above automatic formatting. However a Writer table offers specific useful features (automatic page jump, ...) which would be lost.
Comment 1 Jacques Guilleron 2017-08-03 21:21:46 UTC
Hi Jérôme,

Did you see the results of the recent survey?
https://design.blog.documentfoundation.org/2017/05/08/results-table-styles-survey/
Comment 2 Jérôme 2017-08-06 14:32:26 UTC
Hello Jacques. I didn't read this survey before you tell me about it. Thanks of this information. This new feature "table style" will provide this feature of the Calc tables but not for the Writer table.
Comment 3 Xisco Faulí 2017-08-07 08:56:11 UTC
Moving it back to UNCONFIRMED until someone else confirms it.
Comment 4 Regina Henschel 2017-08-07 09:48:31 UTC
Such formatting can be achieved via AutoFormat. You only need to create it once and it will be available for Calc and for Writer tables.
Comment 5 Heiko Tietze 2017-08-08 11:44:29 UTC
(In reply to Jérôme from comment #2)
> Hello Jacques. I didn't read this survey before you tell me about it. Thanks
> of this information. This new feature "table style" will provide this
> feature of the Calc tables but not for the Writer table.

Table Styles is a feature of Writer. Though not fully implemented (see bug 101756 and in particular bug 105933). You can still use the autoformat feature (Regina's recommendation in comment 4) with the disadvantage that you have to apply it manually.

So it's a WFM.