Apache OpenOffice (AOO) Bugzilla – Issue 114013
shortened links in Calc
Last modified: 2013-12-18 16:39:19 UTC
In MS Excel a link to a distant cell looks like "[Test.xls]Tabelle1!$B$25". The path to the table is somewhere in the background. In Calc this sort of link always looks like "'file:///path/to/the/document/Test.ods'#$Tabelle1.B25". If you e.g. sum up more of those distant cells, the code in the input line gets longer and after a while it tends to be confusing. Is it possible to get a switch in the options dialog or something to shorten the file-links in Calc's input line?
Useful enhancement.