Hello
I have an Excel file which I load into an Infragistics.Excel.Workbook object. In this Excel file, I have a cell where I put a value, and another one which calculates something from the first one. In my code, I want to retrieve the resulting value from this second cell, but all I can get is the formula itself.How do I tell the Infragistics.Excel engine to give me the value, not the formula?ThanksGuy
The ability to solve formulas is not currently supported in the Excel assembly. I would recommend submitting a feature request for this to the support group: http://devcenter.infragistics.com/Protected/RequestFeature.aspx. I have seen other people request this and the number of requests for a certain feature does play a part in what gets implemented in future releases.
Wow... I don't see how the Infragistics.Excel engine can be useful without the ability to get calculated values out of the worksheet!!!!
What do you use it for?!?
Isn't there a way I could do it? I find this hard to believe...
Hi Guys,
I just confirmed that we will support this feature in the next release (2008.3).
Either reply to this post or send me an email if you have any more questions around this or feature needs on Excel.
Thanks
Jason
Hi,
I just checked that 2008.3 release doesnt not have this feature.
I have some named refernces and formulas in cells that need to be calculated based on values in other cells.
Regards,
Yamini
Hi Yamini,
I'm not sure what you checked, exactly, but this feature was added in the 2008.3 release of NetAdvantage.
Hi Mike,
We are using the Net Advantage V10.2 version and need this feature too. It does not seem to have this feature included in this version. Do you know of any hot fix that can be installed on V10.2 to get this working?
Thanks,
_____Danny
Formula solving has been implemented since the 8.3 version. All you need to do is ask the cell for its Value property and if the cell has a formula applied, it will be solved. Is this not working for you? If not, what formula is applied to the cell?
Currently, there is no way to directly get the cached calculated value. Can you post the file with the problem and let me know which cell you are trying to access? I will see if there is a way to get the value.
Excel file i am working has linkage broken but excel still displays value. Is they any way can i retrieve display value of the cell rather than formula? BTW, i am using v10.1 dll's. Any help is greatly appreciated. I am validating an existing process so fixing formula is not an option.
In that case, I think I will need to see the source code related to populating the worksheet to be of any help. It is something you can post on this thread? If not, I will have a Developer Support engineer contact you to create a private case.
It shouldn't be my case, beacuse if it was, it would be irrelevant to put Recalculate() or not before looping my cell values. In my case, instead, if I execute Recalculate(), all formulas are calculated just once and all is running well, if I comment Recalculate(), it seems to calculate all formulas every time I ask for a cell value.
When you add in new formulas in your sample, are many of the other existing formulas dependant on that new formula (directly or indirectly). In other words, would the added formula require all other formulas to be recalculated?