Hello, everyone!
I’ve realized that LibreOffice doesn’t consider the possibility to allign the currency symbol at the extreme left leaving the number regularly aligned on the right (in a single cell of course).
This could be obtained since Excel 2.0 placing the simbol of asterisk (*) whose effect is to fill the space up to the end of the cell with any caracter or even a space if placed after it.
Thanks indeed
Hi albertomaria,
the same function is implemented in LO Calc 3.6.1 (don’t know about earlier versions) but not documented in the help files.
Select your cell, right click mouse, select Format cell… In the Format windows select your number format as currency and you see on the bottom a rectangle with e.g.the following format (you might need an other one):
- [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00 Display $23.45 or -$23.45(in red)
- Now modify the format string to the following:
- [$$-409]* #,##0.00;[RED][$$-409]* -#,##0.00 Display $ 23.45 or $ -23.45
- This inserts padding blanks or any character between the $ and the number. There might be some restriction which characters you can not use.
I hope it solves your problem
Horst
Hi @Horst, I created a new user-defined format to try the format string on LO 3.5.4.2, but I wasn’t able to get it to add any extra padding characters. I assume it should work the same in 3.5 as in 3.6; could you double-check that formatting string in 3.6? Thanks!
Hi @qubit1, I tested the format string in 3.5.7 (not working) and 3.6.4 (working fine). There were a lot of improvements from 3.5 to 3.6.