Just like we check for an initial decimal separator in ScanStartString()
when the string doesn't start with a currency symbol, check for an
initial decimal separator after the currency symbol too. Wi

Just like we check for an initial decimal separator in ScanStartString()
when the string doesn't start with a currency symbol, check for an
initial decimal separator after the currency symbol too. Without this,
"$.nn" gets parsed as a text field with "$.nn" instead of a numeric field
with $0.nn.

Add a subsequent JUnit test for this too.

Fixes: https://bz.apache.org/ooo/show_bug.cgi?id=82687
- Text entry or CSV import treats $.nn as text
Patch by: me

(cherry picked from commit 96178715f486e8815def398176cafa748d3cbb73)

show more ...