I have all the book metadata setup with the author like this:
Author Jane Smith
Author sort Smith, Jane
But I want the Author column in calibre to show LN, FN. When I use the quality check plugin to swap FN LN > LN FN, the author column is sorting by the second word (FN after the swap), so Smith, Jane comes before Jones, Sally.
What is the best way to setup the metadata to have LN, FN in the author column so it sorts by last name alphabetically?
And why, when I swap them, does it add a comma after both names in the author sort field?
TIA
