Issues with Text Box on some worksheets converted to PDF

Aspose.Cells Product Family
1

I have converted *.xlsx workbooks to *.pdf format with Aspose.Cells and the result documents have a few inconsistencies.

The most affected worksheets (pages in the PDF):

TextBoxLayout.xlsx

  • 1: sizes of the text boxes are not correctly converted, resulting in improper layout in the PDF.

TextColumnsInTextBox.xlsx

  • 1: the text originally columned inside the text box is converted into a single column format in the PDF.

TextDirectionInTextBox.xlsx

  • 1: the text that should be displayed vertically is incorrectly converted to a horizontal orientation in the PDF.

TextFormattingInTextBox.xlsx

  • 1: the text inside the text box with small caps formatting overlaps, making it difficult to read.

There are screenshots of these issues in the attached archive, as well as, the workbooks.

Code sample:
var wb = new Workbook(inputFile);
wb.Save(outputFile, SaveFormat.Pdf);

I use Aspose.Cells.dll 25.2.0.0.
test27.zip (1.1 MB)

2

@licenses,

Thanks for the template Excel files and screenshots.

After initial testing, I reproduced the following issues using the specific Excel files:

TextColumnsInTextBox.xlsx
1: the text originally columned inside the text box is converted into a single column format in the PDF.

TextDirectionInTextBox.xlsx
1: the text that should be displayed vertically is incorrectly converted to a horizontal orientation in the PDF.

TextFormattingInTextBox.xlsx
1: the text inside the text box with small caps formatting overlaps, making it difficult to read.

We require thorough evaluation of the issue(s). 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) with details:

  • CELLSNET-57865 - The text originally columned inside the text box is converted into a single column format in the PDF
  • CELLSNET-57866 - The text that should be displayed vertically is incorrectly converted to a horizontal orientation in the PDF
  • CELLSNET-57867 - The text inside the text box with small caps formatting overlaps in the output PDF, making it difficult to read

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

@licenses,

When I manually opened the Excel file in MS Excel and viewed the print preview of the worksheet, the display closely matched the output PDF generated by Aspose.Cells. Aspose.Cells renders worksheets matched with the print preview displayed in MS Excel.

4

Yes, thanks. TextBoxLayout.xlsx seems like the default behavior.

5

@licenses
Thank you for your confirmation. We will proceed to close this issue.

6

@licenses
Your issues (CELLSNET-57866 and CELLSNET-57867) have been resolved and the fixed functionality will be released with version 25.3.

7

The issues you have found earlier (filed as CELLSNET-57866,CELLSNET-57867) have been fixed in this update. This message was posted using Bugs notification tool by leoluo

8

@licenses
Your issues (CELLSNET-57865) have been resolved and the fixed functionality will be released with version 25.4.