https://bugs.documentfoundation.org/show_bug.cgi?id=132136
Bug ID: 132136
Summary: The reference via the ADDRESS function should also
work with the table number.
Product: LibreOffice
Version: 7.0.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
With the function =INDIRECT(ADDRESS(1,1,,, "Sheet1")) I can reference the cell
A1 in the worksheet "Sheet1". But if I don't know beforehand what a user of the
Calc document will call the worksheet, I can't create formulas for example to
collect data.
It should be possible that I can also reference with the table number. For
example: =INDIRECT(ADDRESS(1,1,,,1)).
When I enter a text, the table name should be used, when I enter a number, just
use the table number.
This means the table number which I can read with =SHEET(). What else is this
function for? I can't work with this table number anywhere else.
It would be nice if my wish could be considered.
Stay healthy!
Actual Results:
Expected Results:
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
