Bug 49572 - FORMATTING: missing grid on specific cells
Summary: FORMATTING: missing grid on specific cells
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: x86 (IA32) Windows (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-07 01:56 UTC by faxiomas
Modified: 2015-03-01 11:53 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
screen print showing the bug (376.05 KB, image/jpeg)
2012-05-07 01:56 UTC, faxiomas
Details
The original file which gave me problems (27.48 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-05-07 14:32 UTC, faxiomas
Details
screen print from the Excel Live app (384.66 KB, image/jpeg)
2012-05-08 00:46 UTC, faxiomas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description faxiomas 2012-05-07 01:56:35 UTC
Created attachment 61117 [details]
screen print showing the bug

When opening .xlsx files the empty cells don't show the cell's graphic limits and appear completely blank, the cells with a number 10 inside lose their format and color
Comment 1 Jean-Baptiste Faure 2012-05-07 03:09:41 UTC
Please attach a file allowing to do tests with other versions and OS.

Best regards. JBF
Comment 2 faxiomas 2012-05-07 14:32:44 UTC
Created attachment 61192 [details]
The original file which gave me problems

The original file which gave me problems, here it is: nothing exciting but hope it'll be useful somehow.
Comment 3 Jean-Baptiste Faure 2012-05-08 00:32:45 UTC
(In reply to comment #2)
> [...]
> The original file which gave me problems, here it is: nothing exciting but hope
> it'll be useful somehow.

Thank you very much. Did you see how it looks in MS-Excel 2007 or 2010 ?
Did you play with the most right button on the second toolbar on your screen copy ?

Best regards. JBF
Comment 4 faxiomas 2012-05-08 00:46:19 UTC
Created attachment 61201 [details]
screen print from the Excel Live app
Comment 5 faxiomas 2012-05-08 00:49:07 UTC
Hi . Please note that I don't have Office as a desktop software, but I'm able to load that file into the Excel Live app, as you can see from the attachment. And no, I didn't use anything, just opened the file and I was like wtf??
;)
Comment 6 QA Administrators 2013-05-26 22:31:29 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 7 Jean-Baptiste Faure 2013-05-27 04:41:02 UTC
Hi Markus,

I am afraid that it's one for you: there is a conditional formatting on cell containing the number 10 (column Level). The data are integer but the condition is defined with a decimal number. If you replace 10 by 10,0 in a cell, the conditional formatting works as expected. 
Tested on LO 4.0.4.0+ (Build ID: 5d174f282fadd52f11105e53a816e35e627dd72) on Xubuntu 12.04

About the problem of "graphic limits of the cells" it is a problem with the use of the grid. most right button on the formatting toolbar and using the right option to have the grid visible in colored cells.

Best regards. JBF
Comment 8 Julien Nabet 2015-03-01 10:17:26 UTC
On pc Debian x86-64 with LO Debian package 4.3.3.2, I don't reproduce this.
I put it as WFM.

faxiomas/Jean-Baptiste: don't hesitate to reopen this tracker if you can reproduce this with a recent LO version (4.3.6 or 4.4.1)
Comment 9 Jean-Baptiste Faure 2015-03-01 11:53:20 UTC
I confirm, I do not reproduce anymore with LibreOffice 4.4.2.0.0+.

Best regards. JBF