Description: Libre office can't detect digits (Number) written in Nepali Unicode Character. It only detects text. Before using this libre office, I was in MS Office. Now When I switched to libre office, There is problem in calculation. It only calculate the digits written in English format. But In India and Nepal, We use unicode character. SUM/Divide/Multiply these things are not working when the text is written in Nepali Unicode character. For example, for 1, we use १, for 500, we use ५००. So these issue is thing where we can not use this freely. I hope it will be solve. But in ms office, there is no issue with Nepali unicode and works smoothly. Actual Results: type digits in Nepali unicode, For example १ २ ३ ४ ५ and try to sum them in calc or writter. It won't work. Try in ms office, it works smoothly. Problem is libre office can't detect the digits written in Nepali unicode character. Expected Results: I hope libre office will listen this and improve it. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: TextDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Hmm, seems to work for me. But see also bug 102235 The Unicode block used for नागरि, Nāgari (ne-NP, MS-LCID 0x0461) is Devanāgarī (U+0900) Numbers in table cells in Writer and Calc already are evaluated for the Devangari Unicode digits ०१२३४५६७८९ and equated to their european-arabic digits 0123456789 Meaning the decimal values entered into writer or into calc cells in Nāgari *can* be used in calculations. But the results are not rendered back to their Devangari Unicode, that I can tell. And no simple "toggle" to convert between notations once calculated. But, not sure we'd do that for any locale. @Eike, Laurant, Khalad am I misreading? =-testing-= Locale set to Nepali (Nepal) Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: ne-NP (en_US); UI: en-US Calc: CL threaded
Created attachment 192587 [details] simple test FODT with Nāgari decimal values and evaluated table cells
(In reply to V Stuart Foote from comment #1) > But the results are not rendered back to their Devangari Unicode Apply a ne-NP Nepali (Nepal) number format with the [NatNum1] modifier, for example [NatNum1]0.00 Or even creating and applying a [NatNum1]Standard format would work. Question remains whether that [NatNum1]Standard should be the default format, i.e. is it really expected that all numeric output is displayed in Nepali digits by default? Note that the original poster in comment 0 stated locale en-US. That of course won't work.
(In reply to Eike Rathke from comment #3) > (In reply to V Stuart Foote from comment #1) > > But the results are not rendered back to their Devangari Unicode > Apply a ne-NP Nepali (Nepal) number format with the [NatNum1] modifier, for > example [NatNum1]0.00 > Or even creating and applying a [NatNum1]Standard format would work. > OK, that works. The ne-NP Nepali transliteration is covered in the [NatNum1] handling. I get formula results in Devangari Unicode digits by applying a '[NatNum1]' Number Format to the cell (or its formula) with the cell's language set to 'Nepali (Nepal)' [1] > Question remains whether that [NatNum1]Standard should be the default > format, i.e. is it really expected that all numeric output is displayed in > Nepali digits by default? > I guess that would be a question of usability for the ne-NP user community? Or more general for the other NatNum categories. > Note that the original poster in comment 0 stated locale en-US. That of > course won't work. Thought that might cause issues, I had to work a bit to get out of my normal en-US locale to test. Can set => WFM =-ref-= [1] https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html