Calc could improve the way it represents currencies by allowing formating them with the currency symbol left-aligned in the cell (Excel style). This will make currencies easier to read. This is current behavior: A | B ---------------------------- 1 | Currency 1:| $1,00 2 | Currency 2:| $198,00 3 | Currency 3:| $21,00 4 | Currency 4:| $9851,00 5 | Currency 5:| $5,00 6 | Total: :| $10079,00 Requested enhancement: A | B ---------------------------- 1 | Currency 1:| $ 1,00 2 | Currency 2:| $ 198,00 3 | Currency 3:| $ 21,00 4 | Currency 4:| $ 9851,00 5 | Currency 5:| $ 5,00 6 | Total: :| $ 10079,00
Hi @Marcelo, thanks for reporting. There is a workaround using the Horizontal Alignment Distributed. Resolved as duplicate, please if you are not agree reopen it. *** This bug has been marked as a duplicate of bug 63536 ***
I tried the formatting syntax of bug 63536 but it does not work for me.
Created attachment 116609 [details] Screenshot how it works for me. It works for me with: Win7x64Ultimate Version: 4.4.4.2 Build ID: f784c932ccfd756d01b70b6bb5e09ff62e1b3285 Verify you have written right the format, if your language has comma as decimal separator (like mine) you must change them.
(In reply to m.a.riosv from comment #3) > Created attachment 116609 [details] > Screenshot how it works for me. > > It works for me with: > Win7x64Ultimate > Version: 4.4.4.2 Build ID: f784c932ccfd756d01b70b6bb5e09ff62e1b3285 > > Verify you have written right the format, if your language has comma as > decimal separator (like mine) you must change them. Thanks for the code! Is there any place in which it is explained? I am getting an extra whitespace at the end of the number and would like to be able to solve this sorts of problems without bugging people here. Thanks again!
Click the help bottom to access the help. The '_)' adds an space with the with of closing parenthesis. In this format is to keep alienated positives values with negatives numbers between parenthesis. The underscore adds an space with the width of the following character.