Bug 45977

Summary:	Sometimes it is not possible to select cells to enter into formula by mouse click
Product:	LibreOffice	Reporter:	andis.lazdins
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	andis.lazdins, bfo.bugmail, sasha.libreoffice
Priority:	medium
Version:	3.5.0 release
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description andis.lazdins 2012-02-12 22:35:44 UTC

For instance, when I enter '=if(A1="";A2;A3)', I select specified cells by mouse click. Sometimes, not from the beginning of formula, but usually somewhere in the middle, formula in the Formula bar stops to update, but continues to update in the tip, which appears beside the edited cell. When I press Enter at the end, the formula is not completed and ends at that place, where it stopped to update in the Formula bar. The only way to complete formula is to write it manually. Sometimes, not sure if always, formula bar continues to update, if I cut / paste certain formula elements in cell (not in formula bar), for instance, cut / paste 'A2' from the formula above.

Unfortunately I can't repeat this behaviour with fresh files. It seems that it happens occasionally and complexity of formulas is not a source of the problem.

OS Ubuntu 11.10, LibreOffice 3.5RC3

Comment 1 sasha.libreoffice 2012-05-17 07:11:36 UTC

Thanks for bugreport
Please, verify if in last version of LibreOffice still reproducible

Comment 2 andis.lazdins 2012-05-17 07:20:01 UTC

I think this problem is gone; however, it happened occasionally. I will come back to this later, when I will use 3.5 or newer version on regular basis.

Comment 3 bfoman (inactive) 2012-07-18 08:53:17 UTC

Do not hesitate to reopen if this bug is reproducible with the latest stable release and a test case can be created.

Comment 4 andis.lazdins 2012-07-18 10:28:46 UTC

I didn't meet this bud any more, I guess it is gone and can be closed.