Hi :) Err are you using a Mac? If so the menus are very different. It's
LibreOffice - Preferences - blah instead of Tools - Options - blah Hmmm, on Ubuntu 12.04 with LO 4.0.2 I only get the Tools - Options - LibreOffice Calc option 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 from Tom :) >________________________________ > From: Gregory Smith - Oracle Sparc Verification <[email protected]> >To: mariosv <[email protected]> >Cc: [email protected] >Sent: Tuesday, 20 August 2013, 15:14 >Subject: Re: [libreoffice-users] Re: treatment of blank cells > > >that sounds like it would work, but my options menu does not have that >setting! I am using v3.4.5 > >gs >On 08/19/13 15:51, mariosv wrote: >> Maybe this option can help: >> Menu/Tools/Options/LibreOffice calc/Formula/Detailed calculation >> settings/Custom/Treat empty string as zero >> >> >> >> -- >> View this message in context: >> http://nabble.documentfoundation.org/treatment-of-blank-cells-tp4070670p4070674.html >> Sent from the Users mailing list archive at Nabble.com. >> > > >-- >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 > > > -- 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
