summaryrefslogtreecommitdiff
path: root/offapi
diff options
context:
space:
mode:
authorMuthu Subramanian <sumuthu@novell.com>2011-06-29 12:59:03 +0530
committerMuthu Subramanian <sumuthu@novell.com>2011-06-29 12:59:03 +0530
commit586beca4e429d71acb0745cdec8d4637a7c55b4d (patch)
tree500bbb5f38ddca7f15d59d43a6d1ac4af942cb2c /offapi
parent5ceb3e8335e4f631bbebe69d7acf33f3295bfe54 (diff)
Improved xlsx formula import.
Now uses the values present in the import document rather than calculating the formula. This speeds up document loading. TODO: Extend this to string results as well.
Diffstat (limited to 'offapi')
-rw-r--r--offapi/com/sun/star/table/XCell.idl22
1 files changed, 22 insertions, 0 deletions
diff --git a/offapi/com/sun/star/table/XCell.idl b/offapi/com/sun/star/table/XCell.idl
index 90145c54b3c1..7d7b5be70eee 100644
--- a/offapi/com/sun/star/table/XCell.idl
+++ b/offapi/com/sun/star/table/XCell.idl
@@ -59,6 +59,28 @@ published interface XCell: com::sun::star::uno::XInterface
//-------------------------------------------------------------------------
+ /** sets a formula result into the cell.
+
+ <p>When assigned, the formula cell's result will be set to this
+ value and will not be calculated - unless a HardRecalc is
+ executed.</p>
+ */
+ void setFormulaResult( [in] double nValue );
+
+ //-------------------------------------------------------------------------
+
+ /** sets a formula string into the cell.
+
+ <p>When assigned, the formula is set into the string. But is not
+ compiled, tokenized or calculated. Its useful when loading a
+ document and setFormulaResult() is used. Otherwise it is compiled
+ on trying to fetch a result value.
+ </p>
+ */
+ void setFormulaString( [in] string aFormula );
+
+ //-------------------------------------------------------------------------
+
/** sets a formula into the cell.
<p>When assigned, the string will be interpreted and a value, text