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.knu...@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