Bug 55737 - Names of cells when clicking on it
Summary: Names of cells when clicking on it
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL: http://youtu.be/KMdN0EA3pq8
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
Reported: 2012-10-07 18:30 UTC by Maximilian Schaar
Modified: 2019-11-29 13:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Maximilian Schaar 2012-10-07 18:30:32 UTC
please look youtube video, libreoffice calc dont know the absolute relation to cells:
Comment 1 Roman Eisele 2012-10-11 09:44:20 UTC
(Bug not yet confirmed, reset Status to UNCONFIRMED as appropriate.)
Comment 2 Maximilian Schaar 2012-10-11 20:29:51 UTC
why is the bug unconfirmed?
Comment 3 Roman Eisele 2012-10-12 06:34:56 UTC
Because it was not yet confirmed by an independent reviewer ;-) Believe it or not, it takes some time to reproduce a bug, check for duplicates, etc. ...
Comment 4 Roman Eisele 2012-10-13 08:23:55 UTC
Thank you very much for your enhancement request,
especially for the nice screencast!

Confirmed the behaviour visible in the screencast with LibreOffice
and with a current Master build (LOdev; build ID: 1ae1bca;
pull time: 2012-10-09 04:37:06).

There are two issues here:

1) If you enter a formula and click on some named cell, LibreOffice inserts
   the address of the cell you clicked on into the formula;
   but it would be preferrable that it inserted the name of the named cell
   instead, just like Excel does.

2) As the screencast shows, the calculation of the derived cells below
   works different in LibreOffice Calc than in MS Excel.
   Do you mean this by “libreoffice calc dont know the absolute relation
   to cells”?

While (1) is obviously a valid enhancement request, (2) is not evident; could you (because you seem to have more experience here) please explain in detail
why the behaviour of LibreOffice Calc is wrong, i.e. why you would expect that
Calc should behave like Excel here? (OK, maybe this is a very stupid question,
but it is always good to know exactly what exact behaviour the reporter of a bug expects ;-)

Thank you in advance!
Comment 5 Ron 2012-12-30 05:03:35 UTC
Hi, yes this would be a great feature! I was just realizing how much of a pain it is to type it in instead of clicking on the cell to retrieve its name!

What version will this be added to? Hopefully the upcoming 4.0 release!
Comment 6 QA Administrators 2013-09-24 01:48:10 UTC Comment hidden (obsolete)
Comment 7 Maximilian Schaar 2013-09-24 09:42:59 UTC
I think there are enough informations now!
Comment 8 Marco Ciampa 2013-10-15 21:27:49 UTC
Confirmed behaviour as an indipendent observer... :-)
Comment 9 Sahasranaman M S 2016-01-12 03:27:59 UTC
If we click on a single cell while entering a formula,  it should use the cell's name in case of a named cell.  If we select a range,  then it should ignore the named cell and use the cell range only.

Is this how it is supposed to behave?
Comment 10 Xisco Faulí 2019-11-29 13:27:23 UTC
Changing priority back to 'medium' since the number of duplicates is lower than 5