[Sorry: this may be a duplicate message :-)]
* Terry <[EMAIL PROTECTED]> [031206, 22:41]:
> Richard Detwiler wrote:
> >[EMAIL PROTECTED] wrote:
> >>
> >>Is this still the problem?
> >>
> >>quote:
> >>I want to multiply a row that is sparsely populated with non-zero
> >>numbers only where there are data: when there are no date the cell is
> >>blank. But, when you multiply a blank you get an error message: #value!.
> >>
> >>Can you suppress this error message?
> >>:unquote
> >>
> [cut]
>
> So why is the OP getting an error message?
>
Hi Nino,
I had a similar problem that disappearead when I downloaded 2.0.4 from
OOo.org site (Debian version had 'save file problems'...)
This is my post of the time and the reply:
Ennio-Sr wrote:
> trying to read some .sxc files with OOo_2.0.1 Calc I found they are full
> of _#VALUE_ errors, as a consequence of formulas implying numeric and
> non-numeric cells. AAMOF these formulas work perfectly under old 1.1.4 Calc.
>
> Can any of you confirm this is a _feature_ of the new Calc?
Use the version from the OpenOffice.org website. There was a patch with
such a change (for improved Excel interoperability) that we didn't
integrate, exactly because it breaks old documents. If you use the
version that came with your Linux distribution, it might have that
^^^^^^^^^^^^^^^^^^
change (and other incompatibilities).
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Niklas
--------------
HTH
Regards,
Ennio
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
