asked 2012-08-15 09:19:22 +0200

1812 ● 13 ● 40

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

delete close flag offensive retag edit

Comments

feel free to add a feature request to bugzilla.

tohuwawohu ( 2012-08-15 11:43:56 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-09-05 00:03:38 +0200

horst

1840 ● 11 ● 29

updated 2012-09-05 00:06:59 +0200

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

link delete flag offensive edit

Comments

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!

qubit ( 2013-01-30 09:44:20 +0200 )edit

Hi @qubit, 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.

horst ( 2013-01-30 18:40:26 +0200 )edit

@horst -- Excellent! That would explain it!

qubit ( 2013-01-30 18:56:58 +0200 )edit

@horst -- Excellent! That would explain it!

qubit ( 2013-01-30 18:57:09 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-08-15 09:19:22 +0200

Seen: 189 times

Last updated: Sep 05 '12

calc - format cell - number currency uncomplete

Comments

1 Answer

Comments

Resources

Donate

Question tools

Stats

Related questions