How can I remove unused currencies?

English
,
#1

I only use €, £ and $, but when I click the “format a currency” dropdown in the toolbar, there are many, many options, so finding one of the three I actually use is difficult. If there a way to remove currencies from this list, or pin the ones I use regularly to the top please?

BTW I did search to see if this had been asked before, but only found a post from two years ago that was closed without an answer: https://ask.libreoffice.org/t/remove-unused-currencies-symbols/37474 so, at the moment, I’m assuming there isn’t a way to do this, so how do I make a request for this functionality please?

1 Like
#2

Use styles/cell styles instead of direct formatting, one for each currency.
Right-click on the Default cell style in the sidebar (Ctrl+F5) and select NEW.
Assign a name in the dialog, e.g. “$-Dollar”. In the “Numbers” tab, enter the desired currency.
Select the cell you want to format.
Double-click the new cell style.

1 Like
#4

Thank you for responding to my question. The use of styles does seem to be option, though it seems a little cumbersome to have to open the side bar every time, when there’s a “format currency” dropdown already on my toolbar. I’m guessing that, as you’re offering a workaround (although, granted, a powerful one), I can’t edit the list of currencies?

#5

For example, you can use the sidebar

  • leave it open
  • undock
  • make it smaller
  • set the preview to “user templates” at the bottom

If you already have formatted cells, you can work with the “Transfer format - brush”.

#6

I can’t edit the list of currencies?

No.

#7

You can create a style like @Hrbrgr explained, and then you can assign the style to a keystroke that isn’t being used. A lot of Alt and Ctrl-Alt keystrokes in particular are available. Editing the keyboard can seem a bit tedious, but I’ve found that once that’s done, the keystrokes become like second nature in no time and have saved me a ton of work. I certainly see how opening the sideboard to distribute three different currency symbols could get old. So maybe this can help?

#3

Simply don’t use any currency symbols at all. Put them in separate cells or put them in a column label above a column of numbers with 2 decimal digits after the point.
If you want to use number formats with currency symbols, then you should do so by means of cell styles. Styles are the key to Writer, Calc, Impress and Draw. You can’t master this office suite (Writer in particular) without utilizing the concept of styles.

2 Likes
#8

I’ve just found that having created a new style as suggested by @Hrbrgr , if you give it a short name, e.g. $$ or €€, you can then add it to your Formatting Toolbar next to the currency icon that you always use for your default currency. You do this by Tools>Customize>Toolbars. Under Target choose Formatting. Under Category choose Styles and Cell Styles. Double-click on your new style and it will appear at the bottom of the list under Target/Formatting. You can then drag it up to be beside the Currency icon, and it will appear next to it on the toolbar. The only thing I’ve noticed is that doing it this way does not let you toggle the format on and off. To remove the format, you seem to have no choice but to apply a different format, such as Number.

#9

Choose another style.

#10

Thanks, @Villeroy . Yes, of course that would be possible, but I took the original post by @Toby1 to have to do with ways of doing this that were really effortless, like clicking an icon on the toolbar, rather than having to go into Styles. I appreciate that styles are a powerful feature of LibreOffice; my contribution was only to point out that you can incorporate a frequently-used style into the toolbar.

#11

FTR
tdf#102958
“Currency dropdown toolbar button should list 5 last used entries first”
⠀
I took a quick look at the implementation in version 7.6.2.1. It seems to be still a work in progress.

#12

Roll your own toolbar with push buttons assigned to cell styles.
Currency_Toolbar.ods (53.7 KB)

How can this be an unknown issue?

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.