https://bz.apache.org/ooo/show_bug.cgi?id=126915
Issue ID: 126915
Issue Type: DEFECT
Summary: Display error on the cell when opening a sheet with no
update option if the cell refers to a lookup range
that is on an non existing worksheet.
Product: Calc
Version: 4.1.2
Hardware: PC
OS: All
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Created attachment 85402
--> https://bz.apache.org/ooo/attachment.cgi?id=85402&action=edit
attached files in a zip file
This happens when opening a worksheet (in xlsx format) with Calc (I tried both
4.1.0 & 4.1.2, Traditional Chinese)under Windows XP SP3 & Windows 7 Pro TC x64
SP1. The original equation changed to "=vlookup(C$1:C$1048576;;23;0)" (attached
'vlookuperror-01.jpg')from "=VLOOKUP(C:C,'<FOLDER REFERENCE>[<FILE
REFERENCE>]<SHEET REFERENCE>'!$A$1:$W$129,23,FALSE)" (attached
'vlookuperror-03.jpg') and lost its cached value. The attached
'vlookuperror-02.jpg' shows the result from Excel viewer.
It would be good if the cell can at least show the cached value and the best
points to the same range even if it is not exists.
--
You are receiving this mail because:
You are the assignee for the issue.
