OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (OFFICE-1546) Editor Note: Section17.798.7 <text:table-formula> (text:display)

    [ http://tools.oasis-open.org/issues/browse/OFFICE-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12159#action_12159 ] 

Dennis Hamilton commented on OFFICE-1546:

MISSING FEATURE? <text:table-cell> (ODF 1.2 Part 1 cd02 section 8.1.3) does not have an equivalent of the <text:table-formula> text:display attribute.  The only way I can see this might be supported would be via a style.  Are there defined table-cell styles that provides the equivalent functionality of the three text:display cases?

NOTE PLEASE: <text:table-formula> is deprecated in ODF 1.1.

ODF 1.1 section 6.6.11 Table Formula Field is quite specific about the <text:table-formula> text:display attribute:

"Use this attribute to specify one of the following:

"  -To display the value of the field.

"  -To display the formula used to compute the value.

"See section 6.7.5 for information on using this attribute."

ODF 1.1 section 6.7.5 is a bit problematic in that it specifies that there are three defined values but it makes no specific mention to the cases available in the <table:formula> element.

Even though <text:table-formula> is deprecated, it is probably still useful to get this right.

The cases are

  text:display="none"  - do not present a value

 text:display="value" - present the value - i.e., the last-calculated value of the formula

text:display="formula" - present the formula rather than the value

These variations are quite useful when the formula is for an intermediate result but its presentation is not useful ("none") or when it is the formula that is more of interest ("formula") than its value (which can always be presented in a different place or simply used in further calculations.  The "formula" case is useful in spreadsheets and in situations where presentation of a formula is useful as demonstration of what a derivation is based on (or even when demonstrating a  bug or interoperability problem).

Spreadsheet implementations offer a variety of ways to specify these variations.  


> Editor Note: Section 17.798.7 <text:table-formula> (text:display)

> ------------------------------------------------------------------
>                 Key: OFFICE-1546
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1546
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>    Affects Versions: ODF 1.2
>            Reporter: Robert Weir 
>            Assignee: Patrick Durusau
>             Fix For: ODF 1.2
> Transcribed from ODF_Revised_Editorial_Notes_27May2009.odt
> Original author: Patrick Durusau
> Section 17.798.7 <text:table-formula> (text:display)
> Ed. Note: When we say "allows the display of the formula..." do we mean it could also be the value of the field? How is that choice indicated to the application? 
> Michael Stahl says: "i've no idea, maybe it's just badly formulated?"

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]