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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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;
TABLE FILE CAR
ON TABLE PCHOLD FORMAT XLSX
Thank you.This message has been edited. Last edited by: FP Mod Chuck,
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.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2410 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013