Error "Unexpected token type" when opening a XLSX file

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.

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 (2.89 KiB) Viewed 4502 times

But after resaving your xlsx by MS-Excel, in the beginning of these formulas, there is no the "=".

: hd2.PNG (2.63 KiB) Viewed 4502 times

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

Thanks and Regards