Trying to read in CSV file with numbers using “1E+xx” and getting strange characters show up in Calc spreadsheet. Getting “�” character instead of the “+” character and none of the digits after “+” are imported properly into the cell.
Numbers with “1E-xx” format import correctly.
Example of input with issues:
CORNER,TEMP,VEXPECT,ILOAD,PM,PMf,GM,GMf,GAINDC,VOUT,VERROR,VERRPCT,IIN,IESD,IOUT,IQ
1,-40,1.595,5.00E-05,84.137071,2.24E+04,35.794254,3.22E+06,79.605024,1.5811295,-1.39E-02,-8.70E-01,8.77E-05,-2.31E-12,5.00E-05,3.77E-05
2,-40,1.595,5.00E-05,83.462847,1.91E+04,36.900009,3.75E+06,76.921723,1.5897531,-5.25E-03,-3.29E-01,8.48E-05,-2.95E-12,5.00E-05,3.48E-05