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 b
Hi,
you can try query for error cells:
oContainer = oSheet.queryFormulaCells(com.sun.star.sheet.FormulaResult.ERROR)
HTH
Oliver
--
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mai
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.
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 d