Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Sep 13, 2017 9:16 am

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
Attachments
Spire.zip
Original File
(184.89 KiB) Downloaded 214 times

hervecuzon
 
Posts: 1
Joined: Wed Feb 08, 2017 1:46 pm

Wed Sep 13, 2017 10:04 am

Hello,

Thanks for your post.
I have reproduced both of the two issues you mentioned and referred them to our dev team. Once there's any update, I will let you know.
Sorry for the inconvenience caused.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS