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.

Thu Feb 19, 2015 10:25 am

Hi,

i trying to use replace formula like that:
Code: Select all
        Dim ranges() As CellRange = worksheet1.Range("ad2:ad222").FindAlldouble(999999.0, False)

        For Each range As CellRange In ranges
            range.Text = "TBA"
        Next range

But maybe im doing some errors.
how i can use that?

Thanks in advance

Sintia
 
Posts: 11
Joined: Mon Sep 15, 2014 10:09 am

Fri Feb 20, 2015 1:52 am

Hello,

Thanks for your inquiry. There is no FindAlldouble method, please use the following method.
Code: Select all
FindAllNumber(double,bool);

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Fri Feb 20, 2015 11:38 am

Hi,

i have try using the method u have suggested to me, but in debug mode i have always an error

Code: Select all
        Dim ranges() As CellRange = worksheet1.Range("ad2:ad" & righe).FindAllNumber(999999.0, True)
        For Each range As CellRange In ranges
            range.Text = "TBA"
        Next range


when i come across

Code: Select all
Next range


i get a "null reference exception"

thanks

Sintia
 
Posts: 11
Joined: Mon Sep 15, 2014 10:09 am

Mon Feb 23, 2015 2:22 am

Hello,

Thanks for your response. Sorry for late reply as weekend. Please provide the detailed information for our testing. It would be helpful to reproduce the issue and work out the solution for you ASAP
1.The dll version you used(If you are using the old, please upgrade to the latest and try).
2.The document you tested.
Thanks in advance,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Mon Feb 23, 2015 9:09 am

Hi,

so im using spire.xls dll version: 7.5.20.4040

there is a new version?

thanks

Sintia
 
Posts: 11
Joined: Mon Sep 15, 2014 10:09 am

Tue Feb 24, 2015 6:57 am

Hello Sintia,

The latest version of Spire.XLS is Spire.XLS v7.6.36, please download it and have a try:
http://www.e-iceblue.com/Download/downl ... t-now.html
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Fri Feb 27, 2015 6:49 am

Hello,

Have you tried the latest version of Spire.Xls? Has the issue been resolved?

Thanks,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Mon Mar 02, 2015 8:25 am

Yes thanks i have solved with latest version

Sintia
 
Posts: 11
Joined: Mon Sep 15, 2014 10:09 am

Mon Mar 02, 2015 9:07 am

Hello,

Thanks for your response. Please contact us if you have any questions.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS