Internal to the calibre database ratings are stored as a number from 0-10. For consistency and compatibility with future changes to the database, the rating value is reported as it exists in the database. The best way to deal with this would be to write a function in your spreadsheet which displays the rating value divided by 2.
IIRC, the reason for this is that Kovid wanted to allow for half stars at some future time.
G
|