Focal Point
[SOLVED]Freeze top row of the excel

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9057089486

December 21, 2016, 08:34 AM
info4pal
[SOLVED]Freeze top row of the excel
Hi,

Can we freeze the top-row of the excel workbook.
Please let me know.

Regards,
IP

This message has been edited. Last edited by: info4pal,


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
December 21, 2016, 09:46 AM
Francis Mariani
Yes, though it's an undocumented "feature" which suggests it may disappear. The following command freezes the headings and column titles:

TYPE=REPORT, HFREEZE=TOP, $


HFREEZE is documented to be used with HTML reports only, but I have successfully used it with EXL2K.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 21, 2016, 03:25 PM
Waz
Nice.

Have you also used it with XLSX ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 21, 2016, 05:42 PM
Francis Mariani
Just tried it - of course, it doesn't work Frowner

I haven't started using XLSX - not ready for prime time (in 8.0.08).


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 21, 2016, 06:23 PM
Waz
My offsider here also checked it out to no avail.

XLSX in general seems to work on in 8.1.04, but Report Caster doesn't support it.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 22, 2016, 01:55 AM
info4pal
Hi,

Thanks a lot Francis Smiler and Waz too.

But Iam using EXL07 and it doesn't work in 8105 version.
It works fine in EXL2K but I want EXL07?

Any workaround to make it work in EXL07 as well...Any suggestions please.

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
December 22, 2016, 10:30 AM
J.L. Hinds
Would running an "auto_open" macro be an acceptable option? We do quite a bit of formatting this way.


WebFOCUS 7.6
Windows, All Outputs
December 23, 2016, 03:57 AM
Wep5622
Alternatively, you can use an xltx or xltm template with the correct rows frozen.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
December 23, 2016, 06:53 AM
info4pal
Hi,

Thanks a lot J.L Hinds and Wep5622.I will try that option too Smiler

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML