HeroForge Bug Tracking Page
Mantis Bug Tracker


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000360HeroForgeBugpublic05-04-2010 08:4006-05-2010 16:44
ReporterChristophe Kowalski 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version6.1.0.1 
Target Version6.1.0.1Fixed in Version6.1.0.1 
Summary0000360: Broken list in source books quick select box on Feats
DescriptionReported by Yonner:
Feats - the source quick select box is missing some implemented sources (PHB II), has some non-implemented sources (Fortress of the Yuan-Ti) which throw errors when selected (because they don't exist below), and the sort order has been shuffled. Oh, and the word "war" appears in cell A1.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0001052)
Christophe Kowalski (developer)
05-04-2010 08:43

This is indeed a regression.
The FeatLink list was a static range on sheet Tables. It has been moved as a dynamic list part of TblSourcebooks on options Info in view of harmonizing references.
There was however an error in the formula used to create the dynamic list, causing a shift of one row on every line (Options Info!R2:R147)
=IF(ROW()<=SourcebooksFeatsSrcCnt;INDEX(TblSourcebooks;MATCH(ROW()-1;$Q$2:INDEX(TblSourcebooks;SourcebooksRowsCnt;8);0);2);"")
should be
=IF(ROW()<=SourcebooksFeatsSrcCnt;INDEX(TblSourcebooks;MATCH(ROW()-1;$Q$2:INDEX(TblSourcebooks;SourcebooksRowsCnt;8);0)+1;2);"")

As items in the list are now derived from the master sourcebooks table, a few headers on the Feats sheet became inconsistent with the official names now used:

D1645: Expanded Psionic Handbook should read Expanded Psionics Handbook
D1780: Dragon Magazine > Dragon Magazine (315, 319)
D1946, D2058 and D2064: Player's Guide to Faerun, Magic and Race of Faerun > ... Faerûn
D2464: Secret's of Xen'drik > Secrets of Xen'drik
D3160: Dungeon Masters Guide > Dungeon Master's Guide
D3265: V.R. Arsenal Vol. 1 > Van Richten's Arsenal Vol. 1

The FeatLinkChange routine has been modified to work both directions:

Sub FeatLinkChange in module Feats:
Replace
        Cells.Find(What:=Range("FeatSource").Value, After:=ActiveCell, LookAt:=xlWhole, _
            searchorder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate
With
        Range("D:D").Find(What:=Range("FeatSource").Value, LookAt:=xlWhole, _
            searchorder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate

- Issue History
Date Modified Username Field Change
05-04-2010 08:40 Christophe Kowalski New Issue
05-04-2010 08:43 Christophe Kowalski Note Added: 0001052
05-04-2010 08:43 Christophe Kowalski Assigned To => Christophe Kowalski
05-04-2010 08:43 Christophe Kowalski Status new => assigned
05-04-2010 14:45 Christophe Kowalski Status assigned => resolved
05-04-2010 14:45 Christophe Kowalski Resolution open => fixed
05-04-2010 14:45 Christophe Kowalski Fixed in Version => 6.1.0.1
06-05-2010 16:44 Yonner Status resolved => closed


MantisBT 1.2.0[^]
HeroForge and the HeroForge Logo are Trademarks of HeroForge Software, LLC - Copyright 2008 - 2009 HeroForge Software, LLC. All rights reserved.
MantisBT - Copyright © 2000 - 2010 MantisBT Group
Powered by Mantis Bugtracker