Hi there!
We are using WinForms 12.1 and are having problems with retrieving the correct value for certain cells with formulas.
For example the formula TEXT(B2;"tt.MM.jjjj") with ("01.04.2013") displayed in cell B2, will return "tt.04.jjj" as calculated value using WorksheetCell.Value, whereas in Excel this value will resolve correctly to "01.04.2013".
Is it not possible to resolve text formatting formulas with the infragistics Excel engine?
Thanks for your help!
Janina
Hello Janina,
As our documentation states:
"If a forumula has been applied to a cell or a dta table is associated with the cell, getting the Value will return the calculated value of the cell."
If you wish to retrieve the cell text you can try using the GetText Method.
Let me know if you have any questions regarding this matter.
Hello Michael!Thanks for your quick reply. Unfortunately neither the 'Value' nor the 'GetText()' method returns the correct value.
Please find attached a small example. The output on my system:
A2 should be '01.04.2013'Value: tt.04.jjjjGetText(): tt.04.jjjjA2 should be '30.09.2013'Value: tt.09.jjjjGetText(): tt.09.jjjj
Hello J Jager,
Only the latest service release for 2012 Volume 1 CLR 4 works with your sample. It is (12.1.20121.2135). You can try to see if works in CLR 2.0, but I am having issues loading the workbook.
You can check the exact version of NetAdvantage by selecting the assemblies in Solution Explorer and performing a right-click > properties window > version field
For information on how to get the latest service release, see "How to get the latest service release" http://es.infragistics.com/community/forums/t/29398.aspx
For general information about service packs, see our Service Release Schedule http://es.infragistics.com/support/service-releases
Hello Michael!
Thanks again for your reply. I can confirm, that the error does not occur in the latest version. Unfortunately we cannot update to the latest version because we cannot change our application to .NET 4.0. Do you know if this problem has been fixed in any service release for version 2012?
Thank you again!
Thank you for providing more information and a sample test. The behavior works as expected with our latest version. With a console app, I am outputting exactly the same text with both properties when using Infragistics 2014 Volume 1 & 2:
A2 should be '01.04.2013'Value: 01.04.2013GetText(): 01.04.2013
A2 should be '30.09.2013'Value: 30.09.2013GetText(): 30.09.2013
Please note that version 2012 Volume 1 is no longer maintained. Let me know if you have any questions regarding upgrading to our latest controls. You can trial version 14.2 by downloading the package on our website.