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] Thu Mar 20 19:09:55 +0000 2008 ------- Do we really need the formula to be blocked from working at all? What about presenting a dialogue box at the time the formula is entered (e.g. "This formula may contain an error as it multiplies the contents of two cells which are formatted as currency. Edit formula / Ignore warning / Help"), or putting on an error warning note in the same way that Excel does for e.g. inconsistent formulas? There is a flaw in saying that e.g. currency * currency is always invalid. 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. Moreover currency * currency / 1.48 ought to be valid if the 1.48 really refers to a currency. That would be bad spreadsheet design (the 1.48 ought to entered into a cell formatted as currency and then referenced in the formula) but for example students who are just starting to learn how to use Spreadsheets (I teach a lot of them!) often progress gradually from entering formulas without references (e.g. "=2.12*3.57/1.48") to formulas that consist entirely of references, via formulas that contain partly numbers and partly cell references. Using data typing (especially of currencies) to IDENTIFY potential errors is a fantastic idea!! But while it should warn users of the strong possibility of an error I do not believe the formula should be invalidated. --------------------------------------------------------------------- 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]
