Any idea why xlfFormulaConvert / Application.ConvertFormula would fail in Excel?
If I try to call xlfFormulaConvert (C-API) with same result in COM Application.ConvertFormula on the following formula, it throws "#VALUE/Error 2015" exception, but if I do convert on each part of the formula, they work. Is it because I need to encode the = (comparison) sign? At first I was thinking multiple sheets in the formula, but since the 'left hand' of the = comparison works and it has RBLResult and RBLInput, I don't think that is it.
Fails
?Application.ConvertFormula("=IF(RBLResult!$CL$22,OFFSET(RBLInput!EK$117,1-1,0),OFFSET(RBLInput!EA$117,1-1,0))=RBLInput!$E$40",xlA1,xlR1C1)
Error 2015
Works
?Application.ConvertFormula("=RBLInput!$E$40",xlA1,xlR1C1)
=[Conduent_Nexgen_DBEstimate_SE.xlsm]RBLInput!R40C5
Works
?Application.ConvertFormula("=IF(RBLResult!$CL$22,OFFSET(RBLInput!EK$117,1-1,0),OFFSET(RBLInput!EA$117,1-1,0))",xlA1,xlR1C1)
=IF([Conduent_Nexgen_DBEstimate_SE.xlsm]RBLResult!R22C90,OFFSET([Conduent_Nexgen_DBEstimate_SE.xlsm]RBLInput!R117C[135],1-1,0),OFFSET([Conduent_Nexgen_DBEstimate_SE.xlsm]RBLInput!R117C[125],1-1,0))