Announcement

**Ray** · Oct-18-2007, 08:05 AM

Hi Doug,

This has been previously discussed so you might want to refer to the older threads first for some information to save us repeating ourselves:
http://www.wrensoft.com/forum/showthread.php?t=715

Basically, the context description feature of Zoom is not designed to return data specifically restricted to a row in Excel. It is only supposed to provide a preview of the surrounding text data from where the word was found in the document indexed (in this case, an Excel spreadsheet). So this isn't something that can be prevented, as it is part of the design functionality.

For your use, I would recommend turning off context description all together, so that users are not misled into looking at the wrong phone number, and letting them click on the page, and doing a "Find" within that page themselves (or use our "jump to highlighting" script)

**jclguru** · Oct-23-2007, 08:12 AM

Thanks Ray.

I'm trying the jump to highlighting script now. Of course, I can't
get it to work.

Here's what I'm doing...

1. Convert my Excel spread sheet to a single web page.
2. In the first page that loads I put:

<script type="text/javascript"
src="file://W:/test/highlight.js"></script>

in between the <head> tags (the W is the shared drive where the script
exists).

In the body tag I put: <body onload="highlight()">

3. Highlighting option has the 'jump to...' checked.

4. Start indexing.

The search still works, but no highlight/jump.

I know the help says this doesn't work with xls, but I assume since I
converted it to a web page, this highlight/jump would still work?

Thanks
Doug

**Ray** · Oct-23-2007, 11:28 AM

You're right of course... the "jump to highlighting" script will not work with XLS files, I'm not quite sure what I was thinking when I made that comment (I think I was looking at your example in the original post and seeing it as a link to a .htm file and had temporarily forgotten we were talking about Excel files).

But yes, if you had converted your XLS file to a HTML web page, then it should by all means, work. The absolute file path link to the script would be my first cause of concern. It may be that if the file is opened across a different security zone in Internet Explorer, the script may be blocked (eg. if your page is considered an Internet zone, and the link goes to an Intranet zone). It may be better to link to the file relatively (eg. "../highlight.js" or "/highlight.js", etc.)

May also help to enable Javascript error messages in IE to see what's really going on. It may point out any typos, or mistakes. Firefox's console message window also helps.

Announcement

Excel Searching and Results

Excel Searching and Results

Comment

Comment

Comment