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
Please attach a file allowing to do tests with other versions and OS. Best regards. JBF
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.
(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
Created attachment 61201 [details] screen print from the Excel Live app
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?? ;)
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
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
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)
I confirm, I do not reproduce anymore with LibreOffice 4.4.2.0.0+. Best regards. JBF