Created attachment 122336 [details] sample xlsx file and two screenshots I received an xlsx file. When I opened it in LO, the gray background of the cells were shifted by one row downwards compared to what I get in MS Excel 2013. I prepared a reduced file to show the situation, please find it in enclosed zip: XLS3.xlsx I also enlosed screenshots of Excel 2013 on Windows 8.1 and LibreOffice 5.0.4002 on Mac OS X 10.10.5.
Hi Geza, seems the issue is with Conditional Formatting, some address are wrong in it opening in LibreOffice. conditions for multiple ranges seems not well imported. In the original file: -<conditionalFormatting sqref="G2:H1048576"> -<cfRule dxfId="0" text="" rank="0" percent="0" bottom="0" equalAverage="0" aboveAverage="0" priority="2" type="expression"> <formula>$B2="x"</formula> </cfRule> </conditionalFormatting> -<conditionalFormatting sqref="F2:I2;F1;F3:J1048576"> -<cfRule dxfId="1" text="" rank="0" percent="0" bottom="0" equalAverage="0" aboveAverage="0" priority="3" type="expression"> <formula>$D1="x"</formula> </cfRule> </conditionalFormatting> -<conditionalFormatting sqref="H2:H1048576"> -<cfRule dxfId="2" text="" rank="0" percent="0" bottom="0" equalAverage="0" aboveAverage="0" priority="4" type="expression"> <formula>$A2="x"</formula> </cfRule> </conditionalFormatting> -<conditionalFormatting sqref="G2:H1048576"> -<cfRule dxfId="3" text="" rank="0" percent="0" bottom="0" equalAverage="0" aboveAverage="0" priority="5" type="expression"> <formula>$C2="x"</formula> </cfRule> </conditionalFormatting> -<conditionalFormatting sqref="F1;F2:J1048576"> -<cfRule dxfId="4" text="" rank="0" percent="0" bottom="0" equalAverage="0" aboveAverage="0" priority="6" type="cellIs" operator="notEqual"> <formula>#ref!</formula> </cfRule> </conditionalFormatting>
On pc Debian x86-64 with LO Debian package 5.1.4, I don't reproduce this and have exactly the Excel result. Could you please give a try with last stable LO version 5.1.4?
I tested LibreOffice Calc 5.1.4 on both Windows 8.1 and OS X 10.11.5 by opening the same XLS3.xls file enclosed in the original bug report. The result is still wrong in LibreOffice Calc 5.1.4.2 as it was in LO 5.0.4: the cells F4:J6 have gray background. Only those cells marked by a letter 'G' have to have gray background (F3:J5) as in Excel 2013 (15.0.4823.1000). If there is an 'x' in column D, the cells in the same row (from column F to J) have to have gray background. Instead, the cells in the next row become gray.
(In reply to Geza from comment #3) >... > Only those cells marked by a letter 'G' have to have gray background (F3:J5) > as in Excel 2013 (15.0.4823.1000). If there is an 'x' in column D, the cells > in the same row (from column F to J) have to have gray background. Instead, > the cells in the next row become gray. I must have missed this, I'll try to retest this.
(In reply to Julien Nabet from comment #4) > (In reply to Geza from comment #3) > >... > > Only those cells marked by a letter 'G' have to have gray background (F3:J5) > > as in Excel 2013 (15.0.4823.1000). If there is an 'x' in column D, the cells > > in the same row (from column F to J) have to have gray background. Instead, > > the cells in the next row become gray. > > I must have missed this, I'll try to retest this. Indeed, I supposed I compared with LO screenshot by mistake. Sorry for the noise :-(
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170901
This renders correctly for me now Version: 6.0.0.0.alpha1+ Build ID: 7e03c4eed72452fdfb87341214a21956c08ba969 CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2017-10-25_23:45:02 Locale: en-US (en_US.UTF-8); Calc: group
Hereby I confirm that this bug does not appear on my system any more: LibreOffice_5.4.2_MacOS_x86-64.dmg Version: 5.4.2.2 Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU threads: 8; OS: Mac OS X 10.10.5; UI render: default; Locale: en-US (en.UTF-8); Calc: group LibreOffice versions tested: 5.1.4: wrong 5.2.6: wrong 5.3.3: wrong 5.4.1: Fixed 5.4.2: Still OK Computer: Macmini6,2 OS X 10.10.5 (14F2511) Thank you for fixing this bug. Geza