From 586beca4e429d71acb0745cdec8d4637a7c55b4d Mon Sep 17 00:00:00 2001 From: Muthu Subramanian Date: Wed, 29 Jun 2011 12:59:03 +0530 Subject: 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. --- offapi/com/sun/star/table/XCell.idl | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'offapi') 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. + +

When assigned, the formula cell's result will be set to this + value and will not be calculated - unless a HardRecalc is + executed.

+ */ + void setFormulaResult( [in] double nValue ); + + //------------------------------------------------------------------------- + + /** sets a formula string into the cell. + +

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. +

+ */ + void setFormulaString( [in] string aFormula ); + + //------------------------------------------------------------------------- + /** sets a formula into the cell.

When assigned, the string will be interpreted and a value, text -- cgit