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

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 
 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 
from the Users mailing list archive at
         unsubscribe e-mail to: 
 guidelines + more: 
archive: messages sent to this list will be 
                  archived and cannot be deleted

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.