Description: I’d like to request support for Bitcoin (₿) as a built-in currency preset in Calc. Bitcoin is widely used as a unit of account in accounting and personal finance. Having it as a select-able currency, just like USD ($) or EUR (€), would help users manage Bitcoin transactions directly in spreadsheets without needing custom format workarounds. Technical Details: Symbol: ₿ = U+20BF = BITCOIN SIGN Short name: BTC Long name: Bitcoin Format: 8 decimal places (smallest unit is a Satoshi, or Sat) Placement: Symbol should appear before the number, just like $. Example: Desired format: ₿0.12345678 or -₿0.12345678 Steps to Reproduce: In Calc, enter: 0.12345678 Right-click → Format Cells… Under the Numbers tab, select: Category: “Currency” Browse the currency list → Bitcoin (₿) is not available. Currently I have to format the cell with this code: "₿" #,##0.00000000;-"₿" #,##0.00000000 Actual Results: Bitcoin (₿) is not available. Expected Results: ₿0.12345678 or -₿0.12345678 Available regardless of locale, or as a global option. Reproducible: Always User Profile Reset: No Additional Info: I use Bitcoin in Calc often, and think it would be great to have it added as an official currency, especially since it now is valued more than silver. Thank you Devs! Here is the reddit post I made concerning this: https://www.reddit.com/r/libreoffice/comments/1luqs62/i_want_to_add_a_new_currency_preset/ Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 520(Build:3) CPU threads: 14; OS: Linux 6.15; UI render: default; VCL: kf6 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US 25.2.4-2 Calc: threaded
Hi Eike, is it possible to add a new currency not tied to any specific locale ?
No. However, when added to one locale it would be available in the lists. I'd suggest to add it to the en-DK locale as that combines English with international ISO 8601 date formats. Would be displayed as "BTC ₿ English (Denmark)". Otherwise, the nearest we could do is to create a private-use fake dummy English locale just for Bitcoin representation. Letting escape private-use language tags into the wild by storing them as document content isn't best practice though.. YMMV..
Patch in https://gerrit.libreoffice.org/c/core/+/187653
Hi Xisco, I thank you for getting to this so quickly, but I had a concern when i looked at the commit you linked to. Bitcoin uses 8 decimal points, not 2, is there a reason this was set to 2? Thank you again
(In reply to social.chemicals267 from comment #4) > Hi Xisco, I thank you for getting to this so quickly, but I had a concern > when i looked at the commit you linked to. Bitcoin uses 8 decimal points, > not 2, is there a reason this was set to 2? > > Thank you again I missed that. Fixed in the new patchset. Thanks
No problem — thanks for jumping on this so quickly, really is cool to see an idea be put into practice