Hang when loading a document. *.xls. Conditional formatting

Aspose.Cells Product Family
1

Hi,

I use Aspose.Cells by COM. When I try to load a document, my application hangs. I try to load this document directly by C#, but it’s all work properly.
The problem occured in version 7.0.3.4. I checked version 7.0.3.3 and it has no problem.

I created two simple documents:
1. Document in *.xlsx format with conditional formatting in first cell. This document loads properly;
2. Document in *.xls format. It created by conversion first document to *.xls format. This document hangs.

I also created two simple Delphi projects for reproduce this problem. Before start the application you must to register Aspose.Cells.dll in the same directory.

When I loaded this application with AQtime 6, I got next messages with exception:

Event Thread ID Time
First chance exception 0xC0000091 FLOAT_OVERFLOW occurred at 0x61A484A1 4384 12:15:04:213
0x61A484A1 mscorjit.dll 4384
0x61A57F0A getJit + 0x2DF4 in mscorjit.dll 4384
0x61A4DFBC mscorjit.dll 4384
0x61A4DD00 mscorjit.dll 4384
0x61A4DFA8 mscorjit.dll 4384
0x61A1E27D mscorjit.dll 4384
0x61A1D60C mscorjit.dll 4384
0x61A163AA mscorjit.dll 4384
0x61A15524 mscorjit.dll 4384
0x61A156CB mscorjit.dll 4384
First chance exception 0xC0000091 FLOAT_OVERFLOW occurred at 0x614C8FA3 4384 12:15:04:215
0x614C8FA3 CopyPDBs + 0x4217 in mscorwks.dll 4384
0x61627398 CorLaunchApplication + 0x148D5 in mscorwks.dll 4384
0x613FC0E5 CreateAssemblyNameObject + 0x1A5A6 in mscorwks.dll 4384
0x613FC158 CreateAssemblyNameObject + 0x1A619 in mscorwks.dll 4384
0x613FBECD CreateAssemblyNameObject + 0x1A38E in mscorwks.dll 4384
0x613FBC8F CreateAssemblyNameObject + 0x1A150 in mscorwks.dll 4384
0x613AF7B5 mscorwks.dll 4384
0x613AF973 mscorwks.dll 4384
0x029305FE 4384
0x0698BFD3 4384
First chance exception 0xC0000091 FLOAT_OVERFLOW occurred at 0x614C8FA3 4384 12:15:04:218
0x614C8FA3 CopyPDBs + 0x4217 in mscorwks.dll 4384
0x61627398 CorLaunchApplication + 0x148D5 in mscorwks.dll 4384
0x613FC0E5 CreateAssemblyNameObject + 0x1A5A6 in mscorwks.dll 4384
0x613FC158 CreateAssemblyNameObject + 0x1A619 in mscorwks.dll 4384
0x613FBECD CreateAssemblyNameObject + 0x1A38E in mscorwks.dll 4384
0x613FBC8F CreateAssemblyNameObject + 0x1A150 in mscorwks.dll 4384
0x613AF7B5 mscorwks.dll 4384
0x613AF973 mscorwks.dll 4384
0x029305FE 4384
0x0698BFD3 4384
First chance exception 0xC0000091 FLOAT_OVERFLOW occurred at 0x614C8FA3 4384 12:15:04:220
0x614C8FA3 CopyPDBs + 0x4217 in mscorwks.dll 4384
0x61627398 CorLaunchApplication + 0x148D5 in mscorwks.dll 4384
0x613FC0E5 CreateAssemblyNameObject + 0x1A5A6 in mscorwks.dll 4384
0x613FC158 CreateAssemblyNameObject + 0x1A619 in mscorwks.dll 4384
0x613FBECD CreateAssemblyNameObject + 0x1A38E in mscorwks.dll 4384
0x613FBC8F CreateAssemblyNameObject + 0x1A150 in mscorwks.dll 4384
0x613AF7B5 mscorwks.dll 4384
0x613AF973 mscorwks.dll 4384
0x029305FE 4384
0x0698BFD3 4384
First chance exception 0xC0000091 FLOAT_OVERFLOW occurred at 0x614C8FA3 4384 12:15:04:223
0x614C8FA3 CopyPDBs + 0x4217 in mscorwks.dll 4384
0x61627398 CorLaunchApplication + 0x148D5 in mscorwks.dll 4384
0x613FC0E5 CreateAssemblyNameObject + 0x1A5A6 in mscorwks.dll 4384
0x613FC158 CreateAssemblyNameObject + 0x1A619 in mscorwks.dll 4384
0x613FBECD CreateAssemblyNameObject + 0x1A38E in mscorwks.dll 4384
0x613FBC8F CreateAssemblyNameObject + 0x1A150 in mscorwks.dll 4384
0x613AF7B5 mscorwks.dll 4384
0x613AF973 mscorwks.dll 4384
0x029305FE 4384
0x0698BFD3 4384

I am using Excel 2010 and Aspose.Cells 7.0.3.6.

Thank you,
Alex Shloma

2

Hi,

Thanks for your files.

We have logged your project in our database. We will investigate the problem and update you asap.

3

Hi Alex !

Please try our com demo project in attachment , we do not find issue with your template files

4

Hi Fisher Wang,

Thank you for demo project.

I found the problem. The Delphi and Visual Studio have different default settings. Delphi create exception (Delphi 2009 hangs), When the Float Overflow occurs.

I also found the fix for this problem (https://forums.embarcadero.com/thread.jspa?messageID=334125&tstart=0), but those exceptions may be a cause of incorrect values in components. It will be better, if you fix these exceptions.

Thank you,
Alex Shloma
5

Hi,

Thanks for your feedback. I have added your comment in our database.

We will look into and fix the problems if any and update you asap.

6

Hi,

You may already found Set8087CW($133F) can solve your issue.

We do not catch any “Divided by zero exception” in our code.

So we think we can close this issue.

7
Hi,
Yes, as I written in previous post I found solution for this problem. I call this method before and after all the methods from Aspose.Cell.
Yes, you can close this ticket.

Thank you,
Alex Shloma

8

Hi,

Thanks for your confirmation, we will close this ticket now.