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

             Bug #: 50760
           Summary: If different format in cells, Standard format not
                    applied to all of them in 1 action
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.4 release
          Platform: x86 (IA32)
        OS/Version: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: [email protected]
        ReportedBy: [email protected]


Created attachment 62629
  --> https://bugs.freedesktop.org/attachment.cgi?id=62629
Example file with different cell formats

there is an xls file with 4 cells of the following format

cell A1, category Number, format -1234.12
cell A2, category Number, format Standard
cell A3, category Number, format Standard
cell A4, category Number, format -1234.12

Standard format options:
fractional part - 0
leading zeros - 1
Format code - Standard

-1234.12 format options:
fractional part - 2
leading zeros - 1
Format code - 0,00

If we select all four cells and try to apply Standard format to all them,
everything will remain in original places. Cells A1 and A4 have -1234.12
format. But if we change format to any other, and then to Standard, then all
will be applicable.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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