hyperformula icon indicating copy to clipboard operation
hyperformula copied to clipboard
verified publisher icon handsontable

`TEXT()` function should support popular currency formats

Open sequba opened this issue 2 years ago • 4 comments

Description

Our implementation of TEXT() supports less formats than Excel. We should expand it. Particularly, format $#,##0.00 should be supported.

Alternatively, we can add a config option stringifyCurrency similar to stringifyDateTime

Links

  • https://handsoncode.slack.com/archives/C031GBX62SE/p1672832825163179 (internal discussion)
  • https://github.com/handsontable/hyperformula/issues/1138
  • https://github.com/handsontable/hyperformula/issues/1134

sequba avatar Jan 13 '23 11:01 sequba

@sequba is there any chance of getting this one prioritised? Or any suggested workaround? It's causing me some real problems... Thanks!

grahamorrell avatar Aug 22 '25 13:08 grahamorrell

The scope of the upcoming release is already locked, but we'll try to fit this issue into the next one.

sequba avatar Aug 25 '25 06:08 sequba

@sequba any update on prioritising this one?

grahamorrell avatar Oct 26 '25 18:10 grahamorrell

Hi @grahamorrell,

Currently, we have other tasks on our roadmap that are more important for the development of HyperFormula. However, bear in mind that HyperFormula is an open-source project. We are open to contributions from the community and we would be delighted to collaborate on that feature. Implementing it should be relatively straightforward.

sequba avatar Oct 27 '25 16:10 sequba