Opened 6 years ago

1004 errors in TicketEdit.xls

Reported by: Owned by: Chris.Nelson@… okazaki normal TracDependencyPlugin normal 0.11

Description

I can't get TicketEdit to work. I can't even tell if I'm connecting to Trac. I see Debug.print() stuff in the VB code but I don't know where that might be coming out. Can you suggest some strategies for diagnosing the problems?

comment:1 Changed 6 years ago by Chris.Nelson@…

When the error occurs and I open the debugger, the highlighted line is the te.import() in Sub import() in MultiPrjTicketEdit.

comment:2 Changed 6 years ago by Chris.Nelson@…

I got a little further with this. It's actually failing in setValidationString in MiscModule on the line:

.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=work


the lines right before that in TicketEdit.import() prints:

select
options=...


Where ... is actually a LONG list of milestones (we have well over 100).

comment:3 Changed 6 years ago by okazaki

• Status changed from new to assigned

comment:4 Changed 6 years ago by okazaki

(In [7836]) refs #6958 Validation list length limitation is added to selectable fields.