In a Cross Table, how do I change the width of the columns all at the same time.

[Guillermo Chutrau 2]

In 7.6, in a Cross Table,

 

how do I change the width of the columns all at the same time and not one by one

Is there a way to set a default and "reset to the default"

Can I select several columns and change the width for only the selected columns

 

Thank you

[Andrew Berridge]

Hi there,

We changed this behaviour in Spotfire 7.6. Previously it was only possible to size all columns all at once, which we felt was too restrictive, so we can now set individual column widths. We chose this to replacethe functionality to size them all at once. There's no concept of column selection in a cross table so that won't work either.

You can set the cross table cell width using IronPython - that should set all columns to the same width. Something like:

from Spotfire.Dxp.Application.Visuals import *

vis = vis.As[CrossTablePlot]()

vis.CellWidth = 100

Pass in the cross table plot as a parameter to your script called "vis".

Andrew (TIBCO Data Science)

[Guillermo Chutrau 2]

Hold the CTRL key while dragging the column border and all columns will resize at the same time.

[christopher sawtelle 2]

So you can not adjust the column widths individually in a cross table prior to 7.6  At least this is what I see which is really stupid.  So I have to make all columns huge just so I can see the data in one particular one

 

This ranks right up there with removeing the scroll arrows, especially on the filter boxes so you only have  a slider bar.  Who could have possibly thought these were good ideas

[Sundeep Madichatti]

Hi@andrew, your script works for the columns, but I've got this scenario where I have column names on the Y-axis whichcan be changed by slider, when I change the slider,the column width is not fixed and it gets clumsyeverytime, users have to adjust the column width everytime time in web player when they access and itis annoying, is there a solution for that!! attached pictures I think you will have better understanding

 

PS: I posted it as an answer because for comments I didnt get any option to upload picture, sorry!!!

[Adam Bale]

I'm very green regarding scripting. What would be the best way to run the above script for multiple cross tables. Spotfire keeps crashing on me and I think it may be passing in multiple parameters/visualizations with the same "vis" name. 

[Mike Akister]

Andrew how do you specify which column to change the width for  Thanks! Mike

[Sietske Bakker]

Hi Andrew, I have the same issue: I always need to manually change each column size to have my crosstable layout properly. When I select all column only the size of one will change as opposed to for example changing text orientation. How do I change the width of all the columns simultaneously

Thanks!

Sietske