topic accessing border properties in extension in QlikView

accessing border properties in extension

Mon, 14 Oct 2013 05:42:34 GMT

Hi All,

What is the code to access border properties in an

extension using JScript?

or a macro?

Ex)

Borderwidth,bordereffect, color etc

Thanks,

Anju

shreyashetty_ge — Mon, 14 Oct 2013 06:00:39 GMT

Hi.. Y use a macro when you have it in your chart properties

Mon, 14 Oct 2013 06:02:59 GMT

Hi Shreya,

Because I want to be able to access all the objects with the macro.

Mon, 14 Oct 2013 06:08:11 GMT

Hi,

In Macro, you can try like this,

set up = ActiveDocument.GetApplication.GetUserPreferences

up.BorderEffect = 3 ' walled

ActiveDocument.GetApplication.SetUserPreferences up

Mon, 14 Oct 2013 06:13:04 GMT

Hi Sindhu,

How do I access it for a a particualar object?

Mon, 14 Oct 2013 06:17:13 GMT

Try this,

set mybox = ActiveDocument.GetSheetObject("LB01")

mbp = mybox.GetProperties

mbp.Layout.Frame.BorderEffect = 3

mbp.Layout.Frame.Color.PrimaryCol.Col = RGB(255,0,0)

mbp.Layout.Frame.BorderWidth = 5

mybox.SetProperties mbp

Mon, 14 Oct 2013 06:21:03 GMT

Hi Sindhu,

Is it possible to iterate through all the listboxes in a given document?