openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
Subject Re: Find errors in cells
Date Mon, 21 Oct 2013 17:12:34 GMT
At 18:34 21/10/2013 +0200, Johnny Rosenberg wrote:
>I am going to write a macro that finds cells with Err:522 in them 
>(in my case they are false errors and the macro is going to fix them 
>for me). Of course I can search the cells one by one, but it's time 
>consuming, so I thought I could use the built in find. When I run 
>find manually however, there doesn't seem to be a way to find which 
>cells have an error.
>
>So, is there a way to find the String value of a cell with the Basic 
>API, and not only values and formulas?

This doesn't answer your question exactly, but a workaround may be to 
insert an extra column - perhaps temporarily - and to use ERRORTYPE() 
to extract the number of any error.  You could use Find & Replace to 
locate that.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message