[Solved] Stuck loading excel sheets

Discuss the spreadsheet application

[Solved] Stuck loading excel sheets

Postby streaming » Wed Feb 13, 2019 11:14 am

Hello :)

Just tried to load some excel sheets and it doesn´t work. Normally this is not a problem [I use OO for years now]. That are [xlsx] excel sheets generated by a federal statistic bureau in germany. OO try to open it and get stuck somewhere in the middle of process, using 25% CPU (maybe 1 core). Tried it with 2 separate sheets, downloaded them first [as I most often do; the bigger one was 50MB, the smaller I tested is about 10MB]. Because it failed this time I updated OO to 4.1.6, but nothing changed.

I wonder if there is a new excel version out and incompatible? Or any other known problem?

Apreciate any help :)
Last edited by Hagar Delest on Wed Feb 13, 2019 10:57 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4.1.6 Win7 and Win10
streaming
 
Posts: 5
Joined: Wed Feb 13, 2019 11:04 am

Re: Stuck loading excel sheets

Postby jrkrideau » Wed Feb 13, 2019 2:16 pm

Can you upload a sample or provide a link to the Gov't site so that someone can have a look here.

BTW do you know if your Excel files open in Excel? There is the possibility of a corrupt download.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3682
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Stuck loading excel sheets

Postby John_Ha » Wed Feb 13, 2019 3:34 pm

Try disabling macros - it may be a incompatible macro is looping.

Try converting the .xlsx to a .odt at zamzar.com or similar site.

See [Tutorial] Differences between Writer and MS Word files for a discussion of differences between MS and AOO files - it could be a new feature in the .xlsx file though I would expect AOO just to ignore any such new feature (without telling you :-().
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6592
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Stuck loading excel sheets

Postby streaming » Wed Feb 13, 2019 4:00 pm

I don´t have Excel, so I can´t test ist. The site from where I obtained the sheets is this:

https://statistik.arbeitsagentur.de/nn_ ... rch=Suchen

[the excel symbol right hand side]

I´ll try the recommended converting site! Thanks so far for your replys. :)
Open Office 4.1.6 Win7 and Win10
streaming
 
Posts: 5
Joined: Wed Feb 13, 2019 11:04 am

Re: Stuck loading excel sheets

Postby streaming » Wed Feb 13, 2019 4:14 pm

Zamzar does convert it into .xls but the converted sheet does have errors [fields wich should contain numbers contain "err:504" and "makro??" instead ]. Seems to be a more complicated type of excel sheet. :-/
Open Office 4.1.6 Win7 and Win10
streaming
 
Posts: 5
Joined: Wed Feb 13, 2019 11:04 am

Re: Stuck loading excel sheets

Postby RoryOF » Wed Feb 13, 2019 4:59 pm

Bear in mind that Excel macros will not run on OpenOffice, as there are different underlying engines.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28779
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Stuck loading excel sheets

Postby streaming » Wed Feb 13, 2019 5:04 pm

It was not a problem before. It asked normally [as I open a file] if the content should be updated. So I pressed "no" and it ran fine [I only need the numbers].
Open Office 4.1.6 Win7 and Win10
streaming
 
Posts: 5
Joined: Wed Feb 13, 2019 11:04 am

Re: Stuck loading excel sheets

Postby Villeroy » Wed Feb 13, 2019 5:40 pm

LibreOffice can open and edit the file almost effortlessly. There is a strange warning about too many columns but no sheet (including the 8 hidden ones) goes beyond column U.
https://libreoffice.org is the successor of OpenOffice.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26635
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Stuck loading excel sheets

Postby jrkrideau » Wed Feb 13, 2019 7:59 pm

Hung in Calc, opened but 1st sheet locked in Gnumeric. Gnumeric gave a warning when loading
Code: Select all   Expand viewCollapse view
At A1: ''[2]ZR SGB i Be'!#REF!' Could not find matching closing quote
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3682
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Stuck loading excel sheets

Postby streaming » Wed Feb 13, 2019 9:29 pm

@Villeroy Thanks for the hint about libreoffice. Installed it now and will use it then. :)
Open Office 4.1.6 Win7 and Win10
streaming
 
Posts: 5
Joined: Wed Feb 13, 2019 11:04 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 31 guests