[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] table formula help...
From: |
Thierry Banel |
Subject: |
Re: [O] table formula help... |
Date: |
Tue, 09 Dec 2014 23:35:40 +0100 |
User-agent: |
Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.0 |
Ok, done.
A clean design has been implemented for handling empty cells.
Basically, empty input cells are ignored, and therefore they do not
participate in the aggregation. (However, for aggregation using two
columns (=corr(p,q)= for example), if a pair of cells contains both an
empty and a non-empty cell, then the empty one is replaced by zero.)
On output, empty cells are generated when the aggregation function does
not have enough input. For instance, =mean= needs at least one value,
otherwise a division by zero happens.
Thanks to Michael Brand for his insight and suggestions.
Source code and documentation here:
https://github.com/tbanel/orgaggregate
Melpa installation:
(require 'package)
(add-to-list 'package-archives
'("melpa" . "http://melpa.milkbox.net/packages")
t)
(package-initialize)
M-x package-list-packages
install orgtbl-aggregate
Have fun
Thierry
- Re: [O] table formula help..., (continued)
- Re: [O] table formula help..., Michael Brand, 2014/12/10
- Re: [O] table formula help..., Eric Abrahamsen, 2014/12/07
- Re: [O] table formula help..., Michael Brand, 2014/12/07
- Re: [O] table formula help..., Thierry Banel, 2014/12/07
- Re: [O] table formula help..., Thierry Banel, 2014/12/07
- Re: [O] table formula help..., Michael Brand, 2014/12/08
- Re: [O] table formula help..., Thierry Banel, 2014/12/08
- Re: [O] table formula help..., Michael Brand, 2014/12/09
- Re: [O] table formula help..., Thierry Banel, 2014/12/09
- Re: [O] table formula help..., Thierry Banel, 2014/12/09
- Re: [O] table formula help...,
Thierry Banel <=
- Re: [O] table formula help..., Michael Brand, 2014/12/10
- Re: [O] table formula help..., Thierry Banel, 2014/12/10
- Re: [O] table formula help..., Michael Brand, 2014/12/12
- Re: [O] table formula help..., Thierry Banel, 2014/12/12
- Re: [O] table formula help..., Michael Brand, 2014/12/13