VB.NET ReportViewer: Merged columns when exporting to Excel

I'm using a reportviewer in VB.NET.

When t开发者_运维知识库he user exports a report to Excel some of the columns get merged and hidden. is it possible to fix this?

Maybe by manipulating some code or a setting somewhere..?

---

Excel measures columns in pts, Report Viewer will let you measure in inches, pts, etc. If you are using in. in the report for your column widths try adjusting your column widths so that they convert without any rounding issues to pts. This worked for me. Conversion = 72 pts/inch. So 0.875 inch would convert to a nice even 63 points. Excel will be happy with that. Here is a conversion calculator: http://dx.sheridan.com/advisor/converter.html