Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


On 07/02/2014, Dennis E. Hamilton <dennis.hamilton@acm.org> 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: users+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.