Created attachment 144514 [details]
Line properties when opening attachment #144508 [details] in Excel and Calc
LibreOffice Calc imports fine, but losts during export the line property of shapes in XLSX files, when the shape was created in Microsoft Excel with default properties. If we change the properties (like thickness or color) of the line, the line is preserved. This bug is most likely related to (or even duplicate of) a similar bug #97057 which causes the theme color to be lost when the shape is saved.
Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel
2. Insert a shape with default properties. Do not change anything after the shape has been inserted!
3. Save the spreadsheet as XLSX and close it. For example: attachment #144508 [details]
4. Open the same file in LibreOffice Calc.
5. Save the file as XLSX and reload it.
Both the background color (as we saw in the bug #97057) and the line properties of the shape are lost.
The line properties should be preserved (and also the background color, although that's a different, but most likely related bug).
Build ID: af579ed7d1482df5cfa7e12e8af2603917d40602
CPU threads: 4; OS: Windows 6.3; UI render: default;
Locale: hu-HU (hu_HU); Calc: CL
Created attachment 144515 [details]
The line properties in Calc-saved attachment #144510 [details]
I can confirm with Version: 220.127.116.11.alpha0+
Build ID: 4b5fcd417587cfb9e6d8b61ecb037ab165eeb5b9
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
I can also reproduce it in
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.10; Render: default;
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
Version 18.104.22.168.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
but not in
bibisect-43max points to 4a969ac35174520f1ffeb4f919f5d7bb6d99a628.
Searching for this hash in Bugzilla points to bug 97057, which makes sense...
Closing as RESOLVED DUPLICATED
*** This bug has been marked as a duplicate of bug 97057 ***
Created attachment 166217 [details]
Extended test file from Excel 2013
Extended the original example file, after seeing attachment #121871 [details] from bug #97057 still missing the line width in Calc.
This has three shapes with 1, 1.5 and 0.5 pt line width coming from the shape theme.
Roundtrip is still not good with:
Version: 22.214.171.124.alpha0+ (x64)
Build ID: a883002d8e2fd77f80c43b7b2e6ac329d83d929d
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Created attachment 166218 [details]
The example file as saved by Calc 7.1 alpha
Created attachment 166219 [details]
attachment #166217 [details] in Excel and Calc - good
Created attachment 166220 [details]
attachment #166217 [details] and attachment #166218 [details] in Excel - good line width
Created attachment 166221 [details]
attachment #166218 [details] in Excel and Calc - bad line width in Calc only
This is like the fill color in bug #124013 - Excel uses the default since the actual theme.xml is missing from the file, while Calc defaults to 0 for all three shapes.