LibreCalc number translator

Joined
May 12, 2022
Messages
35
Reaction score
11
Credits
536
Help greatly appreciated.
This has been asked on excel or microsoft excel forums. and there it is for libreoffice calc.
I have to work with arabic/persian numbers excel file that comes from another source. e.g. national tables and standards and codes and I need to convert them in bulk to normal english number that the program recognize them as "number variable types" and not a "string". testing adding ۱۰۰to 100 must result in 200 but it's errored. "#VALUE!" . This is how I know that it's not treated as number in the first place.
I wish there was a function that converts "string numbers" to "number variables" in the first place and another function that translate the numbers.
 


Brickwizard

Well-Known Member
Joined
Apr 28, 2021
Messages
2,831
Reaction score
1,845
Credits
21,133
It's a bit old but I found this, I hope it may help

 
OP
pedro.de.marco
Joined
May 12, 2022
Messages
35
Reaction score
11
Credits
536
I assume that is a javascript code and I need to figure out how to use it. Thank you. right now I found:
and I also found a code here:
Currently I don't know how to use the code with libreoffice. I hope there is a macro option.
 
$100 Digital Ocean Credit
Get a free VM to test out Linux!

Linux.org Hosting Donations
Consider making a donation

Members online


Top