From: Russell Adams <RLAdams@AdamsInfoServ.Com>
To: emacs-orgmode <emacs-orgmode@gnu.org>
Subject: Re: Spreadsheet FR
Date: Fri, 2 Apr 2010 03:16:58 -0500 [thread overview]
Message-ID: <20100402081658.GO7262@thinkpad.adamsinfoserv.com> (raw)
In-Reply-To: <49A58658-88AF-4A88-93E9-1CDB710B08A2@gmail.com>
On Fri, Apr 02, 2010 at 09:49:46AM +0200, Carsten Dominik wrote:
>
>> 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.
Ideally we're just narrowing away lines, collapsing a table like org
collapses headlines.
Why would that be more likely to cause data loss?
>> 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?
Absolutely. Excel 2003 and up support "lists" or in 2007 "tables",
where you can do filter and summary work. I use it all the time for
customer planning because its the closest thing to grep/awk for Windows.
I think the real trick here is making the formulas ignore narrowed content.
If you'd like I can send you a sample.
Thanks.
------------------------------------------------------------------
Russell Adams RLAdams@AdamsInfoServ.com
PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/
Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
next prev parent reply other threads:[~2010-04-02 8:17 UTC|newest]
Thread overview: 13+ messages / expand[flat|nested] mbox.gz Atom feed top
2010-04-01 21:46 Spreadsheet FR Russell Adams
2010-04-02 7:49 ` Carsten Dominik
2010-04-02 8:16 ` Russell Adams [this message]
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20100402081658.GO7262@thinkpad.adamsinfoserv.com \
--to=rladams@adamsinfoserv.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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.