Unable to Show Last Column After Hiding

Tags: #<Tag:0x00007efc656c6098>
#1

When the backing data has more columns than handsontable, I am unable to show the last column.
I’ve created a basic jfiddle here:
http://jsfiddle.net/abmk829z/2/

#2

Hey Bryan,

columns settings that you use always represent the set of columns. If you define only two objects in the columns array you will get only 2 columns.

Try removing

columns: [{
      data: 'A'
    },
    {
      data: 'B'
    }
  ]
#3

Aleksandra,

Thank you for your response. For my use case, the user should only be able to view specific fields in data() and I need to set custom renderers and editors on the fields that I am displaying

#4

You still can add column while using the above structure, but you need to manipulate the array defined in columns. It can be done by calling updateSettings.

#5

Aleksandra,

I’ve updated my example here: http://jsfiddle.net/r8aypd0u/

I have three fields in ‘data’, but I only want two of them displayed in the table, so I used the columns to only display the two fields. The problem occurs when I try to hide columns.
If I try to hide column ‘B’, I am unable to show it again.

20%20AM
Screen Shot 2019-11-04 at 11.09.20 AM.png1472×840 62.3 KB

39%20AM
Screen Shot 2019-11-04 at 11.17.39 AM.png1470×852 60.7 KB

#6

Hey Bryan,

hiding has to be done via hiddenColumns plugin to be available in the default dropdown/context menu. If you want to use columns instead you’d need to create a custom option for the context menu.

#7

Aleksandra,

I am using the hiddenColumns plugin. It works for column A, but not for column B.
If you look at the second screenshot, the “Show column” option does not display even though column B was hidden using the hiddenColumns plugin.

#8

Thank you for sharing the description. It looks like we do not have this issue reported on Github so I’ve posted it here https://github.com/handsontable/handsontable/issues/6426 and will update you as soon as we get this done.

#9

Hi @bryan.miller

I have good news! We’ve just released 8.0.0-beta2 that fixes the mentioned issue. We won’t be closing this ticket now. It will be closed after we release the final 8.0.0 version of Handsontable.

Here’s a full list of changes https://github.com/handsontable/handsontable/releases/tag/8.0.0-beta.2
NPM https://www.npmjs.com/package/handsontable/v/8.0.0-beta.2

All feedback’s appreciated. Thank you for your input.

#10

This issue was solved in v.8.0.0.