Created attachment 127853 [details] The problematic file The attached Excel 2013 made xlsx file contains a simple image of a left pointing arrow. This is imported correctly but after changing the file a bit (text added to A1) and saving to xlsx it opens as a right pointing arrow.
Created attachment 127854 [details] File modified in Calc 5.3alpha
Created attachment 127855 [details] Screenshot of the files in Calc 5.3alpha
Created attachment 127856 [details] The same files opened in Excel 2013 In Excel the arrow points to the left, but it's left end is still at the place where it's right end should be.
not a new bug. I see the same issue with LibO 5.1.5.2 too under Win8.1 x64 I did not test older branches
Already in 3.3.0. The arrow is also rendered wrong if the file is saved in ODS and reloaded.
in the original file the arrow is pointing to the right and rotated by 180°, thus pointing to the left. This is exported correctly. Open the exported file in excel the arrow still points to the left as attachment 127856 [details] shows. But on opening the exported xlsx file in LO the rotation is not applied like in bug 83672. When saving the file as ods (LO 5.2.6) and reopening the rotation is applied, the arrow points to left. (placement is wrong, though) *** This bug has been marked as a duplicate of bug 83672 ***
Created attachment 161338 [details] The example file in Excel and LO7 Still an issue in: Version: 7.0.0.0.alpha1+ (x64) Build ID: fd238380ae7820f12ac1f7c52d0f7180a93f3ba3 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Duplicate bug was about images, this is a shape with not-imported rotation. I almost forgot about this old one of mine :)
Created attachment 161507 [details] Screenshot of the document after opening and after saving & reopening In current master the arrow direction is correct on opening (after bug #83593 is solved) and saving, but the X and Y position values still get both significantly larger in: Version: 7.1.0.0.alpha0+ (x64) Build ID: 75eeb423196c1e94a0189b7eccff37aed5765853 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Created attachment 161509 [details] Rotation position settings in current master Rotation position also changes dramatically upon save&reload.
Created attachment 161757 [details] Comparison MSO 2010 and LibreOffice 7.1 master after RT The problem is the arrow is pointing left in MSO 2010 while it's pointing right in LibreOffice after rountripping the document
Created attachment 161761 [details] The original and exported file in Excel Rotation looks fine when exported with todays nightly: Version: 7.1.0.0.alpha0+ (x64) Build ID: 59939d2490726336546c7ad05082d23031074e12 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Bibisect-6-5 however does not contain the commit to fix bug #83593 Other things are still happening, like multi-step gradient not being supported. Also on the easier side of problems: - Width changes from 19.21 cm to 18.26 cm - Anchor changes from "Move with cells, but size stays" to "Move and resize with cells" or in XML: <xdr:oneCellAnchor> -> <xdr:twoCellAnchor editAs="twoCell"> - Positioning changes, as if the bottom right corner of the shape became the top left, or in XML: <xdr:from> - <xdr:col>6</xdr:col> - <xdr:colOff>0</xdr:colOff> - <xdr:row>2</xdr:row> - <xdr:rowOff>0</xdr:rowOff> + <xdr:col>17</xdr:col> + <xdr:colOff>181800</xdr:colOff> + <xdr:row>5</xdr:row> + <xdr:rowOff>171720</xdr:rowOff> </xdr:from> and this part appeared too: <xdr:to> <xdr:col>28</xdr:col> <xdr:colOff>363240</xdr:colOff> <xdr:row>9</xdr:row> <xdr:rowOff>152280</xdr:rowOff> </xdr:to>
For the remaining problems we have bug #123330 for shape getting narrower bug #123613 for X/Y position changing dramatically I'm still not sure what's going on with anchors, let's keep this for now as a reminder about that.
*** This bug has been marked as a duplicate of bug 123613 ***