This is not a bug but an enhancement request. This is where the "File an enhancement request" link brought me.
I think it would be a good idea to be able to create various views on a spreadsheet in the same way it is possible to create different views on a database table.
After going to considerable effort hiding/showing columns in a large spreadsheet it would be good to be able to save that as a view and allow the user to give that view a meaningful view name.
That way, a user could rapidly load frequently used views of the same sheet which would be very convenient.
Hi @JP, have you looked into Menu/Data/Group & Outline?
It allows group columns/rows on several level for hide and show.
Seems reasonable request