Any idea why xlfFormulaConvert would fail?

33 views

Skip to first unread message

Terry Aney

unread,

May 28, 2024, 2:24:56 PM5/28/24

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