The formula xlsb format problem

Aspose.Cells Product Family
1

Dear colleagues.

There’s another problem with converting xls to xlsb thru Aspose.Cells api.

Here’s the sample Excel file.

If you open it in Excel 2010 and do the “Save as” choosing xlsb format, the formula in embedded object works fine.

If you do the same operation with Aspose.Cells api as we do it in the attached sample piece of code, the formula in the formula is broken.

We need your help to solve the problem.

2

Hi Vladimir,


Thank you for sharing the samples.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for Java 8.7.0.2, and we are able to observe the said problem, that is; if result is saved in XLSB format, the shape formula does not refresh. We have logged this incident as CELLSJAVA-41731 in our bug tracking system. Please spare us little time to properly analyze the scenario to get back with updates in this regard.
3

Hello, dear colleagues!

Here’s another problem. We’re trying to find a workaround to fix the conversion from xls to xlsb (see the issue CELLSJAVA-41731).

We create an xls file using Excel 2010. We put some wordart objects into it. One of them contains static text, another references to an unnamed cell, and the last to the named cell.

So we’re trying to convert it to xlsb.

The result is almost pretty, except we lose all transparency effects in wordart.

The result is much more better, if we’re trying to convert xlsx file with the same content (actually xls file is the result of “Save as” applied to xlsx in Excel 2010).

Please pay your attention that both xls and xlsx files work fine in Excel 2010 with no difference in appearance or behavior of wordarts.

You can see the sample code below and sample Excel files in attachment.

public class Test2

{

public static void main(String[] args) throws Exception

{

Workbook workbook = new Workbook(Test2.class.getResourceAsStream("example_xlsb_2.xlsx"));

File result1 = File.createTempFile("result", ".xlsb");

workbook.save(result1.getAbsolutePath(), SaveFormat.XLSB);

System.out.println(result1.getAbsolutePath());

workbook.dispose();

}

}
4

Hi,


Thank you for sharing this scenario.

We have evaluated the recently shared case while using the latest version of Aspose.Cells for Java 8.7.0.2, and we are able to notice the said issue, that is; transparency is reset to 0 after converting XLS to XLSB. We have logged this incident as CELLSJAVA-41739 for further investigation by the product team. Please spare us little time to properly analyze the case and get back with updates in this regard.
5

Hi,

Thanks for using Aspose.Cells.

It is to inform you that we have fixed your issue CELLSJAVA-41731 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

6

Hi,

Thanks for using Aspose.Cells.

We are afraid, this issue could not be fixed. After further investigation, we found the file must be saved by MS Excel 2007, because of Excel 2007 we do not support reading
those advance records about the setting of transparency of the shapes
now.

7
Please, explain me your answer.
You say that our file is created by Excel 2007? Or you say that there is a requirement to use only files generated by Excel 2007?
8

Hi,

Thanks for your posting and using Aspose.Cells.

We have logged your comment in our database against this issue for re-investigation. We will look into it and update you. Once the issue is resolved or we have some other news for you, we will let you know asap.

9

Hi,

Thanks for using Aspose.Cells.

Your xls file is created by MS Excel 2007. Some records about transparency are created by MS Excel 2007 and Aspose.Cells does not support those records now.

10

Hi,

Thanks, it works with MS Excel 2010.


Vladimir, LOIS.
11

Hi,

Thanks for your posting and using Aspose.Cells.

It is to inform you that we will keep this ticket open until we support this feature.

12

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
13

Hi!

We’ve prepared some test for xls 2 xlsb conversion with WordArts.

You can see some sample files:

  1. test.xlsx – simple xlsx file created by MSE 2010.

  2. test.xls – simple xls file create by MSE 2010 from test.xlsx thru “Save as” .xls

  3. test_aspose.xlsb – xlsb file generated by aspose from test.xls

  4. test_excel.xlsb – xlsb file generated by MSE 2010 from test.xls

As you can see 3 and 4 differs by the transparency effect. Is there any way to obtain xlsb from xls using Aspose.Cells without losing the transparency effect.

14

Hi,


Thanks for providing us more sample files.

Well, I am afraid, the issue “CELLSJAVA-41739” is not resolved yet, so you will get transparency issue for the Word Arts/shapes when rendering to XLSB file format. I have logged your new files with details against your existing issue “CELLSJAVA-41739” for our product team’s reference. I am afraid, unless we figure out your issue (regarding transparency effects) or support those transparency records in the XLSB files, there may not be any workaround to cope with it.

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

Thank you.
15

Hi again,


This is to update you that we have resolved the problem logged earlier as CELLSJAVA-41739. We will shortly share the fix here for your testing.
16

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

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