Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2325

Negative and non-integer inputs for BASE and DECIMAL Functions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      BASE:

      In Syntax, change all Number types to Integer types for all parameters.

      Constraints: X ≥ 0, 2 ≤ Radix ≤ 36, MinimumLength ≥ 0

      Remove Portable Constraints.

      DECIMAL:

      Constraints: 2 ≤ Radix ≤ 36

      Remove Portable Constraints.

      Show
      BASE: In Syntax, change all Number types to Integer types for all parameters. Constraints: X ≥ 0, 2 ≤ Radix ≤ 36, MinimumLength ≥ 0 Remove Portable Constraints. DECIMAL: Constraints: 2 ≤ Radix ≤ 36 Remove Portable Constraints.
    • Resolution:
      Hide

      BASE:

      In Syntax, changed all Number types to Integer types for all parameters.

      Constraints: X ≥ 0, 2 ≤ Radix ≤ 36, MinimumLength ≥ 0

      Removed Portable Constraints.

      DECIMAL:

      Constraints: 2 ≤ Radix ≤ 36

      Removed Portable Constraints.

      Show
      BASE: In Syntax, changed all Number types to Integer types for all parameters. Constraints: X ≥ 0, 2 ≤ Radix ≤ 36, MinimumLength ≥ 0 Removed Portable Constraints. DECIMAL: Constraints: 2 ≤ Radix ≤ 36 Removed Portable Constraints.

      Description

      are negative values allowed for BASE and DECIMAL Fucntions?
      If negatives are allowed are they denoted simply by a leading minus sign?

      The spec seems to allow non-integer inputs, is this correct? If so how should we handle cases like BASE(0.5,3) as 0.5 is not finitely representable in base 3, and since we're returning a string we could (at least theoretically) go on forever?

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: