Then everything works. If you have the tweak set to comma, Calibre expects the author field to contain the author name in the format FN LN and will recalculate the author_sort value accordingly. If your author field contains LN, FN Calibre will assume that the first name is indeed the last name and produce the result you saw.
If you, as you wrote in your first post, want both author and author_sort to contain LN, FN then you'd have to set the tweak to copy, put LN, FN in every author field and then recalculate the author_sort values.
|