Why Style changes after Excel format transform?

Aspose.Cells Product Family
1

Dear all,

I am using the Aspose.Cells for Java 7.3.0 and try to transform the XML Spreadsheet (xls file) to Binary Excel file (xls). I assume the style will keep the same before and after the transformation. But actually it is not. Would you please help to provide a solution so that I can keep the all the same (e.g Data, Style)?
2

Hi,

Thanks for your posting and using Aspose.Cells for Java.

Please provide us your source XML spreadsheet which you are transforming to XLS file and also provide us your sample code to replicate this issue.

We will look into your issue at our end and if it is a bug, we will log it our database for a fix.

3

Thanks!

Please check my Java source:

FileInputStream fStream1 = new FileInputStream(“C:\test\Sample\Sample1_Before.xls”);
Workbook workbook1 = new Workbook(fStream1);
workbook1.save(“C:\test\Sample\output\Sample1_Aftert.xls”, FileFormatType.EXCEL_97_TO_2003);

4

Hi,

Thanks for your source xml file and the sample code.

I was able to replicate this issue using the latest version:
Aspose.Cells for Java 7.3.0


We have logged this issue in our database. We will look into it and fix the problems. Once the issue is resolved or we have some other update for you, we will let you know.

This issue has been logged as CELLSJAVA-40271.

Below is a test code and screenshot for your reference.

Java


String path = “F:\Shak-Data-RW\Downloads\Sample1_Before.xml”;


Workbook workbook = new Workbook(path);

workbook.save(path + “.out.xls”, SaveFormat.EXCEL_97_TO_2003);

5

Dear Shakeel,


Thanks for your help.

May I know when will this can be fixed?
6

Hi,

Thanks for using Aspose.Cells.

Normally it takes 2~3 working days for a fix. But if the fix is difficult to be resolved, then it could take couple of weeks.

Hopefully, your issue will be fixed soon.

7

Dear Shakeel,


Just sent you a private message, please check.

Thanks!
8

Hi,

Thanks for your posting.

You can check your private messages by navigating to this link.

http://www.aspose.com/community/user/privatemessages/default.aspx

Also, I have logged your comments in our database against the issue id: CELLSJAVA-40271. We will try to provide you a fix as early as possible.

If you have any other questions, please feel free to ask, we will be glad to help you.

9

Thanks, Shakeel!

10

Dear,

I found the issue status has been updated as Issues: CELLSJAVA-40271(Resolved).
May I know whether any release will come out soon?
11

Hi,

Thanks for your question and using Aspose.Cells.

I have checked the database and found your issue has been fixed however the fix has not yet been released.

Hopefully it will be released soon within next two days.

12
Please kindly update me when it releases.
Thanks!
13

Hi,

Thanks for your posting and using Aspose.Cells.

Sure, we will update you once the fix is released by posting on this thread.

14

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for Java v7.3.0.4

15

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.