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 360844 - database functions' criteria should allow references
database functions' criteria should allow references
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: Main System
1.10.x
Other All
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2006-10-09 07:20 UTC by A
Modified: 2018-05-22 13:17 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
illustration of the problem (1.83 KB, application/x-gnumeric)
2007-02-09 00:33 UTC, A
Details

Description A 2006-10-09 07:20:33 UTC
criteria for the database functons (dget, dmax dmin etc..) should allow the use of  references to other cells.
Comment 1 A 2006-10-09 09:06:51 UTC
I should say this is for the <. and > conditions. equality uses cell references just fine
Comment 2 Jody Goldberg 2006-10-17 17:55:31 UTC
Please supply a sample worksheet with the desired result.
Comment 3 André Klapper 2006-11-29 15:39:04 UTC
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information Jody asked for.
Thanks!
Comment 4 A 2007-02-09 00:33:27 UTC
Created attachment 82200 [details]
illustration of the problem

Sheet2!A1:A3 should appear identical to Sheet1!A1:A3
Comment 5 A 2013-08-06 04:08:27 UTC
confirmed on gnumeric 1.10.16, Updating Version
Comment 6 Andreas J. Guelzow 2013-08-06 04:26:36 UTC
Note that Gnumeric database functions appear to match the behaviour described in OpenFormula. It would be interesting to now whether Excel permits references in the criteria. (Implementing would potentially cause confusion, on whether '=A5' should match the string A5 or the value of the cell A5.)
Comment 7 A 2013-08-06 04:54:39 UTC
Listing what comes up in excel 2010 in column A of Sheet 2: 

#VALUE!  |||the forumla is "=DGET(Sheet2!A8:A18,1,Sheet2!A6:B7)"
0        |||the forumla is "=DMAX(Sheet2!A8:A18,1,Sheet2!B6:B7)"
0        |||the forumla is "=DMIN(Sheet2!A8:A18,1,Sheet2!A6:A7)"
5
7
1
>A4
1
2
...

so microsoft also do not follow my suggestion to allow references.

This output slightly differs from gnumeric, where #NUM is displayed in cells A2 & A3.
Comment 8 A 2013-08-06 05:00:15 UTC
Incidentally, saving to xlsx causes excel to complain when the file is opened, here is their recovery log, if it might be useful:


<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error077800_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\aerick\Desktop\database_functions xl2007.xlsx'</summary>-<removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/styles.xml part with XML error. (Styles) Load error. Line 26, column 25.</removedPart></removedParts>-<repairedRecords summary="Following is a list of repairs:"><repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet2.xml part</repairedRecord></repairedRecords></recoveryLog>

this is on Gnumeric 1.10.16, which is old, I figure these kind of bugs might be fixed in the newer non-windows versions, so I won't file a new report.

Thanks!
Comment 9 GNOME Infrastructure Team 2018-05-22 13:17:31 UTC
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/64.