Bug 107257 - Default to Use Absolute Reference to Sheet Name for Cell Reference to Another Sheet
Summary: Default to Use Absolute Reference to Sheet Name for Cell Reference to Another...
Status: CLOSED DUPLICATE of bug 90799
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2017-04-19 05:36 UTC by Kevin Suo
Modified: 2017-04-19 16:14 UTC (History)
0 users

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2017-04-19 05:36:13 UTC
Because of Bug 85538, cell referencing between different sheets is a nightmare in LibreOffice - under the default behaviour, when you set the reference to another sheet and then copy/move the sheet to a new file, the data gets messed up as the default behaviour uses relative reference. 

This enhancement request is to request libreoffice by default will use absolute reference (i.e., add a "$" mark before the sheet name). This will retain the data when move/copy sheets, and also retain the "feature" of relative reference between sheets.

Steps to Reproduce:
1. New Calc, type 1 in A1 of Sheet1.
2. Add Sheet2, in Sheet2.A2 type in "=", then click Sheet1.A1.

Current behaviour: 
formula shows as "=Sheet1.A1"

Expected behaviour: 
formula shows as "=$Sheet1.A1" (i.e., $ is added before the name of sheet).
Comment 1 Kevin Suo 2017-04-19 09:57:59 UTC
There are many duplicates in bug 85538. 
I think it is this bug which makes many of the advanced spreadsheet users (like me) mad when using LibreOffice Calc.
Comment 2 Eike Rathke 2017-04-19 16:14:36 UTC
Unnecessary to submit yet another duplicate.

*** This bug has been marked as a duplicate of bug 90799 ***