When I try to generate excel report with exl2k format with hfreeze it is working great but when I tried to generate with xlsx format it is not working.
Can someone help me with this issue.
TABLE FILE CAR PRINT * ON TABLE PCHOLD FORMAT XLSX ON TABLE SET STYLE * TYPE=REPORT, HFREEZE=ON, SCROLLHEIGHT=2.000000, $ END
Thank you advance.This message has been edited. Last edited by: FP Mod Chuck,
Almost everything we do is Excel and HFREEZE has never worked for us, I quit trying years ago. In the 8204 documentation, when HFREEZE is discussed, it is always in reference to HTML output and sometime AHTML. As far as I know it is not supported for any Excel output. We do the Excel equivalent to HFREEZE and many other thing WebFOCUS doesn't do with Auto_Open macros and Excel templates. What is a macro? Just a VB program. Over the years, I've developed a whole library of code to do all kinds of thing: Turn on Filter, draw borders, draw group borders, filtered subtotals(count, count distinct, total, etc.), insert comments, auto fit columns and rows, vertical center, vertical merge cells and more. I rarely record macros anymore, just pull code out of other macros.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
|Powered by Social Strata|