From unknown Sat Aug 16 10:49:32 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#26169 <26169@debbugs.gnu.org> To: bug#26169 <26169@debbugs.gnu.org> Subject: Status: 25.1; ses.el string cell recalculate message Reply-To: bug#26169 <26169@debbugs.gnu.org> Date: Sat, 16 Aug 2025 17:49:32 +0000 retitle 26169 25.1; ses.el string cell recalculate message reassign 26169 emacs submitter 26169 Kevin Ryde severity 26169 minor thanks From debbugs-submit-bounces@debbugs.gnu.org Sun Mar 19 01:02:54 2017 Received: (at submit) by debbugs.gnu.org; 19 Mar 2017 05:02:54 +0000 Received: from localhost ([127.0.0.1]:34479 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cpSzW-0004yo-8A for submit@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 ) id 1cpSzU-0004ya-L7 for submit@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 ) id 1cpSzO-00019s-Oi for submit@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 ) id 1cpSzO-00019o-LH for submit@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 ) id 1cpSzN-0004LM-Hh for bug-gnu-emacs@gnu.org; Sun, 19 Mar 2017 01:02:46 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cpSzI-00018D-Le for bug-gnu-emacs@gnu.org; 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 ) id 1cpSzI-00017Z-DI for bug-gnu-emacs@gnu.org; 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@smtp214.mail.gq1.yahoo.com 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 To: bug-gnu-emacs@gnu.org Subject: 25.1; ses.el string cell recalculate message Date: Sun, 19 Mar 2017 16:02:01 +1100 Message-ID: <87bmsx6era.fsf@blah.blah> 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@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" 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. From debbugs-submit-bounces@debbugs.gnu.org Thu Aug 20 12:22:26 2020 Received: (at 26169) by debbugs.gnu.org; 20 Aug 2020 16:22:26 +0000 Received: from localhost ([127.0.0.1]:43657 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1k8nKc-0006CL-LI for submit@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 ) id 1k8nKY-0006C7-QI for 26169@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 ) id 1k8nKP-0006hA-Mi; Thu, 20 Aug 2020 18:22:16 +0200 From: Lars Ingebrigtsen To: Kevin Ryde Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message References: <87bmsx6era.fsf@blah.blah> 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@blah.blah> (Kevin Ryde's message of "Sun, 19 Mar 2017 16:02:01 +1100") Message-ID: <87ft8hqocs.fsf@gnus.org> 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 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?= , 26169@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Kevin Ryde 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 From debbugs-submit-bounces@debbugs.gnu.org Mon Aug 24 10:20:38 2020 Received: (at 26169) by debbugs.gnu.org; 24 Aug 2020 14:20:38 +0000 Received: from localhost ([127.0.0.1]:58757 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kADKv-0001Mh-Mp for submit@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 ) id 1kADKt-0001MU-3b for 26169@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@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@blah.blah> <87ft8hqocs.fsf@gnus.org> In-Reply-To: <87ft8hqocs.fsf@gnus.org> From: =?UTF-8?Q?Vincent_Bela=C3=AFche?= Date: Mon, 24 Aug 2020 16:20:17 +0200 Message-ID: Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message To: Lars Ingebrigtsen 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?= , Kevin Ryde , 26169@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" 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 = a =C3=A9crit : > > Kevin Ryde 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 From debbugs-submit-bounces@debbugs.gnu.org Mon Aug 24 10:50:37 2020 Received: (at 26169) by debbugs.gnu.org; 24 Aug 2020 14:50:38 +0000 Received: from localhost ([127.0.0.1]:58847 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kADnx-00028d-IH for submit@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 ) id 1kADnu-00028P-P6 for 26169@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@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@blah.blah> <87ft8hqocs.fsf@gnus.org> In-Reply-To: From: =?UTF-8?Q?Vincent_Bela=C3=AFche?= Date: Mon, 24 Aug 2020 16:50:17 +0200 Message-ID: Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message To: Lars Ingebrigtsen 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?= , Kevin Ryde , 26169@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" 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 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 a =C3=A9crit : > > > > Kevin Ryde 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 From debbugs-submit-bounces@debbugs.gnu.org Tue Aug 25 16:27:43 2020 Received: (at 26169) by debbugs.gnu.org; 25 Aug 2020 20:27:43 +0000 Received: from localhost ([127.0.0.1]:36226 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kAfXj-0002vI-An for submit@debbugs.gnu.org; Tue, 25 Aug 2020 16:27:43 -0400 Received: from quimby.gnus.org ([95.216.78.240]:46312) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kAfXh-0002v2-7F for 26169@debbugs.gnu.org; Tue, 25 Aug 2020 16:27:41 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Transfer-Encoding:Content-Type:MIME-Version:Message-ID :In-Reply-To:Date:References:Subject:Cc:To:From:Sender:Reply-To: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=LA6qd1qaYnpJrCgFk6322l44m5yRXl45wRbDF4PhPnQ=; b=IvM5iSVYdBrE/+fF9qrC2F9php +q6PM/ZvyLrKy0ywNpvGuHTP9l4XQdRidEj3qA5nafB13GkdVa5GEn3BZgJaE8q8CcXDhHBjy3wDp ZbGkfbryGaEXjup17RD0RNjjDD8trauXGd+6k21rmNmilR+EUZ0Gaf75YZ5xwECNAhrU=; 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 ) id 1kAfXW-0001p0-Vj; Tue, 25 Aug 2020 22:27:34 +0200 From: Lars Ingebrigtsen To: Vincent =?utf-8?Q?Bela=C3=AFche?= Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message References: <87bmsx6era.fsf@blah.blah> <87ft8hqocs.fsf@gnus.org> Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAGFBMVEUJBwt8fIBcWV7B wMMqHCBbCw6XDhH////N3kznAAAAAWJLR0QHFmGI6wAAAAd0SU1FB+QIGRQGJsMYiTcAAAGmSURB VDjLjZNNkqMwDIUVIrNO2jlAfrr3EHMAVSJYM1Nx1l4E3/8IIxs8YKipGm0o/PGeZEkAjLH7qukY gyALRAaOMZ8p6i1YYeOrKHBUlYPzg6dB9QDDuxuUK4dR4d0gigi8L1k55RLwZJWfgHw/AwdWvUfQ UWkT6J1Lik/XQZcUZf+RLKWy/gWu7Py7SwroLfUK2bbQq/ZlFfbwH6HNt2n0pTEmO24F3E2tTWXM eQl8r/f3KoJdBpwojiM4ZVYfAbcR1FnTB6efRoCuDGcg5DDVXT+rvKiQvLgcznq/Ti73ODFTAGYN apmtfjbmazV0QBk3IxFumiJW4XHdANmTIPv+F6AtuM5+sz9Me7UBFDcteNHKnynuH142AKBJphkg wOav6xoQE+ULDw/5DJsHMdxwARgKaSlWD7qCXtxx+h2wKfhKGZhkp3BW510pzkQQEq/B7iBVET8i WNa7PwcvRgwAciAHKBM8YnbBJ6XaOO+JgDCmk1SYg1vsXnGAqfuzYgLrFVGv6FD8iN1rCdrfbK1t f/1Yq6xdEo1hDvsDr7MfMV0zxR+zC2Cw1nLjhwAAACV0RVh0ZGF0ZTpjcmVhdGUAMjAyMC0wOC0y NVQyMDowNjozOCswMDowMPpIy8gAAAAldEVYdGRhdGU6bW9kaWZ5ADIwMjAtMDgtMjVUMjA6MDY6 MzgrMDA6MDCLFXN0AAAAAElFTkSuQmCC X-Now-Playing: The Residents's _Metal, Meat & Bone (1)_: "Tell Me" Date: Tue, 25 Aug 2020 22:27:29 +0200 In-Reply-To: ("Vincent =?utf-8?Q?Bela=C3=AFche=22's?= message of "Mon, 24 Aug 2020 16:50:17 +0200") Message-ID: <87364a4gjy.fsf@gnus.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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: Vincent Belaïche writes: > 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 numbe [...] 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?= , Kevin Ryde , 26169@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Vincent Bela=C3=AFche writes: > 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)) Hm... or it could just be an alist like ((numberp "%.7g") (stringp "%s") (t "%S")) --=20 (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no From debbugs-submit-bounces@debbugs.gnu.org Wed Aug 26 07:54:39 2020 Received: (at 26169) by debbugs.gnu.org; 26 Aug 2020 11:54:39 +0000 Received: from localhost ([127.0.0.1]:37603 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kAu0k-0003GL-Ol for submit@debbugs.gnu.org; Wed, 26 Aug 2020 07:54:39 -0400 Received: from mail-ej1-f68.google.com ([209.85.218.68]:35305) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kAu0i-0003G7-Uj for 26169@debbugs.gnu.org; Wed, 26 Aug 2020 07:54:37 -0400 Received: by mail-ej1-f68.google.com with SMTP id a26so2452915ejc.2 for <26169@debbugs.gnu.org>; Wed, 26 Aug 2020 04:54:36 -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=ZJw4FiF1Odovsq74hWBs0OdNd8Mq76U1YWjHaR5C09c=; b=e/mVk9AAtrc6y7XmC8t2hPPbsvf4SR/FLwY3H/Oy4iEBuU1jRRfiV5+61Wwx4HYdCL UntZZyUtUc67kFGNvLi9Scm0oCTqb8096oltF9ZBjNrD65Lp/Dwkz8TmreV90iCCN4tg G5Yq4JNH3dA7fBFTZl7XDhhkgU4LrA99wU/RFY4KDQXXt751DhW7BKfl6Jtnj+rfcsO6 jXkl0MsQl41pvIt0OLKFTOv99NcMoU9kkXNOyp62C04+vfBpAA2M2Pvg3+ZD1DxuPHG0 ZXWaRh/ydXL6Oc3a26QPDYgK3yz25mlrPcuqe8mEu2pMVpmd+dfP0aKgIIhv/CIRmH/y pO1Q== 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=ZJw4FiF1Odovsq74hWBs0OdNd8Mq76U1YWjHaR5C09c=; b=HT85yZM9pD9IuIMXOiDef7HGlFeMVf6pVEInqYGe0oByIPxxHhBavLUxdzxrl4waYw AZJIsP6lqrpGRZH6crJl7/cA1B5Kw8vVufpEkT+sXruoI0IXuIw4FwIT2usn2xHBSc8m PRCWGvsEl9Tm/17dRh2XwN3p9Wdj7UJ1hltBrOS/3wcPoFH3j5h3KuV5bPy9PBl4pxbd xbcjZk8FiPa6ADC+ONoU0FtpbneTHKL+6F/J3NK1teAiGo5TiTEhAa5R0Vyc9trM2eL0 FDBN2PKMaPXJFKkgEOAw+VyTOWg2tS4chv63T64tTWoQfbn0NXOkBiK2zAFaBpaI9Bzj WuWw== X-Gm-Message-State: AOAM531cQZKXuavsVENVByyxKMUh/q1gY+aySm/4cgV49yzg+rXByIiB 8SIeZj3IGCNJ8eFjHj8Grpm32SStd+7K3TKxXDg= X-Google-Smtp-Source: ABdhPJzDlUmz0RYdhYaN1eWNPULw5kpU0EPTO2jJqjEMJP7um8q5IhC69/wiets/26Ipym/Qg65X5mP/0Z1aijSxGvw= X-Received: by 2002:a17:906:b156:: with SMTP id bt22mr1251726ejb.481.1598442871043; Wed, 26 Aug 2020 04:54:31 -0700 (PDT) MIME-Version: 1.0 References: <87bmsx6era.fsf@blah.blah> <87ft8hqocs.fsf@gnus.org> <87364a4gjy.fsf@gnus.org> In-Reply-To: <87364a4gjy.fsf@gnus.org> From: =?UTF-8?Q?Vincent_Bela=C3=AFche?= Date: Wed, 26 Aug 2020 13:54:19 +0200 Message-ID: Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message To: Lars Ingebrigtsen 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?= , Kevin Ryde , 26169@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) After some thought the extended format string seems better to me, it could be some separate package as that sort of need is not SES specific, and SES would check if the package is installed or not and use extended format strings if the package is installed. That would be a parameter in the sheet whether is uses extended format strings. So when you share a sheet using extended format with somebody else that do not have a extended formats, they would receive some warning that they need to install the package. V. Le mar. 25 ao=C3=BBt 2020 =C3=A0 22:27, Lars Ingebrigtsen = a =C3=A9crit : > > Vincent Bela=C3=AFche writes: > > > 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)) > > Hm... or it could just be an alist like > > ((numberp "%.7g") > (stringp "%s") > (t "%S")) > > > -- > (domestic pets only, the antidote for overdose, milk.) > bloggy blog: http://lars.ingebrigtsen.no From debbugs-submit-bounces@debbugs.gnu.org Thu Aug 27 09:33:19 2020 Received: (at 26169) by debbugs.gnu.org; 27 Aug 2020 13:33:19 +0000 Received: from localhost ([127.0.0.1]:42141 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kBI1m-0002S9-Pa for submit@debbugs.gnu.org; Thu, 27 Aug 2020 09:33:19 -0400 Received: from quimby.gnus.org ([95.216.78.240]:37840) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kBI1l-0002Rv-EM for 26169@debbugs.gnu.org; Thu, 27 Aug 2020 09:33:18 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Transfer-Encoding:Content-Type:MIME-Version:Message-ID :In-Reply-To:Date:References:Subject:Cc:To:From:Sender:Reply-To: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=cX+3KIGSxMYDmX6qbjO4GsAVBA29uja1stf2vGf+nyA=; b=ElVaH8lawhA85V1ExvxAGrglRh A7eYmWuCHm8J4JXIlaGrf76HFIfkUpXUTq85Chw4R/WCS3gTp5LA/N3L0pBIb7Lgvnr1vljC9AyX9 uTP1Wr3GZpXoHdmf1ST7+Q+Bv5EPj14h0UhKFmRH+O2ssL+QfIEY1j3sc2rKHSNAwHZs=; 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 ) id 1kBI1Z-000397-1H; Thu, 27 Aug 2020 15:33:10 +0200 From: Lars Ingebrigtsen To: Vincent =?utf-8?Q?Bela=C3=AFche?= Subject: Re: bug#26169: 25.1; ses.el string cell recalculate message References: <87bmsx6era.fsf@blah.blah> <87ft8hqocs.fsf@gnus.org> <87364a4gjy.fsf@gnus.org> Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAD1BMVEXFuZpoXF3Am2OU cEH///9sZGuXAAAAAWJLR0QEj2jZUQAAAAd0SU1FB+QIGww7AMPBfjcAAAFxSURBVDjLtZPrkcMw CISxKgimAT0aCNB/b7cgJbY8dz9Pk5kkfGYXEKaD6EV/nL/AQf8GClEt/cLv78/eS+/fko7XJzrP F+g5dcoDFBWqCSoloz59DpePM9RqAHzhnyrXeLjQ0krg5upq8XBZFVQy7y4qrgxQIhlyEziAM/O5 HBIQufhgWWCdmsChkkdmrEQCACMu+CwwW69oCQGHkMhYcyvZRQBPIesT1NUlgKZSH9ekaQIPqTOU HyCMlbUZn+22GBl39sbtre11AQ0iYk1aP5QvEFFkKI5xO25SLuHAOk54lJuUex+CEecK3EpGsYaK zWuAegcGBza3viWEFIpVeReiDXjMHXPMi733jpjHOEZe3gOU9eQTWLdI6mUDUW74WI0l2TPG8Gm0 AYQGmiixa+Uh5dFd3OkOJIXM1hJfAIMaUqf8BrC2yGJ+1hsN5jaqPIYoc1gyJ3P3iPlmnm0AFy6/ AiQgqtPpAdaN4G17X+4/4FBLfdXAE18AAAAldEVYdGRhdGU6Y3JlYXRlADIwMjAtMDgtMjdUMTI6 NTg6NTkrMDA6MDBuU+D5AAAAJXRFWHRkYXRlOm1vZGlmeQAyMDIwLTA4LTI3VDEyOjU4OjU5KzAw OjAwHw5YRQAAAABJRU5ErkJggg== X-Now-Playing: Jim Black Trio's _Reckon_: "Neural Holiday" Date: Thu, 27 Aug 2020 15:33:03 +0200 In-Reply-To: ("Vincent =?utf-8?Q?Bela=C3=AFche=22's?= message of "Wed, 26 Aug 2020 13:54:19 +0200") Message-ID: <87lfi0w6wg.fsf@gnus.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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: Vincent Belaïche writes: > After some thought the extended format string seems better to me, it > could be some separate package as that sort of need is not SES > specific, and SES would check if the package is installed or n [...] 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?= , Kevin Ryde , 26169@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Vincent Bela=C3=AFche writes: > After some thought the extended format string seems better to me, it > could be some separate package as that sort of need is not SES > specific, and SES would check if the package is installed or not and > use extended format strings if the package is installed. > That would be a parameter in the sheet whether is uses extended format > strings. So when you share a sheet using extended format with somebody > else that do not have a extended formats, they would receive some > warning that they need to install the package. I'm not sure I see the logic here -- it's surely a plain and simple bug stat ses signals an error when you're "recalculating" an ascii value. Is your concern that fixing this bug will lead to people creating more spreadsheets with ascii values, and then other people (using older versions of Emacs) won't be able to use those spreadsheets? If so, I think that sounds like an unlikely occurrence. And if it does happen, then there's nothing new about spreadsheets changing the formats in non-backwards-compatible manner -- the recipient will just have to update their spreadsheet software, too. --=20 (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no