Bug 46117 - EDITING: changes to formulae by clicking in a cell not shown in formula bar
Summary: EDITING: changes to formulae by clicking in a cell not shown in formula bar
Status: RESOLVED DUPLICATE of bug 46809
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.1 release
Hardware: All All
: high major
Assignee: Not Assigned
Keywords: regression
Depends on:
Reported: 2012-02-15 08:29 UTC by dww
Modified: 2012-08-23 15:08 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 dww 2012-02-15 08:29:54 UTC
Normally it is possible to edit an equation  by pointing and clicking on cells.
(1) type =
(2) click in cell A1
(3) type +
(4) click in cell A2

... the formula =A1+A2 is shown in the formula bar and applied to the active cell once <enter> is hit or <tick> is pressed.


If while entering a formula the user clicks in the formula bar to move the cursor location (for example, to enter text in the middle of an existing equation) this ceases to work.  Specifically clicking in a cell fails to update the text shown in the formula bar even though it does change the formula saved once <enter> is hit. 

Minimal method to reproduce bug:

(1) active cell is A3
(2) type = 1 + + 2
(3) click between the two +'s in the formula bar to edit the mistake in this equation
(4) click in cell A1
**** no change is shown in formula bar ****
(5) hit <enter>
**** contents of cell A3 are now = 1 + A1 + 2 *****

If at step (4) user click multiple times in A1 because they do not see anything happening, the cell reference will be added multiple times to the formula.
Comment 1 ilalmara 2012-03-16 00:35:20 UTC
Bug present since 3.5.0.
Comment 2 Juan 2012-03-21 03:46:56 UTC
It happens the same to me, I've tested on Libreoffice 3.5.0 and 3.5.1 on Ubuntu 11.10 and 12.04.
Comment 3 Dave Amos 2012-04-02 07:08:29 UTC
same problem for 3.5.1-1 on arch linux 64 bit.
Comment 4 vitriol 2012-04-02 07:21:16 UTC
Probably duplicate of Bug 46809. Please, try version 3.5.2 RC2.
Comment 5 Roman Eisele 2012-08-23 15:08:23 UTC
Hello dww,
hello ilalmara,
hello Juan,
hello Dave Amos:

I can’t reproduce this bug anymore with LibreOffice on MacOS X 10.6.8 (Intel), and therefore I think that vitriol’s suggestion (comment #4) was right: this bug was a duplicate of bug 46809, which was fixed in LibreOffice 3.5.2.

Therefore I mark this bug actually as a duplicate of bug 46809. This means that the present bug report is closed.

If any of you can still reproduce this issue with LibreOffice 3.5.6 or 3.6.x, feel free to open this bug report again, and please give an exact description what is necessary to reproduce this bug with LibreOffice 3.5.6 or 3.6.x.

Thank you very much!

(Just for the record:
This was a regression, cf. comment #1, therefore added keyword "regression";
and this was not only a MacOS X problem, cf. comment #2 and comment #3, therefore changed Platform to "All".)

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