Forum Discussion
Fixed column width
Hi All, I have a matrix with four columns, when at the input side user changes the column name the width of the column is changing automatically, for this i have used "REPT" function to fix the column width. when the user edits the column name first time the width is not changing but when it repeats(column name editing multiple times) the column width is changing, can anyone help with this?
Hi Balaji1414
According to my test,
- When the "auto-size" of "column headers" is off, the column will keep its length, which won't change automatically.
- When the new data is added the first time, the column would fit its width automatically.
- First set "word wrap" on, then set "auto-size" off, it would satisfy your scenario.
You can have a try .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Balaji1414
According to my test,
- When the "auto-size" of "column headers" is off, the column will keep its length, which won't change automatically.
- When the new data is added the first time, the column would fit its width automatically.
- First set "word wrap" on, then set "auto-size" off, it would satisfy your scenario.
You can have a try .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Why isn't it possible to just set the column width as fixed with the number of caracters in the formatting pane? Would make my life a whole lot easier and would save me a lot of time using work arounds like column width measures (REPT..)
Thx! Just want to stop by and say thanks😀
