Skip to Main Content

APEX

How to prevent EXCEL scientific annotation in APEX 21.2?

Hi,
I am facing a very big problem and that is when using the apex_data_parser.parse() function it brings me the data of a numeric field in scientific notation (try as excel community says, but it keeps the scientific notation when the field is selected), but I can't find a way to fix that.
image.png
image.png
I am using the reference from Carsten Czarski's post.
https://blogs.oracle.com/apex/post/super-easy-csv-xlsx-json-or-xml-parsing-about-the-apex-data-parser-package
Thank you.

Comments
Post Details
Added on Jun 28 2022
1 comment
84 views