Aspose Cells header text not fitting in cell

Aspose.Cells Product Family
1

Hi,

We are using Aspose Cells 23.1 with JDK version 8 on CentOS 7.

We have installed all the basic fonts and msttcorefonts.
Attached Input/Output here

2

We reproduced the issue with your file Input.xlsx as you mentioned via screenshot. We found header text is not fitted in the cell in Excel to PDF rendering.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

  Issue ID(s): CELLSJAVA-45093

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@rutuja.mahajan

There maybe some text wrap differences comaring Aspose.Cells genereated pdf and Excel generated pdf when page zoom is not 100%. In your source file, fit to page wide/tall is set, the actual zoom is 80%. We can’t fix it currently.

4

Hi,

When I open this excel by default zoom is 100%. Is it because fit to page wide/tall set to 1?
Will it render properly if I change this or any other setting? Can you please suggest with screenshot please?

5

@rutuja.mahajan

Yes, fit to page wide/tall is set to 1, sheet zoom will be recalculated:
sheetzoom.png (39.5 KB)

Please try to uncheck “Wrap text” and check “Shrink to fit” for the cell:
format_cell.png (15.2 KB)

6

Thanks for your response, can close this now.

7

@rutuja.mahajan
I’m glad to hear your problem was solved.