Excel crashes using text to columns functionality

Aspose.Cells Product Family
1

We have generated excel using aspose and our excel crashes as soon as we text to columns, some time it takes longer time to crashes.
I have attached the generated excel for your reference.
We have observed this on Microsoft Excel 10
Steps to reproduce
1) Open excel file and select column “H”, rows 16-36

2) Click the data tab, select “Text to columns” function under “tools”

3) Keep all the default options, click “next”, “next”, “finish”

4) Excel crashes

Crash report:

Microsoft Error Reporting log version: 2.0

Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2015-04-22 15:49:05 +0000
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 14.4.8.150116
Crashed Module Name: Microsoft Excel
Crashed Module Version: 14.4.8.150116
Crashed Module Offset: 0x00170036
Blame Module Name: Microsoft Excel
Blame Module Version: 14.4.8.150116
Blame Module Offset: 0x00170036
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409
Crashed thread: 0


Thanks!

Nimesh



2

Hi Nimesh,

Thanks for your posting and using Aspose.Cells.

After initial investigation, we were able to observe this issue intermittently. It crashes Excel 2010 but sometimes, it works fine.

Please download and try the latest version: Aspose.Cells for Java (Latest Version) and see if it makes any difference and resolves your issue.

If your issue still occurs, then please provide us some simple runnable code that we could run at our end and replicate this issue. It will help us look into issue and fix it sooner.

Thanks for your cooperation.

3

Hello,

I have tried using latest Aspose.Cells for Java v8.5.1 and we are getting the same issue with Excel 2010.

Can you please look into this issue, by referring the excel.

It is quite difficult for us to create the sample code which reproduce this scenario. We tried to create sample code but we were not able to reproduce with that code, as sample code dont have all the logic to build the excel generated using our excel generator component.


Thanks!
Nimesh

4

Hi Nimesh,

Thanks for your posting and using Aspose.Cells.

The issue is reproducible with your output excel files with the steps mentioned by you in the first post. Please post more such output excel files for our analysis.

We have logged this issue in our database for investigation. We will look into it and see if we could resolve this issue. Once there is some update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41425 - Excel crashes using text to columns functionality

5

Thanks for looking into this issue.

I have attached 2 more excel for your reference.

To reproduce use “Deliv” column of excel.

Thanks!
Nimesh

6

Hi Nimesh,

Thanks for your posting and using Aspose.Cells.

We have looked into this issue and concluded that it is actually Microsoft Excel bug. You can get rid of this bug by disabling the Error Checking option in Microsoft Excel.

Please see this link that explains how to disable Error Checking option in Microsoft Excel.

( Turning Off Error Checking (Microsoft Excel) )

7

Thanks for looking into this issue.

Can we disable Error Checking option in Microsoft Excel setting using Aspose?

Thanks!
Nimesh

8
Hi,

Yes, you may use ErrorCheckOptions class that manages different types of errors checks. You should use ErrorCheckType enumeration to disable/enable different error checking options. For reference, see the document for your reference:
http://www.aspose.com/docs/display/cellsjava/Use+Error+Checking+Options

Thank you.
9

Hi

I disabled all ErrorCheckOption using aspose, but it didn’t resolve the above error.

I have attached excel for the reference.

Code snip to disable ErrorCheckOption
protected void ignoreErrors(){

CellArea cellArea = CellArea.createCellArea(0, 0, 65535, 255);

addIgnoreErrorOption(ErrorCheckType.CALC, cellArea);
addIgnoreErrorOption(ErrorCheckType.CALCULATED_COLUMN, cellArea);
addIgnoreErrorOption(ErrorCheckType.EMPTY_CELL_REF, cellArea);
addIgnoreErrorOption(ErrorCheckType.INCONSIST_FORMULA, cellArea);
addIgnoreErrorOption(ErrorCheckType.INCONSIST_RANGE, cellArea);
addIgnoreErrorOption(ErrorCheckType.TEXT_DATE, cellArea);
addIgnoreErrorOption(ErrorCheckType.TEXT_NUMBER, cellArea);
addIgnoreErrorOption(ErrorCheckType.UNPROCTED_FORMULA, cellArea);
addIgnoreErrorOption(ErrorCheckType.VALIDATION, cellArea);

}

private void addIgnoreErrorOption(int errorCheckType,CellArea cellArea){

ErrorCheckOptionCollection opts = sheet.getErrorCheckOptions();
int index = opts.add();
ErrorCheckOption opt = opts.get(index);
opt.setErrorCheck(errorCheckType, false);
opt.addRange(cellArea);

}

Please let me know if I am missing anything.

Thanks!
Nimesh

10

Hi,


Well, since you are using XLSX file format, so you should create/set the area for it i.e., 1048576 rows and 16384 columns in a single worksheet accordingly. You may try the updated line of code as following:
e.g
Sample code:

CellArea cellArea = CellArea.createCellArea(0, 0, 1048575, 16383);

Let us know if you still find the issue.

Thank you.

11

Hi

We tried this code but no luck, still the same error.

PFA excel.

Thanks!
Nimesh

12

Hi,


Thanks for your feedback and providing us the updated file.

I have logged your provided files with comments against your issue “CELLSJAVA-41425” into our database. Our concerned developer will look into it further soon.

Once we have any update on it, we will let you know here.

Thank you.
13

Hi,

Thanks for using Aspose.Cells.

Please simply use ErrorCheckOptionCollection.clear() method to remove the record about Error check options and it should then fix your issue.