LibreCalc number translator

pedro.de.marco

New Member
Joined
May 12, 2022
Messages
15
Reaction score
3
Credits
224
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,655
Reaction score
1,757
Credits
19,876
It's a bit old but I found this, I hope it may help

 
OP
pedro.de.marco

pedro.de.marco

New Member
Joined
May 12, 2022
Messages
15
Reaction score
3
Credits
224
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


Latest posts

Top