Form Controls - Cells 2.5.4 vs 7.0.1

Aspose.Cells Product Family
1

Hello,

I am opening a XLS file with some Form Controls in it (buttons, checkboxes). Immediately after opening it, I save it to some other file.

If I do this operation with Aspose Cells 2.5.4, all form controls are gone.
If I do this with 7.0.1, the controls are still there.

Is this known behaviour for the pre-7 versions?
Or is it a bug?

I’ve attached a sample XLS file, and the Java code is below:

Cells 2.5.4
Workbook wb = new Workbook();
wb.loadData(Test.class.getResourceAsStream(“controls.xls”));
wb.save(“test254.xls”);

Cells 7.0.1
Workbook wb = new Workbook(Test.class.getResourceAsStream(“controls.xls”))

wb.save(“test701.xls”);

Regards,
Sorin.

2

Hi,

I check, Aspose.Cells for Java 7.0 version is working fine. It is a bug of older version then.

3

Hi Shakeel,

Thanks for you (very) fast answer!

Is Aspose aware of any workarounds for these issues in the 2 version?

4

Hi,


Could you use Workbook.open() method instead of loadData() with even v2.5.4:
Workbook wb = new Workbook();
wb.open(Test.class.getResourceAsStream(“controls.xls”));
wb.save(“test254.xls”)

LoadData method would exclude the drawing shapes and other formatting etc.


Thank you.
5

Hi Amjad,

Thank you, your suggestion worked.

I was not aware of the difference between loadData and open. Can you give me an example where using loadData is better than open?

6

Hi,


If you need to open the XLS files with data/formulas only, you should use loadData() method, this method would be efficient a bit too. It is to be noted using loadData() all other objects, drawing shapes, formatting etc. would be excluded or eliminated.

Workbook.open() method would load the files with every thing e.g data, objects, drawing shapes (charts, graphics etc.), formulas etc.

Thank you.
7

Ok, thank you very much for your explanation.

Just as a note, when I opened the file with loadData, the formatting was not lost.


Have a nice day,
Sorin.