border color

[#1]

hi

I want to give  a text object a border color using macro,and remove its rounded corners

Thnx in advance

[Anonymous]

Hi,

1. change border color

2. remove rounded corners

both can be do by the qlikview properties .. why u need macro for this ??

[Anonymous]

Hi,

Macro is not needed to remove rounded corners. You may go to the Layout tab in the Text object properties and uncheck on the 'Rounded Corners' .

Thanks,

[varshavig12]

The option is directly available in QlikView.

Why macro ?

[#5]

I know That but i want to Do it with Macro

[rubenmarin · Accepted solution]

Hi Nishit, this is the example on automation help for removing rounding cornes:

set mybox = ActiveDocument.GetSheetObject("LB01")

mbp = mybox.GetProperties

mbp.Layout.Frame.RoundedShape = true

mbp.Layout.Frame.FixCorner = true

mbp.Layout.Frame.Pixels = 10

mbp.Layout.Frame.Power = 2

mbp.Layout.Frame.EnableBottomLeftRounded = true

mbp.Layout.Frame.EnableBottomRightRounded = false

mbp.Layout.Frame.EnableTopLeftRounded = false

mbp.Layout.Frame.EnableTopRightRounded = true

mybox.SetProperties mbp

In your case I think you only need:

set mybox = ActiveDocument.GetSheetObject("LB01")

mbp = mybox.GetProperties

mbp.Layout.Frame.RoundedShape = false

mybox.SetProperties mbp