On 23/01/2013, Dennis E. Hamilton <dennis.hamil...@acm.org> wrote:
> ODF 1.0/1.1 did not specify a standard for spreadsheet formulas. Formulas
> were left implementation-specific. Microsoft did not support the
> OpenOffice.org-specific formulas. Instead, they used Excel-specific
> formulas in ODF 1.1. On input of a not-supported formula expression, Excel
> in Office 2007 and 2010 drops the formula and preserves the last-calculated
> value. Whether a wise choice or not, that is what's done.
>
> As Regina says, Office 2013 supports ODF 1.2, including its OpenFormula
> specification. OpenFormula is also used by current implementations of
> LibreOffice and Apache OpenOffice when their documents are saved as ODF 1.2,
> so there is interoperability of formulas shared between ODF 1.2 implementing
> software.
>
> - Dennis
>
> -----Original Message-----
> From: James Knott [mailto:james.kn...@rogers.com]
> Sent: Wednesday, January 23, 2013 05:20
> To: LibreOffice
> Subject: Re: [libreoffice-users] how to tell m$ about ods formula behaviour
> failure
>
> e-letter wrote:
>> after opening in m$ excel 2010 (yes, m$ can open ods
>> spreadsheets, so use that format please!!!) , the formulas were lost,
>> leaving only the result values in the spreadsheet cells.
>>
>> Instead of reporting another erroneous LO bug, does someone know how
>> to forward this error with m4 excel 2010 to m$ bug reporting service?
>
> That is a well known "feature" of MS Office. Excel would replace
> formulas with calculated values. For some reason, MS thought that was
> appropriate, even though no other spreadsheet app does that. This was
> back in the days when MS was ramming their OOXML "standard" through ISO.
>
> I believe, though don't know, that this has been corrected in later
> versions of MS Office. This is one bug that can be laid squarely at the
> feet of MS and one might even suspect it was deliberate.
>
> Bottom line, there's nothing for LO to fix.
>
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>
...
--
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
