View Single Post
Old 01/22/08, 10:17 PM   #1282 (permalink)
Cheeky
Bastard
 
Cheeky
Troll Hunter
 
No WoW Account
Originally Posted by Kaber View Post
Hey Cheeky, I do not know if there was ever any consensus on what was going on with the bug messages I kept getting, but I finally found a way to get the error messages to show up in a useful and informative way. Apparently you programmed this in Excel 2004 (according to the message I got), and the way it handles macros for some of your features is vastly different than Excel 2003 for some reason. So the Shot Rotation, DST, and another page or two become completely disabled. I was able to enter rotations by hand, but I do not know if it actually changed any of the calculations within the spread sheet. I do not believe there is anything you will ever be able to do to make your spread sheet work in 2003, short of reprogramming it entirely which would probably force you to lose features that '03 does not support. As such I wonder if it would be beneficial to add a note that the sheet does not work for that version of Excel just to squash any further issues.

I should note that the time where I began running into problems with the spread sheet was about the time where the Dragon Spine Trophy feature was fully enabled and fleshed out (not the first push, but one of the following).
Hmmm. MY home version of Excel (where I've done 90+% of the development) is Microsoft Excel 2002 (10.6834.6830) SP3. Everything works in that version. When I first converted from Open Office to Excel a year ago I used my work version which might have been 2004, I'm not entirely sure.

Anyone with more experience with Excel (or better yet, a Microsoft Developer) able to shed additional light on this?

 
User is offline.
Reply With Quote