Apache OpenOffice (AOO) Bugzilla – Issue 119832
If different format in cells, Standard format not applied to all of them in 1 action
Last modified: 2012-06-11 03:05:39 UTC
Created attachment 78059 [details] Example file with different cell formats 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.
I can reproduce it upon aoo 3.4 The high-lighted format is incorrect when user selects cells of different number format. when the number format of the selected cells are different, "General" will be high-lighted in the numbers tab of "Format cells" dialog, in regardless what the real formats are. then, when user want to set all those cells to "General" format, he may click OK button directly, but, no "dirty" information detected, and thus no changes be taken... in Excel 2010, if the number format of the selected cells are different, nothing will be highlighted when launching the format dialog and there will be no such a problem.