Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

On Sun, 21 Jun 2015 21:52:53 +0100
Brian Barker <> wrote:

At 21:11 21/06/2015 +0100, Pete Nikolic wrote:
At 19:31 21/06/2015 +0100, Pete Nikolic wrote:
I am running Libre office Version on Arch Linux. I have a 
lot of cells with this or similar in
the problem is that if either D10 or K10 is blank the result is 
displayed as #VALUE! that means several hundred times not only is 
it a pain but it mucks the printing up as well the results do not 
look good covered in #VALUE! . What is the trick to preventing the 
display of aforementioned string.

I have managed to get round it right now  using
That seems to do the job ...

I fancy you mean
- with a comma, not a minus sign.

Brian Barker 

Yep you got it   typo on my part ...

Pete .

Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere. 

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.