You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/04/10 13:23:25 UTC
[Issue 126915] New: 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.
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: issues@openoffice.apache.org
Reporter: guychan@grandcomputech.com.hk
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.
[Issue 126915] 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.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126915
--- Comment #2 from Guy Chan <gu...@grandcomputech.com.hk> ---
Created attachment 85404
--> https://bz.apache.org/ooo/attachment.cgi?id=85404&action=edit
vlookuperror-02.jpg result from Excel viewer
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126915] 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.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126915
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
Status|UNCONFIRMED |RESOLVED
Resolution|--- |DUPLICATE
--- Comment #4 from oooforum (fr) <oo...@free.fr> ---
Already reported
*** This issue has been marked as a duplicate of issue 20495 ***
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126915] 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.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126915
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
Severity|Major |Normal
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126915] 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.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126915
--- Comment #3 from Guy Chan <gu...@grandcomputech.com.hk> ---
Created attachment 85405
--> https://bz.apache.org/ooo/attachment.cgi?id=85405&action=edit
vlookuperror-03.jpg result from Excel 2007 (orignal equation shown)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126915] 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.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126915
--- Comment #1 from Guy Chan <gu...@grandcomputech.com.hk> ---
Created attachment 85403
--> https://bz.apache.org/ooo/attachment.cgi?id=85403&action=edit
vlookuperror-01.jpg, the result from Calc 4.1.2
--
You are receiving this mail because:
You are the assignee for the issue.