Ask Your Question

Conditional formatting Calc not allowing border or date to show correctly [closed]

asked 2012-05-14 06:18:20 +0100

ddgiant gravatar image

I am an old Open Office user and just found out about LibreOffice and wanted to try it and see several improvements over Openoffice.

Now my 2 part question.

I am putting a Calc spread sheet together to track medical claims for my family. The data that I am collecting is Name of member, doctor, date of service, claim number (linked to PDF of the claim) and misc about claim. I have got this part all done up.

Now I am wanting to use conditional formatting to highlight each part by members name. I got this to work, but when done the date field changed to some numbers instead of showing the date, and my borders in the highlighted area disappear.

Any advise on what I might be doing wrong?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 19:07:46.315641


Update: Please elibrate on what you mean by needing more then one style based upon text/number vs date cells, there should not be any difference due to the conditional formattin is based upon a simple yes or no in. As for your comment about "border you need to set one in the cell style borders-tab"

ddgiant gravatar imageddgiant ( 2012-06-11 06:32:04 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2012-05-14 10:26:57 +0100

m.a.riosv gravatar image

Maybe you would need more than one style to apply in the conditional formatting, at least one for text/number cells and one for date cells.

In LibreOffice the background color overlap the grid, to get the border you need to set one in the cell style borders-tab.

edit flag offensive delete link more


Well is there any option that background color would NOT overlap the grid??? Specially in conditional formating?

France gravatar imageFrance ( 2013-01-01 08:37:55 +0100 )edit

answered 2013-01-01 15:42:52 +0100

m.a.riosv gravatar image

Yes there is an option: Menu/Tools/Options/LibreOffice/View/Grid lines. image description

edit flag offensive delete link more

Question Tools


Asked: 2012-05-14 06:18:20 +0100

Seen: 771 times

Last updated: Jan 01 '13