[OASIS Issue Tracker] (OFFICE-3759) Inability to recognize errors

[ https://issues.oasis-open.org/browse/OFFICE-3759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Patrick Durusau updated OFFICE-3759:
------------------------------------
    Resolution: 
Add "error" as a value of office:value-typeÂ

Edit schema and prose.

Â

  was:Add "error" as a value of office:value-typeÂ


> Inability to recognize errors
> -----------------------------
>
>                 Key: OFFICE-3759
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3759
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: Part 1 (Schema), Table
>    Affects Versions: ODF 1.2
>            Reporter: Andreas Guelzow
>            Assignee: Andreas Guelzow
>            Priority: Major
>             Fix For: ODF 1.4
>
>
> 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 that 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), then this file can not be properly displayed.



--
This message was sent by Atlassian Jira
(v8.3.3#803004)