summaryrefslogtreecommitdiff
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
commit6f04c9e9b72dacfda889cfe9184f2b3d37ca2902 (patch)
tree3faaf96cdfd3637b216f4e39af732171a5e9b41f
parenta8f66136310e9a93bb3da308be7b207f4e6b861c (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.
-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 39dc89206..ee6665cfb 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