I have run into an issue with the ASND Export Facility and Office 2007 and need a little assistance confirming the problem. If you look at this discussion response, you will see the problem that Jan is running into. What I need from a few members of the audience playing along at home is the following:
If it works like it does on my work machine (Noes 6.5.x and Office 2003), Excel should show the leading zeros in the column and flag you to let you know that it's a number stored as text. You can either send me an email/IM with your results or, better yet, leave a comment.
Created 8/23/2007 12:53:44 PM email | website
Tested with Notes 7.0.2 and Office 2003 and it exported the leading zeros as you saw in your test with Notes 6.5 and Office 2003. Also got the number stored as text message.
Great app - I used it last year to help generate user registration files when we added thousands of users in a few months.
Created 9/9/2007 3:39:04 PM email | website
Through some testing by another user, we determined the problem had to do with the German version of Office. It seems that the word "General" was replaced with "Standard" in certain versions of Excel. Hopefully, I will be able to find out the exact circumstances that cause the problems and work around them.