WPS - HOW TO CORRECT THE NUMBER AND CURRENCY FORMAT

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.