Incorrect result exporting numbers with formatting

glebovpavel / IR_to_MSExcel

Oracle Apex plugin for Interactive Grid or Interactive Report

http://glebovpavel.github.io/Description_IR_TO_XSLX/

Other

39 stars 14 forks source link

Incorrect result exporting numbers with formatting #48

Closed p3t3r closed 6 years ago

p3t3r commented 6 years ago

IG grid export: Formatting with for example thousand separator doesn't work.

Problem is in the function getCellNumber: str.replace(re, ""); //remove all symbols except digits and decimalSeparator
should be str = str.replace(re, ""); //remove all symbols except digits and decimalSeparator

Additional question: Is it possible to keep the formatting in Excel for numbers? For example: 555,30 becomens 555,3 in Excel I want to keep to trailing zero.

glebovpavel commented 6 years ago

@p3t3r Hm, should be fixed in last bugfix https://github.com/glebovpavel/IR_to_MSExcel/commit/bb0bcec2e532e58596670ca36b6144dc26cf51db