I have created an XML mapping to an Excel spreadsheet. When I refresh the spreadsheet, in order to load the data into it, the values turns to scientific notation (exponent). I tried to change the cells type to general and text, but I get the same result. When I edit the XML and add a character which cannot be interpreted as any kind of number, (such as adding one of the following "'|`, then the scientific notation does not occur. But the action of modifying the XML is impractical and the result after the modification is undesired.
I hope you could shed some light on the issue. Thanks.
Bookmarks