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