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-790 Public Comment: ODFF: more suggestions
  3. OFFICE-2218

DDE: check details of data conversion and cell style

    XMLWordPrintable

    Details

    • Type: Sub-task
    • 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

      In the table, change
      Mode 0: Data converted to number(s) using the default cell style.
      Mode 1: Data converted to number(s), interpreted as US English (en_US) so "." is decimal separator.

      to
      Mode 0: Data converted to number using VALUE in the number style's locale of the default table cell style.
      Mode 1: Data converted to number using VALUE in the English-US (en_US) locale.

      Add to Semantics:
      In an OpenDocument spreadsheet document the default table cell style is specified with table:default-cell-style-name. Its number:number-style specified by style:data-style-name specifies the locale to use in the conversion.

      The DDE function is non-portable because it depends on availability of external programs (server parameter) and their interpretation of the topic and item parameters.

      Show
      In the table, change Mode 0: Data converted to number(s) using the default cell style. Mode 1: Data converted to number(s), interpreted as US English (en_US) so "." is decimal separator. to Mode 0: Data converted to number using VALUE in the number style's locale of the default table cell style. Mode 1: Data converted to number using VALUE in the English-US (en_US) locale. Add to Semantics: In an OpenDocument spreadsheet document the default table cell style is specified with table:default-cell-style-name. Its number:number-style specified by style:data-style-name specifies the locale to use in the conversion. The DDE function is non-portable because it depends on availability of external programs (server parameter) and their interpretation of the topic and item parameters.
    • Resolution:
      Hide

      Applied proposal.

      Show
      Applied proposal.

      Description

      Broken out from OFFICE-790

      DDE:

      • "mode 0 - Data converted to number(s) using the default cell style"
      • actually data is only converted to number (singular I think) if possible,
        otherwise text is returned.
      • Is it converted using VALUE, or some other way?
      • The "default cell style" is mentioned here for the first and only time - does
        this imply this function is only for spreadsheets? Shouldn't there be a bit
        more about the "default cell style"?

      Check these details.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: