Is there any way to create relative link to other Sheet in formula? I need the formula, that point always to right of current Sheet, independently of it’s name. Another needs is “current + 2”, “current -1”, etc.
So I want something like =A1+{'CurrentSheet'+1}.A1 and =A1+{'CurrentSheet'-2}.A1 but can’t find how to do this. Is this feature exist in LibreOffice or OpenOffice?