Excel numbers not found

WARNING: You currently have Javascript disabled!
This website will not function correctly without Javascript enabled.

danock

11 discussion posts

I cannot find the number 222764 in Excel 2003 files. I can find the number when it's part of a text string (like a222764), or when it's a literal text string ('222764), but not when it's just a number.

Please help--FileSeek is a great tool.

Thanks,

--Dan

Jun 21, 2011 • #1

I just did a quick test and was able to find 222764 when formatted as a number in Excel 2003 files. Could you send me a test file that doesn't work for you so I can see if I can duplicate it here?

You can attach it here, or email it to me at support@binaryfortress.com

Thanks!

Jun 24, 2011 • #2

danock

11 discussion posts

Here is the test document. Fileseek 2.1.2.

Thanks for your help.

• Attachment: fileseek test.xls [13,824 bytes]

Jul 1, 2011 • #3

Your test file seems to work ok for me... can you try FileSeek 2.1.3?

It can be downloaded here: http://www.fileseek.ca/Download/

Thanks!

Jul 4, 2011 (modified Jul 10, 2011) • #4

danock

11 discussion posts

Still no luck. See attached screenshot.

• Attachment: fileseek screenshot.doc [108,544 bytes]

Jul 5, 2011 • #5

Interesting! Is it Excel 2003 that you have installed on your system? Or do you have another version of Excel and you're just using the older file format?

Jul 5, 2011 • #6

danock

11 discussion posts

Excel 2003. I tried two more things. 1--copied the cells from fileseek test.xls and pasted them into a new spreadsheet. 2--I opened a new spreadsheet (fileseek test 3.xls, attached) and typed 222764 into cell A1. In both cases, fileseek did not find 222764.

I have offfilt.dll version 2006.0.5730.0. I tried disabling the file handler--still no good.

• Attachment: fileseek screenshot 2.doc [170,496 bytes]

• Attachment: fileseek test 3.xls [13,824 bytes]

Jul 6, 2011 • #7

Ok good to know, I was testing with Excel 2003 files but using a system that has Excel 2010 installed. I will test in a system with Excel 2003 and keep you posted.

Thanks!

Jul 7, 2011 • #8

One more quick question, which version of Windows are you running?

Jul 8, 2011 • #9

danock

11 discussion posts

XP SP3

Jul 8, 2011 • #10

Finally had a chance to test this out in XP SP3 with Office 2003, but I can still find the number ok in the test files. The only difference I found was that my OffFilt.dll was a higher version than yours: 2006.0.5732.0

Could you send me a copy of your OffFilt.dll so I can test it out?

Also, is it only that number specifically? Or does it not find any values in number formatted cells?

Thanks!

Jul 13, 2011 • #11

danock

11 discussion posts

It does not matter what the number is.

DLL attached. Thanks.

• Attachment: offfilt.dll [192,000 bytes]

Jul 14, 2011 (modified Jul 14, 2011) • #12

danock

11 discussion posts

This post seems to relate to the same problem with a different search product:

http://forums.x1.com/viewtopic.php?f=41&t=4222

--Dan

Jul 14, 2011 (modified Jul 17, 2011) • #13

Yep, that's definitely the problem! After replacing my offfilt.dll with yours, it broke.

The version I have came in this hotfix: http://support.microsoft.com/kb/915800

Let me know how it works out once you've installed the hotfix.

Thanks!

Jul 14, 2011 • #14

danock

11 discussion posts

That did the trick! You may want to update your program to read the .dll version number and urge the user to apply the hotfix. I'm surprised this hotfix is not in SP3.

Thanks for helping me with this.

Jul 21, 2011 • #15

Good call, in the meantime, I've added it to the FileSeek FAQ.

Thanks for following up!

Aug 2, 2011 • #16