[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-1814) ISO/IEC JTC 1/SC 34N 1078 : DEFECT REPORT NUMBER JP2-23
[ http://tools.oasis-open.org/issues/browse/OFFICE-1814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797#action_12797 ]
Eike Rathke commented on OFFICE-1814:
-------------------------------------
"auto" is an error for all usages except in data pilot tables.
A table:function="auto" of <table:data-pilot-subtotal> specifies that subtotals shall use the same function(s) that is/are used to calculate the <table:data-pilot-field>s with table:orientation="data".
A table:function="auto" of a <table:data-pilot-field> with table:orientation="column" or table:orientation="row" specifies that no function is applied to that category field.
The functions are the OpenFormula functions used in spreadsheets.
average := AVERAGE
count := COUNTA
countnums := COUNT
max := MAX
min := MIN
product := PRODUCT
stdev := STDEV
stdevp := STDEVP
sum := SUM
var := VAR
varp := VARP
As this issue is also targeted to ODF 1.0 Errata 02, I'm not sure if and how and to what extend we want to include definitions for the functions there? We certainly do not want to repeat the work of OpenFormula ...
> ISO/IEC JTC 1/SC 34 N 1078 : DEFECT REPORT NUMBER JP2-23
> ---------------------------------------------------------
>
> Key: OFFICE-1814
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-1814
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: Table
> Affects Versions: ODF 1.0 (second edition)
> Reporter: Robert Weir
> Assignee: Robert Weir
> Fix For: ODF 1.2, ODF 1.0 Errata 02
>
>
> Transcribed from http://www.itscj.ipsj.or.jp/sc34/open/1078.htm
> Original author: "MURATA Makoto (FAMILY Given)" <eb2m-mrt@asahi-net.or.jp>
> DEFECT REPORT NUMBER JP2-23
> QUALIFIER omission
> REFERENCES IN DOCUMENT "Function" in Clauses 8.6.10, 8.8.4, 8.8.7, and 8.9
> NATURE OF DEFECT The semantics of the functions auto, average, count, countnums, max, min, product, stdev, stdevp, sum, var and varp are not specified.
> SOLUTION PROPOSED BY THE SUBMITTER Define the semantics of these functions.
--
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]