Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Title freeze is not working xlsx but working for exl2k
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Title freeze is not working xlsx but working for exl2k
 Login/Join
 
Gold member
posted
Hello,
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,


WebFOCUS 7.X.X, 8.X.X
Windows, All Outputs
 
Posts: 71 | Registered: February 02, 2016Reply With QuoteReport This Post
Master
posted Hide Post
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.
 
Posts: 918 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Title freeze is not working xlsx but working for exl2k

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.