diff options
| author | Daniel Bankston <daniel.e.bankston@gmail.com> | 2012-07-31 00:26:05 -0500 |
|---|---|---|
| committer | Daniel Bankston <daniel.e.bankston@gmail.com> | 2012-07-31 09:45:27 -0500 |
| commit | cc5b8609490637e3a19761a965af9fdd47310954 (patch) | |
| tree | 0ef60bab0befea49e66497216ec25d43d62e63d6 /sc/source/filter/xml/xmlcelli.hxx | |
| parent | 4f97b3bcad3c2b138ec5d752f28c8032f34150b5 (diff) | |
Import intended blank or error cached formula results instead of 0
There are cases where a formula cell is exported with an office:value of 0 or
no office:value at all, but the formula cell will have a text:p value which
contains the intended formula result. If these cases are not taken into
consideration during import, a 0 will be displayed in the cell
instead of the intended special formula result (blanks or errors).
These cases include when a formula result:
- is blank
- has a constant error value beginning with "#" (such as "#VALUE!" or "#N/A")
- has an "Err:[###]" (where "[###]" is an error number)
Change-Id: I8068cf1c9809c02513662f2b0a6fb16eb44920e0
Diffstat (limited to 'sc/source/filter/xml/xmlcelli.hxx')
| -rw-r--r-- | sc/source/filter/xml/xmlcelli.hxx | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sc/source/filter/xml/xmlcelli.hxx b/sc/source/filter/xml/xmlcelli.hxx index b16eff58a1f3..761045c7c924 100644 --- a/sc/source/filter/xml/xmlcelli.hxx +++ b/sc/source/filter/xml/xmlcelli.hxx @@ -101,6 +101,8 @@ class ScXMLTableRowCellContext : public SvXMLImportContext void PutFormulaCell ( const ScAddress& rScCurrentPos ); void AddFormulaCell ( const ScAddress& rScCellPos ); + bool HasSpecialCaseFormulaText() const; + public: ScXMLTableRowCellContext( ScXMLImport& rImport, sal_uInt16 nPrfx, |