GNU bug report logs - #26169
25.1; ses.el string cell recalculate message

Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.
Package: emacs; Severity: minor; Reported by: Kevin Ryde <user42_kevin@HIDDEN>; dated Sun, 19 Mar 2017 05:03:01 UTC; Maintainer for emacs is bug-gnu-emacs@HIDDEN.

Message received at 26169 <at> debbugs.gnu.org:


Received: (at 26169) by debbugs.gnu.org; 24 Aug 2020 14:50:38 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Mon Aug 24 10:50:37 2020
Received: from localhost ([127.0.0.1]:58847 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1kADnx-00028d-IH
	for submit <at> debbugs.gnu.org; Mon, 24 Aug 2020 10:50:37 -0400
Received: from mail-ej1-f54.google.com ([209.85.218.54]:33198)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <vincent.belaiche@HIDDEN>) id 1kADnu-00028P-P6
 for 26169 <at> debbugs.gnu.org; Mon, 24 Aug 2020 10:50:36 -0400
Received: by mail-ej1-f54.google.com with SMTP id u21so11610479ejz.0
 for <26169 <at> debbugs.gnu.org>; Mon, 24 Aug 2020 07:50:34 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025;
 h=mime-version:references:in-reply-to:from:date:message-id:subject:to
 :cc:content-transfer-encoding;
 bh=nhCblVBS1orkkp3BKnCa986pHyz4W16cWiv4vx1IOfM=;
 b=i2TYjoSMLHJ+xGvUXgu/oDVH+i53oPwRGn9vFuo1dqqRff/q6OmVSG1SKqxgqaF7E6
 Vd279mwfle8BT1SAe1cdaswXWSMmhjmPgNSkfNBpA59mkfRphZmRCfzy8W6trcF/0BVz
 lYSQDL3cWQCbS7lBQ4ZbD92IBc6qIs/qqPxkGGsW00bmcA4uphZbhcG4yXKCmHHbFcOi
 nkhHbH4yjlZZIiEhxbovplke2NREWNNYuOOZnD2684Z203q0zaey3M8jO0M+Wfto/1gl
 vtDUN//aL8X/hfeIJ8KVyrv8rwmF+ZpdN9HXOMZjODHbKlnaym2XmobxRddR1jh78Qpx
 eZnA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20161025;
 h=x-gm-message-state:mime-version:references:in-reply-to:from:date
 :message-id:subject:to:cc:content-transfer-encoding;
 bh=nhCblVBS1orkkp3BKnCa986pHyz4W16cWiv4vx1IOfM=;
 b=CAJmm6qrLldYrCp64VYM7tu0TKIj0IewEfYEaU6BCVxy3mIZJwUwRxA6UzqrjPeRlB
 8I8a+kvzOnmAO5ioOZAj8Sj+5LNdxMfhkZ2XruwLZVNXdKgJ1JN3agoeyhAlqk6gO+GU
 Rp6qVgtcJuUCal+YRgo4SW58x417Cl6gCfGNnlHFs9o8PJfAccraIulwtTwy8sk1jHug
 RTGwsfsxHxVRuxq2gjvl06eI64jP2JEcEtYu/jlmZs2dBIXIIOU6rTMoEspLaVYYbPOf
 rgp75RUb6HGwIVaaZSAJKyHvJb+pS+8sXvH+N7tAxh44JrUy+FF+NR5tF92QCAxYFUqN
 yaeQ==
X-Gm-Message-State: AOAM532nbZ43rqSDRN2OZUY2orGL43R3ErBvR5xWGTSstVASV1FgVD5W
 l7rGbiNc8izipj6WpUqwRkd3R08n+XLh8gxzf0I=
X-Google-Smtp-Source: ABdhPJxd9iUwEV+hLXLLklywyQlmq0vYalTd/MoL537g1tQ4OOCCaYHoCg++p3W9lpsbhDNVw2xryWOfgkCkRoqjzQ8=
X-Received: by 2002:a17:907:724b:: with SMTP id
 ds11mr5873363ejc.481.1598280628816; 
 Mon, 24 Aug 2020 07:50:28 -0700 (PDT)
MIME-Version: 1.0
References: <87bmsx6era.fsf@HIDDEN> <87ft8hqocs.fsf@HIDDEN>
 <CAPAOBV_QT7_6hNnx00eXGdkG4683cNXW8_0KQhDfiss62Gkrqw@HIDDEN>
In-Reply-To: <CAPAOBV_QT7_6hNnx00eXGdkG4683cNXW8_0KQhDfiss62Gkrqw@HIDDEN>
From: =?UTF-8?Q?Vincent_Bela=C3=AFche?= <vincent.belaiche@HIDDEN>
Date: Mon, 24 Aug 2020 16:50:17 +0200
Message-ID: <CAPAOBV_5DLyOnAgTH8+SXp_SFB716iK=0U5vgGLmxvEsbcegcg@HIDDEN>
Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message
To: Lars Ingebrigtsen <larsi@HIDDEN>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Spam-Score: 0.0 (/)
X-Debbugs-Envelope-To: 26169
Cc: =?UTF-8?Q?Vincent_Bela=C3=AFche?= <vincentb1@HIDDEN>,
 Kevin Ryde <user42_kevin@HIDDEN>, 26169 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -1.0 (-)

Or we could have some extended format string, like this:

"%?n{%.7g%}%?s{%s%}%?*{%S%}"

where whatever is between %?xxxx{ and %} is conditioned by some
predicate xxxx that can be n for numberp, s for stringp, and * for
"none of those at the same level", and some parser would compile this
format string into

(cond
   ((numberp x) (format "%.7g" x))
   ((stringp x) (format "%s" x))
   (t (format "%S" x))

Le lun. 24 ao=C3=BBt 2020 =C3=A0 16:20, Vincent Bela=C3=AFche
<vincent.belaiche@HIDDEN> a =C3=A9crit :
>
> Hello Lars,
>
> The root cause is that the default printer is "%.7g". This printer
> being a string it is equivalent for (lambda (x) (format xxxx x)),
> where xxxx is the concerned string, ie "%.7g".
>
> That default printer comes from the const ses-initial-file-contents,
> which hard wires the default printer to "%.7g".
>
> So you can just change your spreadsheet not to get the error by
> setting "%s" as a printer to cell A1 (just press p, then "%s", and
> then RET). You can also change the default column printer with M-p, or
> the default spreadsheet printer with C-c C-p.
>
> A better fix would certainly to accept a new printer format that
> instead of a string would be some sort of expression structure that
> would map a format string to some predicate, where the predicates
> could only be one of stringp , numberp. It could be something
>
> '(printers (stringp . "%s") (numberp . "%.7g"))
>
> So the code would check it for being safe (not to allow viruses on
> load) this way
>
> (mapc (lambda (x) (or (and (memq (car x) '(stringp numberp)) (stringp
> (cdr x)) (errror "Unsafe printer %S" x))
>    yyyy)
>
> where yyyy would be the desired value '(printers (stringp . "%s")
> (numberp . "%.7g")).
>
> Well, probably what sort of structure we want to accommodate needs
> some more thinking.
>
>   Vincent.
>
> PS : I cannot make the fix straight away, my personal PC ethernet card
> has been broken by the latest storm overvoltage, and the other PC
> having my credentials is also under repair after overheating damaged
> the connectors (well, nothing surprising as this was a MACbook pro, a
> notable unreliable sort of machine wrt to thermal extreme conditions).
>
> Le jeu. 20 ao=C3=BBt 2020 =C3=A0 18:22, Lars Ingebrigtsen <larsi@HIDDEN=
> a =C3=A9crit :
> >
> > Kevin Ryde <user42_kevin@HIDDEN> writes:
> >
> > > In debian packaged emacs 25.1.1, starting "emacs -Q /tmp/foo.ses"
> > >
> > >    " Ret            # create a cell with a string
> > >    hello Ret        # the string content
> > >    C-p              # move point to that cell
> > >    c                # ses-recalculate-cell
> > >    =3D>
> > >    Format specifier doesn't match argument type: A1
> > >
> > > I expected recalc on a string cell to leave it unchanged.
> > > The message looks like a caught error, but I don't know if it's
> > > something bad or merely unsightly.  The same happens in emacs 24.
> > >
> > > Occasionally I've had c on a string cell clear it to nil.  I'll see i=
f I
> > > can make something reproducable for that, if it could be related.
> >
> > I had a peek at ses.el (a package I don't use regularly), and something
> > like the following fixes the problem, but is probably totally the wrong
> > solution.
> >
> > I've Cc'd the maintainer on this -- Vincent?
> >
> > diff --git a/lisp/ses.el b/lisp/ses.el
> > index 96b219fc60..e396cc72ac 100644
> > --- a/lisp/ses.el
> > +++ b/lisp/ses.el
> > @@ -1231,7 +1231,9 @@ ses-print-cell
> >                      (ses--col col))
> >                  (ses-call-printer (or printer
> >                                        (ses-col-printer col)
> > -                                      ses--default-printer)
> > +                                      (if (stringp value)
> > +                                          "%7s"
> > +                                        ses--default-printer))
> >                                    value)))
> >         (if (consp ses-call-printer-return)
> >             ;; Printer returned an error.
> >
> > --
> > (domestic pets only, the antidote for overdose, milk.)
> >    bloggy blog: http://lars.ingebrigtsen.no
Information forwarded to bug-gnu-emacs@HIDDEN:
bug#26169; Package emacs. Full text available.

Message received at 26169 <at> debbugs.gnu.org:


Received: (at 26169) by debbugs.gnu.org; 24 Aug 2020 14:20:38 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Mon Aug 24 10:20:38 2020
Received: from localhost ([127.0.0.1]:58757 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1kADKv-0001Mh-Mp
	for submit <at> debbugs.gnu.org; Mon, 24 Aug 2020 10:20:38 -0400
Received: from mail-ej1-f43.google.com ([209.85.218.43]:35358)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <vincent.belaiche@HIDDEN>) id 1kADKt-0001MU-3b
 for 26169 <at> debbugs.gnu.org; Mon, 24 Aug 2020 10:20:36 -0400
Received: by mail-ej1-f43.google.com with SMTP id a26so12165265ejc.2
 for <26169 <at> debbugs.gnu.org>; Mon, 24 Aug 2020 07:20:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025;
 h=mime-version:references:in-reply-to:from:date:message-id:subject:to
 :cc:content-transfer-encoding;
 bh=cm6HO5w7wXSYyyN6FNOI32O7Vx1pD0tMnyStdkGCnBU=;
 b=U5a+v6b3wwy6Ij/h9Zulvat/LU3QsDleL5dtExl4zO7hZv1ftnfyXxpliCEeQGs2su
 gnW9rLtly+OQCVfQPoUvBhnMQVBvJEt+LW+ehfId1lZ9qr/0VUArtqLlJOWa1wA193Xq
 1TRQKfKpC8OgBmgje8zhw8COqsVBDXYtJzka/18VNUITPMOCHQuoT6mT7L+c2lEqktbq
 bTQ3OWFpIt81Jx3Ymhl7AQmua5amn5azVKe9lt0BYmBcIVuhE5x/bfHsExlpG1zLxfKu
 1phcgC3z4oy2BGI+Z3tWNzDeaYq1bHq0XHfXz3VBy4tbQYO/OnyoJybVUwDfxMibNDYM
 pUNQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20161025;
 h=x-gm-message-state:mime-version:references:in-reply-to:from:date
 :message-id:subject:to:cc:content-transfer-encoding;
 bh=cm6HO5w7wXSYyyN6FNOI32O7Vx1pD0tMnyStdkGCnBU=;
 b=Bj7ADYIil+A46lx04uoLSKgdpL0eHllPqHdLEr4ra9/Db3Czw6oSK5S5F4BUwFaPqr
 Q6n8nPSps42fu6mK76wyOjFzqfQe+LS8W32F8U1oWHphJaCex3GDPdYjEuwDc4M9uOId
 pqsQX1zkSUa9lyx16BnuLDRyE84J6d/JX/adM8OUOOLic1iLv/VIiqlGvjwHyoXmfbZW
 QiZuOzNhq0brFlkVQ6CExEGw2BAdrRCE/Vh8Jmr8YKQ8cpsfCtUQgR0uXagsM4070NAT
 RYwtyJSzlUtPd78Fe0A0lacwE2y4bFKpRAEUBOOmcCw/kVD0372dEWFkgbzfPZvLF3fC
 FJLQ==
X-Gm-Message-State: AOAM533AP2buFHeLgCzgy30g2siEi288sRVeferCNNDiDr2G8HYz/0iw
 v10BPFCxiS+sPVFc+9v4t7Bt1iKBFzU85H8fda0=
X-Google-Smtp-Source: ABdhPJwZk+L9Rc4jQnqYolGqq4bkmFgMUg5Y1Gktci7lobP44X6uwOfzZEY294R1Q8ULoKbAFGupZmxtmZNQxsxBzjY=
X-Received: by 2002:a17:906:4b0d:: with SMTP id
 y13mr5757745eju.39.1598278829137; 
 Mon, 24 Aug 2020 07:20:29 -0700 (PDT)
MIME-Version: 1.0
References: <87bmsx6era.fsf@HIDDEN> <87ft8hqocs.fsf@HIDDEN>
In-Reply-To: <87ft8hqocs.fsf@HIDDEN>
From: =?UTF-8?Q?Vincent_Bela=C3=AFche?= <vincent.belaiche@HIDDEN>
Date: Mon, 24 Aug 2020 16:20:17 +0200
Message-ID: <CAPAOBV_QT7_6hNnx00eXGdkG4683cNXW8_0KQhDfiss62Gkrqw@HIDDEN>
Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message
To: Lars Ingebrigtsen <larsi@HIDDEN>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Spam-Score: 0.0 (/)
X-Debbugs-Envelope-To: 26169
Cc: =?UTF-8?Q?Vincent_Bela=C3=AFche?= <vincentb1@HIDDEN>,
 Kevin Ryde <user42_kevin@HIDDEN>, 26169 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -1.0 (-)

Hello Lars,

The root cause is that the default printer is "%.7g". This printer
being a string it is equivalent for (lambda (x) (format xxxx x)),
where xxxx is the concerned string, ie "%.7g".

That default printer comes from the const ses-initial-file-contents,
which hard wires the default printer to "%.7g".

So you can just change your spreadsheet not to get the error by
setting "%s" as a printer to cell A1 (just press p, then "%s", and
then RET). You can also change the default column printer with M-p, or
the default spreadsheet printer with C-c C-p.

A better fix would certainly to accept a new printer format that
instead of a string would be some sort of expression structure that
would map a format string to some predicate, where the predicates
could only be one of stringp , numberp. It could be something

'(printers (stringp . "%s") (numberp . "%.7g"))

So the code would check it for being safe (not to allow viruses on
load) this way

(mapc (lambda (x) (or (and (memq (car x) '(stringp numberp)) (stringp
(cdr x)) (errror "Unsafe printer %S" x))
   yyyy)

where yyyy would be the desired value '(printers (stringp . "%s")
(numberp . "%.7g")).

Well, probably what sort of structure we want to accommodate needs
some more thinking.

  Vincent.

PS : I cannot make the fix straight away, my personal PC ethernet card
has been broken by the latest storm overvoltage, and the other PC
having my credentials is also under repair after overheating damaged
the connectors (well, nothing surprising as this was a MACbook pro, a
notable unreliable sort of machine wrt to thermal extreme conditions).

Le jeu. 20 ao=C3=BBt 2020 =C3=A0 18:22, Lars Ingebrigtsen <larsi@HIDDEN> =
a =C3=A9crit :
>
> Kevin Ryde <user42_kevin@HIDDEN> writes:
>
> > In debian packaged emacs 25.1.1, starting "emacs -Q /tmp/foo.ses"
> >
> >    " Ret            # create a cell with a string
> >    hello Ret        # the string content
> >    C-p              # move point to that cell
> >    c                # ses-recalculate-cell
> >    =3D>
> >    Format specifier doesn't match argument type: A1
> >
> > I expected recalc on a string cell to leave it unchanged.
> > The message looks like a caught error, but I don't know if it's
> > something bad or merely unsightly.  The same happens in emacs 24.
> >
> > Occasionally I've had c on a string cell clear it to nil.  I'll see if =
I
> > can make something reproducable for that, if it could be related.
>
> I had a peek at ses.el (a package I don't use regularly), and something
> like the following fixes the problem, but is probably totally the wrong
> solution.
>
> I've Cc'd the maintainer on this -- Vincent?
>
> diff --git a/lisp/ses.el b/lisp/ses.el
> index 96b219fc60..e396cc72ac 100644
> --- a/lisp/ses.el
> +++ b/lisp/ses.el
> @@ -1231,7 +1231,9 @@ ses-print-cell
>                      (ses--col col))
>                  (ses-call-printer (or printer
>                                        (ses-col-printer col)
> -                                      ses--default-printer)
> +                                      (if (stringp value)
> +                                          "%7s"
> +                                        ses--default-printer))
>                                    value)))
>         (if (consp ses-call-printer-return)
>             ;; Printer returned an error.
>
> --
> (domestic pets only, the antidote for overdose, milk.)
>    bloggy blog: http://lars.ingebrigtsen.no
Information forwarded to bug-gnu-emacs@HIDDEN:
bug#26169; Package emacs. Full text available.

Message received at 26169 <at> debbugs.gnu.org:


Received: (at 26169) by debbugs.gnu.org; 20 Aug 2020 16:22:26 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Thu Aug 20 12:22:26 2020
Received: from localhost ([127.0.0.1]:43657 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1k8nKc-0006CL-LI
	for submit <at> debbugs.gnu.org; Thu, 20 Aug 2020 12:22:26 -0400
Received: from quimby.gnus.org ([95.216.78.240]:59536)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <larsi@HIDDEN>) id 1k8nKY-0006C7-QI
 for 26169 <at> debbugs.gnu.org; Thu, 20 Aug 2020 12:22:26 -0400
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org;
 s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date:
 References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding:
 Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender:
 Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:
 List-Subscribe:List-Post:List-Owner:List-Archive;
 bh=6bokyMgXGhRwVezYe8pneVXtySSab2gl0Gt+plQSRTw=; b=etjws74Zx0itEFgpWQw3JaFBdA
 F6hJ8B/9MLpP1qXed4G4HAlCE3YycUvOL+O3FOZxpc7ssa6d5Tf21cZKjCHJpyd1zhEQsGT2maL+q
 d9TxpnMcHA0D9+FpWNHqie0pcfcfxtCCGsa6/EbiTwiHteZPlY/5+D0IrBKM/93YmCCE=;
Received: from cm-84.212.202.86.getinternet.no ([84.212.202.86] helo=xo)
 by quimby with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
 (Exim 4.92) (envelope-from <larsi@HIDDEN>)
 id 1k8nKP-0006hA-Mi; Thu, 20 Aug 2020 18:22:16 +0200
From: Lars Ingebrigtsen <larsi@HIDDEN>
To: Kevin Ryde <user42_kevin@HIDDEN>
Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message
References: <87bmsx6era.fsf@HIDDEN>
X-Now-Playing: The Declining Winter's _Endless Scenery_: "Alsager Commerce"
Date: Thu, 20 Aug 2020 18:22:11 +0200
In-Reply-To: <87bmsx6era.fsf@HIDDEN> (Kevin Ryde's message of "Sun, 19 Mar
 2017 16:02:01 +1100")
Message-ID: <87ft8hqocs.fsf@HIDDEN>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain
X-Spam-Report: Spam detection software, running on the system "quimby.gnus.org",
 has NOT identified this incoming email as spam.  The original
 message has been attached to this so you can view it or label
 similar future email.  If you have any questions, see
 @@CONTACT_ADDRESS@@ for details.
 Content preview:  Kevin Ryde <user42_kevin@HIDDEN> writes: > In debian
 packaged emacs 25.1.1, starting "emacs -Q /tmp/foo.ses" > > " Ret # create
 a cell with a string > hello Ret # the string content > C-p # move point
 to that cell > c # ses-recalculate-cell [...] 
 Content analysis details:   (-2.9 points, 5.0 required)
 pts rule name              description
 ---- ---------------------- --------------------------------------------------
 -1.0 ALL_TRUSTED            Passed through trusted hosts only via SMTP
 -1.9 BAYES_00               BODY: Bayes spam probability is 0 to 1%
 [score: 0.0000]
X-Spam-Score: 0.0 (/)
X-Debbugs-Envelope-To: 26169
Cc: Vincent =?utf-8?Q?Bela=C3=AFche?= <vincentb1@HIDDEN>,
 26169 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -1.0 (-)

Kevin Ryde <user42_kevin@HIDDEN> writes:

> In debian packaged emacs 25.1.1, starting "emacs -Q /tmp/foo.ses"
>
>    " Ret            # create a cell with a string
>    hello Ret        # the string content
>    C-p              # move point to that cell
>    c                # ses-recalculate-cell
>    =>
>    Format specifier doesn't match argument type: A1
>
> I expected recalc on a string cell to leave it unchanged.
> The message looks like a caught error, but I don't know if it's
> something bad or merely unsightly.  The same happens in emacs 24.
>
> Occasionally I've had c on a string cell clear it to nil.  I'll see if I
> can make something reproducable for that, if it could be related.

I had a peek at ses.el (a package I don't use regularly), and something
like the following fixes the problem, but is probably totally the wrong
solution.

I've Cc'd the maintainer on this -- Vincent?

diff --git a/lisp/ses.el b/lisp/ses.el
index 96b219fc60..e396cc72ac 100644
--- a/lisp/ses.el
+++ b/lisp/ses.el
@@ -1231,7 +1231,9 @@ ses-print-cell
                     (ses--col col))
                 (ses-call-printer (or printer
                                       (ses-col-printer col)
-                                      ses--default-printer)
+                                      (if (stringp value)
+                                          "%7s"
+                                        ses--default-printer))
                                   value)))
 	(if (consp ses-call-printer-return)
 	    ;; Printer returned an error.

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no
Information forwarded to bug-gnu-emacs@HIDDEN:
bug#26169; Package emacs. Full text available.

Message received at submit <at> debbugs.gnu.org:


Received: (at submit) by debbugs.gnu.org; 19 Mar 2017 05:02:54 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Sun Mar 19 01:02:54 2017
Received: from localhost ([127.0.0.1]:34479 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1cpSzW-0004yo-8A
	for submit <at> debbugs.gnu.org; Sun, 19 Mar 2017 01:02:54 -0400
Received: from eggs.gnu.org ([208.118.235.92]:38717)
 by debbugs.gnu.org with esmtp (Exim 4.84_2)
 (envelope-from <user42_kevin@HIDDEN>) id 1cpSzU-0004ya-L7
 for submit <at> debbugs.gnu.org; Sun, 19 Mar 2017 01:02:52 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <user42_kevin@HIDDEN>) id 1cpSzO-00019s-Oi
 for submit <at> debbugs.gnu.org; Sun, 19 Mar 2017 01:02:47 -0400
X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org
X-Spam-Level: 
X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,FREEMAIL_FROM,
 T_DKIM_INVALID autolearn=disabled version=3.3.2
Received: from lists.gnu.org ([2001:4830:134:3::11]:57630)
 by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32)
 (Exim 4.71) (envelope-from <user42_kevin@HIDDEN>)
 id 1cpSzO-00019o-LH
 for submit <at> debbugs.gnu.org; Sun, 19 Mar 2017 01:02:46 -0400
Received: from eggs.gnu.org ([2001:4830:134:3::10]:57902)
 by lists.gnu.org with esmtp (Exim 4.71)
 (envelope-from <user42_kevin@HIDDEN>) id 1cpSzN-0004LM-Hh
 for bug-gnu-emacs@HIDDEN; Sun, 19 Mar 2017 01:02:46 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <user42_kevin@HIDDEN>) id 1cpSzI-00018D-Le
 for bug-gnu-emacs@HIDDEN; Sun, 19 Mar 2017 01:02:45 -0400
Received: from nm21-vm4.bullet.mail.gq1.yahoo.com ([98.136.217.51]:56475)
 by eggs.gnu.org with esmtps (TLS1.0:RSA_ARCFOUR_SHA1:16) (Exim 4.71)
 (envelope-from <user42_kevin@HIDDEN>) id 1cpSzI-00017Z-DI
 for bug-gnu-emacs@HIDDEN; Sun, 19 Mar 2017 01:02:40 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.au; s=s2048;
 t=1489899758; bh=JiMdQzo2QW2s03woBaIIiJ8TZshbtsgzYDRCsK0/uYw=;
 h=From:To:Subject:Date:From:Subject;
 b=fQKJpiAbex2xbui89GW6Nte/3HwbTAchM+aOMaj5SPcSyUn1TsFquaYAIOM62u7CaxVZmVWfZdVJGevcqvtrvDUlFvgxaR+O40l/gCJHF+Xg2kWpSAB39qSwrWq/dy7eYD1vZA2ZNld93iDEIsrWKLDcpQXIqcUlB1+k8rvovWM+U7CFB24A+2YpqbEJDCJHsRy59we2koQCMUH83pvR61ODlAqH5Tofc3st5r+WWij7W+L7+D2orYYfXcAerYvZqIessa0gsDOlvNuLBFVMnq4eWymfXULIGKusof3Ed7iily2YxBztn0nTtB3Go0bZ2jCPRXtmqkqT0igq7MfcbQ==
Received: from [98.137.12.63] by nm21.bullet.mail.gq1.yahoo.com with NNFMP;
 19 Mar 2017 05:02:38 -0000
Received: from [208.71.42.203] by tm8.bullet.mail.gq1.yahoo.com with NNFMP;
 19 Mar 2017 05:02:38 -0000
Received: from [127.0.0.1] by smtp214.mail.gq1.yahoo.com with NNFMP;
 19 Mar 2017 05:02:38 -0000
X-Yahoo-Newman-Id: 357489.53216.bm@HIDDEN
X-Yahoo-Newman-Property: ymail-3
X-YMail-OSG: P9a.3b8VM1m.lLIX4WMUxZOorQWjOsrB4JjOWKTyhVlCjzA
 Dr1NG53aqNYtV1wxvJdxJ7jPKKuoBmSY2udRI9htROodFu.IeFU1vAvuk6OT
 MEBfcc.OF07u8owYdIthlSCBp_CTWYkKGdcGz6021VXznJ2KuTBc4DhfDBl.
 TTB572rHkuK3wZjMyVJlNUTK3HgNfzPXrGxnxJ5JII51DTo0Ven6oJxHd_Wx
 RT6an7H9_9sjgoVuOFATVtpdQna2Im5EzyfDPtD4KmyGkq7z_8zzkuVYQ1Mp
 a1qL51Ob.jcjPzyuCO6JTBoO4Ywh5p7RaTdHsYlQmozbQFTAoVZ4jG0OckiK
 1NyxkJReYC6c_rLQxnBy__WXYoQngsEQLIW0C.eZ_.FJVRWgP4tjwnfl699C
 _Ap3uk9r8IvrmPHTmiACQ9rZzmkH_ePRr1_QXX7EpTgnPoizG5RgAoc4fOjd
 qAekBRfCNGRwHlIItDrIGj4cchlNL4bwdGtCjvkmqJ3t3jnlri19zD3wtA57
 n909OwSDJpEJmlWDoI1dH_PjbMkl2lnDkaAMW2nCnKplmjfxJ5eCYg3jiaIU -
X-Yahoo-SMTP: U8NKAo6swBAxDIMUovTitGGHebxdYQBZ5A--
From: Kevin Ryde <user42_kevin@HIDDEN>
To: bug-gnu-emacs@HIDDEN
Subject: 25.1; ses.el string cell recalculate message
Date: Sun, 19 Mar 2017 16:02:01 +1100
Message-ID: <87bmsx6era.fsf@HIDDEN>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 3.x [fuzzy]
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x
X-Received-From: 2001:4830:134:3::11
X-Spam-Score: -4.4 (----)
X-Debbugs-Envelope-To: submit
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -4.4 (----)

In debian packaged emacs 25.1.1, starting "emacs -Q /tmp/foo.ses"

   " Ret            # create a cell with a string
   hello Ret        # the string content
   C-p              # move point to that cell
   c                # ses-recalculate-cell
   =>
   Format specifier doesn't match argument type: A1

I expected recalc on a string cell to leave it unchanged.
The message looks like a caught error, but I don't know if it's
something bad or merely unsightly.  The same happens in emacs 24.

Occasionally I've had c on a string cell clear it to nil.  I'll see if I
can make something reproducable for that, if it could be related.
Acknowledgement sent to Kevin Ryde <user42_kevin@HIDDEN>:
New bug report received and forwarded. Copy sent to bug-gnu-emacs@HIDDEN. Full text available.
Report forwarded to bug-gnu-emacs@HIDDEN:
bug#26169; Package emacs. Full text available.
Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.
Last modified: Mon, 24 Aug 2020 15:00:02 UTC

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997 nCipher Corporation Ltd, 1994-97 Ian Jackson.