We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

SheetRender align issues on Cells for java

Aspose.Cells Product Family
#1

Hi,

I found a issue with SheetRender align with an element. I put the excel file and image after rendering here.

  1. Personal_Budget.zip it is xlsx file, because your web limited only allow certain type to upload, so I rename the xlsx file to zip. The file is create from excel template, Personal Budget without any modification.

  2. The file render by excel.

  3. The file render by SheetRender(cells java)

  4. The excel template screen.

Thanks,

Y.H.

Personal_Budget.zip (24.9 KB)

Personal_Budget_excel.png (625.3 KB)

sheetRender.png (19.9 KB)

Screen Shot 2017-07-24 at 10.59.39 AM.png (527.5 KB)

#2

thank you so much

#3

@yhBlue,

Thanks for providing us template file and screenshots.

After an initial test, I observed the issue as you mentioned by using the following sample code with your template file. I found that label text is displaced for the Pie chart, the text is not aligned fine. Moreover, Aspose.Cells renders the image as the sheet is displayed in print preview of MS Excel 2007 which itself shows the alignment issue. But MS Excel 2013 does show the label text in the chart fine:
e.g
Sample code:

Workbook book = new Workbook("Personal_Budget.xlsx"); 

         ImageOrPrintOptions imgOptions = new ImageOrPrintOptions(); 
         imgOptions.setImageFormat(ImageFormat.getPng()); 
         imgOptions.setVerticalResolution(300); 
         imgOptions.setHorizontalResolution(300); 

         WorksheetCollection sheets = book.getWorksheets(); 
          
            Worksheet sheet = sheets.get("Current Month"); 
            SheetRender sr = new SheetRender(sheet, imgOptions); 
            sr.toImage(0, "f:\\files\\out1.png");

I have logged a ticket with an id “CELLSJAVA-42350” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.

#4

Please try the latest version/fix: Aspose.Cells for Java v17.7.7:

Your issue should be fixed in it.

Let us know your feedback.

Thank you.

#5

Thanks,
But it is not on your repo yet, is it?
My mvn couldn’t find it,…

#6

@yhBlue,

The naming scheme of releases that are published on Maven are like

17.1
17.2
17.3
17.4

Here 17 means 2017 and 4 means April.

The next release which will be publish in Maven be like

17.8

again, 17 means 2017 and 8 means August.

But the version we provided you on this forum is actually a hot fix. Hot Fix has 3 digits and are not published via Maven.

Hot Fixes provided in April would be like this

17.4.1
17.4.2
17.4.3

and Hot Fixes provided in June would be like this

17.6.1
17.6.2
17.6.3

In short, actual releases are provided once per month and has two digits. While hot fixes are provided throughout the month and has 3 digits.

Actual releases are provided via Maven but Hot Fixes are provided via Forums.

The next actual release i.e. 17.8 will be available on 18-Aug-2017 and it will available via Maven. So, until then, you will have to download the Hot Fix via forums and use in your project or wait for actual release till 18-Aug-2017.

#7

The issues you have found earlier (filed as CELLSJAVA-42350) have been fixed in Aspose.Cells for Java 17.8.