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 /svl | |
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 'svl')
0 files changed, 0 insertions, 0 deletions