https://issues.apache.org/ooo/show_bug.cgi?id=122927
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #21 from Regina Henschel <[email protected]> --- Created attachment 81515 --> https://issues.apache.org/ooo/attachment.cgi?id=81515&action=edit constants and TRUE() and FALSE() with different ways for formatting Hi Oliver, I have applied your patch and build it. I have used the attached file to test it. The ODF part looks good for me: A forced currency format is applied to logical values for constants and for formula result. A format code with text rule shows logical values as string. The ISLOGICAL() test give correct results. The Excel import has this error: A logical constant is imported wrongly. The cell content is =TRUE() instead of constant TRUE and =FALSE() instead of constant FALSE. That is not an error. But despite the formulas =TRUE() and =FALSE(), which should result a logical value, the test ISLOGICAL() results FALSE. To reproduce the Excel import error, save the attached file in *.xls format and reopen it. The error remains, if the *.xls file is opened in Excel 2010 and resaved there. AOO3.4.1 imports logical constants as formulas too, but in AOO3.4.1 the type check with ISLOGICAL() passes. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
