Improved reproducibility of Excel row height and column width


 

We have improved layout reproducibility by reviewing and updating the calculation method for Excel cell row height and column width.

  • For .xlsx files that use Yu Gothic (the standard font in Windows 10/11 and Excel 2016+), the calculation process for both row height and column width has been updated to improve reproducibility. For files using fonts other than Yu Gothic, column width reproducibility has been improved.
  • For .xls, the calculation process for column widths has been updated (including Yu Gothic) to improve reproducibility.

Comparison of conversion results between OSDC V11.0 and OSDC V11.1

The following compares the original Excel data (.xlsx) with PDF output produced by OSDC V11.0 and OSDC V11.1.

Comparative usage data (Source: Digital Agency, Appendix “Counter DXSaaS Requirements Definition Document”)
URL: Download XLSX

Examples (Pages 1–3). From left: “Save Excel to PDF”, “OSDC V11.0”, “OSDC V11.1”.

rowcolcalc-01

Compared to V11.0, V11.1 improves how many rows fit on a page by changing the row-height calculation method. Although page 2 layout may vary depending on the first row, page-break positions for the table on pages 2–3 and conversion accuracy on page 3 have been improved.

Examples (Pages 4–5). From left: “Save Excel to PDF”, “OSDC V11.0”, “OSDC V11.1”.

rowcolcalc-02

Reproducibility of both the number of lines and the page-break positions has been improved on pages 4–5.

“xls-oldcompat-rowcolcalc” attribute in the Option Setting File

Because the row-height and column-width calculation process has changed, results may differ from OSDC V11.0 and earlier. To produce results compatible with V11.0 and earlier, specify the xls-oldcompat-rowcolcalc attribute in the option setting file.

  • xls-oldcompat-rowcolcalc: Set to true to use the pre-V11.0 compatible calculation method. Set to false to use the updated method (default when not specified).
  • Example option setting file:
<?xml version="1.0"?>
<formatter-config>
  <dfv-settings>
    <xls-settings xls-oldcompat-rowcolcalc="true">
    </xls-settings>
  </dfv-settings>
</formatter-config>

Limitations

  • When saving PDF files directly from Excel, page-break positions may vary depending on the Excel execution environment (screen resolution, selected printer, etc.). Because OSDC converts Excel files created across many environments, it is not possible to perfectly align page splitting to match a single specific environment.

Improved display of WordArt (enhanced)


 

dhccmd -d sec3.docxWe have enhanced rendering for WordArt text effects when text is transformed inside shapes.

Comparison of WordArt rendering between OSDC V11.0 and OSDC V11.1

The following shows differences when converting WordArt created in PowerPoint (.pptx) using OSDC V11.0 versus OSDC V11.1.

Created in PowerPoint (PPTX)

wordart260113-pptx

Rendered with OSDC V11.0

wordart260113-v110

Rendered with OSDC V11.1

wordart260113-v111

For details on WordArt Transform conversion behavior and known limitations, see: New Features and Changes in V11.0: Improved WordArt Display .

Adjusted rendering of composite line types in Word (DOCX)


 

We refined rendering to better reproduce border designs in Word (.docx) that combine lines of different thicknesses.

Comparison of rendering between OSDC V11.0 and OSDC V11.1

The following shows differences when converting Word content (.docx) using OSDC V11.0 versus OSDC V11.1.

Created in Word (DOCX)

linetype-docx-eng

Rendered with OSDC V11.0

linetype-v110mr4-eng

Rendered with OSDC V11.1

linetype-v111r1-eng

Limitations

  • Border junction areas (where lines touch) may differ from how they appear in Word.

Supports Excel date and time formats starting with “*”


 

Excel cell date/time formatting now supports formats beginning with “*” (Windows only).

dt-fmt-eng

Note: Formats beginning with an asterisk (*) vary depending on the regional date/time settings configured in your operating system.

Controls for images that exceed Excel print ranges


 

When a figure or graphic in an Excel cell extends beyond the print range, the xls-clip-shape attribute in the Option Setting File determines how it is output:

  • false (default): the entire image is output, including parts outside the print range.
  • true: only the portion inside the cell’s print range is output.
clip-shape-eng

Features in earlier versions

For features introduced in versions prior to V11.1, please refer to the previous release notes page.

Previous New Features from V11.0


For more information on the features implemented in previous versions of Office Server Document Converter, see the following links.

→ OSDC V11.0 New Features