APS Excellence in Physics Education Award
November 2019

Education Prize Logo
Science SPORE Prize
November 2011

NSF Logo
The Open Source Physics Project is supported by NSF DUE-0442581.

[Bug] Export Data to Excel post and replies

Return to the [Bug] Export Data to Excel thread
Login to post to this thread

Cannot Copy Paste to Excel
manos bar
2 Posts

Hello everyone,

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.

Do you have any ideas? Thank you in advance!

Attached File: c.png


Replies to Cannot Copy Paste to Excel

Re: Cannot Copy Paste to Excel -
Douglas Brown Avatar
Douglas Brown
339 Posts

Hi Manos,

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.



Re: Re: Cannot Copy Paste to Excel -
manos bar
2 Posts

Hi Doug! Thank you for your reply!

[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.

Thanks for your time and for this great app!



OSP Projects:
Open Source Physics - EJS Modeling
Tracker
Physlet Physics
Physlet Quantum Physics
STP Book