https://bugs.documentfoundation.org/show_bug.cgi?id=96666
Bug ID: 96666
Summary: EDITING: Address Function incorrectly resolves when
Sheet names is given to #REF
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When trying to obtain the address using the following function:
=INDIRECT(ADDRESS(2,1, ,1,"Sheet1"))
I see a problem when the Formula Syntax is set to "Calc A1" between 4.7 and
5.0. Tools -> Options : LibreOffice -> Formula -> Formula Syntax = "Calc A1"
My file has two sheets:
Sheet1
Sheet2
In Sheet1 I have the following content in Column A
| Column A | Column B |
|----------|----------|
| Bob | |
| Mary | |
On Sheet2, I have the following functions
| Column A | Column B |
|----------|--------------------------------------|
| Mary | =INDIRECT(ADDRESS(2,1, ,1,"Sheet1")) |
| Bob | =INDIRECT(ADDRESS(2,1, ,1,)) |
In Version 4.7, the results on Sheet2 are
| Column A | Column B |
|----------|----------|
| Mary | Mary | <--- Expected Value
| Bob | Bob |
In Version 5.0, the results on Sheet2 are
| Column A | Column B |
|----------|----------|
| Mary | #REF | <--- HERE is the Error
| Bob | Bob |
I have confirmed this with version 5.0.3.2 and 5.0.4.2. I do not know if it is
in the 5.x code base.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
