Hi. I've been lurking here for a little while and been a happy user of Calibre since 2013 but only just now registered. I've started using Calibre to catalog my physical books (couldn't find a satisfactory solution for a while, thought "I wish there was something like Calibre for paper books...wait..."), using dummy.paperbook files so they appear in the format category.
I've created a virtual library for the physical books, using the search query "formats:#=1 and formats : paperbook" for the Paper Books sublibrary.
The problem, though, lies in the default virtual library (which already excludes a specific tag). I'd like to exclude books that have
only a paperbook format. A simple "not formats : paperbook" doesn't work as I have books with both physical and digital formats that I
do want to appear. Can't quite figure out how to accomplish this.
Things I've tried:
"formats : paperbook AND formats:epub" for each different format - rather unwieldy
"formats : paperbook AND formats:#=2" only works for books with two formats
(both of those resulted in every other book getting excluded as well)
I hope someone here may be able to help with this.