[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

--- Comment #8 from Geza  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

eisa01  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #7 from eisa01  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

--- Comment #6 from QA Administrators  ---
** 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

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

Julien Nabet  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #5 from Julien Nabet  ---
(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 :-(

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

--- Comment #4 from Julien Nabet  ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

--- Comment #3 from Geza  ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

Julien Nabet  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO
 CC||serval2...@yahoo.fr

--- Comment #2 from Julien Nabet  ---
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?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97515] FILEOPEN XLSX cell backgrounds shift

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=97515

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #1 from m.a.riosv  ---
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:
-
-
$B2="x"


-
-
$D1="x"


-
-
$A2="x"


-
-
$C2="x"


-
-
#ref!



-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs