Ask Your Question

can i use sum formula in different language?

asked 2018-12-27 11:06:49 +0200

redian gravatar image

updated 2018-12-28 09:21:56 +0200

I want to sum numbers which is in Bangla but the sum formula isn't working with the Bangla numbers.


made by m.excel in android - C:\fakepath\Book (2).xlsx

after opening it on libre office it sort of changed the font

so i converted it into ods and fixed font here - C:\fakepath\Book (2) (copy 1).ods

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-12-27 23:12:07 +0200

m.a.riosv gravatar image

updated 2018-12-27 23:13:56 +0200

If I'm not wrong now it's possible format the cells to show the Arabic numbers with the desire language characters.

Number Format Codes
search for:
Displaying Numbers Using Native Characters

A format code like [NatNum1][$-445]0 for the cell seems to work, but for me is like a blind attempt.

So should be possible to do arithmetic while showing the result in the language.

edit flag offensive delete link more


As I meanwhile tested you can enter numbers in "native characters" and get them recognised.if the language for the 'Numbers' attributes is set properly. I first did not succeed with displaying the recognised numbers with these characters. I got them with U+0030 through U+0039. Your link helped to solve this, too.
Well, I will stick to 'Western', and I am not at all glad with these additional steps into hyperlocalisation.
We should try to have international standards for communication about quantities and dates, omitting the problems we have with languages.

Lupp gravatar imageLupp ( 2018-12-27 23:44:36 +0200 )edit

Hi Lupp, you know I'm agree with you, but I can be comprehensive with people liking other ways

m.a.riosv gravatar imagem.a.riosv ( 2018-12-28 22:48:20 +0200 )edit

answered 2018-12-27 11:55:47 +0200

Lupp gravatar image

updated 2018-12-27 17:38:12 +0200

Since Bangla numbers look strictly decimal to my eye there should be a way. However, if your numbers in spreadsheet cells actually are of type 'Text' the SUM() function and the statistical functions will completely ignore them.

As here mostly 'Westerners' are contributing, few contributors will know about specifics of Bangla, Hindi ... and other 'Eastern' numerals. Please supply a sample SHEET showing what you want to do. Edit your question to do so, and use the tool inconised as a paper-clip for the purpose. (Don't use the 'Answer' feature as long as you don't answer your own question.)

===Edit1 after a first look into the example:===
What you suppose to be numbers is treated as text, and in one case there is even a trailing space.
The digits used writing the numbers are from the unicode range U+09E6 through U+09EF. In addition the "western" decimal point is used (U+002E). I would need the character used for signs in addition. No signed example included (Why?).
Based on the example sheet and my very limited knowledge I can write a conversion function, but I don't know direct support in LibO for numbers written this way, in specific no way to get them recognised as numbers when entered/imported/edited.
An extremely inefficient conversion based on standard functions of LibreOffice Calc (V5.3.4 or higher) is demonstrated in this reworked example.

What's so bad with global usage of the same set of digits? We cannot change the historical fact of hundreds of languages in the world. We could, however, negotiate standards concerning some specialties needed in global communication. Numerical data should probably not be subject to "localised human stubbornness". In my country we are teached that what we call "Arabic digits" originated "in India" and were brought to the west through the Arabic civilisation. However, there was a long time during which the shapes developed, and finally a western version of the West-Arabic digits was spread all over the world. Why not keep this as at least one valuable togetherness?

I'm afraid I should quit contributing to this thread. Too little knowledge. Too little disposition to help split the world another time. I really feel bad about this.

Hopefully at least flight control will stick to globally used terms. Or will we need "AI" next year to accomplish any banality?

edit flag offensive delete link more


link text here is a sample i want to sum its in 'shonar bangla' font {and in south asia almost all of us use that (u know what) so, sorry for that i hope open source software's will also become a thing here}

redian gravatar imageredian ( 2018-12-27 15:48:19 +0200 )edit

Image is useless. Horizontal alignment, too.
Please provide an exampl as an .ods file.
Edit your question to do so, and use the tool inconised as a paper-clip for the purpose. I saw for enough credit points for you to be allowed to attach a file.

Lupp gravatar imageLupp ( 2018-12-27 16:06:38 +0200 )edit

its in ods you can download it there is download button in the right corner

redian gravatar imageredian ( 2018-12-27 16:10:38 +0200 )edit

Why don't you do it the way the software here is prepared for?

Lupp gravatar imageLupp ( 2018-12-27 16:14:05 +0200 )edit

😅 i cant attach file in the comment

redian gravatar imageredian ( 2018-12-27 16:16:13 +0200 )edit

Well, I told you twice (in my answer and repeated in my comment above: "Edit your question to do so (attach a file), and use the tool inconised as a paper-clip for the purpose."
You are not expected to make attachments to comments. Where's the problem?

Lupp gravatar imageLupp ( 2018-12-27 16:26:38 +0200 )edit

i did it link text

redian gravatar imageredian ( 2018-12-27 16:33:54 +0200 )edit

no hard feelings bro i hope one day there will be many contributors from south asia who would contribute to open source softwares in their languages

redian gravatar imageredian ( 2018-12-27 18:03:48 +0200 )edit

hey i attached 2 more files can you look it up

redian gravatar imageredian ( 2018-12-28 08:40:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-27 11:06:49 +0200

Seen: 80 times

Last updated: Dec 28 '18