[OASIS Issue Tracker] Commented: (OFFICE-1562) Editor Note: Section8.5.10 <table:subtotal-field>

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

Patrick Durusau commented on OFFICE-1562:
-----------------------------------------

OK, first question: 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? To ask it as a positive question: 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? 

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."

And, for table:field-number, which now reads: "The table:field-number number attribute specifies a row or column number to sort, subtotal or filter. It is the number of a row or column within a database range."

So I find:

<table:subtotal-rule table:group-by-field-number="some row/column">
   <table:subtotal-field table:field-number ="some row/column" table:function="sum"/>
</table:subtotalrule>

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? 

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

Unless the column "0" is *not* part of the parent database range but is in fact a column for display. Yes? 

In other words, is this a grouping *to* column 0 in some other database range?

Closer/farther away?  


> 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