https://bugs.freedesktop.org/show_bug.cgi?id=75168
Priority: medium
Bug ID: 75168
Assignee: [email protected]
Summary: FILESAVE conditional formating in xlsx format corrupts
the file
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Saving conditional formating in xlsx format with "formula is" condition does
not properly escape xml-characters in the formula.
Steps to reproduce:
1. Create new empty spreadsheet
2. Cursor in A1, open conditional formating dialog (Format / Conditional
Formatting / Conditional... )
3. In the dialog, select "Formula is" and enter "A1 <> 0"
4. Press OK to dismiss the dialog
5. Save file in xlsx format
Expected behaviour:
File can be opened with Excel.
Current behaviour:
Inside the xlsx file xl/worksheets/sheet1.xml is not valid a xml file as it
contains
...
<conditionalFormatting sqref="A1">
<cfRule type="expression" priority="2" aboveAverage="0" equalAverage="0"
bottom="0" percent="0" rank="0" text="" dxfId="0">
<formula>A1<>0</formula>
</cfRule>
</conditionalFormatting>
...
i.e. the formula tag contains unescaped < and > chars.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
