![]() That is why I needed to sort the scoring spreadsheet rows into last name, first name, sequence # order, with the thumbnails being sorted along with the row. I wanted to use the same scoring spreadsheets as a place to write my comments for the narration, but in the order in which they must be shown. The problem arises because, In addition, I need to organize and narrate a showing of all the competition images sorted by maker, not in the different competition order. One version can be printed, while another version can be used in a computer during the judging to summarize the 3 judges' scores for each image as the scores are announced. I used these to build thumbnail images in judging order on scoring spreadsheets. ![]() I receive a folder of images sorted in competition judging order. I am having to organize a competition judging. Unfortunately, the problem I face has nothing to do with storing my personal pictures. Once again, thank you, Villeroy, for your useful comments. Weird!Īny help you can offer would be greatly appreciated, as I shall need to do this kind of sort more often in the future. Yes, I have read the Open Office manual, but I cannot find a clue as to why this is happening or how to correct it.Īnother peculiarity I have noted, which may be related to the cause, is that when I delete rows with images in them, the rows disappear OK but the images pile up undeleted in a single cell after the main body of rows. You will see that the text columns, including the "Title" column, sort correctly on each row, while the images column does not (note that the first sorted row and the last sorted row are unchanged, which is correct). ![]() Then sort, in the order of Column E ("Last Name"), then Column F ("First Name"), then Column A (untitled column containing a sequence number).ĥ. please select (highlight) the rows from 3 through 21 to keep the headers out of the sort.ģ. Please copy the file and open the copy in either Microsoft XCEL or Open Office Calc (if you don't have Open Office, it is free and can be downloaded at ).Ģ. For a simplified sample spreadsheet to test my problem, please go to:ġ.
0 Comments
Leave a Reply. |