On 07/02/2014, Dennis E. Hamilton <[email protected]> wrote:
> I no longer follow these lists, so I'm of limited help.
>
> If gnumeric produces an ods file, Excel 2013 should attempt to read it.
> However, the format you gave as an example is not ODF and I am doubtful. I
> don't have gnumeric, so I can't check that case.
>
Correct, the output provided previously was the native format;
gnumeric was one of the first spreadsheets to use xml as a native file
format. Below is an extract of the gnumeric output when the
spreadsheet is saved as gnumeric ods (without foreign elements, a
gnumeric option):
<table:table table:name="Sheet1" table:style-name="ta-v-lr">
<table:table-column
table:default-cell-style-name="ACE-0x8a4a468"
table:style-name="ACOL-0"/>
<table:table-column
table:default-cell-style-name="ACE-0x8a4a468"
table:style-name="ACOL-0" table:number-columns-repeated="255"/>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x8a4a468"
office:value-type="float" office:value="3">
<text:p>3</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x8a4a468"/>
</table:table-row>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x8a4a468"
office:value-type="float" office:value="5">
<text:p>5</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x8a4a468"/>
</table:table-row>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x8a4a468"
office:value-type="float" office:value="3">
<text:p>3</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x8a4a468"/>
</table:table-row>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x8a4a468"
table:formula="of:=([.A1]*[.A2])/[.A3]" office:value-type="float"
office:value="5">
<text:p>5</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x8a4a468"/>
</table:table-row>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:number-columns-repeated="256"
table:style-name="ACE-0x8a4a468"/>
</table:table-row>
<table:table-row table:style-name="AROW-0"
table:number-rows-repeated="65531">
<table:table-cell
table:number-columns-repeated="256"
table:style-name="ACE-0x8a4a468"/>
</table:table-row>
</table:table>
Similarly, gnumeric output ods with foreign elements:
<table:table table:name="Sheet1" table:style-name="ta-v-lr">
<table:table-column
table:default-cell-style-name="ACE-0x9882780"
table:style-name="ACOL-0"/>
<table:table-column
table:default-cell-style-name="ACE-0x9882780"
table:style-name="ACOL-0" table:number-columns-repeated="255"/>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x9882780"
office:value-type="float" office:value="3">
<text:p>3</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x9882780"/>
</table:table-row>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x9882780"
office:value-type="float" office:value="5">
<text:p>5</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x9882780"/>
</table:table-row>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x9882780"
office:value-type="float" office:value="3">
<text:p>3</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x9882780"/>
</table:table-row>
<table:table-row table:style-name="AROW-0">
<table:table-cell
table:style-name="ACE-0x9882780"
table:formula="of:=([.A1]*[.A2])/[.A3]" office:value-type="float"
office:value="5">
<text:p>5</text:p>
</table:table-cell>
<table:table-cell
table:number-columns-repeated="255"
table:style-name="ACE-0x9882780"/>
</table:table-row>
A quick diff comparison shows no significant differences in this context.
>
> When I saved the file from LibreOffice in *.ods format, Excel 2013 opened it
> fine and the formulas worked. (B1 and C1 were changed and the formulas
> could be seen on the cells.)
>
Thanks, this is good to know; m$ users can be more confidently advised
to either upgrade to versions >=m$2013 or any other odf compliant
software.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
