I am trying to export coordinates data from Tracker to Excel, however a strange bug appears. Although, I have found a way to get around with it, it takes too much time and I was wondering whether someone else has the same experiece.
As you can see in the screeshot, when I try to copy and paste from a table in Tracker to an Excel spreadsheet, I can *10^9 bigger results. That means that for some reason, Excel cannot understand that it is 3,195 and not 3.195.000.000.
Same thing happens when I try to export data from the menu in Tracker and then read it as a csv file in Excel.
This must be related to your locale. I can probably fix it if you can give me a little more information:
1. Have you applied any formatting patterns to the data table columns?
2. Are you exporting the cells with "Full Precision" or "As formatted"?
3. What is your default locale/language and what locale/language are you using when working with Tracker?
Thanks. Doug
...when I try to copy and paste from a table in Tracker to an Excel spreadsheet, I can *10^9 bigger results. That means that for some reason, Excel cannot understand that it is 3,195 and not 3.195.000.000.
[1. Have you applied any formatting patterns to the data table columns?] No. I actually just copy and paste to Excel (special Paste to excel has same results obviously)
[2. Are you exporting the cells with "Full Precision" or "As formatted"?] I have tried both. Both are 10^9 bigger. However, if I first apply a formatting patter to a column with 2 decimals, then everything is copied and pasted correctly. Then I just replace all . with , to do the calculations I need.
[3. What is your default locale/language and what locale/language are you using when working with Tracker?] I have tried on two different systems (MacOS X 10.10 and Windows 8.1 Pro). Both of them English. Tracker is also set to work on English.
Maybe an idea is the option for the user to set a default view for Table View. For example, ALWAYS show t,x,y,v with two decimals (in my sistuation). Now I have to select for all tracked objects to view the table column, then format it with only two decimals and copy it as formatted.
