London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off

Export XForms to Excel

emil.wiklund@dropit.se
emil.wiklund@dropit.se
Vote:
 
Hello I have a problem on a site. I´m trying to export a XForm to Excel. It works fine execept for some fields. In the form we have a textfield where the customer should put her creditcard number. If they write for exemple 1234123412341234, EPiServer saves the correct value in the database. But when i tries to export to Excel i get 1234123412341230. The last number becomes "0". This happens only if there are more than 15 numbers. What is wrong, is it the export function that dosen´t work correct or is it Excel that handels this wrong? Is there any workaround or solution for this? We are using EPiServer 4.50.5.176 /Emil
#17677
Jul 11, 2007 9:00
Vote:
 
The problem is that Excel treats the cardnumber as a large integer, and as such it suffers from "The 15 significant digit limitation". You'd get the same behaviour if you enter 1234123412341234 in a cell and hit enter. More on this limitation can be found in this thread: http://groups.google.se/group/microsoft.public.excel.misc/browse_thread/thread/ddb7f26b246a66a5/de70bf58b8b7ff9f?lnk=st&q=%22The+15+Significant+Digit+Limitation%22&rnum=1&hl=sv#de70bf58b8b7ff9f The solution would be to get Excel to treat the number as a textstring instead, possibly by prepending the number with an apostroph ' This would require you to add some code upon formsubmit to take care of this prepending, check out the event 'BeforeSubmitPostedDataEvent' for the XFormControl. Regards, Johan Olofsson EPiServer AB
#18520
Jul 11, 2007 9:55
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.