[Libreoffice-bugs] [Bug 130333] LibreOffice Calc: Invalid reference result from INDIRECT() function when trying to reference a cell in another sheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130333

Kevin Suo <suokunlong at 126.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
                 CC|                            |suokunlong at 126.com
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #1 from Kevin Suo <suokunlong at 126.com> ---
(In reply to Bret Carver from comment #0)

I can reproduce the "#REF!", but this seems to be not a bug.

Steps:
1. Type "A2" in cell A1, sheet1
2. In another sheet, type in the formula "=indirect(<click cell A1 in sheet1>)"

Current Result:
0.
(Since sheet1.A1 is blank, the value 0 is expected).

The "#REF!" error only appears when the referenced cell (i.e., sheet1.A2) does
not contain any valid cell reverence.

版本: 7.0.0.0.alpha0+
Build ID: 0a6ec034dc8088d9de399142bb193ae7d338e645
CPU 线程: 4; 操作系统: Linux 5.4; UI 渲染: 默认; VCL: gtk3; 
区域语言: zh-CN (zh_CN.UTF-8); UI 语言: zh-CN
Calc: threaded

Am I doing something wrong?

I mark this as NEEDINFO. @Bret Carver: Would you please explain further.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200201/25d9d4e7/attachment.htm>