search

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

Column width exception if no custom column width #52

Closed LifeBasher closed 6 years ago

LifeBasher commented 6 years ago

Hi, first of all thanks for the pluggin, we modified it a bit to add group by and some other functionnality but now since APEX 18, we got a problem with our colon width, in the IR_TO_XLSX package, the custom width has always been define there but since the new apex version, we tried your new version but it just go into the exception if we dont add a custom width. The problematic one is that one...

        v_col_width  := round(to_number(a_col_name_plus_width(v_i))/ v_coefficient);

We traced it so i'm sure it's from there but i cant find anything to replace and return with a column width like in older version of APEX 5 Do you have any idea? Thanks

LifeBasher commented 6 years ago

Nevermind, We found out that the a_col_name_plus_width(v_i) was returning a number with a . instead of a , so the to_number was crashing. We are looking at the environnement to see if it has been correctly configured with the number. Thank again!