Feedback Case Number: 66568
I think Greg did not understand the problem.
Var d As Double = -123.45 Var s As String = d.ToString("#.00;(#.00);0.00")
Windows 10: Invalid Argument exception (this is correct)
Mac: No Exception but the argument is not correct (this is wrong)
The Unicode Number Format Patterns page mentions subpattern for negative numbers, so the correct and valid patter is not
What is expected is that Windows and Mac (Linux too) complain with Invalid Argument Exception when a wrong pattern is used. This is not happening on Mac and a result with the “normal” patter is used: -123.45 instead of (123.45)
If I remove ;0.00 from the pattern, then the result on mac is correct with (123.45)
I can even change the patter to “#.00;#.00-” to get 123.45- instead, so that patter is working as expected.
There is no third pattern of 0 value (that is different than Str), so if we add a third pattern on Mac it should report an Invalid Argument Exception just as Xojo does with Windows.
I hope this is clear.
A pattern contains a postive and negative subpattern, for example, “#,##0.00;(#,##0.00)”.