https://bugs.documentfoundation.org/show_bug.cgi?id=132136
Wolfgang Jäger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #5 from Wolfgang Jäger <[email protected]> --- As compared to the soulution by a BASIC UDF above workarounds -even if again supported by user code- are complicated and error-prone. There are lots of similar solutions around. Well the minimal solution isn't eligible for array-evaluation, but this should be another easy hack. Why anymore talk about workarounds? Are there stringent reasons to not create the new function? I can't see one except the need to find a "sustainable" name which is not in conflict with related functions of competitors where compatibility should not be endangedered. A conceivable alternative would be to give the SHEET() function an optional second pparameter. If it is missing (or 0) the function works as usual. With argument 1 in this position it returns the exact name of the sheet, with 2 the apostrophe-written name. The sheet itself is given then either by a reference in the first place, or by the 1-based index. -- You are receiving this mail because: You are the assignee for the bug.
