We are shifting from aspose cells version 2.5.4 to 7.0 version. But we have found many problems while converting excel files to ods file using new version as compared to old version.
The first difference I noticed is that the latest version 7.0.4 generated files has no charts in it.
Different cell values with different types are almost equal in the ods file generated by old version. While new version generated ods file has many wrong values for different cell type.
Some of the cell values with currency type are missing the currency symbols($ ,Euro,Pound) in new version while previous version has all the currency symbols in cell value.
In new version (7.0) rows style height attribute isstyle:row-height="0.17708333333333334in" * where for older version (2.5) is *style:row-height="12.75pt" and same problems with column attributes as well.
Please let as know when aspose new version removes these issues.
1. Saving chart for ods file is not supported in the V7.x versions currently. We are working on R/W charts for ods file now and reading charts has been supported from V7.0.4. We will continue to work on saving charts to ods file and improving reading charts from ods file. We will try to support saving charts for ods file in the first quarter of 2012.
2. We have found some issues of lost number format for R/W ods files. We have recorded it as CELLSJAVA-40089 and will try to fix those issues asap. However, it is very possible that what we found is not the same issue with what you got in your case. So, it will be much better if you can provide us some template files and point out those issues you got so that we can fix them at first for you.
3. All units such as cm, in, pt…etc. are available for ods file. In old versions we use “pt” as common unit for saving ods files. In new versions we use “in” for saving ods files instead. The size of “0.17708333333333334in” is just same with size of “12.75pt”.
As we are facing lot of abnormal behaviors of our product by using the newer version i.e. 7.0.4. By doing the analysis we found that the xml files of generated ODS Files by versions i.e. ver 7.0.4. is different to those files that are generated by the version 2.5.4,(some of the differences are also posted in the earlier post). please provide versions compatibility so that we can switch to newer version easily.
There is another problem that we have seen in ver 7.0.4 that it does not support filter data also, where as ver 2.5.4 provide this support.
please provide us compatible solution and update us about the status of CELLSJAVA-40089.
For the issue of number format, we are still working on it and will try to provide a fix in two weeks.
For the compatibility issues of ods file, we can only fix those of ods file generated by new version of aspose.cells with openoffice, such as the ods file cannot be opened by openoffice, some values are shown incorrectly in openoffice, and so on.
For the differences between old versions and new versions, such as size unit, id(name) of components(such as charts, shapes, styles and so on), all are valid and follow ods file’s specification for both old and new versions. Even when you create an ods file with openoffice, it may save size with different unit in different environments. We are afraid we cannot help for that.