Hi, I was happy to see that jOpenDocument-1.4rc1 has introduced some set*Formula* methods on MutableCell.
I'm using the following patch on top of jOpenDocument-1.4rc2 to set matrix formulas, too: diff --git a/src/org/jopendocument/dom/spreadsheet/MutableCell.java b/src/org/jopendocument/dom/spreadsheet/MutableCell.java --- a/src/org/jopendocument/dom/spreadsheet/MutableCell.java +++ b/src/org/jopendocument/dom/spreadsheet/MutableCell.java @@ -336,6 +336,16 @@ public class MutableCell<D extends ODDocument> extends Cell<D> { } } + public final void setMatrixFormula(String value) { + setMatrixFormula(1, 1, value); + } + + public final void setMatrixFormula(int nCols, int nRows, String value) { + this.getElement().setAttribute("number-matrix-columns-spanned", String.valueOf(nCols), getTABLE()); + this.getElement().setAttribute("number-matrix-rows-spanned", String.valueOf(nRows), getTABLE()); + setFormula(value); + } + /** * Set the raw value of the formula attribute. * Cheers, Manfred -- --- You received this message because you are subscribed to the Google Groups "jOpenDocument" group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocument+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.