Issue 114013

Summary:	shortened links in Calc
Product:	Calc	Reporter:	strob <strob08>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P5 (lowest)	CC:	elish, issues
Version:	OOO320m18
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	4.1.0-dev
Developer Difficulty:	---

Description strob 2010-08-20 12:27:58 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?

Comment 1 Edwin Sharp 2013-12-18 16:39:19 UTC

Useful enhancement.