Problems copying Japanese titles from Excel to Prism.

This problem only occurs if you run a Japanese version of Windows. The problem occurs when you copy a block of data with titles in the top row from Excel, but the leftmost cell of that top row is blank.

 

When you paste into Prism, the numbers all paste fine, but the titles do not paste. The titles in Prism either remain blank or are replaced with "@". 

 

The bug appears to be within Excel, and we have not yet found a  way to fix Prism to bypass the problem. The only workaround is to put some text into that top left cell of the Excel worksheet.