topic Disable column resize in straight/pivot/table box in QlikView

Disable column resize in straight/pivot/table box

Fri, 11 Jun 2010 22:12:26 GMT

I've searched the properties tab in straight, pivot and table box and couldn't find an option to disable column re-sizing. I see only the following options -

- Allow Drag and Drop

- Allow Move/Size

Is it even possible to disable resizing of a column ? I want to keep the width of each column pretty much static.

Thanks.

Disable column resize in straight/pivot/table box

Fri, 11 Jun 2010 23:07:58 GMT

try layout- near move-size there should be "size to data"

and to make colums alway the same size- I sometimes just make the header size a bit bigger by the lengh of it's name.

for example instel of

Customer-Sale-Q

Customer Name -Sales per customer-Quantity per Customer and so on..

Disable column resize in straight/pivot/table box

Fri, 11 Jun 2010 23:23:20 GMT

"Size to data" is already selected. It still is a problem. Tried unselecting - same thing. Also, I was looking at the Data Visualization example on the "Getting Started" page of the client. In the tables sheet, this is a good example where everything is locked down (column resizing, disallow move, etc) but I don't see where you actually set that option. This is actually what I need.

Disable column resize in straight/pivot/table box

Fri, 11 Jun 2010 23:29:14 GMT

I got it ! It's in Sheet Properties > Security > Move Size/Sheet Objects. This option must be unselected.

Disable column resize in straight/pivot/table box

Sat, 11 Jun 2011 15:25:06 GMT

Thanks Anthony, that helped me.

The interesting thing is that setting the "Allow Move/Size", at an individual object-level in the Layout tab of the Chart Properties dialogbox, seems to not have the same effect. We apparently have control over this behavior for objects at only the sheet level.

D.Will, ATP Engineering