diff options
| author | Kohei Yoshida <kohei.yoshida@gmail.com> | 2012-04-10 15:01:19 -0400 |
|---|---|---|
| committer | Kohei Yoshida <kohei.yoshida@gmail.com> | 2012-04-10 15:09:58 -0400 |
| commit | a7f07eab97d9f52431329cb96bc1bf5ebd7da13d (patch) | |
| tree | 9aa018dd8a504d93d6939ec7cbffab8ec153ba99 /sc | |
| parent | ff0314bf92cd300ddedad566ab0303ddf5e95c17 (diff) | |
bnc#755775: Set numeric formula results when importing xls document.
Without this, calculation upon import may incorrectly show #VALUE!
in some cells when the iterative calculation option is turned on.
This is on par with what we do during the ods document import.
Diffstat (limited to 'sc')
| -rw-r--r-- | sc/source/filter/excel/excform.cxx | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sc/source/filter/excel/excform.cxx b/sc/source/filter/excel/excform.cxx index 02ba65f8f096..4fcf97665b83 100644 --- a/sc/source/filter/excel/excform.cxx +++ b/sc/source/filter/excel/excform.cxx @@ -158,7 +158,9 @@ void ImportExcel::Formula( { if( eErr != ConvOK ) ExcelToSc::SetError( *pCell, eErr ); - (void)fCurVal; + + if (!rtl::math::isNan(fCurVal)) + pCell->SetHybridDouble(fCurVal); } GetXFRangeBuffer().SetXF( aScPos, nXF ); |