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

[shma_lo]

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 6.3.6.2, Windows 10

[mikekaganski]

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

Please file that bug, and CC me there.

[DrRobotto]

I filed the bug 141050.

[mikekaganski]

… fixed now with https://gerrit.libreoffice.org/c/core/+/112734. Thanks for filing and mentoring that!