Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I want to email a QV Straight or Pivot Table to a colleague who does not have access to the app.
When I copy the Full Table and paste to an email it pastes in an ugly default format: Times New Roman font, double line cell borders.
This behaviour happens when I paste into a Word document as well.
Any idea how I can copy over the formatting on the table in Qlikview, or otherwise change this default format?
Thanks
Mike
You can use this macro
SUB Font
set obj = ActiveDocument.GetSheetObject("CH01")
set fnt = obj.GetFrameDef.Font
fnt.PointSize1000 = fnt.PointSize1000 + 1000
fnt.FontName = "Calibri"
fnt.Bold = false
fnt.Italic = false
fnt.Underline = true
obj.SetFont fnt
END SUB