Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Specify how to cross a string in output PDF and image
Contents
[
Hide
]
Possible Usage Scenarios
When a cell contains text or a string that is larger than the width of the cell, the text overflows if the next cell in the next column is null or empty. When you save your Excel file to PDF/Image, you can control this overflow by specifying the cross‑type using the TextCrossType enumeration. It has the following values:
-
TextCrossType.DEFAULT: Displays like MS Excel, depending on the next cell. If the next cell is null, the string will cross; otherwise, it will be truncated.
-
TextCrossType.CROSS_KEEP: Displays the string like MS Excel when exporting to PDF/Image.
-
TextCrossType.CROSS_OVERRIDE: Displays all the text by crossing other cells and overriding the text of crossed cells.
-
TextCrossType.STRICT_IN_CELL: Displays the string only within the width of the cell.
Specify how to cross a string in output PDF/Image using TextCrossType
The following sample code loads the sample Excel file and saves it to PDF/Image format by specifying different TextCrossType. The sample Excel file and output files can be downloaded from the following links:
Sample Code