https://bugs.documentfoundation.org/show_bug.cgi?id=105811
Bug ID: 105811
Summary: Enhancement to Cell() function
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
What I really want is to be able to pass cell ranges (as opposed to the
contents copied into arrays) around freely between Calc and Basic - but that
would raise HUGE backward-compatibility issues, so I'm quite confident it won't
happen.
(Before I switched to Linux I had rewritten a number of Excel's built-in
functions that return the value of a cell, to instead return the cell.)
As a second choice, can the spreadsheet Cell() function be extended - or
another function created - that will take a cell or range</b> and return its
full name as a string? I don't want to just type the string, because
=SomeFunctionOf(Cell("Range",A1:C5)) is a reference to the indicated cells and
will be re-called if anything in the range changes;
=SomeFunctionOf("Sheet1.A1:C5") is not.
Cell("Address",C5) does this but only for cells, not ranges, and won't include
filename or sheetname unless they are included in the function call. A macro
needs this information as well.
--
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
