Bug Hunting Session
Bug 36841 (Gnumeric-Open) - FILEOPEN fails on gnumeric spreadsheet files
Summary: FILEOPEN fails on gnumeric spreadsheet files
Status: NEW
Alias: Gnumeric-Open
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 Beta3
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Format-Filters
  Show dependency treegraph
 
Reported: 2011-05-04 05:54 UTC by John Overmars
Modified: 2018-05-21 18:46 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Gnumeric XML file that does not open in LibreOffice calc 3.3.3 (2.05 KB, application/gzip)
2011-09-23 16:16 UTC, llameadrpc
Details
Same file as plain XML (16.31 KB, application/xml)
2014-01-19 07:36 UTC, Maxim Monastirsky
Details

Note You need to log in before you can comment on or make changes to this bug.
Description John Overmars 2011-05-04 05:54:09 UTC
FILEOPEN treats gnumeric files as csv files and creates junk.  Openoffice had no problem with gnumeric files.
Comment 1 tester8 2011-06-13 02:05:29 UTC
Reproduced with
Ubuntu 10.04.2 x86
LO 3.4
Comment 2 wope 2011-06-18 09:58:28 UTC
Please attach a Testfile. With 3.4.1 and Suse 11.3 I has no problems.
Comment 3 llameadrpc 2011-09-23 16:16:47 UTC
Created attachment 51559 [details]
Gnumeric XML file that does not open in LibreOffice calc 3.3.3

LibreOffice 3.3.3 
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.3-1ubuntu2
Comment 4 Björn Michaelsen 2011-12-23 12:01:34 UTC Comment hidden (obsolete)
Comment 5 Björn Michaelsen 2011-12-23 17:00:23 UTC
needinfo keyword redundant by needinfo status.
Comment 6 Jonathan Nieder 2012-01-20 00:58:25 UTC
What version of oocalc supported this? Based on [1] it seems to have been a longstanding wish that no one had implemented.

[1] https://issues.apache.org/ooo/show_bug.cgi?id=17808
Comment 7 Markus Mohrhard 2012-12-04 20:55:48 UTC
With Libreoffice 4.0 we'll have an technical demo for gnumeric import. It is still in alpha state and only imports values, strings and formulas right now.

This will be only accessible through the experimental mode and does not support gnumeric files that don't have the namespace alias gnm. These limitations will be removed later.
Comment 8 Gerry 2014-01-16 22:22:42 UTC
Shall this bug be closed or renamed to "Remove limitations of Gnumeric import filter (currently in Experimental Mode)"?
Comment 9 tommy27 2014-01-18 08:30:13 UTC
test file still fails to be opened in LibO 4.1.4.2 under Win7 64bit

it loads in Writer and shows this junk:
#‹##Ä#}N##í#moã6ïûý
Í#¶Om#§é]½&‡ôú# íS$ioÏ
Comment 10 Maxim Monastirsky 2014-01-19 07:36:16 UTC
Created attachment 92377 [details]
Same file as plain XML

(In reply to comment #9)
> it loads in Writer and shows this junk:
> #‹##Ä#}N##í#moã6ïûý
> Í#¶Om#§é]½&‡ôú# íS$ioÏ
That's because it's gzipped. I attached the same file as plain XML.
Comment 11 tommy27 2014-01-19 08:03:23 UTC
Ok, now just an empty sheet opens up in Calc
Comment 12 Xavier Van Wijmeersch 2017-11-16 15:20:41 UTC
File is opening and readable, only column with stays the same

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 5.3.8.0.0+
Build ID: 7f1297d9b4f449eb9ada8008fb21b7046d1a8f19
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-5-3, Time: 2017-11-10_15:56:34
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 5.4.4.0.0+
Build ID: a4713560e3b4b7dc3d72e3811e41ff9c4feda24a
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.0.0.0.alpha1+
Build ID: f3eaa4f2de419f5cb96608341ac7d979f5a07625
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 13 Xavier Van Wijmeersch 2017-11-16 15:25:39 UTC
forgot to mention, formatting off cells is lost