Bug 83672 - FILEOPEN: PNG image not rotated in XLSX file created with MSO 2010
Summary: FILEOPEN: PNG image not rotated in XLSX file created with MSO 2010
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: bibisected
Keywords: bisected, regression
Depends on:
Blocks:
 
Reported: 2014-09-09 13:48 UTC by squeezechart
Modified: 2014-11-14 13:53 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:


Attachments
demo.xlsx (84.56 KB, application/excel)
2014-09-09 13:48 UTC, squeezechart
Details

Description squeezechart 2014-09-09 13:48:04 UTC
Created attachment 105984 [details]
demo.xlsx

when opening this XLSX the picture shadow is displayed without gradient and image is not rotated (lion)

spreadsheet opened in Excel 2010: http://www.squeezechart.com/excel.png
spreadsheet opened in alc 4.3.1.2: http://www.squeezechart.com/calc.png
Comment 1 ign_christian 2014-09-09 15:30:43 UTC
Hi again.. Thanks for the report. Since gradient issue has been reported in another bug, lets focus only in not rotated picture.

After unzip the file, I saw the picture is PNG and created with Excel 2010 (14.0300). Don't know if it's the same behavior with another image format.

Confirm reproduced with LO 4.3.1.2, 4.2.6.3, 4.0.6.2, 3.5.7.2 under Ubuntu 12.04 x86

Interestingly LO 3.3.0.4 loaded that image rotated with rotation angle: 343,18 degrees.
But AOO 4.1.1 loaded the image with 338,80 degrees rotation angle and -7,96 degrees slant angle.

Could you check what is the correct angle with Excel?
Comment 2 ign_christian 2014-09-09 15:38:03 UTC
WPS (Kingsoft) Office 2014 tells that image has 16 degrees rotation, which is reversed interpretation compared to LO. Perhaps it's the same interpretation with MSO.
Comment 3 squeezechart 2014-09-09 15:58:57 UTC
Excel 2010 says rotation is 17%
Comment 4 squeezechart 2014-09-09 16:00:57 UTC
(In reply to comment #3)
> Excel 2010 says rotation is 17 degrees
Comment 5 raal 2014-10-17 15:06:07 UTC
2cb4591ac9908e86e6e0844714ce74f2c5f0d813 is the first bad commit
commit 2cb4591ac9908e86e6e0844714ce74f2c5f0d813
Author: Bjoern Michaelsen <bjoern.michaelsen@canonical.com>
Date:   Sun Dec 9 13:51:46 2012 +0000

    source-hash-8201c8a5f680947c2e855504be321afb1e5bc06a
    
    commit 8201c8a5f680947c2e855504be321afb1e5bc06a
    Author:     Caolán McNamara <caolanm@redhat.com>
    AuthorDate: Wed May 30 15:39:01 2012 +0200
    Commit:     Miklos Vajna <vmiklos@suse.cz>
    CommitDate: Wed May 30 15:40:50 2012 +0200
    
        don't overload operator-> and just forward specific methods, take two
    
        Change-Id: If66b0a5f1b0444d8f0a6dfed1b518a0033d61d2e

:100644 100644 f7eccba8d9d5410eeab71c5acf79c4d2e6b8449c faa7d863ad4ade674a03609cc200c69fda050c1d M	autogen.log
:100644 100644 c85daa88476345c0555b5f9ea43fe0a7a9b8012d 7c3f1c10099a1e77c75d8c323d8e6295bd47b297 M	ccache.log
:100644 100644 cea91907e28915818f74122300db370eb990341a 218e49c35131771ba71114a16318edc6eaef370b M	commitmsg
:100644 100644 c046b97495b3688a1b5cbbf74949f8f4c19a1eaa c5b0700c952f25b36471d31a1786cb02443b6d05 M	dev-install.log
:100644 100644 0dbf90a5cd9517d1abfd637bf2a44c6f19740cd2 230d287ab3ea7f81c9336f25b34bb1022042ec67 M	make.log
:040000 040000 644bb0dcdb4ade848eb9829bd5b0334e019cfe62 e405a43d5fd63d8092b82b27563db5efe6070954 M	opt

 git bisect log
# bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e
# good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932
git bisect start 'latest' 'oldest'
# bad: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb
git bisect bad e02439a3d6297a1f5334fa558ddec5ef4212c574
# bad: [8f4aeaad2f65d656328a451154142bb82efa4327] source-hash-1885266f274575327cdeee9852945a3e91f32f15
git bisect bad 8f4aeaad2f65d656328a451154142bb82efa4327
# good: [369369915d3582924b3d01c9b01167268ed38f3b] source-hash-45295f3cdceb4c289553791071b5d7f4962d2ec4
git bisect good 369369915d3582924b3d01c9b01167268ed38f3b
# bad: [6fce03a944bf50e90cd31e2d559fe8705ccc993e] source-hash-47e4a33a6405eb1b5186027f55bd9cb99b0c1fe7
git bisect bad 6fce03a944bf50e90cd31e2d559fe8705ccc993e
# good: [8a39227e344637eb7154a10ac825d211e64d584c] source-hash-f5080ebb7022c9f5d7d7fdca4fe9d19f9bb8cabf
git bisect good 8a39227e344637eb7154a10ac825d211e64d584c
# good: [e4c742a9e244bd7ebeabc50c90182df28ac3daaf] source-hash-c52ba433491afbca70aa1977a624c795bdd5b9ef
git bisect good e4c742a9e244bd7ebeabc50c90182df28ac3daaf
# bad: [a71a4447320f177181c9cff9f7c6fd93802cbd8e] source-hash-9afb6e1e38c362a768e8e981f7b03cf8bcaf22cf
git bisect bad a71a4447320f177181c9cff9f7c6fd93802cbd8e
# bad: [0a0d80b18dc905ee56faaad81c2d6839f8e0172d] source-hash-4ba8147f61fadb4e8ae7abc0ad5c9e928edf4baa
git bisect bad 0a0d80b18dc905ee56faaad81c2d6839f8e0172d
# bad: [2cb4591ac9908e86e6e0844714ce74f2c5f0d813] source-hash-8201c8a5f680947c2e855504be321afb1e5bc06a
git bisect bad 2cb4591ac9908e86e6e0844714ce74f2c5f0d813
# good: [ef67f79d5c082070b3185286da0bacd714bb61b4] source-hash-099198a4224778fe6e43f5dc13b5b9b1b4dc828c
git bisect good ef67f79d5c082070b3185286da0bacd714bb61b4
# first bad commit: [2cb4591ac9908e86e6e0844714ce74f2c5f0d813] source-hash-8201c8a5f680947c2e855504be321afb1e5bc06a
Comment 6 Xisco Faulí 2014-10-20 09:25:10 UTC
Remove 'bisected' from Keyword as the commit that caused this regression hasn't been identified yet.
Comment 7 Sushil Shinde 2014-11-14 10:08:24 UTC
I think this is regression because of this change set http://cgit.freedesktop.org/libreoffice/core/commit/?id=1abc0695d770eebd21256a86aeee14a5384d84c7


This issue is duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=67776.
Comment 8 Xisco Faulí 2014-11-14 13:52:54 UTC
I do confirm that 1abc0695d770eebd21256a86aeee14a5384d84c7 introduced this regression. I add 'bisected' to Keyboard.
Last commit from Noel was on 2014-02-03 so I'm not sure he's still involved in the project to take a look...
@Mmeeks: Do you have access to bnc#762542 ?


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.