[sc-issues] [Issue 62015] Using empty (null) array in MATCH function crashes application
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62015 User fst changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Mon Mar 13 06:48:53 -0800 2006 --- Hi, checked again with OOo2.0.2 and could not reproduce. No crash. Frank - 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]
[sc-issues] [Issue 62015] Using empty (null) array in MATCH function crashes application
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62015 User fst changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Mon Mar 13 06:49:07 -0800 2006 --- closed wfm - 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]
[sc-issues] [Issue 62015] Using empty (null) array in MATCH function crashes application
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]
[sc-issues] [Issue 62015] Using empty (null) array in MATCH function crashes application
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62015 User hobbsjm changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=34234) Test case to | |demonstrate application | |crash --- Additional comments from [EMAIL PROTECTED] Thu Feb 16 18:16:17 -0800 2006 --- Created an attachment (id=34234) Test case to demonstrate application crash - 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]
[sc-issues] [Issue 62015] Using empty (null) array in MATCH function crashes application
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] Tue Feb 14 00:22:53 -0800 2006 --- Hi, could not reproduce. Please attach a document showing this behaviour. Frank - 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]
[sc-issues] [Issue 62015] Using empty (null) array in MATCH function crashes application
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] Tue Feb 14 15:13:52 -0800 2006 --- I tried typing the following into Cell A1 on Sheet 1 =MATCH(EOMONTH(C17;0);$'Sheet 3'.A1:A10) I then copied to Sheet 2 cell A1 not problems on #ref! displayed. WFM - 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]
[sc-issues] [Issue 62015] Using empty (null) array in MATCH function crashes application
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] Tue Feb 14 19:36:18 -0800 2006 --- Tried reproducing the error again today, just to make sure I hadn't done anything daft, and I can't reproduce the error by just typing the incorrectly referenced array. H... However copying the cell, column, row or sheet containing the formula to a new sheet still causes the application to crash, so I'll do a bit more investigation, maybe with a much simpler spreadsheet, and then forward the (hopefully) simplified document to you. If I can't replicate the problem with a simplified document, I'll attach the original document. - 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]