ESdat Forums
»
Forums
»
ESdat
»
Chem Table row order
 Rank: Newbie
Groups: Registered
Posts: 8  Location: Brisbane
|
Hi,
I am having an issue with chem tables exporting incorrectly (see screenshots).
The rows are in the correct order that I want in the Chem Table. I have used a prefix to ensure that the rows are ordered correctly. Everything is displaying as it should.
But as soon as I export the data into excel, it goes into a mixed up row order. I have tried rearranging the sample detail columns, as well as turning various ones on and off. But the export row error is the same no matter how the columns are arranged.
Any help would be appreciated.
Edited by moderator Wednesday, March 25, 2020 2:39:56 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
 Rank: Administration
Groups: Registered, Administrators Posts: 327  Was thanked: 29 time(s) in 29 post(s)
|
Hi Melinda,
I've had a look at the data, and it appears that the samples that are sorting at the end of the table in the export actually have a "tab" in the value.
Did you happen to populate some of the data by copying and pasting from Excel (or similar)?
Sometimes when you do this, Excel copies additional data contained in the cells that your can't see (like tabs or spaces).
You'll need to edit the sample details for those ones sorting at the end to make sure that they don't have any "unexpected" values saved in the fields with the text.
Once you fix these, it should export as expected.
Thanks,
Nick
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 8 Location: Brisbane
|
Thank you so much Nick, you were spot on!
That did indeed fix the problem.
Much appreciated.
Melinda
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Chem Table row order
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.