Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Mon Oct 01, 2012 3:29 am

This error occurred when I've tried to open a 2007 XLSX file using method LoadFromFile() "Unexpected token type: tEqual, string value: at position 1. Formula: =SUBTOTAL(9,O6:O11), Position: 2". Error occurs on both versions 6.6.x and 6.8.x. I'm using Windows 7 32bit SP1, .NET 2.0. I've attached this XLSX file here. This error wont happen if I save this file as XLS format to open it. Thank you!

BTW, there is an issue of unmatched color palette between MS Excel and Spire XLS, you can test with this attached file.
Attachments
HD.rar
(13.46 KiB) Downloaded 368 times

pocketme
 
Posts: 5
Joined: Thu May 10, 2012 2:46 am

Mon Oct 01, 2012 12:13 pm

Hi,

Thanks for your inquiry.
Was your xlsx file generated by MS-Excel? or other tool?
We unpacked your xlsx file with a zip tool, in the file xl\worksheets\sheet1.xml, we found some formulas starting with a "=", for example in cell O5.
hd.PNG
hd.PNG (2.89 KiB) Viewed 3483 times


But after resaving your xlsx by MS-Excel, in the beginning of these formulas, there is no the "=".
hd2.PNG
hd2.PNG (2.63 KiB) Viewed 3483 times

The format of your formual is not supported by our product at present.

Thanks and Regards
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar

harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Return to Spire.XLS