To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62015
------- Additional comments from [EMAIL PROTECTED] Thu Feb 16 18:11:10 -0800 2006 ------- I've created a simplified spreadsheet to check the problem and can reproduce the error. The simplified formula can be found in cell E3 on the 'December 2005' sheet and is: =IF(EOMONTH(A8;0)>=Savings.G6;INDEX(Savings.K6:K15;(MATCH(EOMONTH(A8;0);Savings.G6:G15)));0) This formula evaluates succesfully on the 'December 2005' sheet, but if you attempt to copy this sheet and insert it after the 'December 2005' sheet the application will crash. More thorough testing has shown that it's not the MATCH function alone that's causing the problem, but its interaction with the logic comparison, since making either the Savings.G6 or the Savings.G6:G15 references absolute eliminates the problem. Hence, only the following two combinations of relative references cause the crash: =IF(EOMONTH(A8;0)>=Savings.G6;INDEX(Savings.K6:K15;(MATCH(EOMONTH(A8;0);Savings.G6:G15)));0) and =IF(EOMONTH(A8;0)>=Savings.G6;INDEX($Savings.K6:K15;(MATCH(EOMONTH(A8;0);Savings.G6:G15)));0) It is also possible to cause the application to crash by editing the formula directly on the 'December 2005' sheet and changing the formula to reference the 'Investments' sheet (which has no data in the cells G6:G15) rather than the 'Savings' sheet, namely: =IF(EOMONTH(A8;0)>=Investments.G6;INDEX(Savings.K6:K15;(MATCH(EOMONTH(A8;0);Investments.G6:G15)));0) Hitting return to accept this change will crash the application. Interestingly, if you edit the 'Savings' sheet and delete the data in cells G6:G15 (the cells being referenced on the 'December 2005' sheet) this does not cause the application to crash, but results in the formula evaluating to #N/A. Also, changing the logic test to check a different cell on the 'Savings' sheet eliminates the problem, e.g. =IF(EOMONTH(A8;0)>=Savings.A6;INDEX(Savings.K6:K15;(MATCH(EOMONTH(A8;0);Savings.G6:G15)));0) /* Valid date in cell Savings.A6 or =IF(EOMONTH(A8;0)>=Savings.A16;INDEX(Savings.K6:K15;(MATCH(EOMONTH(A8;0);Savings.G6:G15)));0) /* Empty cell Savings.A16 It would appear that the problem is only occuring when the logic test and MATCH function are referencing some of the same (empty) cells on the 'Savings' sheet, so it seems probable that it's the code that evaluates the formula that's causing the problem, rather than the MATCH function itself. It's also possible that this problem may affect other combinations of functions in a similar manner, but I haven't had time to check this. Apologies for the slightly premature earlier post. Hope this helps. --------------------------------------------------------------------- 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]
