Bug 135828 - FILESAVE XLSX Rotated arrow shapes height and width swapped
Summary: FILESAVE XLSX Rotated arrow shapes height and width swapped
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:7.1.0
Keywords: filter:xlsx
Depends on:
Blocks: OOXML-Shapes
  Show dependency treegraph
 
Reported: 2020-08-17 08:47 UTC by NISZ LibreOffice Team
Modified: 2021-09-01 12:42 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file with rotated arrows (10.11 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-17 08:47 UTC, NISZ LibreOffice Team
Details
The original file saved by Calc (6.46 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-17 08:47 UTC, NISZ LibreOffice Team
Details
Screenshot of the original and exported document side by side in Excel (159.39 KB, image/png)
2020-08-17 08:48 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-08-17 08:47:35 UTC
Created attachment 164368 [details]
Example file with rotated arrows

Attached example file contains some drawing shapes rotated in various angles.
When this file is saved in Calc as XLSX and is reopened the shapes height and width is swapped in some angle ranges, but not in others.

Steps to reproduce:
    1. Open attached file in Calc
    2. Save as XLSX, reopen in Excel

Actual results:
Some of the arrows have their width and height values swapped.

Expected results:
Arrows retain their height and widht.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: <buildversion>
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
(nightly from 08-13)

In older versions import was similarly bad, too:
Verzió: 6.4.0.3 (x86)
Build az.: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: alapértelmezett; VCL: win; 
Területi beállítások: en-US (hu_HU); Felület nyelve: hu-HU
Calc: CL
Comment 1 NISZ LibreOffice Team 2020-08-17 08:47:57 UTC
Created attachment 164369 [details]
The original file saved by Calc
Comment 2 NISZ LibreOffice Team 2020-08-17 08:48:13 UTC
Created attachment 164370 [details]
Screenshot of the original and exported document side by side in Excel
Comment 3 Commit Notification 2020-08-24 16:29:10 UTC
Szabolcs Toth committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/5e8875780d665b7ae0fee1a053b5ce78ec513f69

tdf#135828 XLSX shape export: fix distortion of rotated shapes

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 4 NISZ LibreOffice Team 2020-09-14 07:34:32 UTC
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 34a09c9c61bff30e8c4d16132bb47b2b1b16e422
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded