Sort my library by composer name, limited to Classical, gives unexpected results
It looks like first name is sometime erroneously taken for last name.
See these examples of wrong sequences that I see:
Fabrice Marin Caietain, Carl Maria von Weber, Pierre Francisque Caroubel
Thomas Crecquillon, David Matthews, David Popper, Claude Debussy, Dmitry Kabalevsky, Franco Donatoni
Carlo Gesualdo, Gottfried August Homilius, Olivier Greif
Franz Josef Haydn, Heitor Villa-Lobos, Philippe Hersant
It looks like the composers who don’t sort well are
either not recognized by Roon = unidentified with info coming just from your file tags
or it could be that the metadata for those is “bad”;
sometimes, there are duplicates in the Roon dataset which are not matched to the “good” artist / composer entry.
You can set a sort name manually when Roon doesn’t provide it: Composer>Edit …>Last-First Sort Name
BTW, I checked the metadata of the 30 tracks corresponding to Igor Stravinsky - among them, three had “Igor Stravinski”, instead of Stravinsky. I corrected those three tracks and put “Stravinsky”. It had no effect, Igor Stravinsky remains classified after Gregorio Huet and before … Isaac Albeniz.
Maybe unconnected with your specific problem, but the Igor Stravinsky that Roon knows about has a picture and bio. It would help Roon connecting your performances to other performances at least if you had Roon’s version. (Roon also knows about variant spellings for its version)
If you search for Stravinsky, what comes up?
If more than one, then you can either edit your tags in Roon to suit, or, more easily, merge the composers. (To do that, they would both need to be in your library)
Does your Stravinsky arise from an unidentified album in Roon?
(All of which is effectively what @anon47919701 has suggested above)
I’m not sure if this is a rule, but it seems to be the case that for unknown artists, Roon uses the first name in the sort, irrespective of what you have set. Hence your mix of sometimes first names, sometimes last.