Please upload your .ods file...

Hi,

Thanks for the speedy reply. File attached.

The issue seems unrelated to spreadsheet generation as the same pattern is seen in the 'Look at marks' window.

Thanks,

Steve

Here is a "bad" but not "terrible" solution:
1. Open the source latex file
2. Relabel questions as follows:
1--> 101
2--> 102
...
9--> 109
10--> 110
...
21-->121 etc
3. That should do the trick?

Hi,

I have a workaround in case others have this problem.

I've had a quick look in the database 'scoring.sqllite' and the table 'scoring_title' and edited the entries in here so '1' becomes '01' and '2' is '02' etc. The output is now sorted correctly in both the Look at marks window and the ods file.. So, whatever writes the input into this table is what is causing the issue.

This workaround will allow me to quickly get the test marked for the time being until the solution can be found.

Thanks.

Steve

1. Use function value(entry) to convert text "'1" to number "1" etc.
2. Select part of the table which has marks and row headers of question numbers.
3. Choose Data-->Sort and under options pick left to right (sort columns)
4. Do the sorting.
5. Done. Pl see attached.

The question labels can be strings that describe briefly the content of the question, so that the columns can be identified quickly. That's why these labels are sorted with lexicographic order.

Hi,

Thanks both for the speedy responses. I understand what you are saying, but I still think there is something 'fishy' going on.

What I don't understand is why the issue of sort order has suddenly cropped up for me. I am not doing anything noticeably different in this project to my previous ones which worked as expected. I have never needed to 'trick' the code to get the correct sort order before and this source.tex is a copy a previous one, just a few extra questions and columns.

So to test out whether it is a code issue Latex or some setting somewhere, I cloned an old project that sorted results correctly, deleted the old Latex source.tex and pasted in the new one form the project that exhibits the odd sorting behaviour. I then click Update Documents and Detect Layouts so the old project used the new Latex source. I looked in the database layout.sqlite in this project directory and now questions 1-9 are described as 01, 02, 03 etc and results are sorted correctly on the output. In a 'faulty' project they are just described as 1,2 3 etc. with the leading zeroes missing in this database. So, unless I'm missing something, this tells me there must be a setting somewhere in the project that is causing the issue, not that it is default behaviour or a problem with the Latex code.

Any ideas where this can be found so I can alter it please? Does that even make sense ?! :-)

Thanks,

Steve