Bug 91798 - FILEOPEN unable to open very large CSV file
Summary: FILEOPEN unable to open very large CSV file
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
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:


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
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:
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
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?
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.