Created attachment 114334 [details]
sample gzip compressed csv file
It will be very useful if calc can directly open compressed csv files without the user having to manually extract the csv file from the compressed file first.
Currently if I try to open the attached file "rand.csv.gz" from Calc, it shows the text import dialog but the preview shows garbage text.
I can open file from tar.gz file without problem (from archive manager)
Build ID: c3087d969671e62182eb049850479e77190ccff4
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-03-22_04:37:00
Garbled text I see when I open .gz file directly from calc. It's not common to edit zipped file directly, I don't support this idea. Leaving unconfirmed.
(In reply to raal from comment #1)
> I can open file from tar.gz file without problem (from archive manager)
Suppose you have lots of *.csv.gz files (which is in my case), and you want to see them in spreadsheet to do some analysis, it is preferable to be able to **open from Calc**. This is different compared to __invoking__ Calc with the extracted file. And it is not about opening an archive (tarball), I am trying to open a compressed file *.csv.gz (containing only one csv file) from Calc.
Asked for opinions in the dev channel and the consensus was that this is an OK enhancement request, so I'm setting to NEW.
Submitted a patch at https://gerrit.libreoffice.org/#/c/15108/
*** Bug 90460 has been marked as a duplicate of this bug. ***
Dennis Francis committed a patch related to this issue.
It has been pushed to "master":
enhancement : tdf#90225 Cannot open compressed csv files from calc
It will be available in 5.0.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:
Affected users are encouraged to test the fix and report feedback.
I'll set this resolved. There is a few very minor known issues which we may want to tackle at some point, but the core part should be working fine.