GNOME Bugzilla – Bug 360844
database functions' criteria should allow references
Last modified: 2018-05-22 13:17:31 UTC
criteria for the database functons (dget, dmax dmin etc..) should allow the use of references to other cells.
I should say this is for the <. and > conditions. equality uses cell references just fine
Please supply a sample worksheet with the desired result.
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!
Created attachment 82200 [details] illustration of the problem Sheet2!A1:A3 should appear identical to Sheet1!A1:A3
confirmed on gnumeric 1.10.16, Updating Version
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.)
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.
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!
-- 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.