Description: It should show 負 instead of 偩 in Number Format [NatNum5] for negative sign. Steps to Reproduce: 1. Type negative number in a cell 2. Right click and choose set cell format 3. Type [NatNum5]0 in format code field at Number tab 4. Click OK to apply format code Actual Results: Shows 偩壹仟伍佰 in cell Expected Results: Shows 負壹仟伍佰 in cell Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: kf6 (cairo+wayland) Locale: zh-TW (zh_TW.UTF-8); UI: zh-TW 24.2.3-3 Calc: threaded
Created attachment 194369 [details] Shows config for Cell format dialog
Created attachment 194370 [details] Shows result in cell
It is based on numbertext.org Please test if the same happens in https://numbertext.github.io/
(In reply to m_a_riosv from comment #3) > It is based on numbertext.org I think that's only for NatNum12.
It seems to exist in pretty early version. Actually [NatNum2], [NatNum5], [NatNum8] which show "minus" in Chinese characters, they all are wrong. Confirmed. 版本：6.4.4.2 組建 ID：3d775be2011f3886db32dfd395a6a6d1ca2630ff CPU 執行緒：4; OS：Linux 6.5; UI 算繪：預設; VCL: kf5; 語言地區：zh-TW (zh_TW.UTF-8); 介面語言：zh-TW Calc: threaded
(In reply to m_a_riosv from comment #3) > It is based on numbertext.org > > Please test if the same happens in > https://numbertext.github.io/ numbertext.org only has Simplified Chinese, but its characters (in Simplified Chinese form) is correct. Also the word in Japanese is correct.
Kevin, Laurent, thought you might be interested.
Yes, [NatNum5] is handled by LibreOffice's own code, specifically at core/i18npool/source/nativenumber/data/numberchar.h, line 137: const sal_Unicode MinusChar[] = { 0x002D, // Half Width (Ascii) 0xFF0D, // Full Width 0xFF0D, // Chinese Lower 0x8D1F, // S. Chinese Upper 0x5069, // T. Chinese Upper ... Here 0x5069 is "偩", and should be changed to 0x8CA0 for "負".
(In reply to Ming Hua from comment #8) > Yes, [NatNum5] is handled by LibreOffice's own code, specifically at > core/i18npool/source/nativenumber/data/numberchar.h, line 137: > > const sal_Unicode MinusChar[] = { > 0x002D, // Half Width (Ascii) > 0xFF0D, // Full Width > 0xFF0D, // Chinese Lower > 0x8D1F, // S. Chinese Upper > 0x5069, // T. Chinese Upper > ... > > Here 0x5069 is "偩", and should be changed to 0x8CA0 for "負". Link: https://opengrok.libreoffice.org/xref/core/i18npool/source/nativenumber/data/numberchar.h#132
I have submitted a patch to gerrit: https://gerrit.libreoffice.org/c/core/+/168089
Jeff Huang committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a3f537e13ee64c5bf3155864035c1591e7099101 tdf#161288 Traditional Chinese minus character is U+8CA0(負), not U+5069(偩) It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Jeff Huang committed a patch related to this issue. It has been pushed to "libreoffice-24-2": https://git.libreoffice.org/core/commit/e92d2444d7bbfc8d7bfd1d91f64fe5161395885e tdf#161288 Traditional Chinese minus character is U+8CA0(負), not U+5069(偩) It will be available in 24.2.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.