Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Andy Burns Newsgroups: uk.comp.os.linux Subject: Re: LibreOffixe Puzzle Date: Wed, 21 May 2025 19:00:01 +0100 Lines: 23 Message-ID: References: <100k5q6$2ob2v$1@dont-email.me> <100kfh9$2qu8q$1@dont-email.me> <100ku9r$2tqrb$2@dont-email.me> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net tLmvE6J6ASPDZ/xSNTm9hwRBguZSngOtcwzLyUKpBd8yo+PqT4 Cancel-Lock: sha1:zKvOa1h0mbdLLoijFYMzro23dy8= sha256:pQrxDxmji95EnzSmu+Q8/K+ZHDM9XQThLYTc+x2z5+Y= User-Agent: Mozilla Thunderbird Content-Language: en-GB In-Reply-To: <100ku9r$2tqrb$2@dont-email.me> Xref: csiph.com uk.comp.os.linux:23627 On 21/05/2025 17:16, Davey wrote: > On Wed, 21 May 2025 16:11:31 +0100 > Andy Burns wrote: > >> On 21/05/2025 13:04, Java Jive wrote: >> >>> I note that the conditionals only test whether either Dnn or Enn >>> has a number, yet the formula applied assumes in all cases that >>> both are numbers. >> >> the formula doesn't check whether the F column from the previous row >> is also number? > > No, but that has never been a problem. This problem that I am now seeing > only occurs when the result should be a number. If the problem isn't currently happening, nobody can give an accurate answer how to fix it, have you got a backup (I think that's the default) of the file from before your most recent edit? Maybe turn on versioning in the file menu, so you can "rewind" to previous versions?