https://bugs.freedesktop.org/show_bug.cgi?id=65371

          Priority: medium
            Bug ID: 65371
          Assignee: [email protected]
           Summary: Conditional Formatting not saved in .xls format
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: x86 (IA32)
            Status: UNCONFIRMED
           Version: 4.0.4.1 rc
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 80306
  --> https://bugs.freedesktop.org/attachment.cgi?id=80306&action=edit
Spreadsheet with Conditional Formatting

Windows XP SP3

LibreOffice 4.0.4.1 RC1


In a spreadsheet with conditional formatting that is saved as an .xls, the
formatting adds twelve decimal points to the number when reopening the file.
The original spreadsheet that was created in Excel 2003 shows conditional
formatting style "Excel_CondFormat_1_2_1". If the file is saved as an .ods file
it works fine.

I created a new conditional formatting style that had no decimal places with
red text. I named this style "Format1". The cells changed as expected, but when
the file was saved and reopened, the conditional formatting style returned to
"Excel_CondFormat_1_2_1" with twelve decimal points added to the number.

Attached is a spreadsheet that can be used to verify this behavior.

-- 
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

Reply via email to