Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Aleksandra
85
Problem exporting ValueList to excel using UltraGridExcelExporter
posted

Hello!

I have a column which is in fact a formula, than on top of that formula I have a Value List that displays proper value in the grid.  However, when I export the grid to Excel that column doesn't display a Value List value instead it exports formula result.  

Does anyone know how I can force ExcelExporter to export what's displayed on the grid instead of underlying value?

Thanks.

 

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    Hi,

    By default, the UltraGridExcelExporter converts the grid formula into an Excel Formula. So it's probably exporting the formula instead of the cell text and that's why it's not working the way you want.

    The good news is that this is very easy to fix. Just set ExportFormulas on the UltraGridExcelExporter to false.

Children