Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
95
Trying to load xls
posted

Hi,

   got a problem. I'm loading xls documents with function Workbook.Load(). Then i load simple document it works good, but when i load a document with dropdown, radiobutton objects ... i got an exception. Stack trace:

  System.ArgumentException was unhandled by user code
  Message="Only the DontMoveOrSizeWithCells ShapePositioningMode can be applied to a comment shape.\r\nParameter name: value"
  Source="Infragistics2.Excel.v7.3"
  ParamName="value"
  StackTrace:
       at Infragistics.Excel.WorksheetCellCommentShape.VerifyPositioningMode(ShapePositioningMode value)
       at Infragistics.Excel.WorksheetShape.SetPositioningMode(ShapePositioningMode value, Boolean verifyIsDefined)
       at Infragistics.Excel.Serialization.EscherRecords.ClientAnchor.Load(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.EscherRecordBase.LoadRecord(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.EscherRecordContainerBase.Load(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.ShapeContainer.Load(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.EscherRecordBase.LoadRecord(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.EscherRecordContainerBase.Load(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.GroupContainer.Load(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.EscherRecordBase.LoadRecord(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.EscherRecordContainerBase.Load(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.EscherRecords.EscherRecordBase.LoadRecord(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.BiffRecords.MSODRAWINGRecord.Load(WorkbookSerializationManager manager)
       at Infragistics.Excel.Serialization.WorkbookSerializationManager.LoadCurrentRecord()
       at Infragistics.Excel.Serialization.WorkbookSerializationManager.Load()
       at Infragistics.Excel.Workbook.LoadHelper(Stream stream, String parameterName)
       at Infragistics.Excel.Workbook.Load(String fileName)
       at Testinis.test.MakeXls(Object sender, EventArgs e) in C:\Documents and Settings\mrudys\My Documents\Visual Studio 2005\Projects\Testinis\Testinis\test.aspx.cs:line 44
       at Testinis.test.ButtonClick(Object sender, EventArgs e) in C:\Documents and Settings\mrudys\My Documents\Visual Studio 2005\Projects\Testinis\Testinis\test.aspx.cs:line 68
       at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e)
       at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

In document for all format controls properties i set don't move or size with cells, but i still get an error. May it's impossible to read more complicated document? Maybe somethere are requerements to loading format? 

 

Parents Reply Children
No Data