TomThanks for trying to help out.I have attached a screen grab of
my Formula sub-menu that just doesn't have the option you refer
to.I have went through every menu of the options for calc and
found nothing about this!gsOn 08/20/13 10:10, Tom Davies wrote:
Hi :)Err are you using a Mac?If so the menus are very different.It'sLibreOffice
- Preferences - blahinstead ofTools - Options - blahHmmm, on Ubuntu 12.04 with
LO 4.0.2 I only get theTools - Options - LibreOffice Calcoption if i have a
spreadsheet open in LibreOffice.A blank
"new" spreadsheet is fine.Then i have to click the "Detail"
button in the middle section of the "Formula" page to get the
option to tick the "Treat empty string as zero" line.There's
only 2 lines in that pop-up so it's not easy to get it wrong!
;)It seems like a bit of a faff trying to find the place but i'm
not sure if there is anywhere that would be better.I get the
feeling that either they are going to add more options in there
or else that section is going to be merged with something.Change is
likely in future releases but which way is unclear
from the UI right now.Regards fromTom :)
From:Gregory Smith - Oracle Sparc
[email protected]:[email protected]:[email protected]:Tuesday,
20 August 2013, 15:14Subject:Re: [libreoffice-users] Re: treatment of blank
cells
that sounds like it would work, but my options menu
does not have thatsetting!I am using v3.4.5gsOn 08/19/13
15:51, mariosv wrote:Maybe this option can help:Menu/Tools/Options/LibreOffice
calc/Formula/Detailed calculationsettings/Custom/Treat empty
string as zero--View this message in
context:http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070674.htmlSent
from the Users mailing list archive at
Nabble.com.--To unsubscribe e-mail to:
[email protected]?http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting
guidelines + more:http://wiki.documentfoundation.org/NetiquetteList
archive:http://listarchives.libreoffice.org/global/users/All messages sent to
this list will be publicly
archived and cannot be deleted
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
