openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexandro Colorado <...@oooes.org>
Subject Re: Find errors in cells
Date Mon, 21 Oct 2013 16:41:22 GMT
I think you should look on the formula objects, and see if there is a error
attribute you can fetch.
http://www.openoffice.org/api/docs/common/ref/com/sun/star/formula/FormulaProperties.html
another could be the getError() not sure if it's a formula value error or a
different kind of error thought.
http://www.openoffice.org/api/docs/common/ref/com/sun/star/table/XCell.html#getError



On Mon, Oct 21, 2013 at 11:34 AM, Johnny Rosenberg
<gurus.knugum@gmail.com>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.
>
> In the find dialogue, I can search in formulas or values. Neither of them
> finds an error.
>
> From a macro, I can get values, formulas and strings. I experimented a bit
> and found that if a cell has an Err:522, then Cell.getString() returns
> ”Err:522”, which is useful in this case.
>
> So, is there a way to find the String value of a cell with the Basic API,
> and not only values and formulas?
>
>
>
> Johnny Rosenberg
>



-- 
Alexandro Colorado
Apache OpenOffice Contributor
http://www.openoffice.org
882C 4389 3C27 E8DF 41B9  5C4C 1DB7 9D1C 7F4C 2614

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message