Ask Your Question
0

Can't open .xlsx in Calc

asked 2012-02-20 18:13:48 +0200

hngw47 gravatar image hngw47
1 1 1 1

updated 2013-02-03 10:20:45 +0200

qubit gravatar image qubit flag of United States
5721 3 48 41

I have installed LibreOffice 3.5.0rc3 replacing 3.4.5. Now I can't open xlsx-files. I could open them with version 3.4.5. When I'm trying to open the file I get a message "General Error / General input/output error" and when I press the only button "OK" the file isn't opened.

delete close flag offensive retag edit

14 Answers

Sort by » oldest newest most voted
2

answered 2012-02-21 16:20:03 +0200

webmink gravatar image webmink
126 6

I was able to open sample .xslx files in v3.5 (I tried just now), which suggests your problem is specific to either your computer's configuration or to the files you are using. It may be a bug in LibreOffice, but without more information we'll not know.

Please can you be more specific about the problem? We will need to know the operating system you're using (including the hardware type if your platform has any choices of CPU) and we will need a sample .xslx file that fails on your computer but is OK for all of us to test.

link delete flag offensive edit
2

answered 2012-02-21 14:10:51 +0200

cloph gravatar image cloph
2812 4 18 44

suggestions to narrow down the problem:

  • check the java settings in Tools|Options → LibreOffice → Java (and restart LibreOffice)

if that doesn't help

and try again.

link delete flag offensive edit
0

answered 2013-02-21 23:34:09 +0200

RedbeardinTC gravatar image RedbeardinTC
1

I'm having problems with a .xlsx too, using 3.6.2.2 (on Ubuntu 12.10).

I ended up installing gnumeric to open the file. I saved it as an .ods and then was able to open it fine with LibreOffice.

link delete flag offensive edit

Comments

Hi @RedbeardinTC,

Any chance that you could file a bug about this problem and attach a copy of an xlsx file that LO can't open? Those kinds of files can be VERY helpful in helping us track down compatibility issues. Thanks!

qubit ( 2013-02-22 06:06:08 +0200 )edit
0

answered 2012-09-12 08:48:13 +0200

jack_ gravatar image jack_
1 1

updated 2012-09-12 09:41:48 +0200

I can confirm that still on build 3.6.1.2 I cant open XLSX file created in Report Builder 3.0 [sql 2012] build 11.0.2100.60.

I receive input/output error.

Already tried with newest Java and already recreated new profile. Nothing helps.

Windows 7 x64, Java 7,0 update 7. i5-2500, 8GB RAM.

Below link to sample file: http://www.smallfiles.org/download/2152/sample.xlsx.html

link delete flag offensive edit

Comments

The joke is that it was repaired on version 3.6.2, but now with v. 3.6.3.2 again i have the same error.

jack_ ( 2012-11-20 13:20:40 +0200 )edit
0

answered 2012-10-11 01:30:02 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2012-10-11 01:30:02 +0200

Marcelo García gravatar image Marcelo García
1

Hi, the same happens with version 3.6.2, the last release. General input/output error. In my case, a reporting tool (birt) generates the xls output. With small files (500 rows) it works fine, but with files larger than 1000 rows, it crashes. Help please! Thanks!

link delete flag offensive edit
0

answered 2012-09-12 09:24:16 +0200

prax gravatar image prax
1

I tried opening an xlsx file and it crashed in LibreOffice, the version I am using is 3.5.4.2 (Build ID: 350m1(Build:2)) I am on Ubuntu 12.04

link delete flag offensive edit
0

answered 2012-09-12 09:23:33 +0200

prax gravatar image prax
1

I tried opening an xlsx file and it crashed in LibreOffice, the version I am using is 3.5.4.2 (Build ID: 350m1(Build:2)) I am on Ubuntu 12.04

link delete flag offensive edit
0

answered 2012-07-24 21:34:13 +0200

Andrew gravatar image Andrew
1

it might be password protected

i am trying to open a password-protected excel (.xlsx) file in LO 3.5.3.2, and i get the same behavior

link delete flag offensive edit
0

answered 2012-06-25 16:45:27 +0200

bs gravatar image bs
1

I am having the same issue. The file worked correctly ... I shut down my laptop and then it started asking to select the filter to reopen. I've tried most of the filters and either get an 'input/output error' or the file opens with various characters. I am running Mint 12 and I have tried to open it on a Win7 machine running MS Office 2010. Any help would be greatly appreciated. Please email me @ bsheeks@hotmail.com. Thanks.

link delete flag offensive edit
0

answered 2012-02-20 19:06:57 +0200

Mateusz gravatar image Mateusz
86 5

So you should come back to old version, submit bug and waiting for 3.5.1..

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow
1 follower

subscribe to rss feed

Stats

Asked: 2012-02-20 18:13:48 +0200

Seen: 9,600 times

Last updated: Feb 21