To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89546 Issue #|89546 Summary|=MAX(0,+range) should import as =MAX(0;0+range) Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|jpginn
------- Additional comments from [EMAIL PROTECTED] Fri May 16 07:59:35 +0000 2008 ------- In both Excel and Calc, some functions accept both numbers and ranges, e.g. MAX, MIN, AVERAGE, SUM, COUNT, etc. Named ranges can be used in both Excel and Calc to provide parameters for these functions, and you use a slightly different syntax depending on whether yuo want to pass the range or a single number from the range. In Excel: to pass a range, use: =MAX(1,2,3,RangeName) to pass a number, use: =MAX(1,2,3,+RangeName) In Calc: to pass a range, use: =MAX(1;2;3;RangeName) (i.e. the same) to pass a number, use: =MAX(1;2;3;0+RangeName) (i.e. an extra zero is required) Importing the Excel formula =MAX(1,2,3,+RangeName), Calc receives =MAX(1;2;3;+RangeName). The + is ignored by Calc, and behaviour reverts to passing the whole range. I believe this is a serious error because (unless you get a resulting circularity) it does not show up to the end user. I only found this problem because of the circularity it caused. Jason --------------------------------------------------------------------- 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]
