Re: [Orgmode] Spreadsheet FR

[Darlan Cavalcante Moreira]

How can you expand/narrow the disabled lines if you want to show/hide them?
This will probably interfere with normal TAB use inside a table.

I think that the ability to "disable" some lines based on data in a column,
such as in your example, can be very useful. But maybe we don't need to
really collapse the lines. Only changing the face could be enough.

- Darlan

At Fri, 2 Apr 2010 03:16:58 -0500,
Russell Adams <address@hidden> 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?
> 
> >> 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
> 
> 
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> address@hidden
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode