Cells find with custom formatting

Aspose.Cells Product Family
21

Hi,

Thanks for your point and using Aspose.Cells.

I have logged your comment in our database for product team evaluation and a fix. Once there is some news for you, we will share it with you asap.

22

Hi,

Thanks for using Aspose.Cells.

Please check the source excel file attached with this post. The cell J2 has a formula =Sum(A1:A2) and its value is 0. And we are unable to find this 0 even if the lookin type is formula or value.

I have attached the screenshot for your reference. It means, this feature is not supported by Microsoft Excel, so we will introduce LookInType.OriginalValues to support your needs as we mentioned previously.

23

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.7.0.2 and let us know your feedback.

Please try the fix using the following code.

options.LookInType = LookInType.OriginalValues;

24

Thanks,


It seems to be working as expected now. We will continue to test and will let you know the outcome.


25

Hi,


Good to know that your issue is sorted out by the new fix. Feel free to contact us any time if you need further help or have any issue or queries, we will be happy to assist you soon.

Thank you.
26

The issues you have found earlier (filed as CELLSNET-44182) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.