Nowhere in calibre is there functionality to highlight the part of a metadata field that matches.
And the spreadsheet cells are nowhere near big enough to display a decently-sized comment in its entirety (so you can see multiple matches in a scrolling view of some sort).
Perhaps you could write a plugin to do what you want.
|