Focal Point
[CLOSED] merge cells in excel

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

November 18, 2017, 11:04 AM
getit
[CLOSED] merge cells in excel
Is there a way to merge cells 1A and 2A using css( I tried the following). Dont want to use HTMLFORM.
  
TABLE FILE CAR
PRINT 
COUNTRY AS  '<table tr><td style="border-collapse: collapse; margin: 0; width: 100%; ">COUNTRY1</td></tr></table>' 
SALES 
SEATS
HEADING
"<+0>  <+0>COMBCOLUMN"
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$

TYPE=HEADING,HEADALIGN=BODY,$
TYPE=HEADING,HEADALIGN=BODY,LINE =1,ITEM=1,COLSPAN=1,WRAP = OFF,$
TYPE=HEADING,HEADALIGN=BODY,LINE =1,ITEM=2,COLSPAN=2,WRAP = OFF,$
ENDSTYLE
END  

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


App Studio Version 8202
windows Platform
SQL Server 2008/2012
November 20, 2017, 12:10 PM
FP Mod Chuck
Hi Getit

Maybe I am simplifying the problem too much but way don't you create a DEFINE or COMPUTE that concatenates the info together..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 21, 2017, 11:41 AM
getit
No, I created this example for a more complicated problem, This problem is related to be able to merge the two cells vertically.


App Studio Version 8202
windows Platform
SQL Server 2008/2012
November 22, 2017, 02:39 PM
FP Mod Chuck
Getit

I guess I don't understand. Do you want two values in a single cell or do you want to aggregate?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 22, 2017, 04:18 PM
Francis Mariani



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
November 27, 2017, 08:52 AM
jgelona
I have a report similar to this. I did it with a macro enabled template. Using the example that Francis has, "APPLE" would be in cell A1 and cell A2 would be blank. The use excel to vertically merge cells A1 and A2.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
November 28, 2017, 08:51 AM
Rifaz
Might help
Merging cells using CSS - Excel


-Rifaz

WebFOCUS 7.7.x and 8.x