Bug 127817 - Excel XML format will not load if a color is included in the style declaration <s:Font s:Color="Red"/>
Summary: Excel XML format will not load if a color is included in the style declaratio...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.1.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-27 09:23 UTC by Rolf
Modified: 2019-09-30 13:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rolf 2019-09-27 09:23:48 UTC 
Description:
If you try to open an excel XML doc that has styles defined that include color it will not open and gives the input/output error. In addition it also ignores all style declarations.

Steps to Reproduce:
1.Create a suitable XML document and save;

<?xml version='1.0'?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
<ss:Styles>
	<ss:Style ss:ID="myTitles">
		<ss:Font ss:Color="Red"/>
	</ss:Style>
</ss:Styles>
<ss:Worksheet ss:Name="Sheet1">
        <ss:Table>
            <ss:Row>
                <ss:Cell ss:StyleID="myTitles">
                    <ss:Data ss:Type="String">First Name</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Last Name</ss:Data>
                </ss:Cell>
                <ss:Cell>
                    <ss:Data ss:Type="String">Phone Number</ss:Data>
                </ss:Cell>
            </ss:Row>
        </ss:Table>
    </ss:Worksheet>
</ss:Workbook>

2.Save as test.xls

3.Attempt to open in Libre office

Actual Results:
You get a general error, general input/output error

Expected Results:
Should open and obey the style declarations


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Oliver Brinzing 2019-09-28 12:28:31 UTC 
reproducible with:

Version: 6.3.2.2 (x64)
Build-ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

but *not* reproducible with:

Version: 6.4.0.0.alpha0+ (x64)
Build ID: 71ef762f21ada8c25aad2183065478171e985e8c
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded
Comment 2 Xisco Faulí 2019-09-30 13:40:05 UTC 
The orcus package has been upgraded on master, and with that, this issue is now fixed -> https://cgit.freedesktop.org/libreoffice/core/commit/?id=56ffe3c0a1261cd98a3d42b8b08d5f8eb013ead4
The fix will be available in LibreOffice 6.4