ReportViewer Export to Excel has an extra hidden column at end of 'sheet' RRS feed

  • Question

  • When exporting a report to Excel, I'm seeing an issue where a hidden column is tacked on to the end of the report.

    For example, if I have columns 'Name, Price, Quantity, Total', all four columns would show (A,B,C,D), and then the next column visible in Excel would be Column F. I checked to see if this was a case where E is just super small and it isn't, you actually have to select columns D and F and right click 'Unhide', and then E shows up.

    Anyone else seeing this?

    Also for completeness, I'm exporting using Render with device info (not the toolbar button)

    EDIT: The concern here is that clients will think data is being hidden from them (we're talking financial records, not a simple product log like I mentioned earlier)

    • Edited by JosephSeattle Monday, November 28, 2011 8:34 PM Explained concern with this
    Monday, November 28, 2011 8:32 PM

All replies