Any idea why xlfFormulaConvert would fail?

25 views
Skip to first unread message

Terry Aney

unread,
May 28, 2024, 2:24:56 PMMay 28
to Excel-DNA
If I try to call xlfFormulaConvert on the following formula, it throws ExcelErrorValue, but if I do convert on each part of the formula, they work.  Is it because I need to encode the = (comparison) sign?

XlCall.Excel( XlCall.xlfFormulaConvert, "=IF(RBLResult!$CL$22,OFFSET(RBLInput!EK$117,1-1,0),OFFSET(RBLInput!EA$117,1-1,0))=RBLInput!$E$40", true, false )
ExcelErrorValue
XlCall.Excel( XlCall.xlfFormulaConvert, "=RBLInput!$E$40", true, false )
"=[Conduent_Nexgen_DBEstimate_SE.xlsm]RBLInput!R40C5"
XlCall.Excel( XlCall.xlfFormulaConvert, "=IF(RBLResult!$CL$22,OFFSET(RBLInput!EK$117,1-1,0),OFFSET(RBLInput!EA$117,1-1,0))", true, false )
"=IF([Conduent_Nexgen_DBEstimate_SE.xlsm]RBLResult!R22C90,OFFSET([Conduent_Nexgen_DBEstimate_SE.xlsm]RBLInput!R117C[140],1-1,0),OFFSET([Conduent_Nexgen_DBEstimate_SE.xlsm]RBLInput!R117C[130],1-1,0))"



Reply all
Reply to author
Forward
0 new messages