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-1562) Editor Note: Section8.5.10 <table:subtotal-field>



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

Eike Rathke commented on OFFICE-1562:
-------------------------------------

@Patrick:
> Do you agree that the language: ""Provisional results, the cell values of a row or column are grouped by their value, that is, all cells with the same content in the same field form a group." is in any event incorrect?

Umm.. no, but it also isn't sufficient. The rows are grouped by a column's values, but the result is calculated on another column's values.

> Is there a constraint on table:field-number that it can only be used where are row or column has content with the same value? Granting it would be silly to do a sum on a row with text, numbers, etc. in the cells but my question is do we have a rule that prohibits that?

No, no formal constraints. Yes, it may be silly to sum mixed text and numbers, but it is entirely up to the user. Using the 'count' function on text values even does make sense.

> Second, for table:group-by-field-number, which now reads: "The table:group-by-field-number attribute specifies the field, for example, a column, that is to be grouped. It is the number of a row or column within the database range."

Maybe emphasize that grouping is done such that all data belonging to a row of the database range is grouped along:

"The table:group-by-field-number attribute specifies the field, for example, a column, by which the data is to be grouped. It is the number of a row or column within the database range, based 0."

> I think what is puzzling me is how do I have a field being selected in both cases? Both of them appear to be rows/columns in the database range of the containing parent <table:database-range> element.
> 
> Yes?

Yes.

> Or to use your example, why would I select column "0" for grouping, only to select another field for the sum argument?

The data is grouped by column 0, then for each group a calculation is done on another column. Short example:

Object  Amount
apple   1
egg     2
apple   4
egg     8

Subtotalled by grouping on Object and sum on Amount would give:

Object          Amount
apple            1
apple            4
apple Sum        5
egg              2
egg              8
egg Sum         10
Grand Total     15


> Editor Note: Section 8.5.10 <table:subtotal-field>

> ---------------------------------------------------
>
>                 Key: OFFICE-1562
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1562
>             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 8.5.10 <table:subtotal-field>
> Ed. Note: This seems to assume that subtotals are of single rows/columns. Ah, so <table:subtotal-rule> enables the calculation from a group of subtotals. Well, except that we left out any way to specify the calculation in <table:subtotal-rule>. 

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