To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86708
------- Additional comments from [EMAIL PROTECTED] Wed Mar 5 18:48:36 +0000 2008 ------- > the problem is that this works under EXCEL Correct. The problem is that this works in Excel. Respectively sometimes it does, and sometimes it gives unexpected results, depending on the locale. For details see http://qa.openoffice.org/issues/show_bug.cgi?id=5658#desc110 and following. > Is there not a possibility to let Oo check the format of the cell when > there is an "IF" statement involved and if the format is explicitely > set to a number format, then not convert to a text format ? There is no conversion to text involved. The result of the formula involving IF() _is_ text. That is what the formula is told to return. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]