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] Created: (OFFICE-3787) Part 2 uses "empty cell" and "cell is empty" - normalize on "empty cell"


Part 2 uses "empty cell" and "cell is empty" - normalize on "empty cell"
------------------------------------------------------------------------

                 Key: OFFICE-3787
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3787
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Bug
          Components: OpenFormula
    Affects Versions: ODF 1.2
            Reporter: Patrick Durusau
            Assignee: Patrick Durusau
            Priority: Minor
             Fix For: ODF 1.3


6.3.5 Conversion to Number: (last bullet item, end of paragraph) - "If the cell is empty (blank), use 0 (zero) as the value. Evaluators may choose to convert references to Text in a different manner than they handle converting embedded Text to a Number."

6.3.14 Conversion to Text (last bullet item): "Reference: perform conversion to scalar. If the referenced cell is empty, treat as an empty string (a text value with length 0). Then perform as above."

6.3.15 Conversion to DateParam (last bullet item): "Reference: perform conversion to scalar, then perform as above.  If the cell is empty, return 0."

6.3.16 Conversion to TimeParam (last bullet item): "Reference: perform conversion to scalar, then perform as above.  If the cell is empty, return 0."

This happens in 6.13.8 COUNTBLANK and 6.13.14 ISBLANK but they are too intertwined to fix separately (and they have other issues. I will open a separate JIRA issue on them.


Reference, convert cell value to Number. Empty cell returns the value 0. After conversion or empty cell value return, perform conversion for Number, 6.3.14.

-- 
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]