Ask Your Question
0

Automatic borders / lines between months in a spreadsheet?

asked 2016-08-01 17:47:19 +0200

donquixote gravatar image

I have a spreadsheet showing a list of bookings from my bank account. Each booking has a date, obviously. I'd like to visually group the bookings by month, to get some visual structure. This could be done with background colors or with separator lines / cell borders.

Is there any way to do this automatically / dynamically in LibreOffice Calc?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-01 20:34:12 +0200

mark_t gravatar image

This can be done with conditional formatting.

Select first complete row of data. Choose conditional formatting. For condition choose "Formula Is", then enter the formula "MONTH($A2)<>MONTH($A3)", (assuming date is in first column.). Select new style and then in the cell style window choose "Borders" and set up bottom border style. Then copy the top row of the table and use paste special, formats only to the remainder of the table.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-01 17:47:19 +0200

Seen: 135 times

Last updated: Aug 01 '16