Ask Your Question

Base: alternating row color

asked 2016-11-07 19:23:47 +0200

ace214 gravatar image

I just transitioned a record of all my musical works from Excel to Base so that I wouldn't have to maintain multiple lists.

The only thing I'm lacking is a way to alternate the row color on reports, like this. I want each entry to be easier to read across the page.

Is this possible in Base? I would prefer not to use Calc since I am using groups.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-11-07 20:14:24 +0200

Ratslinger gravatar image

updated 2016-11-07 22:54:23 +0200

An explanation of how to do this is found in the Reports chapter of the Base Handbook starting on page 35. For pdf click here. For more Base/LO documentation click here

Edit: Sample - MusicListReports.odb with alternating line colors

edit flag offensive delete link more


Thanks for the link. It seems I need to recreate my report with the Report Builder rather than the wizard...

ace214 gravatar imageace214 ( 2016-11-07 20:55:44 +0200 )edit

I'd be surprised if you had to start over. Never been a problem for me.

Ratslinger gravatar imageRatslinger ( 2016-11-07 21:01:23 +0200 )edit

I can't find how to add the counter or how to do conditional formatting in the Writer editor.

ace214 gravatar imageace214 ( 2016-11-07 21:27:43 +0200 )edit

Will look at and try to get sample to you probably later.

Ratslinger gravatar imageRatslinger ( 2016-11-07 22:06:04 +0200 )edit

I figured out a solution that works: I can open the report as an editable ODT doc and apply AutoFormatting that way. It just means I have to do it every time I update, but it's pretty quick.

ace214 gravatar imageace214 ( 2016-11-07 22:10:42 +0200 )edit

Just to have it (already done when I saw your post) the alternating lines are on report "MUSICLISTdescNOPrint". The counter is just a text box (reduced to minimum width so it appears invisible) and conditional formatting is under the menu item Format. BTW - conditional formatting doesn't always take first - some took me two or three tries. Might be a bug?

Ratslinger gravatar imageRatslinger ( 2016-11-07 22:59:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-07 19:23:47 +0200

Seen: 1,073 times

Last updated: Nov 07 '16