https://bugs.documentfoundation.org/show_bug.cgi?id=132136
--- Comment #9 from Wolfgang Jäger <[email protected]> --- (In reply to Eike Rathke from comment #8) > Yes, displayed formulas are generated from tokens and from a sheet reference > index the current sheet name is obtained. No, making a SHEETNAME() volatile > isn't wanted because that would trigger recalculation on _any_ modification > and we already have more of that than wanted. >From my experience: The next to only reason for what users assume a function SHEETNAME() to be needed (or is UDFed) is the the intention to use the ADDRESS() function of which the OPTIONAL parameter "SHEET" only accepts names and even converts numbers to "enapostrophed" text. The rtesulting address is then generally used as the argument for INDIRECT(). If ADDRESS() also accepted a sheet number as returned by SHEET() and converted it to the sheet's name for displaying the result, the problem would vanish. Much better, of course, would be an enhanced OFFSET.aaa() function with a SHEET argument used with NUMBERs (whether or not supporting cuboids). -- You are receiving this mail because: You are the assignee for the bug.
