[libreoffice-users] Zeros when linking cells between sheets
I have a spreadsheet with 3 sheets. I want sheets 1 (Phone) and 2 (Network), when edited, to update sheet 3 (All) which is the master view. I have linked each of the needed cells (e.g. cell a3 on the All reads =Phone.a3). If Phone.a3 is empty then All.a3 has a 0 (zero). I would prefer, for readability, for the cell to be blank like the referenced cell. Is there a way to do this? Thanks, John -- John Kennedy -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Zeros when linking cells between sheets
Hi John, Am 21.03.2011 12:07, schrieb John Kennedy: If Phone.a3 is empty then All.a3 has a 0 (zero). I would prefer, for readability, for the cell to be blank like the referenced cell. Is there a way to do this? Tools | Options... | LibreOffice Calc | View | Zero values Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Zeros when linking cells between sheets
On Mon, Mar 21, 2011 at 13:32, Stefan Weigel stefan.wei...@bildungskreis.org wrote: Hi John, Am 21.03.2011 12:07, schrieb John Kennedy: If Phone.a3 is empty then All.a3 has a 0 (zero). I would prefer, for readability, for the cell to be blank like the referenced cell. Is there a way to do this? Tools | Options... | LibreOffice Calc | View | Zero values Stefan Stefan, Just what I needed. Thanks, John -- John Kennedy -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***