Calc locks up when attempting to import eg.txt (a CSV file from the USGS website). I’m using a Lenovo u430 Touch notebook. Windows 8.1. I checked the memory usage of Calc in the task manager and it doesn’t exceed 60 meg and I have memory free, so there’s got to be something going on there.
I posted to en.libreofficeforum.org and got this reply:
"Linux Mint 16, LibreOffice Version: 18.104.22.168 Build ID: 410m0(Build:3). I got the first 20K lines of the file (Linux command split -l 20000), when opened in Calc it says “The data could not be loaded completely because the maximum number of characters per cell was exceeded.” Maybe it’s related. Hope it helps"
Steps to reproduce:
1. To replicate the problem follow the instructions at this link: http://maps.cga.harvard.edu/qgis/wkshop/import_csv.php
2. You download this file: http://earth-info.nga.mil/gns/html/cntyfile/eg.zip
3. Unzip it, rename from eg.txt to eg.csv
4. Open it in Calc.
5. The only delimiter that the tutorial asks you to use is a tab character. So when the text import window appears, make sure only the tab delimiter check box is selected before the OK button is clicked.
Calc freezes after the OK button is clicked.
Calc imports the CSV file and displays the table.
Operating System: Windows 8
Version: 22.214.171.124 release
On 4.2.4 on Windows 7, it took 14 minutes for the loading bar to begin moving and at 29 minutes, a dialog box stating that LibO could not load completely as the maximum number of characters per cell was exceeded, though pressing okay showed the sheet.
As a comparison, Word 2013 and Kingsoft Writer loaded the csv file in less than 10 seconds, though not rendered correctly as csv delimiter options werent presented.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later): https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2015-07-18
It now opens in 10 secs. WFM.
New link: geonames.nga.mil/gns/html/cntyfile/eg.zip
Win 7 Pro 64-bit Version: 126.96.36.199.alpha1+
Build ID: fcc2415ade6ae93710bbbda9f7e163045e323105
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-10-21_16:55:13
Locale: fi-FI (fi_FI)