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) Version: 4.5.0.0.alpha0+ 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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f0edb677f09ad338e22ac3b5d91497b4479e0b3c 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: http://wiki.documentfoundation.org/Testing_Daily_Builds 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.