https://bugs.documentfoundation.org/show_bug.cgi?id=106193
Bug ID: 106193
Summary: Erroneus Formula calculation containing
INDIRECT(ADDRESS()), ending in error value
Product: LibreOffice
Version: 5.2.5.1 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jas.nu...@gmail.com
Description:
I have found that a formula like:
=INDIRECTO(DIRECCION(1;1;;;"Specs"))
produces a #REF! result.
That should be equivalent to:
=INDIRECTO(DIRECCION(1;1;;1;"Specs");1)
which also fails.
However if R1C1 notaition is used, it works fine:
=INDIRECTO(DIRECCION(1;1;;0;"Specs");0)
which produces the right result.
It looks like when the A1 style argument is ommited or set to its default value
(non zero) is not applied correctly.
Steps to Reproduce:
See Description.
Actual Results:
#REF! result
Expected Results:
Actual value of referenced cell
Reproducible: Always
User Profile Reset: No
Additional Info:
After some testing it seems that ADDRESS function is returning the expected
value as described in the help. It looks like INDIRECT function does not work
correctly when A1 style is especified explicitly or by default.
Spreadsheets using this functions become useless due to #REF! values produced.
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:51.0) Gecko/20100101 Firefox/51.0
--
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