Formula.References not handling all cases correctly
Status: Beta
Brought to you by:
eciloci
Menu
▾
▴
#1 Formula.References not handling all cases correctly
In the debugger, I noticed that the References interface in the Formula object will not correctly identify cell references on the same sheet for any sheet other than the first in the workbook.
Specifically, I have Sheet1 labeled "Summary" and Sheet8 labeled "Factors". On the Factors sheet, there is a formula of the form, "=E12*Sheet9!C39*Sheet9!C69". When I analyze the formula object, the second and third references are correct, but the first reference appears as "Summary!E12". The correct reference is "Factors!E12".
Source code is attached. I am learning .NET, C#, the .NET Excel Automation classes, and formulaengine with this project, so don't expect any beauty.
main file in .NET/C# project