[OASIS Issue Tracker] (OFFICE-1148) Public Comment: Demand for modification of ODF file format about regression curvein spreadsheet

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

    [ 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:06 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)