Freeze rows and columns in Excel report output.

[David Beagan]

Someone asked about freezing columns in Excel report output. I did a quick check of the Creating Reports manual and found this feature. Freezing rows with HFREEZE has been around for years, columns seems to be a more recently added feature. Here is an example.

TABLE FILE ggsales
SUM UNITS DOLLARS
BY REGION 
BY ST
BY CITY
HEADING 
" Demonstration of freezing rows and columns "
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *
TYPE=REPORT, HFREEZE=ON, FREEZE-COLUMN=N2, $
END

 With FREEZE-COLUMN you identify how many columns to freeze, N2 for two columns.

 

[David Beagan]

I was wondering which of these features might be available in InfoAssist. I found that on the Format tab has an option in the toolbar Freeze which freezes the title and heading rows. I did not see any option for freezing columns. 

Fortunately, I could go into the text editor and add FREEZE-COLUMN. On subsequent editing of the report with InfoAssist it excepted it and retained it on saving in InforAssist.

This was all done in WebFOCUS rel. 9.1.

Edited February 11 by David Beagan