https://bugs.documentfoundation.org/show_bug.cgi?id=157062
--- Comment #3 from Eike Rathke <[email protected]> --- (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.
