[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.
Thanks.
------------------------------------------------------------------
Russell Adams address@hidden
PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/
Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
- [Orgmode] Spreadsheet FR, Russell Adams, 2010/04/01
- Re: [Orgmode] Spreadsheet FR, Carsten Dominik, 2010/04/02
- Re: [Orgmode] Spreadsheet FR,
Russell Adams <=
- Re: [Orgmode] Spreadsheet FR, Darlan Cavalcante Moreira, 2010/04/02
- Re: [Orgmode] Spreadsheet FR, Carsten Dominik, 2010/04/04
- Re: [Orgmode] Spreadsheet FR, Xiao-Yong Jin, 2010/04/04
- Re: [Orgmode] Spreadsheet FR, Russell Adams, 2010/04/04
- Re: [Orgmode] Spreadsheet FR, Xiao-Yong Jin, 2010/04/04
Re: [Orgmode] Spreadsheet FR, Dan Davison, 2010/04/02
[Orgmode] Re: Spreadsheet FR, Matt Lundin, 2010/04/02
[Orgmode] Re: Spreadsheet FR, Matt Lundin, 2010/04/02