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
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.
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.
Hi Lupp, you know I’m agree with you, but I can be comprehensive with people liking other ways
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.
But:
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?
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}
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.
its in ods you can download it there is download button in the right corner
Why don’t you do it the way the software here is prepared for?
i cant attach file in the comment
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?
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
hey i attached 2 more files can you look it up
