[Libreoffice-bugs] [Bug 157062] There should be a version of OFFSET() allowing for an offset concerning the sheet index.
https://bugs.documentfoundation.org/show_bug.cgi?id=157062 --- Comment #3 from Eike Rathke --- (In reply to ady from comment #2) > there is not standardized name format for worksheets That wouldn't matter though, as a reference internally resolves to numeric (absolute or relative) values, including the sheet, so $Sheet1.$A$1 (with Sheet1 being the first sheet) points to a cell (0,0,0) and with a sheet-offset of +1 could point to (1,0,0). A tricky part would be scenarios, as they are managed as hidden sheets, e.g. for Sheet1 with one scenario the scenario would be a second related sheet and a following Sheet2 would internally be the third sheet (can easily be seen in the Navigator and with =SHEET(Sheet2.A1) that results in 3), so (0,0,0) +1 sheet would not be (1,0,0) but (2,0,0) instead. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157062] There should be a version of OFFSET() allowing for an offset concerning the sheet index.
https://bugs.documentfoundation.org/show_bug.cgi?id=157062 --- Comment #2 from ady --- FWIW... Using relative addresses for worksheets would be a solution for some use-cases without needing a new function. That would not be the same exact method as "pointing to the next/prior Nth worksheet" (similar to the offset addressing), but still. Regarding cell addresses vs worksheet addresses, the former are always named in a standard way (A1 or R1C1, and their respective absolute and relative notations), whereas the later are not; there is not standardized name format for worksheets). I assume this would be an important factor to consider for such suggested "offset-like" function, and (probably) it would be one important reason for the difficulties to precisely define the function and its arguments. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157062] There should be a version of OFFSET() allowing for an offset concerning the sheet index.
https://bugs.documentfoundation.org/show_bug.cgi?id=157062 Stéphane Guillou (stragu) changed: What|Removed |Added CC||er...@redhat.com, ||stephane.guillou@libreoffic ||e.org Whiteboard| QA:needsComment| --- Comment #1 from Stéphane Guillou (stragu) --- Thanks for the suggestion, Wolfgang. For a workaround, not sure if this works for you: https://stackoverflow.com/questions/45807823/using-offset-with-a-3d-range-range-across-multiple-sheets Sounds like a pretty niche use, but what do you think, Eike? I haven't really delt with new function requests before. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157062] There should be a version of OFFSET() allowing for an offset concerning the sheet index.
https://bugs.documentfoundation.org/show_bug.cgi?id=157062 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157062] There should be a version of OFFSET() allowing for an offset concerning the sheet index.
https://bugs.documentfoundation.org/show_bug.cgi?id=157062 Wolfgang Jäger changed: What|Removed |Added CC||j...@psilosoph.de Summary|Thereshould be a version of |There should be a version |OFFSET() allowing for an|of OFFSET() allowing for an |offset concerning the sheet |offset concerning the sheet |index. |index. -- You are receiving this mail because: You are the assignee for the bug.