I edit in odt format in LO Writer and Save As an EXTRA docx for Calibre
Importing the docx to Calibre gives
Code:
-LO Writer Properties "Title" = Calibre Field "Title"
-LO Writer Options | User Data "First/last name/initials" = Calibre Field "Author"
-LO Writer Options | User Data "Company" = Calibre Field "Publisher"
-LO Writer Properties "Keywords" = Calibre Field "Tags"
-LO Writer Properties "Comments" = Calibre Field "Description"
-LO Writer Properties "????" = Calibre Field "Series"
-LO Writer Properties "????" = Calibre Field "Series_Index"
-LO Writer Properties "Subject" = Calibre Field "Tags"
Document Language seems to go to Calibre Language
Date is date first imported or record without formats created.
LO Writer Options | User Data [./] Use data for document properties
No need for Calibre Field "ID"
I'd put Series and Series_Index in the Comments and then after import Copy/paste those in the Metadata editor.
I don't see a Calibre Field "Genre"?
Subject and Keywords seem to be alphabetically sorted and combined to Tags.
Publish date is edited from a spreadsheet, if applicable.
I have a separate custom Collections column used for Sony and Kobo ereaders that is manually entered.