https://bugs.documentfoundation.org/show_bug.cgi?id=174434

            Bug ID: 174434
           Summary: Fonts set for Asian text are ignored when number
                    formats contain CJK characters
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
When a number format containing CJK characters is applied to a cell, the
displayed value is rendered using a font different from the font set for Asian
text.

Users can set any font for Asian text through the Cell style or the Format
Cells dialogue. However, after saving and reloading the document, the font set
for Asian text is no longer applied.

Number formats can introduce CJK characters into the displayed value, even when
the cell contains only a numeric or date/time value. For example, date/time
values entered in formats such as YYYY/MM/DD, HH:MM:SS or ISO 8601 can be
displayed with characters such as "年", "月", "日", "時", "分" or "秒" added by the
number format. The same issue also occurs with other number formats containing
CJK characters, such as 0,,"百万".

Since these characters are generated solely by the cell's number format rather
than entered as part of the cell value, users cannot correct the font on a
character-by-character basis.

This prevents users from working comfortably and creating documents with their
preferred fonts. It also undermines one of LibreOffice's strengths: the ability
to set separate fonts for Western, Asian and CTL.

Steps to Reproduce:
1. Set any font for Asian text (e.g., Ctrl + 1 -> Font -> Asian).
2. Enter any value (e.g., 1234567890) in a cell.
3. Apply a number format containing CJK characters (e.g., Format Code: 0,,"百万")
to that cell.
4. Save and reload the document.

Actual Results:
CJK characters introduced by the number format are displayed using a font
different from the font set for Asian text.

Expected Results:
The displayed value, including CJK characters introduced by the number format,
uses the font set for Asian text.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 5.4.7.2
Build ID: c838ef25c16710f8838b1faec480ebba495259d0

Version: 26.8.2.2 (X86_64)
Build ID: 9dea406ab7695df6325b11b0e19fdca8db4b7276
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded Jumbo

Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: 47afde11747e46972133e3e94fb9ac463b71124b
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: ja_JP
Calc: threaded Jumbo

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to