Quote:
Originally Posted by AnotherCat
Yes it was Dazrin's spreadsheet that I used, so seems I used the wrong one...
|
I've discovered the problem, well for me
. When one opens the spreadsheet from the link it is populated with a subset of the whole population of books. So if one does a search (either by the filtering macros or visually) of "doom" or "cholera" for example the output is blank. If one then filters on "All"
then one gets all the books.
My problem is that I am so used to working with spreadsheets and databases that to find one that opens already filtered to a subset of the whole population is most unusual. I now see that there is a note by the filtering "Show" macro cell " (Blank = NLBC Ineligible books only)" (what is NLBC? took me a few minutes to fathom that out too, turned out to not be North London Borough Council
) but that was just noise to me as is contrary to usual database practice (should open fully populated or empty, not in some in between state).
Maybe I am the only one who has run into this but my suggestion would be that the spreadsheet should open fully populated and filters applied by the user to get the subset of books looked for. Compare with Calibre, for example, when run the library list opens full populated, not at some subset filtered on some tag.
(This could be moved into the Literary Club sticky thread)