On 06/02/2014, e-letter <[email protected]> wrote:
>
> As an alternative, can anyone confirm if formulae are kept in xml
> formatted spreadsheets, for example of gnumeric or LO calc xml
> spreadsheets are imported by m$? For example simple formula from
> gnumeric:
> ...
> <gnm:Cells>
> <gnm:Cell Row="0" Col="0" ValueType="40">3</gnm:Cell>
> <gnm:Cell Row="1" Col="0" ValueType="40">5</gnm:Cell>
> <gnm:Cell Row="2" Col="0" ValueType="40">3</gnm:Cell>
> <gnm:Cell Row="3" Col="0">=(A1*A2)/A3</gnm:Cell>
> </gnm:Cells>
> ...
>
> from LO calc, saved as fods:
> ...
> <table:table-row table:style-name="ro1">
> <table:table-cell
> table:formula="of:=([.A1]*[.A2])/[.A3]" office:value-type="float"
> office:value="5">
> <text:p>5</text:p>
> </table:table-cell>
> </table:table-row>
> ...
>
> from LO calc, saved as m$ 2003 xml:
> ...
> <Table ss:StyleID="ta1">
> <Column ss:Width="64.2614"/>
> <Row ss:Height="12.8126">
> <Cell>
> <Data ss:Type="Number">3</Data>
> </Cell>
> </Row>
> <Row ss:Height="12.8126">
> <Cell>
> <Data ss:Type="Number">5</Data>
> </Cell>
> </Row>
> <Row ss:Height="12.8126">
> <Cell>
> <Data ss:Type="Number">3</Data>
> </Cell>
> </Row>
> <Row ss:Height="12.8126">
> <Cell ss:Formula="of:=([.A1]*[.A2])/[.A3]">
> <Data ss:Type="Number">5</Data>
> </Cell>
> </Row>
> </Table>
> ...
>
Further investigation of the m$ output xml spreadsheet:
...
<Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="4"
x:FullColumns="1" x:FullRows="1" ss:DefaultRowHeight="15">
<Row>
<Cell>
<Data ss:Type="Number">5</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">3</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">3</Data>
</Cell>
</Row>
<Row>
<Cell ss:Formula="=(R[-3]C*R[-2]C)/R[-1]C">
<Data ss:Type="Number">5</Data>
</Cell>
</Row>
</Table>
...
(Un)Surprisingly, m$ displays the value of the formula but discards
the formula from the formula bar within the gui, even though a formula
exists within the xml element.
--
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
