https://issues.apache.org/ooo/show_bug.cgi?id=122927
--- Comment #17 from Oliver-Rainer Wittmann <[email protected]> --- My view on this issue: I also figured out that the changes for bug 121126 triggered this issue. The changes for 121126 has two parts. One in the Microsoft Excel binary file format import filter code to not lose format codes on certain cells. The second one is in the cell formatting code and changes AOO formatting behavior regarding boolean values. In Microsoft Excel the user is not able to format a boolean value as a number, date, currency, ..., as far as I have seen. Microsoft Excel treats boolean value as a number in formulas and calculation, but it looks like as it treats it as string/text in the formatting. In AOO until version 3.4.1 can format a boolean value a number or a currency and the corresponding format code is apply to the number interpretation of the boolean value. This AOO formatting behavior has been changed be the fix for bug 121162. Thus, is this formatting change an improvement or a regression? For whose which need to import Microsoft Excel files it is an improvement. For whose who are making use of the AOO boolean formatting capability - like the reporter of this issue - it is a regression. Now, I will have a closer look at Clarence's proposed solution to this dilemma. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
