Free Support Forum - aspose.com

Cells .NET change/bug 4.0.1.0- 4.0.2.0

Aspose.Cells Product Family
#1

I was going trough some of the projects where I use Aspose cells today and upgraded the .dll files, but suddenly there was a problem reading a workbook, it “worked” on 4.0.1.0 but not on 4.0.2.0 returning this exception.

Inner Exception: Aspose.Cells.CellsException

Message: This Excel files contains BIFF7(Excel95 or earlier file format) records.

Code: UnsupportedFeature

TargetSite: Void ၻ(Aspose.Cells.Ss.໓)

Source: Aspose.Cells

StackTrace: at Aspose.Cells.RW.ွ.ၻ(໓ ၼ)

at Aspose.Cells.RW.ွ.໿(Stream Ԏ)

at Aspose.Cells.Workbook.Open(Stream stream)

at ssc.ExcelReader.BreReader.Process() in C:\Arbeid\Visual Studio Projects\ProductionReader\prodbre\BreReader.cs#137

The document is a very heavy/messy document that 4.0.1.0 wasn’t able to calculate the formulas on (not that I needed them I was reading it to collect data).

I went back to using 4.0.1.0. Just wanted to report the change/bug.

#2

Could you please zip and post your Excel file here? It can only be downloaded by Aspose developers. Or you can zip and send it to nanjing@aspose.com. I will check it ASAP.

Generally I think this file is "Microsoft Excel 97-2003 & 5.0/95 Workbook". You can verify it by using MS Excel to open this file and choose "Save As".

To solve this problem, you can save it as "Microsoft Excel Workbook" in MS Excel.

#3

The document is developed over a long time (since 95 or so) but it’s updated to 97/2003. Some of the formulas might be old.

#4

Yes, this file is "Microsoft Excel 97-2003 & 5.0/95 Workbook" format.

In v4.0.1 we just load Excel97 data from it and don't touch Excel95 data. However, this may cause problem. In v4.0.2, Aspose.Cells rejects this kind of files.

I use MS Excel to changed this file to BIFF8 format. Since my posted file can be downloaded by all users, I don't post it here. What's your email address? I will send the changed file to you.

#5

Thank you for looking into this on so short notice.

My email is asmund.goytil@heidelbergcement.com.

#6

I have sent it to you. Please check you email.