Find Button for spreadsheet component

[Alex Shirley]

Hi

I have an OWC Excel spreadsheet on a web page.
On that web page I want to have a button which when clicked will find
the next cell that has an interior.color of red.

Is this possible? Any pointers?

Many Thanks

Alex

 

[Alvin Bruney [MVP]]

I don't think this is possible. the range find method finds the contents of
a cell based on the data contained in the cell. Color forms part of the cell
attributes and not the data. I don't have a workaround for you at present.
what are you trying to do?

 

[Alex Shirley]

Hi Alvin.

I have a OWC spreadsheet and a script that automatically highlights
cells in red if they require user attention (the spreadsheet will
eventually be imported into database, the script just facilitates the
user and makes sure that everything cell is in the right format and
place before the import happens).

As the user might encounter a lot of red cells, and the spreadsheet
can be quite large it makes sense they should be able to navigate from
red cell to red cell in a controlled manner, rather than just browsing
it in a hit and miss fashion.

Many thanks

Alex

I don't think this is possible. the range find method finds the contents of
a cell based on the data contained in the cell. Color forms part of the cell
attributes and not the data. I don't have a workaround for you at present.
what are you trying to do?

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi

I have an OWC Excel spreadsheet on a web page.
On that web page I want to have a button which when clicked will find
the next cell that has an interior.color of red.

Is this possible? Any pointers?

Many Thanks

Alex

 

[Alex Shirley]

Any ideas at all?
Cheers

Alex