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.
Bug present since 3.5.0.
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.
same problem for 3.5.1-1 on arch linux 64 bit.
Probably duplicate of Bug 46809. Please, try version 3.5.2 RC2.
hello Dave Amos:
I can’t reproduce this bug anymore with LibreOffice 220.127.116.11 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 ***