Origin Ver. and Service Release (Select Help-->About Origin): Origin 8.5.1 Pro Operating System:Windows XP Hello! I've got one problem, using origin 8.5.1. When I'm trying to import data from csv file to origin project with drag&drop, it replaces zero data points to the "." and recognizes it as text. In older version it have been replaced to the 0. How can I fix it in my version of origin?
Your csv import filter is probably inserting an ellipse, which is a text string like "-" or "--", into cells with missing data points. You can try writing a LabTalk script in the Advanced Filter Options window to search and replace the ellipses with zeroes. But first, you may have to change the column data types from Text&Numeric to plain Numeric (so your zeroes will be numeric not text). Good luck.