Focal Point
[SOLVED]Freeze top row of the excel
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 , December 27, 2016 07:41 AM 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.04 Upgrade: WebFOCUS 8.2.07 OS: Linux Outputs: 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
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.04 Upgrade: WebFOCUS 8.2.07 OS: Linux Outputs: 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
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
Regards,
IP
Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML