Re: Gnumeric 1.4.3 problems.

From: Jody Goldberg <jody gnome org>
To: arief# <arief_m_utama telkomsel co id>
Cc: gnumeric-list gnome org
Subject: Re: Gnumeric 1.4.3 problems.
Date: Mon, 28 Mar 2005 09:51:25 -0500

On Mon, Mar 28, 2005 at 10:30:59AM +0700, arief# wrote:


Dear all.


What happened in Gnumeric 1.4.3, why does my formulas suddenly gone mad?


This formula was okay before I upgrade,
=if(sumif('Traffic Prediction'!$B$3:$B$739,$A25&B$4,'Traffic
Prediction'!$D$3:$D$739)+sumif('Traffic Prediction'!$B$3:$B$739,B$4&
$A25,'Traffic Prediction'!$D$3:$D$739)<=0,"",sumif('Traffic Prediction'!
$B$3:$B$739,$A25&B$4,'Traffic Prediction'!$D$3:$D$739)+sumif('Traffic
Prediction'!$B$3:$B$739,B$4&$A25,'Traffic Prediction'!$D$3:$D$739))

after upgrade it is now generate #VALUE! errors.


known problem.  Some fixes in SUMIF and COUNTIF made the test for 3d
references somewhat overzealous.  I'll make up a patch tonight.

References:
- Gnumeric 1.4.3 problems.
  - From: arief#

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]