https://bugs.freedesktop.org/show_bug.cgi?id=62732
Priority: medium
Bug ID: 62732
Assignee: [email protected]
Summary: EDITING: INDIRECT function to build access to a cell
on another sheet results in #REF! error
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Indirect function does not seem to work in Calc but does work in Excel
Steps to reproduce:
1. I have the formula =INDIRECT($N$5&"!Q16") in a cell, and $N$5 contains
"2012" which is the name of another sheet, and cell 2012!Q16 contains an
integer, Calc gives me a "#REF!" error. M$ Excel correctly grabs the number in
Q16 on sheet 2012 for further calculation.
Current behavior: #REF! error
Expected behavior: Should result in the contents of the cell
Could the problem be due to confusion whether 2012 is a string or an integer?
Operating System: Windows 7
Version: 3.6.5.2 release
--
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
