How is this serious problem?CELLSJAVA-41337

Aspose.Cells Product Family
1

CELLSJAVA-41337


This is a very very serious problem,it makes the sheet002.htm increasing unlimited!!
2

Hi,

Thanks for your posting and using Aspose.Cells.

We have already logged your previous excel file i.e

Attachment: stop.xlsx

and now you have provided new file

Attachment: CELLSJAVA-41337.xlsx

It seems both files are same. Do you find any difference in them? If yes, then we will also log this file with this ticket.

3

Two file is same!I want to know how is this problem,it is very very serious!we have report it long time ago,but it still in your new aspose-cells.jar


4

Hi Xu,


Thank you for the confirmation on sample.

We have looked in to the problem logged earlier as CELLSJAVA-41337, and we are able to identify the problem cause for the huge size of generated child HTML files. Please note, in your provided sample, the Worksheets named as “KMS后台管理_越秀主页基本设置”, “知识文档库”, “专家网络库” and “filenet” have cell shading applied to whole worksheet, as a result Aspose.Cells APIs tend to export all the cells (max row & column limit) instead of exporting only the cells with data. If you remove the cell shading from the empty cells from aforementioned worksheets, the resultant HTML file(s) would be smaller in size.

Moreover, if you compare the results generated with Aspose.Cells APIs against the result of Excel, you will notice that Excel application generates quite large HTML files for such worksheets, however, size is small as compared to Aspose.Cells’ generated HTML. Reason being, Excel application merges many cells with no data and exports them as one cell. Unfortunately, Aspose.Cells APIs cannot opt this approach (i.e. merge the cells without data) for compatibility reasons in different browsers. Based on the discussion as above, you have to remove the cell shading (background color) from the unused cells to reduce the size of generated HTML.
5

Hi,

Thanks for using Aspose.Cells.

It is to inform you that this issue should be fixed in about January 13, 2016.

6

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for Java v8.6.3.2 and let us know your feedback.

7

This problem was solved,it is ok now,Thanks!

8

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.

9

The issues you have found earlier (filed as CELLSJAVA-41337) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
(2)