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
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!
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?
Error occurs when you try to Load a Excel file has a cell that has two format string. Example: Bold Italic
Can you post the file you are trying to load so I can try to reproduce it?
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."}