LibreOffice Calc fails to load spreadsheets after upgrade to Windows 8.1

users
#1

After upgrading Windows 8 Pro 64-bit to Windows 8.1, Calc will open with a
blank spreadsheet but will freeze (Not Responding) when doing a Load
Document. The spreadsheet grid turns into a gray pane, probably system
theme. The Menu bar (File, Edit, etc.) is at the top but unresponsive. The
Status bar at the bottom only shows Load Document. Only the Minimize button
on the Title bar at the top works. It has run at least 60 minutes in this
state with the turning circle. The only way to exit is click on the Close
button and select Close the program (the other option to select is Wait for
the program to respond) or go to the Task Manager to force close the
program. All my .ods spreadsheets normally open within 10 seconds. A new
file is left behind that ends in .ods# and when LibreOffice is opened it
asks me if I want to recover files. How do I get my computer to open Calc
spreadsheets once again. I am heavily dependent on printing out
spreadsheets in my personal life and use them to store my personal data
without using paper copies. I can no longer lookup information I need.
This happened while using version 4.1.2. The same thing happens with
versions 4.0.6, 4.1.1, and 4.1.3.

#2

reverting not an option?

Also, maybe it's I/O related. Does this happen if you move a file elsewhere
(other drive, USB thumbstick, network share...) and try to open it from
there? Trying this might help finding the cause of the problem (or provide
a temporary workaround)

#3

Hi Gabriel,
  I copied my spreadsheets folder to my namespace with the same result.  The same happens with an old USB thumb drive.  The only other drive I have currently is an external backup drive that I am unwilling to endanger as I am in the process of moving to a new case and want to get 8.1 working before I complete the process.

Alan

#4

Hi Gabriel,
  I have LibreOffice 4.1.3.2 Calc opening and printing spreadsheets again a short time ago.  I might have had 2 or 3 problems causing this.  The last problem I solved this afternoon was PDFs did not print.  I found this out using the Gnumeric spreadsheet program which can open .ods files. Gnumeric uses PDFs as print previews and on my computer they open in Adobe Reader.  I found my printer no longer worked with Adobe Reader after the upgrade to Windows 8.1.  After removing the Samsung ML-2955ND printer and 4 or 5 tries installing to get the test page to print I was in business.  On a whim yesterday I removed the multiple versions of Microsoft Visual C++ 2005 & 2008 Redistributable that had been installed by programs and only kept the most recent.  That allowed me this morning to open a spreadsheet a couple of times out of a few attempts without freezing though both tries to print froze Calc.  I also gave full security access yesterday to
the 4 users (I only have 1 user/login) which might or might not have had anything to do with this.
Thanks for your help

Alan