Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sheet Background Color ( issue on property > UseColorBkg )

Hi all,

i'm working on a macro that set up Sheet Background Color with gradients ( QlikView 9.SR5 Desktop x64)

My macro DOES apply all the parameters ( such as Primary and Secondary Color, Gradient Type, etc ) but it seems that property UseColorBkg isn't recognized : i need to activate sheet background color settings by hand after macro execution.

Any idea ? What am i doing wrong?

Cheers,

Fabrizio

Sub SetBackgroundCol(SheetId)

set vSheet = ActiveDocument.GetSheetById(SheetId)

set vSheetProp = vSheet.GetProperties

vSheetProp.BkgColor.Mode = 2

vSheetProp.BkgColor.PrimaryCol.Col = RGB(88,143,254)

vSheetProp.BkgColor.SecondaryCol.Col = RGB(128,143,254)

vSheetProp.BkgColor.FillDirection = 0

vSheetProp.BkgColor.FillPattern = 0

vSheetProp.UseColorBkg = true

vSheet.SetProperties vSheetProp

end sub





1 Solution

Accepted Solutions
Not applicable
Author

Hi,

I believe you also need to explicitly state that you do not want to use the document defaults for the background.

Try adding the following line to your macro -

vSheetProp.UseApplicationBkg = false

I hope this helps

Thanks

Nick

View solution in original post

2 Replies
Not applicable
Author

Hi,

I believe you also need to explicitly state that you do not want to use the document defaults for the background.

Try adding the following line to your macro -

vSheetProp.UseApplicationBkg = false

I hope this helps

Thanks

Nick

View solution in original post

Not applicable
Author

Nick!

* * * G R E A T * * * * *

Thank you so much! It works perfectly!!

You have avoided me a BIG embarrassment!

Best regards,

Fabrizio