> If you set it as the int/short value 7, and query the format string that
> gets applied based on that, how does the string compare to what you were
> trying to set?
>
"$"#,##0.00_);("$"#,##0.00)
I guess it needs the dollar signs quoted now. The regression note I found said
something like that - I just didn't understand what it was getting at. The
format also seems to have a trailing underscore in the first (non-negative?)
pattern that wasn't there before. I guess that's so positive and negative
currency amounts line up even with the trailing parenthesis on negative amounts.
Anyway, the string has changed from what it used to be. I guess as long as 7
seems to be the index for the 'standard currency' format, maybe it's better to
just use that, since the string seems to be subject to change with POI updates.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
