Hi there,
I have to make an excel export from a GridView (WinForms) for a customer. I have some special items like barcode etc., so i could not use the default GridView-export. I made a report by hand, because the order of the columns are depending of the order in the GridView.
Now i want to include some excel formulas in the report, because the customer needs to edit some values that change the values in some other fields (e.g. total of a price column).
But I had the problem that, when I included the formula, it was formatted as text. So what you see in the field is e.g. "=SUM(F3:F32000)" instead of the result.
The value for this field in the code is
How could I do this that excel accepts my formula?
Regards Simon
I have to make an excel export from a GridView (WinForms) for a customer. I have some special items like barcode etc., so i could not use the default GridView-export. I made a report by hand, because the order of the columns are depending of the order in the GridView.
Now i want to include some excel formulas in the report, because the customer needs to edit some values that change the values in some other fields (e.g. total of a price column).
But I had the problem that, when I included the formula, it was formatted as text. So what you see in the field is e.g. "=SUM(F3:F32000)" instead of the result.
The value for this field in the code is
headerTotalAmount.Value = "=\"=SUM(" + (char)(columnIndex + 65) + "3:" + (char)(columnIndex + 65) + "32000)\""; |
How could I do this that excel accepts my formula?
Regards Simon