Posted 8 September 2017, 2:39 pm EST
<DIV id=_ctl0__ctl1_bcr__ctl0___PostRepeater__ctl1_PostViewWrapper class=ForumPostContentText>
The SaveExcel method is particularly slow. Saving a file from a few hundred kb takes easily more than a minute.
We use the flag "NoFormulas".
<FONT face="courier new,courier">SaveExcel(fileName, FarPoint.Excel.ExcelSaveFlags.NoFormulas);</FONT></BLOCKQUOTE>
We are using the FpSpread for windows forms 5.0.2018.
We reproduce the case with a simple application that open an Excel file and save it with the SaveExcel function.
Do you have any idea why this is so slow ?
Thanks in advance
PS: If necessary, you can download a zip file containing the solution of my test application and the Excel file imported before calling SaveExcel: