Andreas Schneider wrote: > That way I could just > check if the cell is somehow connected to a volatileresult delivered by > my addin
1. objCell.getType() returns a c.s.s.sheet.CellContentType.EMPTY|VALUE|TEXT|FORMULA 2. objCell.getFormula() returns the formula string (not nesessarily a formula. It's the "stored english cell-content" like "=SUM(A1:B5)", "0.5" or "abcd"). 3. objCell.getError() = 0 if the formula result is not an error. 4. objCell.queryFormulaCells(c.s.s.sheet.FormulaResult.STRING|VALUE) returns a collection of one or zero single range when called from a single cell. c.s.s.sheet.FormulaResult.ERROR fails due to a known issue 58749, but we can use method 3. So you can test if the cell has any formula [1], if the formula includes something like com.sun.star.calc.your_Addin.getSomething(*) [2]. If it has no error[3], but includes an element of text or numeric formula result[4], then you can get the "real value" by objCell.getString() or objCell.getValue() respectively. Finally you can search for sub-string com.sun.star.calc.your_Addin.getSomething(*) and call your add-in function after evaluating the arguments. You need a parser which is able to resolve string-references: - SheetX.A1:B5 with all possible "$" included (OK, no big deal) - 'Sheet X'.A1:B5 (still no big deal if you know that the apostrophes are not part of the sheet name) - 'file:///path/doc/foo.xls'#SheetX.A1:B5 where 'file:///path/doc/foo.xls'#SheetX (including the apostrophes!) is the name of a hidden import sheet. - NamedRange objNamed.getReferredCells() returns Null if the range is relative by any means. Only a full absolutized [$SheetX].$A$1:$B$5 returns any range. If the sheet name is missing completely, the name refers to a range on this sheet. Unfortunatly, objNamed.getReferredCells() always returns a range from sheet(0) in this particular case (yes, I agree. This API is close to unusable). - NamedDatabaseRange objNamed.getReferredCells() always returns a range since database ranges are specified by an absolute range address. Have a look at this: http://www.oooforum.org/forum/viewtopic.phtml?t=61265 Different problem, but similar issues. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
