If you became a customer of the Syncfusion Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion.
For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion for its reporting solutions. Our team will be happy to assist you with any questions you may have.
Thank you for choosing Syncfusion for your reporting needs.
In simplified form, I have an Excel template file which consists of two worksheets. If I put a value in the second worksheet which reads "=+Worksheet1!C10" I would like the cell on the second worksheet to display the same value as appears on Worksheet 1 in cell C10. Unfortunately, however, when a new spreadsheet based on the two template worksheets is opened, my referencing cell, instead of showing the value that I want, displays an error.
However, if I put the cursor in the status (data entry) textbox at the top of the worksheet and hit the enter key, this reference is resolved and the correct value is displayed.
In reality, my template file contains many worksheets and I have many, many cross referenced cells which I would like to have automatically resolved/updated when the spreadsheet is opened. Expecting users to manually update these references is not a practical option. Is there any way to achieve this programmatically?
INIshwarya Narayanan Syncfusion Team October 30, 2015 10:05 AM UTC
Thank you for contacting Syncfusion support.
We are unable reproduce the issue, so we have prepared a simple
sample as per your scenario in the below link. Kindly modify the sample to
reproduce the issue and let us know so as to proceed further and provide
a prompt solution at the earliest.
I built a very simplified sample to illustrate my problem but it did not have the same undesirable result. It will take some additional testing for me to either determine what is different/ wrong in our actual working application or to create a sample application which illustrates the problem.
I will let you know regardless of which result I find. Thanks.
MMMathu Mohan Vijayakumar Syncfusion Team November 3, 2015 05:06 AM UTC
Thank you for updating us.
We will wait to hear from you. Regards, Mathu Mohan V A