Hi,

I tried fining a way to solve this but I can't. Please help me!

I have an excel report that shows 2 decimals(123.45), when I click on the particular cell, I see 4 decimals coming up in function area like (123.4567) but I want to show upto 6 decimals (123.456789) which I cant.

Here is my sample code.

DEFINE FILE CAR
FLD_1/D12.6 = 12.34567800;
END
TABLE FILE CAR
PRINT
CAR
FLD_1/D12.2
BY COUNTRY
ON TABLE PCHOLD FORMAT XLSX
END
-RUN
  

Thank you.

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

With this code I see 6 decimals in Excel (2016)

 
DEFINE FILE CAR
FLD_1/D12.6 = 12.34567800;
END
TABLE FILE CAR
PRINT
CAR
FLD_1
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL07
END
-RUN
 

XLSX also works by the way.

quote:

FLD_1/D12.2

With the above pav you redefines the output format to only see 2 decimals. So to see up to 6 decimals you have to remove the reformatting as per suggested by Frans.

Thanks for the reply frans and martinY.

I am trying to show upto 2 decimals in the body for excel(display value) but When we click on the data than in the function bar or edit bar on top of the columns it should show decimals upto 6.


Example :

---------------------------------------------------------------------------------------------------
12.541234
---------------------------------------------------------------------------------------------------

col_1 col_2

1 12.54 (when you click on this value than on top(function bar) is should upto 6 decimlas)
2 14.58
3 59.59
4 15886.36
5 45.89



Please let me know if you still did't understand my question.

Thanks.

What's to format, in the synonym, of the source field?

here is the mas file
FIELDNAME=MONTH, ALIAS=month, USAGE=D9.8BC, ACTUAL=A15,
MISSING=ON,

pav,

Now you are asking for Excel feature which WebFOCUS as no direct control on it.

What you should do is to have your TABLE file producing the report with the 6 decimals to an Excel macro file where you will add an Excel formatting macro in it to have the column displayed with only 2 decimals.
You need to rely on Excel for your request, not FOCUS.

Thank you for the information martinY