Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] -HTMLFORMTYPE Excel - Data issue.
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] -HTMLFORMTYPE Excel - Data issue.
 Login/Join
 
Gold member
posted
Hi,

In the below code why my COL value is changed by default to scientific format(5.00E+61) in EXCEL, only if we use HTMLFORM?
Is there any solution to display the same value (5E061) using HTMLFORM?

  
DEFINE FILE CAR 
COL/A10 = '5E061'; 
END
TABLE FILE CAR
	 BY CAR BY COL 
ON TABLE HOLD AS REP001 FORMAT HTMTABLE
END
SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM BEGIN
!IBI.FIL.REP001;
-HTMLFORM END


Thanks in advance Smiler
Dev

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


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Reply With QuoteReport This Post
Master
posted Hide Post
First off if you are wanting to display it as excel why would you be using HTMLFORM




Scott

 
Posts: 865 | Registered: May 24, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
Because I have to change the text(Title and totals) to 90 Deg rotation, Because of that am using HTMLFORM with the help of CSS


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Reply With QuoteReport This Post
Master
posted Hide Post
If you are allowed, try using an excel template with an embedded macro to format. I use them for formatting, turning on filters, filtered subtotals, group borders, etc.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 958 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
We have to figure it out without macro! Frowner


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
Try using FORMAT XLSX with styling / without an embedded macro.
Here's a FocalPoint link, Search for "excel style rotate title": Vertical column title to Excel . Check it out.
 
Posts: 3106 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi,

Sorry I might share my table request file.. May be this will give you all in more clear.
I have both BY and Across columns, BY alias name we can know it is static. but across columns it will be quiet difficult (even we can hold the across value and load it line by line as a variable). but the think is How my value's are loading alpha to scientific form?

 
ABLE FILE HMRD7
SUM
     SELECTX AS ''
	 CUR_MI_F NOPRINT
BY SORT1 NOPRINT
BY HIGHEST DLVRBL_PLATN_Y NOPRINT
BY ITEM_A AS 'S.No'
BY APQ008X AS 'PMT'
BY APQ01TE_N AS 'Supp'
BY APQ10_C AS 'Code'
BY APQ20STAT_X AS 'Status'
BY NTEI AS 'Count'
BY APQ20RT_N AS 'Comm'
BY NO_OPEN AS 'Open'
BY COMMMS_DEL AS 'Steps'
BY SCH_DLVRBL_ED_CMPLTN_Y AS ' to Green'
BY APQ01TING_C AS 'Verfication'
BY S_MGR AS 'S Manager'
BY APQ0_CDS_D AS 'Sneer'
BY LNG    AS 'Lneer'
BY LEYER AS 'Lyer'
-SET &K = 1;
-REPEAT :Loop_visits13 &Visits_cnt.EVAL TIMES
BY AVISIT&K.EVAL AS '&Visits_Head&K.EVAL'
-SET &K = &K + 1;
-:Loop_visits13

-SET &K = 10000;
-REPEAT :Loop_PPAP13 &Late_cnt.EVAL TIMES
BY AA&K.EVAL AS '&PPAP_Head&K.EVAL'
-SET &K = &K + 10000;
-:Loop_PPAP13

BY DUMM1 AS 'Direct,sted Date'
BY DUMM2 AS 'Meeting, Summary/Notes'
BY VISIT_VAL NOPRINT

ACROSS DLVRBL              NOPRINT
ACROSS APE_C  NOPRINT
ACROSS PGN_DT AS ''
ACROSS BURG NOPRINT
ACROSS COLOR_VAL NOPRINT
ACROSS DLV_X AS ''
 


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
Once the data stream has left WebFOCUS, the display of your "report" is down to the application in which it is displayed - in your instance MS Excel.

So you should understand how MS Excel interprets any data that it is given as that is where your answer will lie.

E.g. If you wanted a text value not to be re-interpreted by MS Excel then you would probably prefix it with a single quote - doing that in WebFOCUS will then see MS Excel happily displaying the single quote as well!!

Remember that Microsoft thinks it knows better than you as regards what you want - or is it trying to be helpful? Jury is still out!

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5686 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
Tony its true what you said.

Why the same MS Excel is not thinks better while we use EXL2K, XLS & XLSX formats!
Why it is truly behave while we use HTMLFORM XLS?


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] -HTMLFORMTYPE Excel - Data issue.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.