Free Support Forum - aspose.com

Stlying changes after conversion of XLS file

Please run following code:

import com.aspose.cells.FileFormatType;
import com.aspose.cells.Workbook;

public class Aspose
{
    public static void main(String[] args) throws Exception
    {
        String inputFile = "C:\\aspose\\input.xls";
        String outputXlsx = "C:\\aspose\\output.xlsx";
        String outputXls = "C:\\aspose\\output.xls";

        Workbook xlsWorkbook = new Workbook(inputFile);
        xlsWorkbook.save(outputXlsx, FileFormatType.XLSX);

        Workbook xlsxWorkbook = new Workbook(outputXlsx);
        xlsxWorkbook.save(outputXls, FileFormatType.EXCEL_97_TO_2003);
    }
}

on input.xls file attached files.zip (15.3 KB). Then open output.xls file, you will notice following issues:

  • symbols from cells I24:J25 get a white background and border shadow
  • style of data series “UCL” changes on the chart - type of marker changes from “X” to a square

@wjeczalik,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-43151 – Styling changes after conversion of XLS file

@wjeczalik,
We have fixed the two issues. But there is another issue that the size of plot area is too small.We are working on it. Once we have any further update on it, we will let you know here.

@wjeczalik,

Please try our latest version/fix: Aspose.Cells for Java v20.3.3 (attached)

Your issue should be fixed in it.

Let us know your feedback.
aspose-cells-20.3.3-java.zip (7.0 MB)

The issues you have found earlier (filed as CELLSJAVA-43151) have been fixed in Aspose.Cells for Java v20.4. This message was posted using Bugs notification tool by ahsaniqbalsidiqui