|
24 is a number, not text. Calc automatically makes it an integer. You have to either use '24 to force it to text, or to manually format all of your cells as text. Or both to be sure. However, you cannot leave any cell empty, since Calc defaults to a number (it is a spreadsheet app after all). Put a blank space in empty cells to force it to text.
Each and every cell must be double-quoted text. If you open your csv file in Notepad, look for any double commas ,, since that means there is at least one numeric column. You should see only ","",""," and never ",,,".
I am preparing a major enhancement to the tool for release very soon, and one of the things I have enhanced is its ToolTips that explain the above.
The tool does not change any capitalization. Remember that a pre-existing Tag's capitalization is retained when you add the identical Tag with differing capitalization to another Book. That behavior is standard Calibre.
|