Libreoffice Calc - relative link to Sheet in formula [closed]

asked 2015-04-20 08:47:30 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-20 12:14:16.999535