[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Buovjaga  changed:

   What|Removed |Added

Version|5.2.0.2 rc  |4.4.5.2 release

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Buovjaga  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |FIXED

--- Comment #12 from Buovjaga  ---
Ricardo: please pay attention to Caolán's comment:

(In reply to Caolán McNamara from comment #7)
> caolanm->maxim: The "cancel" didn't cancel for me straight away, it got
> stuck waiting for libxslt to complete. The above makes "cancel" cancel in
> reasonable time for me with this document.
> 
> Other than that, yeah, there's not much I think we can go wrt xslt filters
> cause its not really the right tech for this sort of import thing. I think
> this is as good as it gets without a replacement custom import filter.

Closing again.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

RicardoM  changed:

   What|Removed |Added

Version|4.4.5.2 release |5.2.0.2 rc

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

RicardoM  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |---

--- Comment #11 from RicardoM  ---
Problem description: When I try to open the xml file too large error occurs
"General input/output Error". I can't open large XML files with LibreOffice
calc.
I am using a spreadsheet with 1700 lines by 40 columns in XML and when I try to
open this XML file with the LibreOffice calc, occurs the error. 
The performance to open others XML files is very, very slow.
The bug number 100057 wasn't solved. The problem persist.
Steps to reproduce: Open the attached XML file with LibreOffice Calc.
Expected behavior: Open XML large file sheet and improve the performance.
Platform: Windows 7 Pro. Applies to LibreOffice version 5.0.6.2, 5.1.4.0,
5.2.0.3 and 5.3.0.0-alpha0.
Thanks in advance for your help and troubleshooting.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

--- Comment #10 from RicardoM  ---
I would like to thank you for the assistance provided by all of you to improve
the LibreOffice. 

Great Team. ;-)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

--- Comment #9 from RicardoM  ---
(In reply to Maxim Monastirsky from comment #6)
> Well, the file will open after all, but it will take ages (~40 minutes on my
> laptop).
> 
> (In reply to RicardoM from comment #0)
> > Problem description: When I try to open the xml file too large error occurs
> > "General input/output Error". 
> This isn't really an error message. It's a fix introduced in Bug 35543
> comment 20 (see discussion there), and we have Bug 65980 to improve the
> message to something more helpful.
> 
> > I created a spreadsheet with 1700 lines by 40 columns in LibreOffice calc
> > and saved it as XML,
> Bad idea. LO doesn't have a real filter for Excel 2003 XML, just some XSLT
> stuff. By using this thing you'll have big problems sooner or later.

Hi, Maxim, I created a spreadsheet in libreoffice calc with Excel 2003 XML
format to show the problem, about the Libreoffice calc does not open this file.
In my scenario, I'm generating a big file of Excel 2003 Xml and try to open it
with Libreoffice Calc.

Another thing, I think you spend ~40 minutes to open this file is not
acceptable, do you agree? In Excel this same file opens in ~1 minute.

Regards

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=93
   ||997

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

--- Comment #8 from Commit Notification 
 ---
Caolán McNamara committed a patch related to this issue.
It has been pushed to "libreoffice-5-2":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=bce5cdcc7f59da19c063205c6c79fc30874cb5ee=libreoffice-5-2

Resolves: tdf#100057 force libxslt to give up when we cancel a transformation

It will be available in 5.2.0.1.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:5.3.0|target:5.3.0 target:5.2.0.1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Caolán McNamara  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #7 from Caolán McNamara  ---
caolanm->maxim: The "cancel" didn't cancel for me straight away, it got stuck
waiting for libxslt to complete. The above makes "cancel" cancel in reasonable
time for me with this document.

Other than that, yeah, there's not much I think we can go wrt xslt filters
cause its not really the right tech for this sort of import thing. I think this
is as good as it gets without a replacement custom import filter.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Maxim Monastirsky  changed:

   What|Removed |Added

   Keywords|bibisectRequest, regression |
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=65
   ||980,
   ||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=35
   ||543

--- Comment #6 from Maxim Monastirsky  ---
Well, the file will open after all, but it will take ages (~40 minutes on my
laptop).

(In reply to RicardoM from comment #0)
> Problem description: When I try to open the xml file too large error occurs
> "General input/output Error". 
This isn't really an error message. It's a fix introduced in Bug 35543 comment
20 (see discussion there), and we have Bug 65980 to improve the message to
something more helpful.

> I created a spreadsheet with 1700 lines by 40 columns in LibreOffice calc
> and saved it as XML,
Bad idea. LO doesn't have a real filter for Excel 2003 XML, just some XSLT
stuff. By using this thing you'll have big problems sooner or later.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:5.3.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

--- Comment #5 from Commit Notification 
 ---
Caolán McNamara committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=2805adb0d3cf68d7def01a93bf07fb2e8121ec10

Resolves: tdf#100057 force libxslt to give up when we cancel a transformation

It will be available in 5.3.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

--- Comment #4 from Caolán McNamara  ---
On the command line...

xsltproc
instdir/program/../share/xslt/import/spreadsheetml/spreadsheetml2ooo.xsl
File_libreOffice_1600_lines_by_40_columns.xml

basically reproduces the same problem

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Cor Nouws  changed:

   What|Removed |Added

   Hardware|x86-64 (AMD64)  |All

--- Comment #3 from Cor Nouws  ---
(Ubuntu 32 bits)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100057] FILEOPEN: large XML sheet files causes crash/hang in Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100057

Cor Nouws  changed:

   What|Removed |Added

   Keywords||bibisectRequest, regression
 CC||c...@nouenoff.nl
Summary|FILEOPEN: large XML sheet   |FILEOPEN: large XML sheet
   |files causes crash in Calc  |files causes crash/hang in
   ||Calc

--- Comment #2 from Cor Nouws  ---
Does open in LibreOffice 3.3.0
Daily20160525 hangs.

Range is A1:AN1602

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs