Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting a decimal point to number in excel.

da5c60f6-cb40-488c-8764-0a8982d13ae1May 19 2017 — edited May 19 2017

Hi ,

I am developing in jdeveloper 12.2.1.0.0 I have a query related to export to excel functionality during a report generation.

Actually we have a report which we are generating using ADF query component. In the report , we have a Amount field which is of integer type. We are inserting a decimal point ie upto 2 decimals using minimum fraction 2 in adf .But now the challenge is when we are exporting the same report to excel also we need to insert it as a decimal point upto 2 decimals in the excel. Please suggest .

Please find the screenshots below for the same and suggest for a solution .

pastedImage_0.png

Now when we click on export to excel button ,it displays an excel as below . The values in Earn Amounts section should be inserted as a decimal point upto 2 decimals.

pastedImage_2.png

Thanks

Ravi Kiran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2017
Added on May 19 2017
#application-development-in-java, #jdeveloper-and-adf
2 comments
363 views