[Libreoffice-bugs] [Bug 119035] New: INDIRECT uses R1C1 syntax when uses 2-argument syntax with empty second argument

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119035
           Summary: INDIRECT uses R1C1 syntax when uses 2-argument syntax
                    with empty second argument
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Steps:

1. Put 1 to A1
2. Put `=INDIRECT("A1")` to A2, `=INDIRECT("A1";)` to A3, `=INDIRECT("R1C1")`
to A4, `=INDIRECT("R1C1";)` to A5.

Expected: A2 and A3 should show `1`; A4 and A5 should show #REF! (because in
all formulas, the second parameter is not given, so all formulas should
interpret their strings as using A1 syntax).

Actual: A2 and A5 are `1`, A3 and A4 are #REF!, so when there is an argument
separator present with absent optional second argument, it is treated as 0.

Tested with Version: 6.1.0.2 (x64)
Build ID: b3972dcf1284967612d5ee04fea9d15bcf0cc106
CPU threads: 12; OS: Windows 10.0; UI render: GL; 
Locale: ru-RU (ru_RU); Calc: CL

See INDIRECT documentation:

https://helponline.libreoffice.org/latest/en-US/text/scalc/01/04060109.html#bm_id3153181

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018426_715980110

*But* MS Excel (at least 2016) does the same. So possibly this is intentional
to be compatible (bug-to-bug?).

-- 
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/20180801/4c588699/attachment-0001.html>