Hello,I'm getting the following error while doing a Workbook.Load(Filename) on what I think is an excel 2003 file.
System.InvalidOperationException: The formatted string is already the value of another cell. Clone it first and apply the clone to the new cell.
I'm not sure what this error means. Possibly there is a cell in my workbook that takes its value from another cell.. and IGExcel doesn't like it?
I know this error only happens for specific sheets in my workbook. Is there a way to pick which sheets you want to load?
Thanks!-Robin
This is a bug that has already been reported and fixed in version 7.3 and later. However, the hotfix containing the fix has not been released yet. I would recommend submitting the issue to the support group and referencing issue BR30961: http://ko.infragistics.com/gethelp. If you are using 7.3 or later, you will be notified when the hotfix is released. If you are using an earlier version that is still supported, the fix will be moved back to the version you are using.
I think this issue is still not fixed.
I have downloaded NetAdvantage for Windows Forms 2011 Vol. 1 Complete Bundle but still i am getting the erro message with using Infragistics3.Documents.Excel.v11.1.dll
Error Messgae:- {"The formatted string is already the value of another cell or shape. Clone it first and apply the clone to the new cell or shape."}
Can you post the file you are trying to load so I can try to reproduce it?
Error occurs when you try to Load a Excel file has a cell that has two format string. Example: Bold Italic
I am not able to reproduce this issue. You can post a sample which reproduces it? If not, can you tell me what version you are using?
I have the same problem with the version Infragistics35.WebUI.Documents.Excel.v11.1.
when I use the load(string path) method ,it throws the exception :
The formatted string is already the value of another cell. Clone it first and apply the clone to the new cell
Can you tell me your email ,and then send the excel template to you.
Best Wishes!
it's OK now!
Thank you.
Hello All,
I was able to reproduce this issue with the initial build of NetAdvantage 2011 Volume 1. After updating NetAdvantage to the latest service release (Build: 11.1.20111.2178), this exception didn't occur. Please follow the instruction found here to download and install the latest service release for your version of NetAdvantage.
Please let me know if you have any questions regarding this matter.
This is my test excel Template
Hello,
I will be happy to help you out with this issue.
I have created case # CAS-90016-GKSNNC for you to better assist you with this issue going forward. To access the case, simply log into your IG account and click on My Support Activity. Please compress the mentioned file as a Zip file before attaching.
Please let me know if you have further questions in this matter utilizing the case created.
If you cannot post the file on the forum, it is probably best for you to send this to one of our Developer Support Engineers. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.