0

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

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

bztom35 gravatar image bztom35
53 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");

     CellOperationUtil.hide(rowRange);
     rowRange.setHidden(true);

}
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
1

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

cor3000 gravatar image cor3000
5399 2 7
ZK Team

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:

https://doc.keikai.io/dev-ref/bookmodel/HideRowsandColumns

Does this work in your case?

link publish delete flag offensive edit

Comments

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

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

Question tools

Follow
1 follower

RSS

Stats

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

Seen: 7 times

Last updated: Sep 14

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