Spire create xlsm - formula lost

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Spire create xlsm - formula lost

Postby hervecuzon » Wed Sep 13, 2017 9:16 am

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();

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();
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
Original File
(184.89 KiB) Downloaded 18 times
Posts: 1
Joined: Wed Feb 08, 2017 1:46 pm

Re: Spire create xlsm - formula lost

Postby Jane.Bai » Wed Sep 13, 2017 10:04 am


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.

E-iceblue support team
User avatar
Posts: 784
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 1 guest