[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

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 --

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