Hi :) I think they fixed the problem in MS Office 2013. Prior to that for spreadsheets in ODF formats MS Office would apparently lose the formula and leave values as a fixed.
Errr, i think there is a lot more there but i only managed to make sense of the last paragraph. Hopefully others can help with the rest! Regards from Tom :) On 6 February 2014 20:17, e-letter <inp...@gmail.com> wrote: > 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 -- 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