Libreoffice Calc - relative link to Sheet in formula

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

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 close merge delete