After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 720629 - conditional formatting feature: hide row /column
conditional formatting feature: hide row /column
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: General
git master
Other Linux
: Low enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2013-12-17 19:35 UTC by David Ronis
Modified: 2018-05-22 14:06 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description David Ronis 2013-12-17 19:35:33 UTC 
I'd like to be able to conditionally hide rows or columns based on some logical test on a cell (or range of cells).  If this isn't currently possible consider this a feature request.

Thanks

David
Comment 1 Morten Welinder 2013-12-21 16:30:45 UTC 
That is certainly not currently possible.

It is also likely quite a lot of work.  What is the use case for this?
Comment 2 David Ronis 2013-12-22 18:29:49 UTC 
(In reply to comment #1)
 
> It is also likely quite a lot of work.  What is the use case for this?

I maintain a spreadsheet showing enrollment data for courses we offer.  There is about a decade's worth of data, and about 1/4 of the entries haven't been offered in several years (courses are phased in/out, reorganized, etc.).   Normally, I hide all but the last 3 columns (years) of data, and the obsolete courses simply take up space.    My current solution is to maintain 2 versions of the spreadsheet, one "pruned"
the other not.  It would be better to simply hide any row where the enrollment was 0 say for the last 3 years.  I don't know how to do this within gnumeric, other than manually.
Comment 3 GNOME Infrastructure Team 2018-05-22 14:06:52 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/243.