Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
amars
Specialist
Specialist

Export to HTML Gridlines gets suppressed if cell is blank or missing

Hi all,

I am using a macro to export all object's in my dashboard to HTML.

Now the issue is the gridlines are not displayed on missing Cells, which makes it look distorted.

Is there a way to display the Gridlines (rather than putting some symbol for Missing or Null Values).

Distorted Image.JPG

Thanks in Advance

Regards

Amar

2 Replies
Not applicable

Could you past macro code here?

amars
Specialist
Specialist
Author

The macro is quite simple

set cs = ActiveDocument.GetSheetObject("myObjectId")
cs.ExportHtml "C:\test.html"