Hi Gretkatillor... Your update to the sheet is AWESOME!!! I like it very much!
I do have couple of things to report.
First you have a mistake in Identify spell. Identify is a Ritual spell but in your code is not. If I find more stuff like this, I'll let you know.
Second in Foxit/Phantom adding spells with ADD ITEM/SPELL function is not working properly. When adding a individual spell or all spells, function populate spell names but doesn't populate other spell entries, like range, duration etc. Also when adding single spell, spell name is in lowercase and as soon I enter Uppercase for first letter in each word, then spell details are autocalculated.
But when adding all of spell for particular level, then all spell names are correct (with first letter in uppercase) but spell details are missing.
I tried this in Acrobat and is working fine.
Also one suggestion. Maybe you should put a link to this thread in description for easier reference. Thanks
EDIT:
Same as with Identify, all 1st lvl and 2nd lvl wiz spells are tagged as non ritual spells which is not true. Didn't check but maybe none of spells in sheet are tagged with "Ritual".