Bug 64228 - Request for Calc: Create a variable name to a cell and reference that name by clicking on it
Summary: Request for Calc: Create a variable name to a cell and reference that name by...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Reference
  Show dependency treegraph
Reported: 2013-05-05 01:14 UTC by Ron
Modified: 2017-07-11 21:55 UTC (History)
1 user (show)

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 Ron 2013-05-05 01:14:39 UTC

I wrote this up a long time ago and forgot to make a feature request. 

Naming cells and clicking cells to retrieve cell name in formula

I like using libreoffice's Calc but one feature that is in Excel but not in Calc is that you can name a cell and enter a formula in another cell by clicking on the named cell.

For example:

A1 contains 5 B1 contains 10 A1 named five B1 named ten

You click on C1, type =, and click on A1, press +, click on B1

In Excel it will display:


In Calc it will display:


I want to keep it with the named cells. I can do so if I manually type it out but it would be easier if I could click on the cell and have it retrieve the cell's name instead of the cell's original reference.


My apologies if someone already requested this feature. I searched and could not find a duplicate.

Comment 1 GerardF 2013-05-05 08:04:02 UTC
It could be a nice feature.
Set to enhancement.
Comment 2 Ron 2013-05-05 22:25:11 UTC
Glad you think so. I hope this feature will be in the next release as it is a very important feature to the students at the University of New Hampshire, specifically civil engineers.

A few of us have already dropped our dependence on Windows but alas some features, albeit small, such as this, drive us to use the Windows computers on campus to take advantage of MS Office. 

Thanks again,
Comment 3 RB 2013-09-10 01:35:51 UTC
Is there any developer interest at all in this simple feature? Or is it just me and a lot of other people who are interested in switching from MS to LO?