NUMBER AND CURRENCY FORMAT IN WPS
Deepin It has undergone changes, and in this year 2020 it has taken a spectacular turn with its new look and improvements that have given the end user great satisfaction. Hopefully nothing is perfect, but it continues to evolve by leaps and bounds.
In this tutorial we are going to explain in the simplest, clearest and most concise way how to solve the problem about the format of numbers in WPS. In this version of Deepin, certain things have been corrected for its proper functioning, but certain configurations remain to be resolved and that is what will be resolved at this time.
We have the scenario of when we want to write a number in WPS Spreadsheets and the number when formatting with separation of thousands and decimal numbers does not do it correctly.
SOLUTION
To solve it we will do the following:
Step 1: Open a terminal, you can use Ctrl + Alt +T
Step 2: sudo nano / usr / share / i18n / locales / es_MX
Once we have entered the password of our user of the command before carried out, the file where we will configure will be displayed, and we look for the section LC_MONETARY, especially on the line mon_thousands_sep «», this line is empty, and only inside the quotation marks will we put the comma «," as shown below:
LC_MONETARY
int_curr_symbol "MXN "
currency_symbol "$"
mon_decimal_point "."
mon_thousands_sep ","
mon_grouping 3;3
positive_sign ""
negative_sign "-"
int_frac_digits 2
frac_digits 2
p_cs_precedes 1
p_sep_by_space 1
n_cs_precedes 1
n_sep_by_space 1
p_sign_posn 1
n_sign_posn 1
END LC_MONETARY
Paso 3: Presionamos Ctrl+O (para guardar cambios), después la tecla enter (para aceptar los cambios) y por último Ctrl+X para salir
Step 4: sudo dpkg-reconfigure locales
The application will open and we will search es_MX.UTF-8 UTF-8 and we will mark it by pressing with the space bar and we will press accept.
Then we will select es_MX.UTF-8 and we press accept as shown in the following image.
Finally, if everything was fine, the result will be displayed as follows.
Final step: We close the session or restart the PC.
The final result can be seen in the initial Image of the article.
As additional information, if we open WPS Spreadsheets and we go to the option Menu-> Options
Posteriormente a «General and save«, Then now we can choose Set decimal symbol as «,» but in our case we will not mark it, this could not be done in version 15.11 of Deepin, in version 20 this was fixed.
Pound sterling correction £
In this second part we will see how to correct or put the dollar sign or any other that is desired in WPS.
1. Write a number.
2. Select the currency format
3. Right-click on the cell to display the context menu and select Format Cells.
4. Select the Custom option
5. Now in the Type section: manually change the pound for the peso sign.
by
6. Done. Press accept and it will be with your Currency format with the dollar sign.
I hope it will be of great help to all new users of the Deepin system. This should also apply to the other GNU / Linux distributions.
Excellent article and very good tutorial @Ppjc72, thank you for your cooperation.
Good tutorial, thanks for the input.
Good stuff, it has happened to me more than once that is why I always came back to libreoffice, let's see how it goes with this guide.
It works wonders, thanks.
Well, it turns out very well, thanks for the tutoring.
It works thank you.
Great, thank you very much, cash, fix it.
thanks for the tutoring, it suits me well.
Very useful, thanks, another reason to use wps.
Although wps is popular, I prefer libreoffice.
Would it be the same to fix it in any version of wps?
Yo diría que si, pero veamos a ver que dice
Cesar
Hello such.
What is really being done is to configure the Deepin file where the parameters are so that applications such as wps Spreadsheets read it.
In other distros this file is configured correctly that is why they do not present this error.
This configuration is from Deepin 20. There is another tuto for when you had version 15.11 of Deepin.
Understood thanks
Эли Y
Cesar by the explanation.
Me funciono cien por ciento, muchas gracias por el tutorial.
Qué bueno que le funcionó, es un buen método definitivamente.