Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] COLSPAN works with HTML by not EXCEL

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] COLSPAN works with HTML by not EXCEL
 Login/Join
 
Platinum Member
posted
WF AppStudio 8105m

Why does this code work in HTML by not EXL07

  
DEFINE FILE CAR
BLK/A1='';
END
TABLE FILE CAR
PRINT COUNTRY CAR MODEL BODYTYPE BLK AS '' SEATS DEALER_COST RETAIL_COST SALES BLK AS '' LENGTH WIDTH HEIGHT WEIGHT WHEELBASE 
 
ON TABLE SUBTOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'Grand Total'
 
SUBHEAD
"Why does this work in HTML but not EXL07"
""
HEADING
"This will colspan4<0+> <0+>This will colspan4<0+> <0+>This will colspan5"
-*ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
	 GRID=ON,
$
TYPE=REPORT,
     FONT='Verdana',
     SIZE=10,
$
TYPE=TABHEADING,
     FONT='Verdana',
     JUSTIFY=LEFT,
	 COLOR=BLACK,
	 STYLE=BOLD,
	 SIZE=12,
$
TYPE=HEADING,
     HEADALIGN=BODY,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=1,
     FONT='Verdana',
     JUSTIFY=CENTER,
	 OBJECT=TEXT,
	 STYLE=BOLD,
	 COLSPAN=4,
	 BACKCOLOR=RGB(50 50 50),
	 COLOR=WHITE,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=1,
     FONT='Verdana',
     JUSTIFY=CENTER,
	 OBJECT=FIELD,
	 STYLE=BOLD,
	 COLSPAN=4,
	 BACKCOLOR=RGB(50 50 50),
	 COLOR=WHITE,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=2,
     FONT='Verdana',
     JUSTIFY=CENTER,
     OBJECT=FIELD,
	 STYLE=BOLD,
	 COLSPAN=1,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=3,
     FONT='Verdana',
     JUSTIFY=CENTER,
	 OBJECT=TEXT,
	 STYLE=BOLD,
	 COLSPAN=4,
	 BACKCOLOR=RGB(50 50 50),
	 COLOR=WHITE,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=3,
     FONT='Verdana',
     JUSTIFY=CENTER,
	 OBJECT=FIELD,
	 STYLE=BOLD,
	 COLSPAN=4,
	 BACKCOLOR=RGB(50 50 50),
	 COLOR=WHITE,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=4,
     FONT='Verdana',
     JUSTIFY=CENTER,
     OBJECT=FIELD,
	 STYLE=BOLD,
	 COLSPAN=1,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=5,
     FONT='Verdana',
     JUSTIFY=CENTER,
	 OBJECT=TEXT,
	 STYLE=BOLD,
	 COLSPAN=5,
	 BACKCOLOR=RGB(50 50 50),
	 COLOR=WHITE,
$
TYPE=HEADING,
     LINE=1,
	 ITEM=5,
     FONT='Verdana',
     JUSTIFY=CENTER,
	 OBJECT=FIELD,
	 STYLE=BOLD,
	 COLSPAN=5,
	 BACKCOLOR=RGB(50 50 50),
	 COLOR=WHITE,
$
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Virtuoso
posted Hide Post
Jveselka

Your right it won't work with EXL07 or XLSX but does work with EXL2K.. But I have no clue why.. Sorry


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Expert
posted Hide Post
DEFINE FILE CAR
BLK/A1='';
END
TABLE FILE CAR
PRINT COUNTRY CAR MODEL BODYTYPE BLK AS '' SEATS DEALER_COST RETAIL_COST SALES BLK AS '' LENGTH WIDTH HEIGHT WEIGHT WHEELBASE
BY BLK NOPRINT
ON TABLE SUBTOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'Grand Total'

ON BLK SUBHEAD
"Why does this work in HTML but not EXL07"
""
HEADING
"This will colspan4<0+> <0+>This will colspan4<0+> <0+>This will colspan5"
-*ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
GRID=ON,
$
TYPE=REPORT,
FONT='Verdana',
SIZE=10,
$
TYPE=TABHEADING,
FONT='Verdana',
JUSTIFY=LEFT,
COLOR=BLACK,
STYLE=BOLD,
SIZE=12,
$

TYPE=SUBHEAD, HEADALIGN=BODY, COLSPAN=15,$

TYPE=HEADING,
HEADALIGN=BODY,
$
TYPE=HEADING,
LINE=1,
ITEM=1,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=TEXT,
STYLE=BOLD,
COLSPAN=4,
BACKCOLOR=RGB(50 50 50),
COLOR=WHITE,
$
TYPE=HEADING,
LINE=1,
ITEM=1,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=FIELD,
STYLE=BOLD,
COLSPAN=4,
BACKCOLOR=RGB(50 50 50),
COLOR=WHITE,
$
TYPE=HEADING,
LINE=1,
ITEM=2,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=FIELD,
STYLE=BOLD,
COLSPAN=1,
$
TYPE=HEADING,
LINE=1,
ITEM=3,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=TEXT,
STYLE=BOLD,
COLSPAN=4,
BACKCOLOR=RGB(50 50 50),
COLOR=WHITE,
$
TYPE=HEADING,
LINE=1,
ITEM=3,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=FIELD,
STYLE=BOLD,
COLSPAN=4,
BACKCOLOR=RGB(50 50 50),
COLOR=WHITE,
$
TYPE=HEADING,
LINE=1,
ITEM=4,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=FIELD,
STYLE=BOLD,
COLSPAN=1,
$
TYPE=HEADING,
LINE=1,
ITEM=5,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=TEXT,
STYLE=BOLD,
COLSPAN=5,
BACKCOLOR=RGB(50 50 50),
COLOR=WHITE,
$
TYPE=HEADING,
LINE=1,
ITEM=5,
FONT='Verdana',
JUSTIFY=CENTER,
OBJECT=FIELD,
STYLE=BOLD,
COLSPAN=5,
BACKCOLOR=RGB(50 50 50),
COLOR=WHITE,
$
ENDSTYLE
END


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
There's got to be a way to make this work....It seems to work on the first span but then it gets lost.


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Platinum Member
posted Hide Post
Tom, did that work for you? I can't make it happened on my end.


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Expert
posted Hide Post
Yes - works perfectly!
Will update my Profile: 8.1.05m Server
Added BACKCOLOR=TAN to double-check, works...
Trying to find a site to upload...

TYPE=SUBHEAD, HEADALIGN=BODY, COLSPAN=15, BACKCOLOR=TAN, $

See if you can see this:

EXL07 Car Report

This message has been edited. Last edited by: Tom Flynn,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
Added the image, hope you can get to it...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
Nope, did you opened it with EXL07 and you are on 8105m?


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Expert
posted Hide Post
Yes, and, Yes...
What site can you get to for images?


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
Please email to jveselka@txfb-ins.com


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Expert
posted Hide Post
Incoming - Let me know that you received it...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
That is not what I need. Run it in HTML and you will see how it should look.

The ""Why does this work in HTML but not EXL07" should stay at the top and about each column should be the span
"This will colspan4<0+> <0+>This will colspan4<0+> <0+>This will colspan5"

Maybe I have my SUBHEAD and HEADING out of place.

I emailed you a pic


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Platinum Member
posted Hide Post
Or better yet, just set my original code to output to EXL2K. This will show you how I want it, but EXL2K is a SOB to open due to all the popups.

Thanks
JV


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Expert
posted Hide Post
I do see minor differences - Don't code in the GUI, so, there's that...

Not going to debug all the styling for the HEADING;
Something is overriding something, I'm sure you'll figure it out...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
Here is a better example

Run it as is and you will see that the COLSPAN works for both ITEM1 and ITEM2 but ITEM2 is not displaying HELLO. If you comment out the call for ITEM1, HELLO shows up but ITEM1 is now only over the first column (as it should without call).

 
TABLE FILE CAR
SUM SALES BY COUNTRY BY CAR BY MODEL BY SEATS BY CAR
ON COUNTRY SUBHEAD
"This is my subhead<0+>HELLO"
" "
"Country is:<COUNTRY Car is:<CAR"
"Model is:<MODEL"
IF COUNTRY EQ 'ENGLAND'
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLESHEET * 
TYPE=SUBHEAD, HEADALIGN=BODY, $ 
TYPE=SUBHEAD, LINE=1, ITEM=1, COLSPAN=2, JUSTIFY=CENTER, $ 
TYPE=SUBHEAD, LINE=1, ITEM=2, COLSPAN=2, JUSTIFY=CENTER, $ 
ENDSTYLE
END
 


Again this works fine in HTML and EXL2K
Is <0+> the right function to separate the two items?


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
Expert
posted Hide Post
It's <+0> - not <0+>

TABLE FILE CAR
SUM SALES BY COUNTRY BY CAR BY MODEL BY SEATS BY CAR
ON COUNTRY SUBHEAD
"This is my subhead<+0>HELLO<+0>"
" "
"Country is:<COUNTRY Car is:<CAR"
"Model is:<MODEL"
IF COUNTRY EQ 'ENGLAND'
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=BODY, STYLE=BOLD, $
TYPE=SUBHEAD, LINE=1, ITEM=1, COLSPAN=2, JUSTIFY=CENTER, $
TYPE=SUBHEAD, LINE=1, ITEM=2, COLSPAN=2, JUSTIFY=CENTER, $
ENDSTYLE
END

-EXIT


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Virtuoso
posted Hide Post
Good One I went back to the original example and replaced the <0+> with <+0> and all is well.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
YES>>>>I figured it out and I can't believe what it was........

This

"<0+> <0+> <0+>This is my<0+> <0+>heading<0+> <0+>line2"

should be

"<+0> <+0> <+0>This is my<+0> <+0>heading<+0> <+0>line2"



My bad....ughhhh

Thanks


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 156 | Registered: August 23, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] COLSPAN works with HTML by not EXCEL

Copyright © 1996-2020 Information Builders