DDE: check details of data conversion and cell style

XMLWordPrintable

    • 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.
    • Hide

      Applied proposal.

      Show
      Applied proposal.

      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.

            Assignee:
            Eike Rathke (Inactive)
            Reporter:
            Eike Rathke (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: