Hello,
i'm using Spire.XLS version 7.12 in .Net Framework 3.5.
The following code generated an error (spire_error_1.png)
Spire.Xls.Workbook _Workbook = new Spire.Xls.Workbook();
_Workbook.LoadFromFile(fileName);
_Workbook.Save();
So, looking to forums, i use the following code:
CultureInfo cc = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
Spire.Xls.Workbook _Workbook = new Spire.Xls.Workbook();
_Workbook.LoadFromFile(fileName);
_Workbook.Save();
System.Threading.Thread.CurrentThread.CurrentCulture = cc;
but i have an error when i open the file with excel (spire_error_2.png)
The original file is modele_Controle_FDPIO.xlsm, contain a formula in tab "Contrôle FDP" Cell D11
The result file is Controle_FDPIO.xlsm, and the formula is empty. it is my main issue.
I do lots of test, without any result : change file extension, different load options, and declare the following code
System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US", false);
My computer :
Windows 8.1 Professionnel 64 bits
Processeur : Intel(R) Core(TM) i7-6600U CPU @ 2.60 GHz 2.80 GHz
RAM 8.00 Go
Microsoft Office 365 ProPlus Version 1701 (Build 7766.2099)
Best Regards
Herve CUZON