I am already using interops to convert a Datable into a Excel file, everything is ok but when I try to insert in the excel a formula like this:
=(0,5*E30)
I have an error but if I try to insert another one like this:
=(0*E30)
everything it's ok. I am inserting it like a String. So what can be happening? I can't understand why only for use a , I get that error.
Excepción de HRESULT: 0x800A03EC</Message><StackTrace> en Intranet.InteropExcel.DataTableToExcel(DataTable DataTable, String ExcelFilePath) en C:\Desarrollo\VisualStudio2010\ImeApps\Buscador\Intranet\ExportToExcel.cs:línea 301
en Intranet.Intranet.butExcel_Click(Object sender, EventArgs e) en C:\Desarrollo\VisualStudio2010\ImeApps\Buscador\Intranet\Intranet.cs:línea 3306
en System.Windows.Forms.Control.OnClick(EventArgs e)
en System.Windows.Forms.Button.OnClick(EventArgs e)
So what can be happening? Thanks in advance!