Hi,
Hi,
Thanks for using Aspose.Cells.
Since you are looking for the value therefore you should change your line to this and it will work fine.
C#
foundCell = fileWorkbook.Worksheets[0].Cells.Find(" - ", foundCell, options);
In the previous versions of Aspose Cells this was working fine. You’re saying that if I have 20 ways of formatting a zero valued cell I should call find 20 times with different input string to accommodate all the possible outcomes of formatting? I’m sorry but that will not do as it breaks a lot of our code base and is now affecting our customers. Is there any Find overload that looks at the actual value instead of the formatted one?
Hi,
Thanks for your posting and using Aspose.Cells.
I have tested this issue with some older versions and they are also not working fine. Could you please let me know the older version which is working fine. I will look into it and log this issue for a fix in our database.
Hi,
It seems i’m not able to update/upload a new zip file. Any idea why?
Hi,
Thanks for your posting and using Aspose.Cells.
I have tested lots of previous versions including 7.1.2.0 as well and your sample project is not working with any of them.
Could you please upload your working sample console application project with old Aspose.Cells dll on some file sharing site like dropbox.com and provide the download link here?
I am able to attach .zip file and did not find any issue. Could you please retry?
Hope this works
http://1drv.ms/23bQzOx
Hi,
Thanks for your useful sample projects and using Aspose.Cells.
We were able to observe this regression and logged it in our database for a fix. We will look into it and resolve this issue. Once the issue is fixed or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSNET-44182 - Cells find with custom formatting works in older version but not in newer version
Hi again,
This is great and much appreciated but what does shortly mean in your system of reference?
Hi,
Thanks for using Aspose.Cells.
Please download and try the latest version:
Aspose.Cells for .NET 8.7.0 your issue should be fixed with it.
The issue you filled is not listed in the release notes. An the issue is not fixed, please use the latest sample I’ve sent you a week ago to test.
Hi,
Thanks for your feedback and using Aspose.Cells.
You are right, I have tested the project with the latest version and found the issue is not fixed in 8.7.0 although the issue status is marked as resolved in database, so you will get the fix in 8.7.0.1 after few days. I have also logged the comment for it in the ticket CELLSNET-44182.
Hi,
Yes, I still have the same issue using the sample I’ve sent you. I find it odd you did not test on the sample I gave you. Can we please escalate this issue? It’s been a while since we filled it in and I can’t say there was any real progress. Facts are simple, this worked on previous versions, it doesn’t work now. Can’t your dev isolate it to a source file and then check what’s changed between these two versions in that source file?
Hi,
I’m afraid you are not using the latest sample code I’ve sent. This is a code snippet from the last sample I’ve sent and there a couple of things different as well as the input file.
Hi,
Hi,
Thanks for using Aspose.Cells.
It seems that MS Excel could not find “0” if it is value of the formula and formatted as “-”.
If you find how to set find options in MS Excel to support your needs, please share us.
And we will add LookInType.OriginalValues to support your needs before that we need to know how to do it in MS Excel.
Hi,