We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Upgrade from to 11.4400.0.26 gives invalid sheet indexes in formulas

Thread ID:





115070 Dec 20,2013 04:30 PM UTC Jan 3,2014 07:35 AM UTC WinForms 1
Tags: XlsIO
DUPLICATEThomas G Mayfield
Asked On December 20, 2013 04:30 PM UTC

For unit testing one of my components, I have an XLSX and an XLS file that have two sheets filled with the formula:
=CONCATENATE("Sheet #: ",SHEET(A1),", Row: ",ROW(A1),", Column: ",COLUMN(A1))

When I load it in XlsIo and export to a DataTable, the "Sheet #" gives wildly inaccurate results, like "Sheet #: 6" or "Sheet #: 8" when the maximum possible is 2. I've tested directly accessing the CalculatedValue after calling EnableSheetCalculations() and get the same bad values.

Note that this doesn't always fail. The first time the engine is used, sometimes the first-run test passes while all the others fail.

I've attached an NUnit testing project that tests the engine with XLSX, XLS, and CSV files. Running the tests will show the failures.


Rajesh A [Syncfusion]
Replied On January 3, 2014 07:35 AM UTC

Hi Thomas,

         Sorry for the inconvenience.

    We are unable to download your attachment “ClassLibrary1_e8ddd0b.zip” due to our file server problem. Can you please re-attach the file or send the file to support@syncfusion.com for analysing the issue? It will help us to proceed further on this.

Please let us know if you have any clarification.




This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon