Discussion Board for collaboration on QlikView Integration.
Does anyone have example of script to change the color of table box ?
Click on the Design Grid icon :
Then, right click on your table box and choose Custom Format Cell.
Hope this helps,
Thanks Bruno, I am able to do it in menu, How to do it in the script .. I am trying like
set TB = ActiveDocument.GetSheetObject("TB01")msgbox(TB.GetrowCount)
If TB.GetrowCount > 1 thenset prop = TB.GetPropertiesprop.Layout.Frame.Color.PrimaryCol.Col = RGB(0,0,0)
This does not work
Means you are doing it through macro
Hi kamal ,
In UserPreferences -> design -> check Always show design Grid Menus
and right click on any cell value of Table Box, Straight table and Pivot table..
U can have one Option RightClick -> Custom format Cell
Through that U can change color and font of Cell value..
yes.. I want to do it in macro