Attempted to hide an entire column in Keikai (5.x) failed [closed]

asked 2020-09-11 12:11:09 +0800

bztom35 gravatar image bztom35
103 4

updated 2020-09-11 14:05:00 +0800

I was attempted to hide Column E with range from E1 to E120; however, it has no effect. Maybe this was not the proper way to do it?

@List("onClick = #processColumn")
private void hideColumn() {

        //Hide Column E - from row E1 to E120

    Range rowRange = Ranges.range(ss.getSelectedSheet(), "E1:E120");


delete flag offensive retag edit

The question has been closed for the following reason "the question is answered, right answer was accepted" by cor3000
close date 2020-09-15 10:40:43

1 Answer

Sort by ยป oldest newest most voted

answered 2020-09-14 10:04:01 +0800

cor3000 gravatar image cor3000
6280 2 7

updated 2020-09-14 10:06:03 +0800

You can only hide/unhide entire columns/rows.

Also the documentation mentions you have to call toColumnRange first, otherwise calling setHidden won't have any effect:


Does this work in your case?

link publish delete flag offensive edit


Yes , I was able to hide a column based on your example.

bztom35 ( 2020-09-14 21:49:40 +0800 )edit

Question tools

1 follower



Asked: 2020-09-11 12:11:09 +0800

Seen: 7 times

Last updated: Sep 14 '20

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More