Bug 107367

Summary:	After upgrade from 5.2.6 to 5.3.2.2, there is a spreadsheet that will not propperly open
Product:	LibreOffice	Reporter:	Jos <josvandervliet>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INSUFFICIENTDATA
Severity:	normal	CC:	miguelangelrv, vsfoote
Priority:	medium
Version:	5.3.2.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Jos 2017-04-23 12:32:15 UTC

Description:
After I've upgraded a spreadsheet (.ods) opens but the content is not showing. The cursor seems very busy and I can't click on anything. After some time there are shown a few cells. The cursor still is busy. I cannot edit anything. After deinstall 5.3.2.2 and reinstall the 5.2.6 version, the file opens ok.
There are other spreadsheets that opens in the new version in the right way. So not all .ods file have that problem

Steps to Reproduce:
1.Open file
2.
3.

Actual Results:  
I only open the .ods file

Expected Results:
Cursor keeps busy. Some cells will show after a wile the contence. After a very long time sometimes the sheet gets complete on the screen but is not to edit because the cursor stays busy.


Reproducible: Always

User Profile Reset: No, because not all .ods files experience that problem.

Additional Info:
Almost all .ods files contains graphics. In the problemfile there are no links to other sheets etc.
I've installed the 64 bit version of both versions.


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0

Comment 1 m_a_riosv 2017-04-23 13:30:55 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.

If it doesn't solve the issue, please can you attach a test file where to reproduce the issue.

Comment 2 V Stuart Foote 2017-04-23 14:10:50 UTC

Please post a screen clip of the problem spreadsheet open in 5.3.2.2 so we can see the issue you are having.