I'm using a reportviewer in VB.NET.
When the 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..?
A:
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
J Cooper
2010-09-28 05:15:56
Or you could try expressing all your widths as pts, but I think this would be harder to work with.
J Cooper
2010-09-28 05:19:36