Spire.xls

[Sintia]

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

[Gary.zhang]

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

[Sintia]

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

[Gary.zhang]

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

[Sintia]

Hi,

so im using spire.xls dll version: 7.5.20.4040

there is a new version?

thanks

[burning.liu]

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

[Gary.zhang]

Hello,

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

Thanks,
Gary
E-iceblue support team

[Sintia]

Yes thanks i have solved with latest version

[Gary.zhang]

Hello,

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

Sincerely,
Gary
E-iceblue support team