File error?

Aspose.Cells Product Family
1

Hello,

I have a very strange problem ; in attach you'll find 2 excel worksheets that are completely the same ( or should be). But when I process 'Decisions XChange.xls' with Aspose Cells ( only open and save it under a new name) MS Excel can't open the file anymore. The other one no problem. I recreated the file 'Decisions XChange OK.xls' a few moments ago, based on a working file. But I can't see any ( important) difference between the 2 files.

I have a similar strange problem with another file. Always resulting in a 'file error' message. Created it at least 3 times from scratch. Tried to find out what's wrong ; created the file. Add some formatting /formula's - test - ok - some more formula's - test - ok - more formatting ... and so on. And everytime when the file is almost the way it should be, I get the file error. Sometimes when changing the page setup. Another time when adding our logo ( but removing it again doesn't help anymore). Last time only changing the alignment of some cells. I have to fill in some cells to get the error but have no time now to create a test project. 'Market Rpt 3 OK.xlt' works correct. 'Market Rpt 3.xlt' has only changes in the formatting of a few cells, but fires the error. And 'Market Rpt 3 B3P3.xls' is the resulting file, with error. ( when opening in Excel 2000).

I guess the 2 problems are somewhat related.

I use version 4.1.0.0; .Net 2.0 ( Visual Basic) . And MS Excel 2000.

Luc

2

Hi Luc,

I use MS Excel2000 to open all these 5 files and don't see any problem. My Excel2000 version is 9.0.2812. Have you tried to view these file in another machine with Excel2000?

I attached a new version here. You can also try it.

3

Yes, the original templates work perfectly in MS Excel. But I have problems after processing them with Aspose Cells. I atached the output with errors again. File 'Market Rpt 3 B2P3.xls' didn't give an error message anymore because I opened and saved it. When you open 'Market Rpt 3 B3P3.xls' now, you should get a message 'file error' and you'll see cells D32- I32 displaying #REF! However they don't refer to a wrong position ( and aren't updated). File 'Output.xls' asks 'enable macro's ?' and then nothing.

I use MS Excel 2000 9.0.8948 SP-3. And I tested it on another PC, same problem. ( same version of Excel )

I'll try the fix.

Luc

4

By the way : why can't I select the Aspose Cells dll anymore in the .Net References ( when adding a new reference) ? It used to be one of the firsts in the list, now I have to browse for the dll.

( no big problem, I just wonder about it )

5

Aha ! To my surprise everything works fine now with the bugfix. ( surprised because you didn't see any problem). This would have saved me a lot of time last week. Anyway , thanks ! Smile [:)]

Luc

6

Hi Luc,

I open and save your template files and don't find problems.

For these two files I do see the error message. Please try my fix first. If it doesn't work, could you please post your whole project here? That will help me to figure out the problem. Thank you.

When you install Aspose.Cells setup package, it will register Aspose.Cells.dll automatically. If you uninstall it or don't install it, you won't directly see it in .NET references. You can still use the dll without any problem.

7

Hi, When you add reference of Aspose.Cells Dll file into your project, first you have to remove the older ref.

Could you try with the fixed version and send us the results?

I did test some of your files without any error.

For your confirmation:

But when I process 'Decisions XChange.xls' with Aspose Cells ( only open and save it under a new name) MS Excel can't open the file anymore.

Well, I did simply open and save with Aspose.Cells. Then opened it using MS Excel with no such error.

Market Rpt 3.xlt has only changes in the formatting of a few cells, but fires the error.

Well, I did open and set some format and save as with Aspose.Cells. Then opened it using MS Excel without any error what so ever.

I use MS Excel 2002 ...SP-1.

If the problem still persits, please create a test project and send us code with template file. So that we may sort out the things. Thank you.

Regards

Amjad Sahi

Aspose Najing Team

8

Great news! Big Smile [:D]