Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

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