search

Senipah / VBA-Better-Array

An array class for VBA providing features found in more modern languages
MIT License
112 stars 18 forks source link

[BUG] Failing unit `ToCSVString_Simple2RowNoHeadersDatesAndDoubles_ValidStringReturned` in German Excel #24

Open Mo-Gul opened 8 months ago

Mo-Gul commented 8 months ago

The title says it all.

In the Immediate Window I get the following values

for Expected

Sub-Saharan Africa,Chad,Office Supplies,Online,L,1/27/2011,"292,494,523.00",12/02/2011,"4,484.00",651.21,524.96,"2,920,025.64","2,353,920.64","566,105.00"
Europe,Latvia,Beverages,Online,C,12/28/2015,"361,825,549.00",1/23/2016,"1,075.00",47.45,31.79,"51,008.75","34,174.25","16,834.50"

and for Actual

Sub-Saharan Africa,Chad,Office Supplies,Online,L,1.27.2011,"292.494.523,00",12.02.2011,"4.484,00","651,21","524,96","2.920.025,64","2.353.920,64","566.105,00"
Europe,Latvia,Beverages,Online,C,12.28.2015,"361.825.549,00",1.23.2016,"1.075,00","47,45","31,79","51.008,75","34.174,25","16.834,50"

So the Doubles, Dates are returned "wrong". Without digging deeper I think I can understand why the Doubles are "wrong" I don't have an idea why the Dates are returned wrong when the output format is given as spec (DateFormat:="m/dd/yyyy").

When you are interested in making class/tests "language" aware I could dig deeper ...