Re: [libreoffice-users] Re: treatment of blank cells

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 
Verificationgreg.a.smith@oracle.comTo:mariosvmariosv@miguelangel.mobiCc:users@global.libreoffice.orgSent: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: 
users+unsubscribe@global.libreoffice.orgProblems?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: users+unsubscribe@global.libreoffice.org
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