https://bugs.freedesktop.org/show_bug.cgi?id=75168
Priority: medium Bug ID: 75168 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: FILESAVE conditional formating in xlsx format corrupts the file Severity: major Classification: Unclassified OS: Linux (All) Reporter: l...@tajuma.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs