Bug 91875 (Gnumeric-Export) - gnumeric format export
Summary: gnumeric format export
Status: NEW
Alias: Gnumeric-Export
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Format-Filters
  Show dependency treegraph
 
Reported: 2015-06-05 11:25 UTC by inpost
Modified: 2018-05-21 18:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
example gnumeric (1.78 KB, application/x-gnumeric)
2015-08-18 16:19 UTC, inpost
Details
example calc (20.09 KB, application/vnd.oasis.opendocument.spreadsheet-flat-xml)
2015-08-18 16:19 UTC, inpost
Details

Note You need to log in before you can comment on or make changes to this bug.
Description inpost 2015-06-05 11:25:47 UTC
Please allow spreadsheets to be exported to gnumeric xml format.

http://www.mail-archive.com/users@global.libreoffice.org/msg45211.html
Comment 1 Robinson Tryon (qubit) 2015-07-22 16:00:56 UTC
(In reply to inpost from comment #0)
> Please allow spreadsheets to be exported to gnumeric xml format.
> 
> http://www.mail-archive.com/users@global.libreoffice.org/msg45211.html

I'm not sure about this statement "The xml of the gnumeric spreadsheet format seems superior (more compact) compared to the xml of the calc module," however export seems like a possible addition, so status: NEW seems fine.

What's the use case for Gnumeric XML export? Are there any large companies or groups standardizing on Gnumeric XML?
Comment 2 inpost 2015-08-18 16:19:05 UTC
Created attachment 117998 [details]
example gnumeric
Comment 3 inpost 2015-08-18 16:19:40 UTC
Created attachment 117999 [details]
example calc
Comment 4 inpost 2015-08-18 16:24:40 UTC
(In reply to Robinson Tryon (qubit) from comment #1)
> (In reply to inpost from comment #0)
> > Please allow spreadsheets to be exported to gnumeric xml format.
> > 
> > http://www.mail-archive.com/users@global.libreoffice.org/msg45211.html
> 
> I'm not sure about this statement "The xml of the gnumeric spreadsheet
> format seems superior (more compact) compared to the xml of the calc
> module," however export seems like a possible addition, so status: NEW seems
> fine.
> 

Gnumeric:

      <gnm:Cells>
        <gnm:Cell Row="0" Col="0" ValueType="60">test</gnm:Cell>
        <gnm:Cell Row="0" Col="1" ValueType="40">10</gnm:Cell>
        <gnm:Cell Row="0" Col="2" ValueType="40">20</gnm:Cell>
        <gnm:Cell Row="1" Col="0">=sum(B1*C1)</gnm:Cell>
      </gnm:Cells>

Calc:

         <table:table table:name="Sheet1" table:style-name="ta1" table:print="false">
            <table:table-column table:style-name="co1" table:number-columns-repeated="3"
                                table:default-cell-style-name="Default"/>
            <table:table-row table:style-name="ro1">
               <table:table-cell office:value-type="string">
                  <text:p>test</text:p>
               </table:table-cell>
               <table:table-cell office:value-type="float" office:value="10">
                  <text:p>10</text:p>
               </table:table-cell>
               <table:table-cell office:value-type="float" office:value="20">
                  <text:p>20</text:p>
               </table:table-cell>
            </table:table-row>
            <table:table-row table:style-name="ro1">
               <table:table-cell table:formula="of:=SUM([.B1]*[.C1])" office:value-type="float"
                                 office:value="200">
                  <text:p>200</text:p>
               </table:table-cell>
               <table:table-cell table:number-columns-repeated="2"/>
            </table:table-row>
         </table:table>

> What's the use case for Gnumeric XML export? Are there any large companies
> or groups standardizing on Gnumeric XML?

Those that seek to use the alternative xml of gnumeric, for example for creation of an xml database.

Commercial use, by definition, not necessarily disclosed to public domain.
Comment 5 Markus Mohrhard 2015-10-09 21:49:21 UTC
Gnumeric XML is a quite bad format as it changes regularly. We are going to have an initial import in 5.1 but I doubt that we will ever implement a gnumeric export.