Aspose cells shifted all over the sheet

Aspose.Cells Product Family
1

Hi,

We are using Aspose cells 23.1 with Java 8 for CentOS 7
Facing issues with this excel file, Aspose Cells shifted all over sheet.zip (3.8 MB)

  1. Cells are shifted and some characters are not readable
  2. Asterik signs are missing at the end of some cells
2

@rutuja.mahajan
Please confirm whether “MS Sans Serif” is installed.
If you export the whole worksheet to one page with PdfSaveOptions.setOnePagePerSheet(true) ,
we have to shrink the corresponding row height, column width and font size,but the font cannot be infinitely reduced，so it looks shift. Please do not export the whole worksheet to one page if the worksheet contains many rows and columns.

3

“Microsoft Sans Serif Regular” is installed. Is this for asterik sign?

4

@rutuja.mahajan

In your code, you cleared printarea, however, in the source file, fit to page wide/tall is set, this makes the sheet zoom to be 10%(the mini value of sheet zoom).

Asterik signs are there(take column U for example), but they are wrapped to next line, so it is not visable.

Font “Arial” can show the asterisk sign.

5

I have set scale to 100% and considering printarea setup, now it is converted properly.
Thank you, we can close this ticket.

6
7

@rutuja.mahajan,

Thanks for your feedback and good to know that your issue is sorted out now.
We have closed the ticket.