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] (OFFICE-1148) Public Comment: Demand for modification of ODF file format about regression curvein spreadsheet


    [ https://issues.oasis-open.org/browse/OFFICE-1148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67721#comment-67721 ] 

Regina Henschel edited comment on OFFICE-1148 at 10/3/17 11:09 PM:
-------------------------------------------------------------------

Gnumeric has the option "use abscissa" for moving average. That cannot be represented with the proposal "08/Dec/15".
For example the following data [x y] give with period 3 the (rounded) result [average on x and y]
[x  |  y ]        [ average on x and y]	
[ 1  | 1]		
[ 2  |  2]         [ 2.7  | 2]
[ 5  |  3]         [ 4.3  | 3]
[ 6  | 4]          [ 6.0  | 4]
[ 7  |  5]         [ 8.3  | 5]
[12 |  6]        [10.7  | 6]
[13 | 7]         [13.7  | 7]
[16 |  8]        [16.0  | 8]
[19 | 9]         [18.3  | 9]
[20 |10]		
[Hopefully now table better readable]

That is not the same as the attribute chart:regression-moving-type="central".


was (Author: regina.henschel):
Gnumeric has the option "use abscissa" for moving average. That cannot be represented with the proposal "08/Dec/15".
For example the following data [x y] give with period 3 the (rounded) result [average on x and y]
[x    y ]        [ average on x and y]	
[ 1   1]		
[ 2    2]          [ 2,7    2]
[ 5    3]          [ 4,3    3]
[ 6    4]         [ 6,0    4]
[ 7    5]          [ 8,3    5]
[12   6]        [10,7    6]
[13   7]         [13,7    7]
[16   8]        [16,0    8]
[19   9]         [18,3    9]
[20  10]		
[Hopefully now table better readable]

That is not the same as the attribute chart:regression-moving-type="central".

> Public Comment: Demand for modification of ODF file format about regression curvein spreadsheet
> -----------------------------------------------------------------------------------------------
>
>                 Key: OFFICE-1148
>                 URL: https://issues.oasis-open.org/browse/OFFICE-1148
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: Chart, Part 1 (Schema)
>            Reporter: Rob Weir
>            Assignee: Jos van den Oever
>            Priority: Blocker
>             Fix For: ODF 1.3
>
>
> Copied from office-comment list
> Original author: Laurent BALLAND-POIRIER <Laurent.Balland-Poirier@laposte.net> 
> Original date: 8 Dec 2008 18:49:56 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200812/msg00007.html



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)


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