To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79924
------- Additional comments from [EMAIL PROTECTED] Sun Apr 27 21:25:53 +0000 2008 ------- > currency * currency / currency ought to be valid (it could be used > e.g. in various rescaling calculations) so therefore by extension the > (yucky!) (currency * currency) / currency ought to be as well While "currency * currency / currency" is valid as it returns currency, this does NOT justify "currency * currency". During my years of Auditing / Quality Control involving spreadsheets I found way too many errors to be comfortable with such formulas. As said, IF the whole formula was written within one cell, NO error would be raised. Strong typing would still found that the result is "currency", so NO error. [Although I do not encourage such usage.] IF however, one cell contains "currency * currency", then this is at least bad design. IF the student needs a conversion factor (please note, I do teach spreadsheets, too), then the correct way is to define it somewhere like: = currency / currency which is a scalar [ I may add, that this definition should proceed in a special area of the spreadsheet, for which I posted a new feature request: http://www.openoffice.org/issues/show_bug.cgi?id=67499 ] Multiplying with this scalar is OK and never would raise an error. Also, I advocate introducing beyond the generic currency, more specific currencies and handle conversions on a higher - more structure - level. [see the FURTHER DEVELOPMENT in my first post] I was also NOT very explicit about raising errors for valid operations, even IF the result is a bogus unit: > 2. (currency) * (currency) (see statistics comment; maybe allowing > this operation, BUT IF the cell formatting has UNIT<currency>, > raise an ERROR) However, in the meantime, I am even less convinced that "currency * currency" should be accepted without raising some error/warning. The only argument against is the variance, which has a valid unit of "currency * currency" in this example. --------------------------------------------------------------------- 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]
