Bug 91798 - FILEOPEN unable to open very large CSV file
Summary: FILEOPEN unable to open very large CSV file
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Import
  Show dependency treegraph
 
Reported: 2015-06-01 16:46 UTC by pavel.dvorak.work
Modified: 2019-09-12 12:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description pavel.dvorak.work 2015-06-01 16:46:15 UTC
try open this csv
http://download.companieshouse.gov.uk/en_output.html
it doesn't open it just hangs
even the window doesn't appear
it should maybe open only sample of this file and display open to load more
Comment 1 raal 2015-06-02 05:23:55 UTC
I can not confirm with Version: 5.1.0.0.alpha1+
Build ID: 1a8e9dae32997bf199dbd192058fcd8f187ddc49
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-05-31_03:57:11
No problem to open BasicCompanyData-2015-06-01-part1_5.csv

Pavel, specify your version of LO. Please test with LO 4.4
http://www.libreoffice.org/download/libreoffice-fresh/
Comment 2 Urmas 2015-06-02 05:56:39 UTC
Confirmed with June 1st version.
It is caused by the default import settings not matching the file format.
Comment 3 pavel.dvorak.work 2015-06-02 09:37:57 UTC
set version
yes it have , not ;
will you implement the sample thing for large files?
thanks
Comment 4 QA Administrators 2016-09-20 09:46:14 UTC Comment hidden (obsolete)
Comment 5 Timur 2019-09-12 12:20:28 UTC
I tried with 64-bit master 6.4+. 
I downloaded full CSV which is unzipped 2 GB (!)
I opened via File-Open, using default settings.
Document load was slow, I'd say as expected. 
Message was: "The data could not be loaded completely because the maximum number of rows per sheet was exceeded." because it has more than a million rows. 
I'll close as WFM.
Please test with new LO 64-bit version.