[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Orgmode] Spreadsheet FR

From: Carsten Dominik
Subject: Re: [Orgmode] Spreadsheet FR
Date: Fri, 2 Apr 2010 09:49:46 +0200

On Apr 1, 2010, at 11:46 PM, Russell Adams wrote:

Fellow Org'ers,

I adore the text spreadsheet, however there's one feature Excel
provides which I don't have in org.

I often use Excel for "lists", where I can sort or narrow the data by
specific criteria from a larger list.

Would it be feasible to "narrow" a table by criteria on a specific
field in between separators? Ie: only display those cells in field A
if they are > 2, or if field B matches "Pick Me!".

This one might be possible - but dangerous for losing data.

A nice feature would be updating the totals at the bottom with only
the visible data.

I don't think Excel works like this, does it?

Just like the outline folding the goal would be to hide entries that
don't match, they should still remain.

So for example:

| *Lime* | *Cost* |
| Y      |      1 |
| Y      |      2 |
| Y      |      2 |
| N      |      3 |
| N      |      4 |
| Y      |      5 |
| Total  |     17 |
#+TBLFM: @8$2=vsum(@address@hidden)

I can already sort by Lime or Cost, but if I filtered where Lime =
"Y", I would have:

| *Lime* | *Cost* |
| Y      |      1 |
| Y      |      2 |
| Y      |      2 |...
| Y      |      5 |
| Total  |     10 |
#+TBLFM: @8$2=vsum(@address@hidden)

No loss of the lines, on reload or changing the view they would come
back, but note that the formula at the end didn't consider
them. Ideally the cell references wouldn't change (the example above
would break if recalc was hit).

I'm not sure whether this would be cumulative or whether the criteria
specification would need to allow for multiple logical conditions.

Would anyone else consider this a useful feature? I'm not sure how
difficult the implementation would be.


Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.

- Carsten

reply via email to

[Prev in Thread] Current Thread [Next in Thread]