OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Updated: (OFFICE-3436) ODF 1.2 CD05 Part 26.13.3 CELL Assumptions Too Host-Dependent

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

Michael Brauer updated OFFICE-3436:

    Fix Version/s: ODF-Next
                       (was: ODF 1.2 CD 06)

As agreed by the TC on 2010-11-01 this issue has been moved to ODF-Next

> ODF 1.2 CD05 Part 2 6.13.3 CELL Assumptions Too Host-Dependent
> --------------------------------------------------------------
>                 Key: OFFICE-3436
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3436
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Dennis Hamilton
>            Assignee: Dennis Hamilton
>             Fix For: ODF-Next
> The CELL function is currently defined with far too man host-dependent characteristics.
> 1. CELL("SHEET") It assumes that sheets are numbered, without further explanation.  (This applies for a great variety of the functions in secction 6.13.)
> 2. The determination of CELL("ADDRESS") is underspecified with regard to sheet and if the current cell is being referenced externally.
> 3. The determination of CELL("FILENAME") is unclear, especially in the context of packages.  This result is apparently always a host-dependent behavior, but it is not clear what is the desired interoperable case were the CELL("FILENAME") used as an IRI Reference, and in what context.  What guidance is there for what value should be provided here and what an user could rely on it for.  Is an IRI always returned, rather than an IRI Reference, for example.
> 4. Does the result of CELL("CONTENT") provide a value of the type of the cell, or does it always provide text that can be interpreted as the appropriate type?
> 5. Is CELL("FORMAT") intended to be comprehensive? Does "-" mean that the color is in lieu of a minus sign in the formatted value?  For the (), see 
> 6. Is CELL("TYPE") meant to be comprehensive?  What about date-type values, currency-type values, and other distinct cell value types that may happen to be supported (Logical, Complex, ... )?
> 7. Is CELL("PARENTHESES") related to the use of parentheses to signify NEGATIVE values in accounting information?  Why does it say POSITIVE here and under CELL("FORMAT")?
> The note at the bottom does not comprehend all forms of references.  There are cuboids and cells whose values are arrays/matrices, yes?

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]