Bug 143738 - feature request: support for double line display shapes such as excel
Summary: feature request: support for double line display shapes such as excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: XLSX-Shapes
  Show dependency treegraph
Reported: 2021-08-05 03:37 UTC by qve00761
Modified: 2022-07-21 23:11 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Double Line Test data (9.06 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-08-05 03:39 UTC, qve00761
Snapshot in EXCEL (19.95 KB, image/png)
2021-08-05 03:40 UTC, qve00761

Note You need to log in before you can comment on or make changes to this bug.
Description qve00761 2021-08-05 03:37:43 UTC
In Excel straight line data, line attributes include not only style settings and line width settings, but also multiple line display attribute items.
Since LibreOffice does not have this function, the straight line that was displayed as a double line in EXCEL is displayed as a single line.

Steps to Reproduce:
1) Read the attached file with LibreOffice.
2) The straight line that was displayed as a double line in EXCEL is displayed as a single thick line.

Actual Results:
Double-line display attribute information is invalid in CALC.

Expected Results:
It is displayed as a double line.

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x86) / LibreOffice Community
Build ID: b89ebf135818ccaa45bbfb164099a6e199bd7d11
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: threaded
Comment 1 qve00761 2021-08-05 03:39:14 UTC
Created attachment 174093 [details]
Double Line Test data
Comment 2 qve00761 2021-08-05 03:40:03 UTC
Created attachment 174094 [details]
Snapshot in EXCEL
Comment 3 m_a_riosv 2021-08-05 15:59:58 UTC
Even it is not selectable with LO
Version: (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL
Comment 4 Julien Nabet 2021-08-05 20:24:43 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.
xl/drawings/drawing1.xml contains this (after having "beautified" it:
     16     <xdr:cxnSp macro="">
     17       <xdr:nvCxnSpPr>
     18         <xdr:cNvPr id="3" name="直線コネクタ 2" />
     19         <xdr:cNvCxnSpPr />
     20       </xdr:nvCxnSpPr>
     21       <xdr:spPr>
     22         <a:xfrm>
     23           <a:off x="822960" y="830580" />
     24           <a:ext cx="5379720" cy="2247900" />
     25         </a:xfrm>
     26         <a:prstGeom prst="line">
     27           <a:avLst />
     28         </a:prstGeom>
     29         <a:ln w="50800" cmpd="dbl" />
     30       </xdr:spPr>

Regina: any thoughts here?
I mean, we indeed can't do it even when trying modifying line once the file is opened. So perhaps not even in odf specs and completely exclusive to Excel?
Comment 5 Regina Henschel 2021-08-05 21:44:26 UTC
(In reply to Julien Nabet from comment #4)
> Regina: any thoughts here?
The relevant ODF attribute is draw:stroke and that has only "none", "dash" and "solid". The double-lines which you notice on table cells are fo:border in ODF, and fo:border can have more line styles.

It is formally possible to use fo:border instead of draw:stroke or in addition to it. Writer frames use fo:border. I think, it would be a large effort to support it for shapes too.

Similar request is in https://bugs.documentfoundation.org/show_bug.cgi?id=124186.
Comment 6 Gabor Kelemen (allotropia) 2022-07-21 23:11:22 UTC
This is pretty similar to bug 127389, but let's keep this open for xlsx-specific bits (if any... but probably there would be).