We have a requirement to allow some columns to be show/hidden and others to only be shown based upon certain criteria per data loaded. For reference there is one particular column that needs to exist for data ref needs, but can never be shown. There are others that may be shown if the data is setup a particular way, but are usually hidden.
Currently I’m using this to hide the columns in question:
hiddenColumns: {
copyPasteEnabled: false,
indicators: true,
columns: [0, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23]
},
Column 0 has to always exist but be hidden. 13-23 can only be shown via the code and never by the user. I don’t want the indicator to show between any of the above columns. We do need to allow the user to hide other columns and show them that are shown by default. So we need the show to exist sometimes on the menu, but not others.
I haven’t found anyway to do this with the current hot api. Any clue here?