Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon Nov 12, 2018 1:14 pm

Hi,

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

Tulak
 
Posts: 3
Joined: Mon Nov 12, 2018 9:44 am

Tue Nov 13, 2018 6:18 am

Hi,

Thanks for your inquiry.
I'm sorry that we can't investigate this issue without the sample file. To help us reproduce the issue, could you please send the sample file and code? You can replace the confidential information or send us a dummy file as long as we can reproduce the issue.
Sincerely,
Mike
E-iceblue support team
User avatar

Mike.Zhang
 
Posts: 93
Joined: Thu Sep 27, 2018 7:11 am

Tue Nov 13, 2018 7:52 am

Hi,

this is the code :
Code: Select all
class Program
    {
        public static void AutoFitRows(Spire.Xls.Worksheet worksheet)
        {
            if (worksheet.AllocatedRange.CellsCount > 0)
            {
                foreach (var row in worksheet.Rows)
                {
                    row.AutoFitRows();
                    double newHeight = row.RowHeight + 15 <= 409.5 ? row.RowHeight + 15 : 409.5;
                    row.SetRowHeight(newHeight, false);
                }
            }
        }

        static void Main(string[] args)
        {
            var wb = new Spire.Xls.Workbook();
            wb.LoadFromFile("C:\\Users\\bahjaoui\\Documents\\OXFORD AUTOMOTIVE Dossiers BR_12112018.xlsx");
            AutoFitRows(wb.Worksheets[0]);
        }
    }


The sample :
OXFORD AUTOMOTIVE Dossiers BR_12112018.zip
check the line 128
(7.1 KiB) Downloaded 204 times


And the version of spire.xls : 8.9
Sincerely,

Omar

Tulak
 
Posts: 3
Joined: Mon Nov 12, 2018 9:44 am

Tue Nov 13, 2018 9:48 am

Hi Omar,

I have reproduced the issue and logged it in our bug tracking system. Once there is any update, we will let you know. Sorry for the inconvenience caused.
Sincerely,
Mike
E-iceblue support team
User avatar

Mike.Zhang
 
Posts: 93
Joined: Thu Sep 27, 2018 7:11 am

Tue Feb 12, 2019 8:57 am

Hi mike,

sorry for the late but thanks, it's working.

Sincerely,

Omar

Tulak
 
Posts: 3
Joined: Mon Nov 12, 2018 9:44 am

Tue Feb 12, 2019 9:02 am

Hi Omar,

Thanks for your inquiry.
If there is any question, please feel free to contact us.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS