Thank you for your response but something I found on your own web page is
Developers can easily manipulate Excel cells and Evaluate formula value in C#, VB.NET or ASP.NET at runtime. Super-fast, scalable excel calculation engine is compatible with the 97-2003/2007/2010 Excel. Cell Styles are supported by this Excel .NET component, such as cell merging/unmerging, text wrapping/unwrapping, text alignment, rotation, interior, borders, lock/unlock and etc. Font formats, like setting font type, size, color, bold, italic, strikeout and underlining etc. is also fully supported. Conditional formatting, text search and replace, filter and data validation can be applied to cells as easily as you expect.
I have bolded the actual statement made. I can understand having a real fast Excel calculation engine but can it be said to actually be fast if you can't reach the calculations in an efficient manner? I am only being given one choice on how to run my calculations on a spreadsheet I am not allowed to edit. That same spreadsheet in Excel itself does not suffer the same penalties that you are saying your API has.
So for example, couldn't you have a background thread created when a workbook is spun up that inventories all of the formulas and stores them for easy access. That way they could be fired from that point instead of having to inventory them every time you run the app.
I am just searching for a reasonable resolution here. This API is sold as an Enterprise solution. I am trying to write an enterprise application which has demands on it that go beyond what is being offered. I understand you stated you have more important things to work on than making this more efficient but that statement was said before when I had a broad problem I could not prove. I put together the test to show you where the failure is. I was hoping for more of a statement than sorry, you are out of luck because we wrote it the way we did.
Thank you for your honest evaluation of this post