1 Topic by f.kerkhof (edited by f.kerkhof 2024-10-17 13:15:55)

  • f.kerkhof
  • -
  • Offline

I have recently given version 2024.1 a try.
It looks and works good but I have encountered a problem when exporting from the linear kinematics with the copy to clipboard function.

In version 0.9.5 the pasted data is available in the following format:

1560;1,167802
1564;1,164904
1568;1,174584
.....

With version 2024.1 data gets pasted from the clipboard in the following way:

"1560";"1,167802"
"1564";"1,164904"
"1568";"1,174584"
.....

Is this expected behaviour or is it possible the choose the data format (number, string) ?

2 Reply by joan

  • joan
  • joan
  • Admin
  • Offline

The double quotes don't make the content string, it's a standard way of writing the data in case the cell separator is the same as the decimal separator.

What is the problem you are facing exactly? Is there a spreadsheet software that won't take this and create numbers? Does it not go through a text import dialog?

I'm surprised by the fact that the first value seemingly uses a coma and the others a point as decimal separator. You can force the separator in preferences under Drawings > Export.

3 Reply by f.kerkhof

  • f.kerkhof
  • -
  • Offline

The use is indeed to copy/paste data into Excel columns and process this further.
So this does not go through the import test dialog.

The first value as a comma and the other lines with a point as decimal was a typo from my side, sorry.

Strange is of course that decimal (,) and cell separator (;) are not the same here and the quotes are added anyway.

I will be possible to change to processing of the data in Excel itself to tackle the issue. But I was just wondering why the behaviour had changed in the new version.

4 Reply by joan

  • joan
  • joan
  • Admin
  • Offline

The behavior was changed to make it more robust and more standard conformant.

I don't have Excel at hand here but when I try in online Excel in OneDrive, it fails by default and puts everything in a single column, but there is a "Paste options" button with a "Split Text to Columns" option where I can select the correct variant. (edit: I can also do this after the paste by selecting the cells and doing Data > Split Text to Columns).

Are you saying that the version without the quotes is splitting the columns by default correctly on your machine and the one with the quotes is not?

The quotes should really not change anything. They are necessary if the text can contain the decimal separator which is the case here since the headers are user-entered text.

When I paste in LibreOffice, if I keep the headers, it automatically shows the text import dialog. Then the values are imported as text or as numbers based on the decimal separator.

If I paste in Google Sheets it's the same as OneDrive Excel, fails by default but there is a button "paste formatting" with a "Split text to columns" option with the options.

"Time (ms)";"Trajectory 1"
"133";"142.0046"
"167";"150.0579"

"Time (ms)";"Trajectory 1"
"133";"142,0046"
"167";"150,0579"

Time (ms);Trajectory 1
133;142.0046
167;150.0579

Time (ms);Trajectory 1
133;142,0046
167;150,0579

5 Reply by f.kerkhof

  • f.kerkhof
  • -
  • Offline

OK, understand.
Currently I'm using some functions in Excel to split the columns automatically when pasted. These are not working any more.
But as said, it will be possible to adapt those functions to get it working again. The options you explored with "split text to columns" also works.

Thanks!