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
Dev

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

First off if you are wanting to display it as excel why would you be using HTMLFORM

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

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.

We have to figure it out without macro!

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.

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 ''
 

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

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?