>> "Brian" == Brian Barker writes:
> At 21:54 20/10/2013 +0200, Uwe Brauer wrote:
> Do you mean a table in a text (Writer) document?
Yes!
> o Copy the table.
> o Paste into a spreadsheet (Calc) document, but using Paste
> Special... | Formatted text [RTF].
> o Copy the table in
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
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.
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
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