Bug 92121 - Add option to format currency with currency sign left aligned
Summary: Add option to format currency with currency sign left aligned
Status: RESOLVED DUPLICATE of bug 63536
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.4.2 rc
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-16 16:31 UTC by Marcelo Ruiz
Modified: 2015-06-18 21:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot how it works for me. (57.41 KB, image/png)
2015-06-17 20:17 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marcelo Ruiz 2015-06-16 16:31:45 UTC
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
Comment 1 m_a_riosv 2015-06-16 21:58:11 UTC
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 ***
Comment 2 Marcelo Ruiz 2015-06-17 17:18:58 UTC
I tried the formatting syntax of bug 63536 but it does not work for me.
Comment 3 m_a_riosv 2015-06-17 20:17:39 UTC
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.
Comment 4 Marcelo Ruiz 2015-06-18 18:05:08 UTC
(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!
Comment 5 m_a_riosv 2015-06-18 21:51:36 UTC
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.