Description: 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: 7.3.0.0.alpha0+ (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
Created attachment 174093 [details] Double Line Test data
Created attachment 174094 [details] Snapshot in EXCEL
Even it is not selectable with LO Version: 7.1.5.2 (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
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?
(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.
This is pretty similar to bug 127389, but let's keep this open for xlsx-specific bits (if any... but probably there would be).