Re: [libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread pete nikolic
On Sun, 21 Jun 2015 20:05:33 +0100 Brian Barker b.m.bar...@btinternet.com wrote: At 19:31 21/06/2015 +0100, Pete Nikolic wrote: I am running Libre office Version 4.3.7.2 on Arch Linux. I have a lot of cells with this or similar in =IF(D10-K100,D10-K10,) the problem is that if either D10 or

Re: [libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread pete nikolic
On Sun, 21 Jun 2015 21:52:53 +0100 Brian Barker b.m.bar...@btinternet.com wrote: At 21:11 21/06/2015 +0100, Pete Nikolic wrote: At 19:31 21/06/2015 +0100, Pete Nikolic wrote: I am running Libre office Version 4.3.7.2 on Arch Linux. I have a lot of cells with this or similar in

Re: [libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread Brian Barker
At 19:31 21/06/2015 +0100, Pete Nikolic wrote: I am running Libre office Version 4.3.7.2 on Arch Linux. I have a lot of cells with this or similar in =IF(D10-K100,D10-K10,) the problem is that if either D10 or K10 is blank the result is displayed as #VALUE! that means several hundred times not

Re: [libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread Brian Barker
At 21:11 21/06/2015 +0100, Pete Nikolic wrote: At 19:31 21/06/2015 +0100, Pete Nikolic wrote: I am running Libre office Version 4.3.7.2 on Arch Linux. I have a lot of cells with this or similar in =IF(D10-K100,D10-K10,) the problem is that if either D10 or K10 is blank the result is displayed

Re: [libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread Regina Henschel
Hi Pete, pete nikolic schrieb: Hi All .. Having a problem here that is becoming a real PITA situation . I am running Libre office Version 4.3.7.2 on Arch Linux I have a lot of cells with this or similar in =IF(D10-K100,D10-K10,) the problem is that if either D10 or K10 is blank the result

[libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

2015-06-21 Thread pete nikolic
Hi All .. Having a problem here that is becoming a real PITA situation . I am running Libre office Version 4.3.7.2 on Arch Linux I have a lot of cells with this or similar in =IF(D10-K100,D10-K10,) the problem is that if either D10 or K10 is blank the result is displayed as #VALUE! that