To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91146
User amy2008 changed the following: What |Old value |New value ================================================================================ Status|VERIFIED |CLOSED -------------------------------------------------------------------------------- ------- Additional comments from amy2...@openoffice.org Fri Mar 27 03:40:55 +0000 2009 ------- Verified in DEV310m7. Formulas '=INDIRECT("'"&C$1&"'"&"!j"&ROW()+1)' works well in the first tab "Execution Summary" of UDT Test Cases TEST.xls. The nested formulas are on the "Test Case Summary Pass # " tab of the Test Tracking document, under the section called "Roll Up Columns". Specifically the formulas, such as "=IF(AND((ISERROR(SEARCH("Pass",$F8))),(ISERROR(SEARCH ("Warn",$F8))),(ISERROR(SEARCH("Closed",$F8)))),0,1)", work well too. Closing Li Meiying --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org