All the grid lines disappeared for cells with background colour set to anything other than "No Fill"
Yes, that's intentional for compatibility with other spreadsheet programs. There have been many requests for this feature from those users who use Calc to design input forms; to remove grid lines in selected areas. When designing forms inside spreadsheet, grid lines look very ugly.
Same with WIN XP.
I strongly disagree with that "intention", and I prefer incompatibility to other spreadsheet programs instead of now seeing my spreadsheets ugly and unusable. If you want to make cell border grid lines invisible in a selected area, create a property "do not show grid"!
Ho hum - what fun. Clearly, in full wysiwyg mode - the lines are not printed, and if you really want grid lines - it is easy to get them back by adding explicit grey grid lines (?)
@ Michael Meeks:
> it is easy to get them back ...
And to remove them for Printout? That's a completely different behaviour from the standard grid lines, what will not be useful for me at all.
I heard that we will get a selection in menu 'Tools -> Options -> Calc -> Compatibility' for "OOo legacy". Can we get a similar selection for the behaviour discussed here? My wife is disabled and has has a system with colored columns + default grid to "navigate" within a sheet, that becomes difficult if in some columns grid as help for orientation is missing. And borders cause much workd and other problems.
Alright. But we'll have to wait until the next release, since we are way past the 3.3 code freeze, I'm afraid.
Re-assigning to Katarina. The goal is to make this a configuration option, under Calc - Compatibility in the Options dialog.
Hie, have you postponed the option to the next version? I didn't find the new option into the 3.3.1.
*** Bug 34175 has been marked as a duplicate of this bug. ***
*** Bug 34518 has been marked as a duplicate of this bug. ***
I'm _very_ eagerly awaiting this fix :)
Using 3.3.1 on Ubuntu 10.10 and can not find the option anywhere. Where was the fix applied?
This is very important to myself as I do not care much about Excel compatibility(I use ODF formats) and find the missing guidelines not only ugly, but make the spreadsheet less readable. I am surprised that Excel uses this as a standard as guidelines are there to make rows and columns more readable and there is no reason to take them away.
Modified version to the one most nearby to the report.
A quick search found 2 unfixed bugs with target 3.3.1:
Bug 30800 - UI: grid lines disappeared in Calc for cells with background colour
Bug 31672 - Background Color not overriding
Please, please, pretty please make this fix as soon as possible. For me (and apparently for many others) this bug, or shall we say missing feature, is the real "no go" for LibreOffice. Thx.
There is a pilot on the flight?
Just a little answer will be appreciated.
So I'm still waiting in OOo 3.2.
Pleasepleasepleaseplease... get back grid cells!!! :~(
A config option would be supportable too... ;-)
I'm sorry, but current behavior is the result of crazy idea, until now I did not read any comprehensible argument for it. But we have some serious counter-arguments.
It should not be too different to return to the old behavior.
Rised Importance due to discussion.
(In reply to comment #17)
> I'm sorry, but current behavior is the result of crazy idea, until now I did
> not read any comprehensible argument for it. But we have some serious
I appreciate you Rainer, but calling this a crazy idea is a bit out of line. There were users who relied on this behavior for Excel compatibility as I already explained! and call that idea crazy is very subjective!!
Let's make this an easy hack, so that an interested party can contribute a patch for this. I'll be the assignee meanwhile.
Goal: The goal of the easy hack is to make this a configuration option.
Code Pointer: ScOutputData is the class that implements the rendering of all things on the sheet. You need to change the ordering of layers depending on the configuration option.
Many thanks for your comment.
I hope to see soon this option.
I'm not clear on what solution is being proposed. The current behavior is that any cell with a background color shows no grid lines. It sounds like people are suggesting an option to go back to the old Calc approach whereby grid lines are always shown regardless of the cell's background color.
But that isn't a good solution either. There should be a PER CELL option --- part of the cell formatting just like borders and fill --- to show gridlines or not.
I very rarely get involved in discussions & bug reporting, but this one affects me greatly (and is the reason why I have to stick with Ooo for now, after trying LO 3.4), so I would like to chime in.
By searching the mailinglist, I came across this Bug Report, and found out that this is a "feature", and there is nothing wrong with the argument for the current choice. However, it presents a huge issue for people like me who color spreadsheet areas for easier reference and navigation and now have single values floating anchorless in large colored rectangles...
I fully support the current position of giving people at least the OPTION to put the grid back on top.
I would also like to propose to add it this way in the preferences/options (rather than naming it some obscure compatibility feature):
- LibreOffice Calc -> View -> Visual Aids -> Grid Lines -> Checkbox already exists.
(To turn the whole grid on/off)
- Under that, there is already the color chooser.
- ! Under that, simply add "Overlay" -> Checkbox.
(To put the grid on top if checked (like OOo), if unchecked (default) leave it underneath for the current Excel compatibility)
BTW, in #22 Brenbarn asked for a per-cell solution: that is already available as the current fix: simply add a similar-to-grid sized/colored border to any individual cells requiring something like this. The issue is for people like me that would require to do that to EVERY cell in the sheets, which could be 1000s... (and probably slowing down LO in the process)
I hope this can be implemented, I would really like to switch to LO, not the least because I appreciate the spirit and effort people here have been putting into it.
ok, taking this one.
there is already a brief discussion on he topic at
currently I have a prototye that implements both option in Calc - View and in Calc - Compatibility. I need at least one week more to discuss what would be the better choice and identify sideffcets, proper wording ...
would be good, if people who like too get a good solution would join
email@example.com list and evaluate the opions
and side effects (e.g. if it is resonable to remove grid color selection
from Calc - view)
patch is currently in review. Implementation follows this spec:
Just pushed this to master. For the next major release (3.5)
Why can the patch not be integrated in the next bugfixrelease?
This should not be included in 3.4.x, as it is not just a bugfix - it is new functionality including new UI strings and help texts. We would break lots of localizations if we would include all this.
One year to coming back to the previous status!!
Found fix in parallel installation of MinGW Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID: 2ba5d12-e8c71c5-41e7bcd-4b83b90)] (daily/MinGW_cross-compilation2011-10-25_00.12.09)". Correctly mentioned in Help.
Nice the 3.5 is coming.
But the solution is not perfect.
When you have a border on a set of colored cells, the grid is just over the border and the result is really not pleased due to the duplicate : border + grid...
Hope to be useful.
Fixed, not Invalid!
Pleaase do not touch "dashboard"!
I have LibreOffice 3.5.0beta2 now and can not see the option to display the grid through the background.
This is the Bug tracking system, not a helpdesk! You can get assistance on the public users mailing list firstname.lastname@example.org, a mailing list from <http://www.documentfoundation.org/contribution/#lists> or
Help index 'Grid -> Displayin lines (Calc)'
Help search "grid view" item 'Spreadsheet options' -> View' leads to
"Grid lines - Specifies when grid lines will be displayed. Default is to display grid lines only on cells that do not have a background color. You can choose to also display grid lines on cells with background color, or to hide them" in Calc 'Tools -> Options -> Calc -> View -> Viusal aids - Grid lines'
This Topic is not fixed yet.
Yes, the new option enables grid lines to be on top, BUT it overwrites frames at the same time.
So to finally get this right again, either frames should be put on top, or the option should be edited in that way, you could decide in which order backgroundcolor, gridlines and frames are displayed.
Logical would be the original order (from bottom to top):
background color, gridlines, frames
Please do not change the version number, it indicates the first version in which the bug has been found.
Please, could you attach a screen copy showing the problem with frame?
Best regards. JBF
No worries. I just discovered & fixed the cell border issue yesterday. It will be fixed in RC2 (note RC2 not RC1).
Please submit new bugs for new problems and check the bugzilla database before you do.
Please close "Bug 44218 - Grid additionally shown with Cell borders" if your fix covers that problem.
I'm sorry if I caused some trouble, it was not intended.
Anyway a BIG Thank You to all you people participating and fixing stuff! Your effort can not be estimated highly enough!
EasyHack tags unification: tags only allowed in Whiteboard to make queries more easy and reliable