The following formula:
"=SummaryTable[[#This Row],[SampleID]]&"_"&SummaryTable[[#This Row],[SeqNr]]"
gives the following error:
"The formula has extra expressions after the end of it.
Portion with error: [[#This Row],[SampleID]]&"_"&SummaryTable[[#This Row],[SeqNr]]"
When I try to load the file:
Infragistics.Excel.Workbook workbook = Infragistics.Excel.Workbook.Load("C:\\Template.xlsx");
Are structured references supported?
Currently this syntax is not supported, so I have logged a feature request for you with reference number: 12851
If you would like to follow up on your feature request at a later point, you may contact Developer Support management via email. Please include the reference number of your feature request in the subject and body of your email message. You can reach Developer Support management through the following email address: email@example.com
Let me know if there is something more I can do for you.
Do you have any other questions that I can help with?
No, thanks. We use structured references extensively in our data presentation spreadsheets. People often manipulate the data extensively and absolute references break down rather quickly in that environment.
There are other things I would like to do, like array formulas, graphs, manipulate the size of tables, etc. But if Infragistics doesn't support structured references that's a non-starter for me.
I have sent your request for supporting structured references. I will ask our Product Management team what are the plan for implementing it and will update you here.
After I contacted with our product management team we can ensure you that we are going to implement this feature in the coming year. For now we can’t give any specific time frame when this will be, but this feature is included in our features plans.
Thank you for using Infragistics Components.