Created attachment 105984 [details]
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 22.214.171.124: http://www.squeezechart.com/calc.png
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 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11 under Ubuntu 12.04 x86
Interestingly LO 18.104.22.168 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?
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.
Excel 2010 says rotation is 17%
(In reply to comment #3)
> Excel 2010 says rotation is 17 degrees
2cb4591ac9908e86e6e0844714ce74f2c5f0d813 is the first bad commit
Author: Bjoern Michaelsen <firstname.lastname@example.org>
Date: Sun Dec 9 13:51:46 2012 +0000
Author: Caolán McNamara <email@example.com>
AuthorDate: Wed May 30 15:39:01 2012 +0200
Commit: Miklos Vajna <firstname.lastname@example.org>
CommitDate: Wed May 30 15:40:50 2012 +0200
don't overload operator-> and just forward specific methods, take two
: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
Remove 'bisected' from Keyword as the commit that caused this regression hasn't been identified yet.
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.
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 ?
I have reverted previous changes and unit test for it.
Please review : https://gerrit.libreoffice.org/#/c/13090/
** I have reverted previous changes and added unit test for it.
Please review : https://gerrit.libreoffice.org/#/c/13090/
Created attachment 113662 [details]
test doc for other bug
Attached document is broken by the patch. I'm not going to accept the patch in its current form as it just reverts another fix.
This issue is still present in LibreOffice 22.214.171.124 alpha tested today
Migrating Whiteboard tags to Keywords: (bibisected)
*** Bug 97988 has been marked as a duplicate of this bug. ***
Steps to reproduce:
1. In Calc or Excel, insert an image
2. Rotate the image
3. Save as XLSX
4. Open in Calc
This import issue affects both Calc and Excel generated XLSX files.
*** Bug 67776 has been marked as a duplicate of this bug. ***
bug is still present - tested with LibreOffice 5.2.1 on Win10_x64
*** Bug 91454 has been marked as a duplicate of this bug. ***
*** Bug 103050 has been marked as a duplicate of this bug. ***
serdarot5 committed a patch related to this issue.
It has been pushed to "master":
fixed image and textbox rotation on xlsx files tdf#83672
It will be available in 6.0.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Build ID: 78960ad06faca055a6d97afbc764c902d5d07f6f
CPU threads: 1; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@39, Branch:master, Time: 2017-08-30_06:31:19
Locale: es-ES (es_ES); Calc: group
@serdarot5, thanks for your work here. Could you please close this as RESOLVED FIXED if your work is done here? Could you also backport it to 5.4?