Error "Unexpected token"

[RomanLoubet]

Just tried to open and save some of my XLSX-files using Spire.XLS package v. 7.8.26. Code example is:

Code: Select all

            var wbk = new Spire.Xls.Workbook();
            try
            {
                wbk.LoadFromFile(InputFileName);
                wbk.CalculateAllValue();
                wbk.CalculationMode = Spire.Xls.ExcelCalculationMode.Manual;
                wbk.SaveToFile("SPIRE."+OutFileName);
                MessageBox.Show("Well done");
            }
            catch (Exception e)
            {
                MessageBox.Show("ERROR: " + e.ToString());
            }

Got the exception:

Unexpected token.Unexpected token type: tInteger, string value: at position 34. Formula: COUNTIFS(Enterprises!$A$6:$A$3098,2,Enterprises!$H$6:$H$3098,BI$4,Enterprises!$B$6:$B$3098,$B12,Enterprises!$G$6:$G$3098,$C12)+SUMIFS(Enterprises!$M$6:$M$3098,Enterprises!$A$6:$A$3098,4,Enterprises!$H$6:$H$3098,BI$4,Enterprises!$B$6:$B$3098,$B12,Enterprises!$G$6:$G$3098,$C12)+SUMIFS(Enterprises!$M$6:$M$3098,Enterprises!$A$6:$A$3098,5,Enterprises!$H$6:$H$3098,BI$4,Enterprises!$B$6:$B$3098,$B12), Position: 34

Confused by commas instead of semicolons in formula... Input xlsx-file is OK, because it was just saved by MS Excel 2010.

Can provide test xlsx-file by request.

Thank you.

[sweety1]

Hello,

Thanks for your inquiry.
Please offer us your sample excel file.
It would be helpful to replicate the issue and work out the solution for you ASAP.
If the information is confidential, you can send it to us ( Support@e-iceblue.com ) via email.

Best Regards,
Sweety
E-iceblue support team

[RomanLoubet]

If the information is confidential, you can send it to us ( Support@e-iceblue.com ) via email.

Sent to you sample file.
Thank you.

[sweety1]

Hello,

Thanks for your information.
I have noticed your issue. And I have posted the issue to our dev team. We will inform you when it is fixed. Sorry for the inconvenience.

Best Regards,
Sweety
E-iceblue support team

[RomanLoubet]

Hello,

is there any progress with my bug report?

We are considering possibilities of using different xlsx-handling libraries in order to select the optimal alternative to the Excel in our project and we can not rate your product yet.

Thank you.

[sweety1]

Hello,

Thanks for your reply.
As the issue you reported, we have created a research on it, but we need some more time to fix it. I can not provide you any reliable estimate regarding it's complexity. However, you will be surely informed once we fix it.

Best Regards,
Sweety
E-iceblue support team

[RomanLoubet]

Hello,

is there any progress with my bug report?

Thanks.

[amy.zhao]

Hi,

Sorry for the delay update. Our dev team have done the investigation for your issue. It should be caused by the decimal separator of your local culture.
Please try the below solution:

Code: Select all

                CultureInfo cc = Thread.CurrentThread.CurrentCulture;
                Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
                wbk.SaveToFile("SPIRE."+OutFileName);   
                Thread.CurrentThread.CurrentCulture = cc;

Please give us some feedback after testing the solution on your side, so that we can know if it solves your issue.
Thanks.

Best Regards,
Amy
E-iceblue support team

[amy.zhao]

Hello,

Has your issue been resolved?
Thanks for your feedback.

Best Regards,
Amy
E-iceblue support team