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

Public Comment: Re: [office-comment] ODFF: list of suggestions: TRIMMEAN

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: No Action
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None

      Description

      Copied from office-comment list

      Original author: "David King" <openoffice@drking.plus.com>
      Original date: 22 Dec 2008 23:28:57 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200812/msg00045.html

      > > TRIMMMEAN page 379
      > > * "Let n denote the number of elements in the data set" - that's
      > > too vague - does it mean elements including or excluding non-
      > > numbers/blank cells? Calc ignores non-numbers.
      >
      > That is expressed by declaring the dataSet parameter as NumberSequence.

      I disagree

      This highlights my unease at having 'conversion types' - I would
      be happier if all parameters were defined as 'types', so
      NumberSequence would be a 'type' that triggered conversion. I'd
      like to be able to look up any parameter type in the same place.

      In this case it's not clear whether the number of elements is
      counted before or after conversion.

      "Let n denote the number of elements in dataSet after conversion
      to NumberSequence" is a bit better, but still less than clear,
      because dataSet is defined as a NumberSequence as well as being
      converted to a NumberSequence.

      Actually that's the essence of the prob for me - you can't define
      a parameter as a NumberSequence and then convert it to a
      NumberSequence....

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: