Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Thousands Separator Inconsistent

My locale is en_ZA. The default currency format employing commas as thousands separators, negative signs after the currency symbol, and spaces between the symbol and digits is unacceptable to me. I can edit a user-defined cell format to effect the necessary changes, but the result of using a space as a thousands separator is inconsistent with that of the original comma, as illustrated below:

[$R]#,##0.00;-[$R]#,##0.00
       R12.00
      R123.00
    R1,234.00
R1,234,567.00

Observe that the comma thousands separator automatically repeats its task for every groups of three digits before the decimal point. This is good, except that I'd like to replace the commas with spaces.

[$R]# ##0.00;-[$R]# ##0.00
     R 12.00
    R 123.00
   R1 234.00
R1234 567.00

A space thousands separator only works literally, in that it inserts a space before the first set of three digits, as defined by the hashes in the format code, and never again. Furthermore, the space is entered as long as there are three digits or fewer.

This is what I would LIKE to see, and any assistance achieving it would be greatly appreciated:

       R12.00
      R123.00
    R1 234.00
R1 234 567.00

Gavin

Thousands Separator Inconsistent

My locale is en_ZA. The default currency format employing commas as thousands separators, negative signs after the currency symbol, and spaces between the symbol and digits is unacceptable to me. I can edit a user-defined cell format to effect the necessary changes, but the result of using a space as a thousands separator is inconsistent with that of the original comma, as illustrated below:

[$R]#,##0.00;-[$R]#,##0.00
       R12.00
      R123.00
    R1,234.00
R1,234,567.00

Observe that the comma thousands separator automatically repeats its task for every groups group of three digits before the decimal point. This is good, except that I'd like to replace the commas with spaces.

[$R]# ##0.00;-[$R]# ##0.00
     R 12.00
    R 123.00
   R1 234.00
R1234 567.00

A space thousands separator only works literally, in that it inserts a space before the first set of three digits, as defined by the hashes in the format code, and never again. Furthermore, the space is entered as long as there are three digits or fewer.

This is what I would LIKE to see, and any assistance achieving it would be greatly appreciated:

       R12.00
      R123.00
    R1 234.00
R1 234 567.00

Gavin

Thousands Separator Inconsistent

My I am running LibreOffice v5.1.3.2 on Linux Mint 17.3, and my locale is en_ZA. The default currency format employing commas as thousands separators, negative signs after the currency symbol, and spaces between the symbol and digits is unacceptable to me. I can edit a user-defined cell format to effect the necessary changes, but the result of using a space as a thousands separator is inconsistent with that of the original comma, as illustrated below:

[$R]#,##0.00;-[$R]#,##0.00
       R12.00
      R123.00
    R1,234.00
R1,234,567.00

Observe that the comma thousands separator automatically repeats its task for every group of three digits before the decimal point. This is good, except that I'd like to replace the commas with spaces.

[$R]# ##0.00;-[$R]# ##0.00
     R 12.00
    R 123.00
   R1 234.00
R1234 567.00

A space thousands separator only works literally, in that it inserts a space before the first set of three digits, as defined by the hashes in the format code, and never again. Furthermore, the space is entered as long as there are three digits or fewer.

This is what I would LIKE to see, and any assistance achieving it would be greatly appreciated:

       R12.00
      R123.00
    R1 234.00
R1 234 567.00

Gavin