I have a problem with spire.xls method "autoFitRows", it throw an exception :
- Code: Select all
System.ArgumentOutOfRangeException
HResult=0x80131502
Message=L'argument spécifié n'était pas dans les limites de la plage des valeurs valides.
Nom du paramètre : iStartPos
Source=Spire.XLS
StackTrace:
at sprⱂ.ᜀ(Int32 A_0, Int32 A_1, Int32 A_2)
at Spire.Xls.Core.Spreadsheet.RichTextString.SetRichTextFont(Int32 iStartPos, Int32 iEndPos, IFont font)
at Spire.Xls.Core.Spreadsheet.RichTextString.SetFont(Int32 startIndex, Int32 endIndex, IFont font)
at Spire.Xls.Core.Spreadsheet.Collections.XlsCellRecordCollection.ᜀ(spr㟾 A_0, Boolean A_1, RichTextString A_2)
at Spire.Xls.Core.Spreadsheet.Collections.XlsCellRecordCollection.FillRTFString(Int64 cellIndex, Boolean bAutofitRows, RichTextString richText)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ᜀ(Int64 A_0, RichTextString A_1, Boolean A_2)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ᜀ(Int32 A_0, Int32 A_1, Int32 A_2, Boolean A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.AutofitRow(Int32 rowIndex, Int32 firstColumn, Int32 lastColumn, Boolean bRaiseEvents)
at Spire.Xls.Core.Spreadsheet.XlsRange.AutoFitRows()
at Lavoix.Dashboard.RechercheConflit.ConflitManagerExcelStyle.AutoFitRows(Worksheet worksheet) in C:\svn\trunk\Lavoix.Dashboard.RechercheConflit\ConflitManager.cs:line 1825
at Lavoix.Dashboard.RechercheConflit.ConflitManager.GetBrevetList(String tiersNomAbr, List`1 tiersTypeOppose, Boolean contains) in C:\svn\trunk\Lavoix.Dashboard.RechercheConflit\ConflitManager.cs:line 1534
at Lavoix.Dashboard.RechercheConflit.ConflitManager.CreateEmailAttachments() in C:\svn\trunk\Lavoix.Dashboard.RechercheConflit\ConflitManager.cs:line 1252
at Lavoix.Dashboard.RechercheConflit.ConflitManager.SendEmailConflit() in C:\svn\trunk\Lavoix.Dashboard.RechercheConflit\ConflitManager.cs:line 1204
at Lavoix.Dashboard.RechercheConflit.Controllers.ConflitControllers.SendMail(Guid idSession, DateTime dateRecherche) in C:\svn\trunk\Lavoix.Dashboard.RechercheConflit\Controllers\ConflitControllers.cs:line 115
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
Could you explain why it do this plz ?
And no i can't send my excel it's confidential.
Sincerely,
Omar