![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
Hi,
i found a bug which wasnt in openoffice. When you fill cells with a
background color the border lines of the cells will disappear.
Do the developers read here too or where do i have to send this bug report?
regards,
Stevie
Hi Stevie,
You might want to provide more information on
http://bugs.freedesktop.orgthan you gave us though, such as what
operating system you run and maybe
even a sample document that shows the issue. Personally, I just did a quick
test (opened calc, added a border to a cell, then filled it with a
background color) and the border was still there... so is it some special
kind of situation?
Chris Carpenter
Dear Friend
What software version are you using? In version 3.3 BR-Office could not
identify the problem reported by you.
Sorry for writing but I'm writing from Brazil and my English is not
practical for some time.
Anderson Mattozinhos de Castro - Economista
E-mail: mattozinhos@yahoo.com.br
MSN: andcastrojf@hotmail.com
Tel Com.: +55 32 3257-4040
Cel.: +55 32 8834-2458
Twitter: http://twitter.com/mattozinhos
"Esta mensagem, e qualquer arquivo em anexo, são para uso exclusivo da
pessoa ou entidade à qual estão endereçados e podem conter informações
confidenciais,proprietárias e/ou material restrito ao público em
geral.Exceto conforme previsto acima, é proibida qualquer revisão,
retransmissão, divulgação ou outro uso de, ou a realização de qualquer ato
com base em tais informações por pessoas ou entidades, exceto o destinatário
original das mesmas. Caso tenha recebido esta mensagem por engano, por favor
notifique o remetente e apague-ade qualquer mídia e destrua quaisquer cópias
impressas ou não. "
"This e-mail, including any attachments, is intended solely for the person
or entity to which it is addressed and may contain confidential, proprietary
and/ornon-public material. Except as stated above, any review,
re-transmission,dissemination or other use of, or taking of any action in
reliance upon thisinformation by persons or entities other than an intended
recipient isprohibited. If you receive this in error, please so notify the
sender anddelete the material from any media and destroy any printouts or
copies."
-----Mensagem original-----
I had the same issue. Just take a new Calc doc with no borders set. Fill a set of cells with a color and the grid lines disappear. If I then set borders of course they come back. but this wasn't an issue in Oo 3.2.1.
Hi Stevie,
You might want to provide more information on
http://bugs.freedesktop.orgthan you gave us though, such as what
operating system you run and maybe
even a sample document that shows the issue. Personally, I just did a quick
test (opened calc, added a border to a cell, then filled it with a
background color) and the border was still there... so is it some special
kind of situation?
Chris Carpenter
Oh, yea, I am using Windows XP SP3 and LO 3.3.0 final.
Hi again,
Alright, when you make the bug then don't call them borders, call them grid
lines. Technically they aren't borders, because they aren't manually added
(and don't show up when the sheet is printed). I can confirm the issue in
Libreoffice 3.3 with Fedora 14. Not really sure if that is by design or a
bug though, they might have thought it looked better that way? In any case,
still a good idea to file a bug.
Chris Carpenter
Hi Stevie,
i found a bug which wasnt in openoffice. When you fill cells with a
background color the border lines of the cells will disappear.
Not a bug. It´s a feature. Works like MS Excel now and increases
compatibility with documents created by Excel. (I am not saying I
like it, but it works as designed.)
Stefan
Hi Stevie,
Stevie wrote (08-02-11 20:47)
i found a bug which wasnt in openoffice. When you fill cells with a
background color the border lines of the cells will disappear.
This is a feature. I guess it is the behaviour that people know from Excel. And the guys that worked on the Novell version of OOo have - and do - spent a lot of time to make the step easier for Excel users. So this means try to behave as Excel, as far as reasonable.
Personally I am not always happy with those changes. Simply because I am used to OOo Calc and because something as Ctrl-D (Selection list) for example is used often by me.
Discussion with the devs has led to the page Tools > Options > LibO Calc > Compatibility > Key bindings.
Maybe, if there are enough people to help, it is also possible to add the gridlines there?
(Hurray, even more options 
)
Do the developers read here too or where do i have to send this bug report?
Sometimes devs read here - maybe if they are pinged for a special subject
Others already pointed to Bugzilla. However, there is a good chance that there is already an issue, and a thread with discussion about this feature.
Hope this helps,
Regards,
Cor
Hi 
A normal spreadsheet shows thin grey lines between cells.
There is a "Page Settings" setting for including those thin grey lines on
printouts, the option is labeled "gridlines" and i think that is set by default
usually although i could be wrong.
It is difficult to know what to call those thin grey lines because as you
pointed out "borders" means something quite specific but so does the word
gridlines.
Anyway it is those lines that vanish in most spreadsheet programs when a few
adjacent cells are given a background colour. I don't think there is a way to
get them back except by using borders and then carefully setting the the borders
weight and width to be the same as the thin grey lines.
Regards from
Tom
Hi
It is worth posting this as a bug-report
http://wiki.documentfoundation.org/BugReport
Because a lot of us don't like the way Excel or other spreadsheet programs work
which is why we switched to OOo or LO in the first place. Having an option
seems a much better plan.
However, many people that receive printouts or look at spreadsheets are used to
this strange type of behaviour so they probably wont even notice.
Regards from
Tom
Please someone of you who is already registered at Bugzilla should post this
bug. When i try to open this site i get an error that the security
certificate is wrong.
HI
Yes, sorry about that. The certificate still hasn't been registered properly
but it is fine. Just accept the certificate and all will be fine.
Regards from
Tom
Try the instructions at:
http://wiki.cacert.org/BrowserClients
Aferwards you should be able to access https://bugs.freedesktop.org/
Sorry, forgot to add that it looks like it's already been filed:
https://bugs.freedesktop.org/show_bug.cgi?id=30800
[grid lines disappeared in Calc for cells with background colour]
Note: once you get your cacerts sorted out, you can search for bugs ala:
<https://bugs.freedesktop.org/buglist.cgi?query_format=specific&order=relevance+desc&bug_status=open&product=LibreOffice&content=calc>