Get data from Excel - Currency data crashes Notes

HCL Domino Domino Forum
1

When I retrieve data from Excel into a notes document, Notes crashes “NSD is running…”. This has been running without error in release 5 and previous. Now - only in r6 and above we encounter this problem.

When I change the datatype in the spreadsheet to number instead of currency, the import works fine. I really don’t want to re-deploy this spreadsheet. Any suggestions?

set excel = createobject(“Excel.Application”)

Excel.visible = false

excel.workbooks.open xlFileName

Set xlWorkbook = Excel.ActiveWorkbook

set xlSheet = xlWorkbook.ActiveSheet

…

NewDoc.Purpose = .range(“Purpose”).value (this works fine)

NewDoc.Cost1 = .range(“Cost1”).value (this crashes Notes when Cost1 in excel is currency data type)

2

Subject: Known bug in 6.5.3. Workaround: NewDoc.Cost1 = Cdbl(.range(“Cost1”).value)

3

Subject: THANX BILL…

That solved a long standing issue.

4

Subject: Get data from Excel - Currency data crashes Notes

Are you using SP2?

I had no problem till SP2 came along , organization is using all versions from 6 to 6.5.2,

but however after SP2 and 6.5.3 the feature stopped working. There seems to be a fix for this in FP1 for 6.5.3 and in upcoming 6.5.4, but I cannot find the 6.5.3 FP1 on the site,

It is a known regression caused in 6.5.3.