OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

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

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Tue, 3 Oct 2017 23:06:54 +0000 (UTC)

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

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