Bug 159729

Summary:	Calculation in Nepali Unicode Font not working.
Product:	LibreOffice	Reporter:	Gurubhai <gurubaral45>
Component:	LibreOffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	normal	CC:	erack, jumbo4444, khaled, sophi, vsfoote
Priority:	medium
Version:	24.2.0.3 release
Hardware:	All
OS:	Windows (All)
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=102235 https://bugs.documentfoundation.org/show_bug.cgi?id=36038
Whiteboard:	numberformat
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	119352
Attachments:	simple test FODT with Nāgari decimal values and evaluated table cells

Description Gurubhai 2024-02-15 08:11:39 UTC

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

Comment 1 V Stuart Foote 2024-02-15 14:58:23 UTC

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

Comment 2 V Stuart Foote 2024-02-15 15:10:43 UTC

Created attachment 192587 [details]
simple test FODT with Nāgari decimal values and evaluated table cells

Comment 3 Eike Rathke 2024-02-15 18:33:25 UTC

(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.

Comment 4 V Stuart Foote 2024-02-15 20:23:42 UTC

(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