Skip to content

XLSX: quoted currency suffix in custom number formats is dropped #365

Description

@developer0hye

Summary

A quoted literal suffix in a custom number format is dropped. In 09_expense_report_en.xlsx the amount column uses a EUR format that Excel prints as 1,240.00 € (currency symbol suffixed after the number); office2pdf prints 1,240.00 with no at all. Prefixed symbols (e.g. $#,##0.00 in other fixtures) survive, so the loss is specific to literal text positioned after the digits.

Reproduction

Convert an XLSX cell with a custom format such as #,##0.00 "€" (or #,##0.00\ €) and compare with Excel.

Expected

The literal suffix renders after the number: 1,240.00 €.

Actual

Only the bare number renders; the suffix is silently dropped.

Related

Related: #256, #237

Visual comparison

Ground truth (native Microsoft Office export) is on the left; office2pdf output at filing time is on the right. Both pages were rendered with pdftoppm at 150 DPI.

GT and office2pdf output

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions