Re: [office] [OASIS Issue Tracker] Updated: (OFFICE-3759) Inability to recognize errors

[Patrick Durusau <patrick@durusau.net>]

Andreas,

Can you expand a bit on your example?

That is when you say: "Inability to recognize errors" do you mean:

1) The format distinguishes errors from strings but in this case a 
failure elsewhere doesn't define which should be applied?

2) The format fails to specify different formats for errors versus 
strings but errors vs. strings are well defined.

3) The format fails to distinguish errors versus strings in all cases.

4) Some other point that I have overlooked.

Sorry, despite your careful example it isn't clear where the difficulty 
lies.

Hope you are having a great day!

Patrick

On 5/23/2012 7:15 PM, OASIS Issues Tracker wrote:
>       [ http://tools.oasis-open.org/issues/browse/OFFICE-3759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
>
> Andreas Guelzow  updated OFFICE-3759:
> -------------------------------------
>
>      Description:
> Consider the following file snippet:
>
> <table:table-cell table:style-name="Gnumeric-default" table:formula="of:=IF(RAND()&gt;0.5;&quot;#DIV0!&quot;;1/0)" office:value-type="string" office:string-value="#DIV/0!">
> <text:p>#DIV/0!</text:p>
> </table:table-cell>
>
> There appears to be no way to determine whether the cell currently contained an error or a string. (Note the for the given expression both is possible.)
> If the cell format yields different results for errors than strings (for example in Gnumeric the default alignment differs), than this file can not be properly displayed.
>
>    was:
> Consider teh following file snippet:
>
> <table:table-cell table:style-name="Gnumeric-default" table:formula="of:=IF(RAND()&gt;0.5;&quot;#DIV0!&quot;;1/0)" office:value-type="string" office:string-value="#DIV/0!">
> <text:p>#DIV/0!</text:p>
> </table:table-cell>
>
> There appears to be no way to determine whether the cell currently contained an error or a string. (Note the for the given expression both is possible.)
> If the cell format yields different results for errors than strings (for example in Gnumeric the default alignment differs), than this file can not be properly displayed.
>
>
> > Inability to recognize errors
> > -----------------------------
> >
> >                  Key: OFFICE-3759
> >                  URL: http://tools.oasis-open.org/issues/browse/OFFICE-3759
> >              Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> >           Issue Type: Improvement
> >           Components: Table
> >     Affects Versions: ODF 1.2
> >             Reporter: Andreas Guelzow
> >
> > Consider the following file snippet:
> > <table:table-cell table:style-name="Gnumeric-default" table:formula="of:=IF(RAND()&gt;0.5;&quot;#DIV0!&quot;;1/0)" office:value-type="string" office:string-value="#DIV/0!">
> > <text:p>#DIV/0!</text:p>
> > </table:table-cell>
> > There appears to be no way to determine whether the cell currently contained an error or a string. (Note the for the given expression both is possible.)
> > If the cell format yields different results for errors than strings (for example in Gnumeric the default alignment differs), than this file can not be properly displayed.

--
Patrick Durusau
patrick@durusau.net
Chair, V1 - US TAG to JTC 1/SC 34
Convener, JTC 1/SC 34/WG 3 (Topic Maps)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net
Twitter: patrickDurusau