all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* Spreadsheet FR
@ 2010-04-01 21:46 Russell Adams
  2010-04-02  7:49 ` Carsten Dominik
  2010-04-02 14:26 ` Matt Lundin
  0 siblings, 2 replies; 13+ messages in thread
From: Russell Adams @ 2010-04-01 21:46 UTC (permalink / raw)
  To: emacs-orgmode

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!".

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

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(@-I..@-II)

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(@-I..@-II)

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.

Thanks.

^ permalink raw reply	[flat|nested] 13+ messages in thread

end of thread, other threads:[~2010-04-05  2:39 UTC | newest]

Thread overview: 13+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2010-04-01 21:46 Spreadsheet FR Russell Adams
2010-04-02  7:49 ` Carsten Dominik
2010-04-02  8:16   ` Russell Adams
2010-04-02 13:00     ` Darlan Cavalcante Moreira
2010-04-04  7:01     ` Carsten Dominik
2010-04-04 16:46       ` Xiao-Yong Jin
2010-04-04 20:19         ` Russell Adams
2010-04-05  2:39           ` Xiao-Yong Jin
2010-04-02 14:44   ` Dan Davison
2010-04-02 14:55     ` Russell Adams
2010-04-02 17:09       ` Russell Adams
2010-04-02 20:43     ` Matt Lundin
2010-04-02 14:26 ` Matt Lundin

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.