https://issues.apache.org/ooo/show_bug.cgi?id=122927
--- Comment #22 from Oliver-Rainer Wittmann <[email protected]> --- (In reply to Regina Henschel from comment #21) > Created attachment 81515 [details] > 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. > Thanks for the testing and the feedback. > 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. This import behavior has not been changed in AOO 4.0.0. It also occurs in OOo 3.3.0 and AOO 3.4.1 > AOO3.4.1 imports logical constants as formulas too, but in AOO3.4.1 the type > check with ISLOGICAL() passes. This seems to be also triggered by the changes made for bug 121126. @Regina: Please submit a separate issue for it. Thanks in advance. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
