After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 509427 - crash with malformed dsum() argument
crash with malformed dsum() argument
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Normal critical
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-01-14 17:42 UTC by Andreas Hartmann
Modified: 2008-01-16 02:23 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
example spreadsheet (1.83 KB, application/x-gnumeric)
2008-01-14 17:55 UTC, Andreas Hartmann 		  Details
ppp (1.83 KB, patch)
2008-01-14 18:57 UTC, Morten Welinder 		none Details | Review

Description Andreas Hartmann 2008-01-14 17:42:10 UTC 
The following spreadsheet example crashes gnumeric 1.6.3:

X	Y	Z	
7	o	p	
8	e	n	
9	o	n	
	Y	Z	
	o	p	=dsum(A1:C4,"X",B5:B6+C5:C6)

Gnumeric crashes immediately upon hitting ENTER after entering the formula
in cell D6. The crash is apparently caused by the last malformed argument "B5:B6+C5:C6" as the correct formula =dsum(A1:C4,"X",B5:C6) works fine.

Is there a way to pass @criteria directly to the function without passing
a cell range? I want to use dsum() in consecutive cells and therefore do
not have the space to set up a range of criteria cells (in my case two
columns wide because I require two independent criteria)?
Comment 1 Andreas Hartmann 2008-01-14 17:55:17 UTC 
Created attachment 102835 [details]
example spreadsheet

Edit cell D6 and remove the leading "'".
Gnumeric crashes upon pressing ENTER.
Comment 2 Morten Welinder 2008-01-14 18:34:38 UTC 
Still crash in SVN head.

+ Trace 185324

  • #0 sheet_cell_get
    at sheet.c line 1445
  • #1 parse_database_criteria
    at value.c line 1614
  • #2 database_float_range_function
    at functions.c line 177
  • #3 gnumeric_dsum
    at functions.c line 1022 






Comment 3


Morten Welinder





          2008-01-14 18:57:09 UTC
        



Created attachment 102844 [details] [review]
ppp

Proposed patch for 1.8.1 and svn head.






Comment 4


Morten Welinder





          2008-01-16 02:23:11 UTC
        



This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.

This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.