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.