Created attachment 62629 [details] 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.
The same problem was confirmed in Apache OpenOffice 3.4.0 https://issues.apache.org/ooo/show_bug.cgi?id=119832
Confirmed with: LO 3.5.4.2 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit It is not possible to apply Standard format when cells with different formating are selected.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.