Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro for increasing row height

I want a macro for increasing row height of a table

.

I could not find that in the API Guide

9 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi Sumit,

Can you elaborate the requirment.

What you want to do Actualy ??

Regards,

Nilesh Gangurde

Not applicable
Author

i have a table with 10 rows. i have incorporated another table below that with one row. For some selection the second table disappears and that creates a void space below the first table. to remove that void space i want to adjust the height of the rows in first table such that it occupies the void space left.

Not applicable
Author

Hi

Try this code,It will increase the cell height.

Sub Height

set TB = ActiveDocument.GetSheetObject("TB01")

set box=TB.GetProperties

box.Layout.MultiLine = 2

TB.SetProperties box

End Sub

Hope it helps you...

Regards

....

Not applicable
Author

can you use a variable in place of the 2 in the multiline properties?  I tried a few ways but not working.  What is syntax if possible, for using variable in macro

Not applicable
Author

Sub Height



set TB = ActiveDocument.GetSheetObject("TB03")

set box=TB.GetProperties
set vRows = ActiveDocument.GetVariable("vRowHeight")


box.Layout.MultiLine = vRows

TB.SetProperties box

End Sub

This is not working.  how do I pass the variable to the box.layout.multline setting?

tamilarasu
Champion
Champion

Hi Deborah,

Could you open a new thread for this issue. ?

Not applicable
Author

Not applicable
Author

This worked so I am good!  Thank you

tamilarasu
Champion
Champion

Glad the you found the solution.