+ Start a Discussion

Filter issue: Always receive "Type Mismatch" error regardless what filter is applied

Dear All,


I am desperately lookin for help.


I am using Force.com Connector for Excel version version 16.03.  It works perfectly as long as I don't apply any filter.


Regardless what filter I applied, I alway got error message "Could not set the list property. Type Mismatch"


For example,  I tried

Account Name starts A


Account Name starts "A"


When I do debug, it highlights line 4 in the code below.


Sub AddClause(clauseNum As Integer) ' 5.42
    With Me.queryClausesList
        .AddItem clauseNum, clauseNum
        .List(clauseNum, 1) = Selection.Offset(0, 1)
        .List(clauseNum, 2) = Selection.Offset(0, 2)
        .List(clauseNum, 3) = Selection.Offset(0, 3)
    End With
End Sub


Please kindly help.






Okay, I just found out the root cause.


The filter functin doesn't work with German locale settings (e.g number format: 7.000,09)


I changed my PC's Regional Data Format to English (United States) , then it works.