[Top][All Lists]

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

Re: [Orgmode] Spreadsheet FR

From: Russell Adams
Subject: Re: [Orgmode] Spreadsheet FR
Date: Fri, 2 Apr 2010 03:16:58 -0500
User-agent: Mutt/1.5.18 (2008-05-17)

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.


Russell Adams                            address@hidden

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

reply via email to

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