Focal Point
in webfocus5.3 , EXL2K with boder tables and colspan for a row

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

November 17, 2006, 01:56 AM
naveen rao
in webfocus5.3 , EXL2K with boder tables and colspan for a row
i have 2 questions. I am using excel 2000 and the "boder" for the table is not working . can any one please tell me how to do in excel 2000.
next question, i have a report in excel with 2 tables one after other. I am using "ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK" and "ON TABLE PCHOLD FORMAT EXL2K CLOSE" to get the report in one excel file. In first table i have 3 columns and in 2nd i have only one column. I want the 2nd table column to have 3 cell in excel to merge and show the data .
November 17, 2006, 03:27 PM
Tomsweb
Are you sure that "BORDER" is correctly spelled
in your code?

Confused

Just a thought?


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
November 17, 2006, 05:02 PM
reFOCUSing
to my understanding border only works in html and pdf.
November 27, 2006, 02:54 PM
Kerry
Hi Naveen,

For your first question, reFOCUSing is right that, the BORDER and GRID options are not available for EXCEL formats -- they
are primarily intended for use with HTML and PDF formats. This document may be of interest: Using BORDER and GRID for EXL2K format worksheets

For your second question, can you please post a sample code so we can take a look at what you are trying to do?

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.