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 661800 - database criteria Excel incompatibility
database criteria Excel incompatibility
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
1.10.x
Other Linux
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-10-14 19:11 UTC by Andreas J. Guelzow
Modified: 2013-04-16 18:16 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Sample file (2.11 KB, application/x-gnumeric)
2013-04-16 17:45 UTC, Morten Welinder 		Details

Description Andreas J. Guelzow 2011-10-14 19:11:48 UTC 
This is 
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=645218

When usign databse functions, if I want one of the criteria to match for
a string, I can put either of these values in the criteria cell:

mystr
="=mystr"

The latter is the only one accepted by Excel.  The former is equivalent
in Gnumeric, but in Excel it means to match a string beginning with
"mystr".  This not only creates an incompatibility with .xls files
created with Excel, but moreover deprives Gnumeric of the very
interesting ability to match an initial substring as a criterion.


observed in 1.10.17
Comment 1 Morten Welinder 2013-04-16 17:45:51 UTC 
Created attachment 241670 [details]
Sample file

Excel behaviour confirmed.  Here's a sample file.
Comment 2 Morten Welinder 2013-04-16 18:16:05 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.