To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94419
------- Additional comments from [EMAIL PROTECTED] Mon Sep 29 19:53:32 +0000 2008 ------- Can confirm that: = <some cell with currency> + IF(1; <some cell with currency> ;0) => currency, BUT = <some cell with currency> + IF(1; 0 ;0) => NO CURRENCY The currency is not inherited IF adding a non-currency using IF()! Please note, IF adding non-currency directly, currency IS still inherited! Though, avoiding the inheritance is in my opinion desirable, allowing to implement *type checking* later on. However, the situation should be consistent, and: = <some cell with currency> + non-currency should NOT inherit the currency, as opposed to the current implementation! Having a type _0_currency_ is warranted in these situations, to ease the use of IF() clauses. discoleo -> chuv In order to make the formula work, you should rewrite the "0" inside the IF() clause as: 0 * <any cell with currency>. The result will be still 0, BUT will inherit the currency. Tested on OOo-dev3 m29 --------------------------------------------------------------------- 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]