Hi,
I’m building a LibreOffice Calc for myself.
I’m gathering data to fill my sheets in a DialogBox.
I have trouble writing my currencyfield’s data.
Right now, if I write “xx €” it fills the sheets with the correct data. But when I enter “xx,xx € (or xx.xx €)” it will shurten it to xx€ skipping the “.xx” part
Here is some of my code :
Dim ValMont as Variant
...
ValMont = oDialog.getControl("montant").Text
...
feuille0 = ThisComponent.sheets(0)
currCell = feuille0.GetCellByPosition(13,6)
currCell.Value = ValMont
Using the step by step method, I checked that my “ValMont” has the correct value (xx,xx€).
But as soon as this value is transmitted to currCell it becomes xx€.
Can someone help me ?
Thanks