Just a thread to discuss nothing but the spreadsheet and any errors anyone finds.

Errors found since last release:  (11.4)

1) Some of the Sort deck macros weren't working (had broken when I got rid of the Extended legality column.  Fixed already for 11.5
2) Found and corrected some minor formatting issues on the BlankDeck template
3) Corrected the formula error on the EmptyTable template tab in column P - this is the formula that looks up the Flavour text for the card and was looking it up in the wrong column - again, bug introduced when I got rid of the Extended Legality column on the BlankDeck tab.  If you want to correct this mistake yourself, simply unprotect the sheet ("mtg" is the password), select column P and do a find and replace - "V:V" for "U:U".  :-)

Nyoze, you mentioned not managing to get the Draft Initial Post working... though from the look of your recent posts, I'm guessing you did.  Worked fine for me. :-)

Having issues again.

When I click copy, this is the result: ￿￿

Hi Nyoze, not sure which bit you are referring to...  Are you referring to the "copy draft post to the clipboard?" button?  Or the right-click "Copy to Clipboard" function?

And by the result, do you mean that the contents of the clipboard after you've done it is a couple of strange characters?

Copy Draft post. I didn't know there was a right click copy to clipboard, unless you refer to the standard windows copy function?

And yeah, I click that, and then that's what's in the clipboard.

Yeah - I've added a number of "right-click" options :-)

The main one is the Copy to Clipboard.  It is almost the same as doing a CTRL-C, however it removes the quote marks that you will get if you copy a cell that has a carriage return in it.

Current version: 11.5
Downloadable from http://matthewfenn.ipage.com/n.../Downloads/index.htm

Known Errors found in this version:

1. Mythic Rare card count formula incorrect on the Table tab - Corrected in next version.
   
2. Error in the change macro that invokes when changing to a deck tab that has an incorrect card name in the first entry - for example, when you first create a new empty table and blank deck ready for editing.   - Corrected in next version.

This message was last edited by the GM at 17:23, Tue 20 Feb 2018.

Current version: 11.5
Downloadable from http://matthewfenn.ipage.com/nj-pbem/Downloads/

Lots of bug fixes - even an update of cards.  Most significant fix was changing a variable from Integer to Long - which meant that the import of cards into the datatbase, which I'd suddenly noticed had stuck at 32767 cards, could actually continue to the full current number of cards - 35627.

Another fix is getting the rest of the images loaded into the CardImages folder...  I'd almost given up, since I was getting a permission denied error - and had assumed that magiccards.info had changed their website to stop people scraping the images off it - but actually, it was a change in Windows10 that stopped the command I was using to do it from working...   A different command did the job just fine!

A new feature I'm particularly proud of is that whenever you click on a card name, a comment will pop-up on the card description field (be it on the Table tab, the Deck tab, the Archive tab or the All Cards tab, giving you the card description - which saves you having to expand the line to read it...  Of course, because this functionality relies on triggering a macro every time you change selection, this means that the copy buffer dies...  so CTRL-C broke...  But the Right-Click "Copy to Clipboard" macro still worked - so I decided to make CTRL-C the short cut to trigger that macro - so effectively restoring the normal behaviour of Copy.... (though you don't get to see the animated dotted line around your selection any more).

Another change is to improve the error checking on the Deck tab for Commander Decks so that it will take into account the new "Partner" commanders :-)  I have just noticed that the "Copy Draft Initial Post to Clipboard" macro on the version I've uploaded will miss the second General though - so another minor improvement for version 11.7 no doubt! :-)

Errors that got fixed include the strike-through formatting on the Deck tab that marks the cards that are in use on the Table tab, plus some minor macro errors.

I'm sure there are still plenty of bugs here and there - but most of the time, it should just work...  if you find any, please post them here and give me as much detail about what you were doing at the time, what version Excel you have etc..

Finally, I'd like to mention that although I have downloaded a copy of LibreOffice, my efforts to get my spreadsheet to work in it are so far fairly limited... In an ideal world, I'd get the macros cleaned up in Excel so that they worked seamlessly in LibreOffice as well...

I will keep you posted.  Sadly, I doubt I'll ever get away from needing to have a full spreadsheet program - so if you play on just an iPad or similar, then I'm afraid you're probably stuffed. :-(

PS: The upload of the zipped CardImages folder might not complete till sometime tomorrow...  My FTP is going very slowly tonight and it is over 2.7gb!
This message was last edited by the GM at 22:54, Sun 15 Apr 2018.

Alright matthew what am I doing wrong?

I downloaded the new spreadsheet, enabled macros/analysis toolpak

and whenever I start to put card names in the deck I get a 1004 runtime error.

"unable to get the vlookup property of the worksheetfunction class"

I'm using office 365.

Hmmm... not immediately sure...

Can you do the "debug" and then let me know where in the code it is crashing?

Actually, I suspect I know what it is...  If it is what I think it is, I've already fixed it in the new version...

I'll upload a new version this evening.

Matthew