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 74241 - Failure to import Applixware sheet: "Invalid format"
Failure to import Applixware sheet: "Invalid format"
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export Applix
git master
Other other
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2002-03-11 14:16 UTC by Greg Ward
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Applix spreadsheet that Gnumeric fails to import (5.44 KB, application/applixware)
2002-03-11 14:17 UTC, Greg Ward 		Details
Modified version of test1.as that Gnumeric can import (5.40 KB, application/applixware)
2002-03-11 14:17 UTC, Greg Ward 		Details

Description Greg Ward 2002-03-11 14:16:26 UTC 
Gnumeric is unable to import the attached test1.as.  The error message is:

  Invalid format, missing '('
  Invalid expression

test2.as is test1.as with the two data rows removed, leaving only the 
header rows.  Gnumeric can import test2.as just fine.

Both were created with Applixware 4.42, and yes Applixware can handle 
them just fine.  ;-)
Comment 1 Greg Ward 2002-03-11 14:17:11 UTC 
Created attachment 7101 [details]
Applix spreadsheet that Gnumeric fails to import
Comment 2 Greg Ward 2002-03-11 14:17:37 UTC 
Created attachment 7102 [details]
Modified version of test1.as that Gnumeric can import
Comment 3 Jody Goldberg 2002-03-13 06:53:08 UTC 
Ahh I see the problem.

#AND#
#OR#
#NOT#

We mostly reuse the expression parser from gnumeric for applix.  The only
difference currently is to support applix's a1..c3 format.  I can add support
for parsing these operators, but we also do not support them directly.
I'll think about how to handle this.
Comment 4 Jody Goldberg 2002-03-14 03:19:33 UTC 
Fixed in CVS.  The patch will _not_ be back ported to 1.0.6.  If it works out
smoothly in 1.1 I'll consider putting it in 1.0.7.  However, it is a rather
central change to consider putting into the stable branch.