CloudERP - Excel Desktop Integration

Sandip Kumar, PMP, CPIM

Summary

Issue in exporting data in Excel format

Content

Unfortunately, this is not a bug. Rather, it is the result of a security fix that had to be implemented due to an 
Excel security vulnerability called "CSV formula injection". Please search the web for "CSV formula injection" 
for further details on this vulnerability. 

A workaround is documented on file Bug27012520 _Workaround.doc, basically a Search and Replace 
on the exported file. 

Also, other customers have asked if this new behavior is permanent, yes, this behavior will be permanent at least 
until either Microsoft fixes the vulnerability on Excel or Oracle Developers find a less disruptive solution. 

Also refer below KM note: 
Export To Excel now includes an single quote on negative numbers ( Doc ID 2331252.1 ) 

Sandip Kumar, PMP, CPIM

Oracle Developer could do the following: 

#01: During import process, it should check for "CSV Injection" security issue. 

#02: During export it could give an option: Format with special character (Default - NO) so that someone who is not aware of - will get simple excel / csv file export. 

This should be a simple fix rather than turning this as a feature and waiting for Microsoft to check/ change Excel first. 

Thanks
Sandip Kumar

Wendy Ware

Thank you for sharing this information on this forum!  It was on my to-do list to figure out how/why/when this was happening.  Now I have an answer before I even asked the question!  Wendy