To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111250
User rainerbielefeld changed the following: What |Old value |New value ================================================================================ CC|'' |'rainerbielefeld' -------------------------------------------------------------------------------- Keywords| |needmoreinfo, oooqa -------------------------------------------------------------------------------- Priority|P1 |P3 -------------------------------------------------------------------------------- Summary|VLOOKUP error |VLOOKUP crashes OOo in par | |ticular documents -------------------------------------------------------------------------------- ------- Additional comments from rainerbielef...@openoffice.org Thu Apr 29 11:42:21 +0000 2010 ------- NOT reproducible with my own test kit and "Ooo-Dev 3.3 multilingual version English UI WIN XP: [DEV300m77 (Build 9496)]" or "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]"! My test: 0. unzip my attached "testkit.zip" 1. open "sample1.ods" 2. modify 'A2' (for sources in same sheet) or 'A8' for sources in sheet2 both worked fine for me 3. open "sample2.ods 4. Modify 'A1' to show contents from "sample1.ods" 10. close both documents (do not save) 11. redo from step 3 should also work fine It seems that the problem occurs only for particular documents? Not P1 with obsolete OOo version @sambadi: May I ask you to read read our guidelines on <http://qa.openoffice.org/issue_handling/pre_submission.html> and <http://www.openoffice.org/bugs/bug_writing_guidelines.html> before you file further issues or post again here? Then select correct information for all Issue Tracker selection fields, contribute a clear step by step instruction containing all observations (error messages ...), _every_key_press_and_every_mouse_click_ how to reproduce the problem, and explain why you believe that your results are unexpected. That means (for example): do not write something like "I am not able to ...", but 6. left mouse click on … expected: …, color of … changes, … actual: no …., color remains white, no … Screenshots might help to explain the problem. Please - always specify your OOo download source, version (pls. check!), localization, OS and Platform you used for your tests! - attach a sample document (always with ODF source document)! - Always contribute a meaningful Summary --------------------------------------------------------------------- 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