Apache OpenOffice (AOO) Bugzilla – Issue 111250
VLOOKUP crashes OOo in particular documents
Last modified: 2017-05-20 09:58:40 UTC
I have upgraded (fresh install) to ooo 3.2 on XP SP2. I work on same files as edited in previous versions of ooo. The VLOOKUP works only when the sourse file in in the same worksheet, otherwise it crashes. I have teste in: - but also in .xls and .ods - ooo 2.0 (OK xls/ods) and 3.2(CRASH xls/ods - PC desktop + laptop
Spreadsheet component.
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
Created attachment 69170 [details] Pls see my comment
Created attachment 69187 [details] it contains xls + jpg
Created attachment 69188 [details] Description
Product/Version/Component:In which product did you find the issue? OpenOffice.org Calc Original Filename scalc.exe Internal Name scalc File Version 3.02.9476 (3.2.9476.500) Product Version 3.02.9476 (3.2.9476.500) Company Name OpenOffice.org File Description OpenOffice.org Calc Copyright Copyright © 2009-2010 by Sun Microsystems, Inc. File Name scalc.exe File Path C:\Program Files\OpenOffice.org 3\program\ Type Portable Executable (32-bit) File Attributes Archive Creation Time 2010-02-01, 21:10:14 Last Write Time 2010-02-01, 21:10:14 File Size 305152 Bytes (298.0 KBytes) Platform: On which hardware platform did you find this issue? (e.g., Sun, PC) Property Value Manufacturer Micro-Star International Product Name CX600 Version Ver 1.000 Machine Type AT/AT COMPATIBLE Infrared (IR) Supported No Manufacturer motherboard MICRO-STAR INTL CO., LTD Model MS-1682 Version Ver 1.000 Serial Number BSS-0123456789 North Bridge SiS 671/FX/DX/MX Revision 00 South Bridge SiS 968 Revision 00 CPU Intel(R) Core(TM)2 CPU T6500 @ 2.10GHz Cpu Socket Socket P (478) System Slots 1 PCI, 1 AGP Memory Summary Maximum Capacity 4096 MBytes Maximum Memory Module Size 2048 MBytes Memory Slots 2 Error Correction None DMI System UUID 00000000-00000000-00000024-216C6B7D UUID 00000000-0000-0000-0000-0024216C6B7D Disk Space Disk C: 39 GB Available, 75 GB Total, 39 GB Free Disk D: 99 GB Available, 99 GB Total, 99 GB Free Disk E: 97 GB Available, 99 GB Total, 97 GB Free Disk F: 59 GB Available, 60 GB Total, 59 GB Free Disk G: 7252 MB Available, 61444 MB Total, 7252 MB Free Disk H: 69 GB Available, 70 GB Total, 69 GB Free Physical Memory 3072 MB Total, 2170 MB Free Memory Load 29% Virtual Memory 7003 MB Total, 5895 MB Free PageFile Name C:\pagefile.sys PageFile Size 4092 MB In use 338 MB Max used 340 MB Registry Size 4 MB (current), 120 MB (maximum) Profile GUID {b813de40-34e1-11df-a8d0-806d6172696f} The system clock interval 15 ms OS: On which Operating System (OS) did you find this issue? (e.g. Linux, Windows NT) Name Windows XP Professional Service Pack 3 Features Terminal Services in Remote Admin Mode, Multiprocessor Free, OEM-Version Activation Status Activated Checked Build No Boot Device \Device\HarddiskVolume1 System Device \Device\HarddiskVolume1 Kernel Version 5.1.2600.5938 Security 128 bits, 40 bits Product Name Microsoft Windows XP Build Lab 2600.xpsp_sp3_gdr.100216-1514 Hardware DEP Available Yes DEP for 32 Bits Applications Yes DEP for Drivers Yes DEP Policy OptIn (only Windows system binaries) Windows Update's version number 7.4.7600.226 Language English (United States) Installation Time 2010-03-21 12:17:36 Boot Time 2010-04-30 08:30:20 Up Time 3 Hours 31 Minutes 26 seconds How important is the issue? Defect: VLOOKUP crashes the files that work fine in previous versions Resolution Priority: How urgent is a fix required? 1. being an important formula (for me at least), it is very important. Who will be following up on the issue? Assigned To: Which engineer should be responsible for fixing this issue? spreadsheet (spreadsheet) Cc: Who else should receive e-mail updates on changes to this issue? mru@openoffice.org rainerbielefeld@openoffice.org What else can you tell the engineer about the issue? please see attached files Summary: How would you describe the issue, in approximately 60 or fewer characters? Working in a spreadsheet previously created with ooo2.2 with VLOOKUP, it crashes both in .ods and .xls. Moreover, when recovers experience same thing ... crashes. Downgraded back to ooo2.2 everything's just fine. Description: What else can you tell the engineer about this issue? please see attachement For crashing issues it might help to have additional information in case you're able to provide that: please see attachement Attachments. gestiune.zip
This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download Please report back the outcome of your testing, so this Issue may be closed or progressed as necessary - otherwise the issue may be Resolved as Invalid in the future.
Cannot reproduce. Tried with AOO 3.4.1 on Windows 7. 1) Detached files from ZIP in first attachment (Pls see my comment) 2) Verified operation of VLOOKUP in sample1.ods, the file with local VLOOKUP 3) Loaded ssample2.ods. Changed value of cell from 1 to 2 to 3. It worked for 1 and 2, but not 3. Then noticed that the formula was not specify the same range as sample1.ods, so updated it to: =VLOOKUP(A1;'file:///C:/testkit/sample1.ods'#$Sheet1.D2:E101;2) 4) At that point the formula calculated correctly.