https://bugs.documentfoundation.org/show_bug.cgi?id=130333
Kevin Suo <suokunl...@126.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
CC| |suokunl...@126.com
Status|UNCONFIRMED |NEEDINFO
--- Comment #1 from Kevin Suo <suokunl...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs