Editable Worksheet - Sorting

[lalcaraz]

I was using the editable worksheet to quickly put in Purpose and Channel information before I exported it to Lightwright.

The 1st time I used it, it was fine.

I updated it and used it a few more times.

Then I went back to my information and all of the unit #'s, color, channels, etc. was mixed up.

I ran a few tests to eventually figure out that whenever I would create a new one and sort it in a different way, for example - the 1st time I sorted it was by Channel and the 2nd time by Position.

The spreadsheet would only sort the Column that I asked to sort -- ie. Position. This would be like selecting only 1 column in excell and then sorting. Thus all of the rest of the columns stay the same and just the new sort would change.

This causes all of the information to get mixed up.

Has anyone realized this, or am I crazy.

Thanks

Lonnie

[kmoore1]

quote:

---

Originally posted by lalcaraz:

Create Editable worksheet....The 1st time I used it, it was fine.

I updated it and used it a few more times.<SNIP>The spreadsheet would only sort the Column that I asked to sort -- ie. Position. This would be like selecting only 1 column in excell and then sorting. Thus all of the rest of the columns stay the same and just the new sort would change.

This causes all of the information to get mixed up.

Has anyone realized this, or am I crazy.

Thanks

Lonnie

---

I've heard some reports of the data getting rearranged but haven't had a clear description like yours and have not been able to repeat it. Thanks for the good description and detective work. I'll look into this and see if I can make it happen here.

[lalcaraz]

Kevin

Thanks for the update

Can you let me know when the patch is available, as I have a dozen students to pass it along to.

Thanks

Lonnie

[kmoore1]

quote:

---

Originally posted by kmoore1:

I've heard some reports of the data getting rearranged but haven't had a clear description like yours and have not been able to repeat it. Thanks for the good description and detective work. I'll look into this and see if I can make it happen here.

---

Thanks for the research Lonnie. I figured out what was going on. The command is not sorting the last column in the worksheet. I've fixed it and should have a patch up on the website either today or tomorrow.

In the meantime you can add an extra field that you're not using to the worksheet. This field won't be sorted, but as long as its empty this won't matter.

HTH