Currency cell type

[DanielusG]

Hi, currently I find that the library works very well but I can't use it to store values of type currency in cells

1.200,00 € or 1200.00 $

is reported as a formatting error when the document is opened in Excel

The code used for the generation of the cell in excel:

sheet.insertRowIterables([
    TextCellValue("${currentWallet.toStringAsLocale(2)} €")
]);

And toStringAsLocal is a custom function that add group separation and the comma for italian locale

I am currently using the library in my code with the following import:

excel:
    git: https://github.com/justkawal/excel.git

[uysuy]

I also tried with custom format too, but seem it doesn't help.

any advice ?

[ProfZEA]

same problem here, please update or give advice to solve that, thanks