From: Carsten Dominik <carsten.dominik@gmail.com>
To: Russell Adams <RLAdams@AdamsInfoServ.Com>
Cc: emacs-orgmode <emacs-orgmode@gnu.org>
Subject: Re: Spreadsheet FR
Date: Sun, 4 Apr 2010 09:01:30 +0200 [thread overview]
Message-ID: <1BB83608-9D78-439A-A5E3-7BD02E823A24@gmail.com> (raw)
In-Reply-To: <20100402081658.GO7262@thinkpad.adamsinfoserv.com>
On Apr 2, 2010, at 10:16 AM, Russell Adams wrote:
> 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?
Because there would be ellipsis in unfamiliar places and the danger to
accidentally modify invisible text would be higer.
>
>>> 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.
OK, I did not know this.
>
> I think the real trick here is making the formulas ignore narrowed
> content.
>
> If you'd like I can send you a sample.
Please do - but that does not mean that I am going to implement this.
This would be tricky.
- Carsten
next prev parent reply other threads:[~2010-04-04 7:01 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
2010-04-02 13:00 ` Darlan Cavalcante Moreira
2010-04-04 7:01 ` Carsten Dominik [this message]
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
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=1BB83608-9D78-439A-A5E3-7BD02E823A24@gmail.com \
--to=carsten.dominik@gmail.com \
--cc=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 public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).