Details

    • Type: Improvement
    • Status: New
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Working Draft
    • Fix Version/s: None
    • Component/s: ODF11-InteropProfile
    • Labels:
      None

      Description

      The draft mentiones the table:formula element (8.1.3). There are more elements that are able to contain formulas and should be mentioned in a similar way. Unfortunately, there are some insufficiencies in the current ODF11 spec which have been fixed in the current ODF12-CD04. I am not sure how to handle this in our draft. Following a list of these elements with some remarks:

      8.5.3 Table Cell Content Validation (the <table:condition> element)
      The ODF11 spec already mentions an optional leading namespace. The equals sign must not occur in the conditions. Note that the namespace prefix is in front of the entire expression, not inside the conditions which contain the formula fragments. For example:
      of:cell-content-is-between(1+2,3+4)
      where "1+2" and "3+4" are the formulas without namespace and equals sign.

      • If namespace is omitted, OpenFormula is assumed for all formulas.

      8.5.5 Named Expressions (the <table:expression> element)
      The ODF11 spec does not mention a namespace prefix at all. This has been covered by an issue for the 1.2 version and is present in the CD04 (19.637):

      • Namespace prefix is optional.
      • If namespace is omitted, leading equals sign is optional, and OpenFormula is assumed.
      • If namespace is present, equals sign must follow.

      14.1.1 Style Condition (the <style:condition> element) used for conditional formatting in spreadsheets
      The ODF11 spec does not mention a namespace prefix at all. This has been covered by an issue for the 1.2 version and is present in the CD04 (19.470):

      • Namespace prefix is optional.
      • If namespace is omitted, OpenFormula is assumed for all formulas.
      • The equals sign must not occur in the conditions (see above).

        Attachments

          Activity

            People

            • Assignee:
              bart.hanssens Bart Hanssens (Inactive)
              Reporter:
              daniel.rentz Daniel Rentz (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: