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 [email protected].
For more options, visit https://groups.google.com/d/optout.
