Bug 101099

Summary:	EDITING: UI freeze when entering a formula
Product:	LibreOffice	Reporter:	Björn Martin <documentfoundation>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	aron.budea, ilmari.lauhakangas, miguelangelrv
Priority:	medium
Version:	5.1.4.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Björn Martin 2016-07-24 16:01:10 UTC

After creating a new sheet with very few cells that just contain text I added the first formula into cell F2:

=E2*1,19

Just calculcate the gross value of a net value. This caused the UI to freeze and not recover (I waited for a few minutes the first time this happened).

Later I tried a simpler formula in cell E2:

=D2+C2

Same thing, the application freezes.

I can reproduce this every time.

Just did a fresh install of v5.1.4.2 on Windows 10. Java is installed as JDK 1.8.0_102, 64 bit, with NO public JRE.

Comment 1 Björn Martin 2016-07-24 16:03:05 UTC

Just did a re-test with RC version 5.2.0.3 and it's fixed there.

And another bit of information: I ran the application in German in both cases. Just in case German had a number formatting problem with . and , maybe.

Comment 2 m_a_riosv 2016-07-24 21:52:35 UTC

Please try resetting the user profile, sometimes solves strange issues.
https://wiki.documentfoundation.org/UserProfile
Usually it's enough renaming/deleting the file "user/registrymodifications.xcu",  it affects all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.

Comment 3 Aron Budea 2016-07-25 04:38:28 UTC

Unchecking 'Tools -> Options... -> LibreOffice -> OpenCL -> Allow use of OpenCL' and 'Allow use of Software Interpreter (even when OpenCL is not available)' and restarting LibreOffice might also be worth a try.

Comment 4 Buovjaga 2016-07-29 07:22:31 UTC

Yep, as the problem is not present on the same computer with 5.2.0.3, it really seems like some transient glitch.
Björn: do you agree to close this as WORKSFORME?

Comment 5 Björn Martin 2016-08-02 04:50:22 UTC

Yep, I agree, it's fixed in version 5.2.0.3.

I hope other users won't have to wait too long for 5.2 to become the primary download suggestion on http://www.libreoffice.org/