On 21/06/2015 02:31 PM, pete nikolic wrote:
I too am running 184.108.40.206, but on what is known as Curtains, though you
may still think of windows.
I am running Libre office Version 220.127.116.11 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
In my instance, blanks are interpreted as zeros, so your problem doesn't
However, a long-term annoyance to me is LO interpreting alpha chars as
illicit in some formulae.
That was done in apparent slavish adherence to micro$$ bad practice;
good old 123, and Mosaic Twin, took such chars to be zero.
Using your example on my system, if D10 = something possibly useful,
such as "insert revenue here", the dreaded #VALUE! will appear.
You could try, z.b.,
For no apparent reason, that works to interpret alphas as zero, and so might work for you.
This example is unnecessarily verbose, just to illustrate the idea.
Other such redundant function employments have worked in other places, so you could tinker with the
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: 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