https://bugs.documentfoundation.org/show_bug.cgi?id=155369
Bug ID: 155369
Summary: Formula Calculation: Indirect() returns #REF!
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dennisfrancis...@gmail.com
Description:
Opening xlsx file with =INDIRECT() formula shows #REF! error instead of actual
value referred.
Steps to Reproduce:
1. Open the attached xlsx file in Calc.
2. Observe the values in F2:F7 in Sheet1.
Actual Results:
The cells in the range F2:F7 shows #REF! error.
Expected Results:
The cells in F2:F7 should be the corresponding values in A2:A7.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: en-US (en_IN); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.2
Calc: threaded
This is also present in the current master build in Linux 64 bit.
--
You are receiving this mail because:
You are the assignee for the bug.
