On 06/02/2014, e-letter <inp...@gmail.com> 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: users+unsubscr...@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