[]
Provides settings that control how wrapped text is reduced during PDF export so that the text can fit within the available cell area. Use PdfSaveOptions.getShrinkToFitSettings() to access this interface and configure whether wrapped text can shrink to fit and the minimum font size to use.
worksheet.getRange("A1").setValue("Document Solutions For Excel");
worksheet.getRange("A1").setColumnWidth(12);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
PdfSaveOptions options = new PdfSaveOptions();
IShrinkToFitSettings settings = options.getShrinkToFitSettings();
settings.setCanShrinkToFitWrappedText(true);
settings.setMinimumFont(10);
workbook.save("path/to/output.pdf", options);
booleandoublevoidsetCanShrinkToFitWrappedText(boolean value) voidsetEllipsis(String value) voidsetMinimumFont(double value) Returns whether wrapped text is allowed to reduce its font size during PDF export when shrink-to-fit is applied.
worksheet.getRange("A1").setValue("Document Solutions For Excel");
worksheet.getRange("A1").setColumnWidth(12);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
PdfSaveOptions options = new PdfSaveOptions();
IShrinkToFitSettings settings = options.getShrinkToFitSettings();
settings.setCanShrinkToFitWrappedText(true);
boolean canShrinkWrappedText = settings.getCanShrinkToFitWrappedText();
workbook.save("path/to/output.pdf", options);
true if wrapped text can be shrunk to fit during PDF export; otherwise, false.Sets whether wrapped text is allowed to reduce its font size during PDF export when shrink-to-fit is applied.
worksheet.getRange("A1").setValue("Document Solutions For Excel");
worksheet.getRange("A1").setColumnWidth(12);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
PdfSaveOptions options = new PdfSaveOptions();
IShrinkToFitSettings settings = options.getShrinkToFitSettings();
settings.setCanShrinkToFitWrappedText(true);
workbook.save("path/to/output.pdf", options);
value - true if wrapped text can be shrunk to fit during PDF export; otherwise, false.This value specifies the smallest font size that can be used when wrapped text is reduced during shrink-to-fit processing.
worksheet.getRange("A1").setValue("Document Solutions For Excel");
worksheet.getRange("A1").setColumnWidth(12);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
PdfSaveOptions options = new PdfSaveOptions();
IShrinkToFitSettings settings = options.getShrinkToFitSettings();
settings.setCanShrinkToFitWrappedText(true);
settings.setMinimumFont(10);
double minimumFont = settings.getMinimumFont();
workbook.save("path/to/output.pdf", options);
This value specifies the smallest font size that can be used when wrapped text is reduced during shrink-to-fit processing.
worksheet.getRange("A1").setValue("Document Solutions For Excel");
worksheet.getRange("A1").setColumnWidth(12);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
PdfSaveOptions options = new PdfSaveOptions();
IShrinkToFitSettings settings = options.getShrinkToFitSettings();
settings.setCanShrinkToFitWrappedText(true);
settings.setMinimumFont(10);
workbook.save("path/to/output.pdf", options);
value - The minimum font size used during shrink-to-fit processing."...". This string is used when wrapped text is not fully displayed during shrink-to-fit processing. It can be used together with getMinimumFont() to control how truncated wrapped text is shown.
worksheet.getRange("A1").setValue("Document Solutions For Excel");
worksheet.getRange("A1").setColumnWidth(12);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
PdfSaveOptions options = new PdfSaveOptions();
IShrinkToFitSettings settings = options.getShrinkToFitSettings();
settings.setCanShrinkToFitWrappedText(true);
settings.setMinimumFont(10);
settings.setEllipsis("~");
String ellipsis = settings.getEllipsis();
workbook.save("path/to/output.pdf", options);
"...". This string is used when wrapped text is not fully displayed during shrink-to-fit processing. It can be used together with getMinimumFont() to control how truncated wrapped text is shown.
worksheet.getRange("A1").setValue("Document Solutions For Excel");
worksheet.getRange("A1").setColumnWidth(12);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
PdfSaveOptions options = new PdfSaveOptions();
IShrinkToFitSettings settings = options.getShrinkToFitSettings();
settings.setCanShrinkToFitWrappedText(true);
settings.setMinimumFont(10);
settings.setEllipsis("~");
workbook.save("path/to/output.pdf", options);
value - The ellipsis string used for wrapped text that cannot be fully displayed.