report viewer 10 export excel 2007 copy and paste RRS feed

  • Question

  • My problem:

    I have created a report with Visual studio
    2010(ReportViewer 10, client side report). Then copy and paste a table
    or some cells with background colors(such as blue) in my report to a new
    excel file(not another tab in the same excel file) . The blue color
    becomes red.

    I think that the report is generated with Excel 2003,
    my guess. Is there a way to tell it to export the excel file with excel

    • Moved by Quist Zhang Monday, January 14, 2013 6:54 AM Report View issue
    Thursday, January 10, 2013 11:23 PM

All replies

  • Hi Sharon,

    Thank you for posting in the MSDN Forum.

    I'll move your thread to Visual Studio Report Controls for better support since this forum is for Excel related development issues. If you have questions on Excel object model Excel VBA and developing Excel add-ins, you're welcomed to post your questions here.

    Besides, if your report is in Excel 2003 format (.xls), I suggest you try to save it as Excel 07-10 (.xlsx) format and then see whether the color changed or not.

    Hope it helps.

    Best regards,

    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, January 14, 2013 6:53 AM