Bug 93997 - Fileopen: xml excel file General input/output error
Summary: Fileopen: xml excel file General input/output error
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.4.2 rc
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, haveBacktrace, regression
: 95103 (view as bug list)
Depends on:
Blocks:
 
Reported: 2015-09-07 17:04 UTC by wolf_mann
Modified: 2017-07-28 15:50 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
procdum debug (17.09 KB, text/plain)
2015-09-08 15:48 UTC, Timur
Details
XML test file zipped (388.05 KB, application/zip)
2015-09-09 07:19 UTC, Timur
Details
only 2 rows, 34 cells (5.10 KB, text/xml)
2016-04-13 12:30 UTC, Robert Antoni Buj i Gelonch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description wolf_mann 2015-09-07 17:04:16 UTC
When trying to open this file Libraoffice hangs and will not answer to any key in. File is http://www.tlv.se/Upload/Tandvard/Referenspriser_m_dentalt_material_140901.xlsx.
Opens ok with EXCEL 2013
Comment 1 MM 2015-09-07 18:28:21 UTC
Unconfirmed with v4.4.5.2 under windows 7 x64.
Unconfirmed with v5.0.1.2 under mint 17.2 x64.

File opens pretty fast, no hangs.

Maybe you can try it with a fresh user profile ?!
https://wiki.documentfoundation.org/UserProfile
Comment 2 wolf_mann 2015-09-07 19:05:12 UTC
(In reply to wolf_mann from comment #0)
> When trying to open this file Libraoffice hangs and will not answer to any
> key in. File is http://www.tlv.se/Upload/MV/periodens-vara-september-20150901.xls
> 
> Opens ok with EXCEL 2013

Sorry I did refer to a file that openes up ok.
Changed to the failing one now.
Delete user profile and opened the failing file. Still fails.
Comment 3 raal 2015-09-07 19:42:27 UTC
I can open file with excel 2010

with Version: 5.1.0.0.alpha1+
Build ID: 50f2c712c46c66264279ab3b61888e491a4d8dca
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-09-04_06:07:29

Error message: General input/output error  and then LO freeze(100% CPU, killed after 2 mins). I can open file with Verze: 4.4.2.2,ID sestavení: 40m0(Build:2) -> regression.
Comment 4 MM 2015-09-07 20:53:26 UTC
Tried to open the file with v4.3.7.2 under mint 17.2 x64. Also got the 'General input/output error'.
Then tried v4.2.8.2 under mint 17.2 x64. This one gives the 'text import' window.
After selecting, it opens the file as a text file. So the bug must be between these version. Dunno why v4.4.2.2 opens the file correctly. Maybe it was fixed and then broken again ?! Or a patch that got reverted...
Comment 5 m_a_riosv 2015-09-07 22:08:11 UTC
Open for me with:
Win10x64
Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99

As 4.3 is End Of Life, no more patches, and it works with the latest 4.4, I think we must resolve as works for me.
Please if you are not agree reopen it.
Comment 6 MM 2015-09-07 22:20:34 UTC
(In reply to m.a.riosv from comment #5)
> Open for me with:
> Win10x64
> Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99
> 
> As 4.3 is End Of Life, no more patches, and it works with the latest 4.4, I
> think we must resolve as works for me.
> Please if you are not agree reopen it.

Sorry, but raal already reproduced it as said in comment 3

>with Version: 5.1.0.0.alpha1+
>Build ID: 50f2c712c46c66264279ab3b61888e491a4d8dca
>TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-09-04_06:07:29

For me v4.3 was the earliest affected version.
Reporter first gave the wrong file, so i unconfirmed that.
But with the correct file, i get the general input/output error. Tested with v4.4.5.2/5.0.1.2 under mint 17.2 x64 and v4.4.5.2 under windows 7 x64.
Comment 7 m_a_riosv 2015-09-07 23:01:03 UTC
Sorry, my mistake, I had verified with the wrong file.
Comment 8 Timur 2015-09-08 15:48:32 UTC
Created attachment 118532 [details]
procdum debug

(In reply to raal from comment #3)
> Version: 5.1.0.0.alpha1+ Error: General input/output error  and then LO freeze
> I can open file with Verze: 4.4.2.2

Recent regression, XML opens (albeit slowly) with 4.4.3 and freezes with 4.4.4+.
Linux console output may be nice.
Comment 9 Timur 2015-09-09 07:19:08 UTC
Created attachment 118541 [details]
XML test file zipped
Comment 10 Timur 2015-10-19 10:05:48 UTC
*** Bug 95103 has been marked as a duplicate of this bug. ***
Comment 11 Puggan SE 2015-10-21 21:35:27 UTC
Tried bibisecting it using 50max, but could open it with both latest and oldest, a bit slow, around 1minute, but working.

Tried bibesecting it using dbgutil, but couldn't open it with either master and oldest. (master -> source-hash-7323190456c2ed4ec9f092f8e69ba12ce41587cd)


uname -a
Linux asuna 4.0.5-gentoo #2 SMP Thu Aug 27 19:48:48 CEST 2015 x86_64 AMD FX(tm)-8120 Eight-Core Processor AuthenticAMD GNU/Linux
Comment 12 raal 2015-12-05 07:38:42 UTC
Tested Version: 5.2.0.0.alpha0+
Build ID: e963e4788d4d4a493e02d3f6c4b1024f3091c502
Threads 4; Ver: 4.2; Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-11-28_00:26:06
and Version: 5.2.0.0.alpha0+ (x64)
Build ID: e7c78e67292ad93c6a4a0772d8b06a0e6e7d26c8
Threads 1; Ver: Windows 6.1; Render: default; 
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-11-30_22:37:14

and I can open the file. Please could you test with dev version?
http://dev-builds.libreoffice.org/daily/master/
Thank you
Comment 13 wolf_mann 2015-12-13 18:45:00 UTC
Installed as suggested this file:http://dev-builds.libreoffice.org/daily/master/Win-x86_64@62-TDF/2015-12-02_06.37.24/master~2015-12-02_06.37.24_LibreOfficeDev_5.2.0.0.alpha0_Win_x64_en-US_de_ar_ja_ru_qtz.msi
To be very specific I installed it on my \d: drive as I wanted to keep the Swedish version I have instelled. But still got the same issue:
General input/output error.
Comment 14 Joel Madero 2015-12-14 04:11:57 UTC
No crash with 44max either which is strange. I'm removing bibisectRequest as it's apparently not possible. Has a backtrace so that should help.
Comment 15 raal 2016-04-13 07:19:23 UTC
This seems to have begun at the below commit.
Adding Cc: to Robert Antoni Buj Gelonch; Could you possibly take a look at this one? Thanks

commit 0da5f1a7ef1745f37a478bf58b17f48402bf27a0
Author: Norbert Thiebaud <nthiebaud@gmail.com>
Date:   Wed Jul 8 22:02:38 2015 -0700

    source 0cd2895e70eb96083ea78b1350583fe791b4237a

    source 0cd2895e70eb96083ea78b1350583fe791b4237a

author	Robert Antoni Buj Gelonch <robert.buj@gmail.com>	2015-05-20 00:46:21 (GMT)
committer	David Tardon <dtardon@redhat.com>	2015-05-21 07:19:45 (GMT)
commit 0cd2895e70eb96083ea78b1350583fe791b4237a (patch)
tree 57ee18d114a1b93f3066f490e5620904d66d6649
parent ebdba869de1de51b4cc7ca24c1a6a639d44de1bf (diff)
tdf#90999: Import spreadsheetML cells with inline formatting tags
Comment 16 Robert Antoni Buj i Gelonch 2016-04-13 12:30:41 UTC
Created attachment 124302 [details]
only 2 rows, 34 cells

It fails because the xml contains a high number of cells (92157), those cells are translated to nodes and exceeds limits.
Comment 17 Mark Dwyer 2017-01-25 04:54:01 UTC
This is affecting me recently. Unable to open xml files (generated with Stata 13) in excel format. Used to be able to. 

Confirmed that XLM test file zipped (388.05KB, 93997 periodens-vara-september-20150901.xml) fails with General I/O error for me as well.


Version: 5.2.2.2
Build ID: 1:5.2.2-0ubuntu1~trusty0
CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 18 Laurent Balland 2017-07-28 15:50:40 UTC
Successfully open attachment 118541 [details] and attachment 124302 [details] with:
- Version: 5.3.4.2 (x64)
Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3
Threads CPU : 4; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR); Calc: group

==> works for me