Can function CCur(s) accept negative string like "-100" ?

Why function CCur(s) can’t accept negative string like “-100” ?

dim c as currency

c = CCur(“100”)

Print c ’ result: 100

c = CCur("-100") ’ result: Inadmissible value or data type. Data type mismatch.

LO, Windows 10

This is a bug in ImpStringToCurrency, which does not increment iterator when processing sign.

Please file that bug, and CC me there.

I filed the bug 141050.

… fixed now with Thanks for filing and mentoring that! :tada: