From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: =?iso-8859-1?Q?Vincent_Bela=EFche?= Newsgroups: gmane.emacs.devel Subject: RE: using ses programatically (was: a ses question) Date: Sun, 24 Dec 2023 21:13:11 +0000 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="_000_PAXP192MB16082462DE71B69A33593E3E849AAPAXP192MB1608EURP_" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="5494"; mail-complaints-to="usenet@ciao.gmane.io" Cc: emacs-devel , "boruch_baum@gmx.com" To: =?iso-8859-1?Q?andr=E9s_ram=EDrez?= Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 25 04:21:36 2023 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1rHbX5-0001CR-4B for ged-emacs-devel@m.gmane-mx.org; Mon, 25 Dec 2023 04:21:35 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rHbW6-0001eC-JA; Sun, 24 Dec 2023 22:20:34 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rHVmh-0006Dh-Ns for emacs-devel@gnu.org; Sun, 24 Dec 2023 16:13:20 -0500 Original-Received: from mail-am7eur03olkn2054.outbound.protection.outlook.com ([40.92.59.54] helo=EUR03-AM7-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rHVmd-0006u0-Ic for emacs-devel@gnu.org; Sun, 24 Dec 2023 16:13:18 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=mpyNpNTgciJCxxSIgs9KjTF/lA5yqYZe/ZlRfhAJSCs3VQeGgImcHeVdHHOOHnY+GGM4c8pJVAJnDxUbzJkFugGXxnFyxPo8oxhm3xkk79wQAIjg18IiuBrfM1GDToyFJPFWhXDtk72mdVy4RItOjqJw4mEF2o+2XUglu7y9DdbOolDd5nHRwMe/KZiik1uPIOrjyd0Wn2bfB/IzbHvVbx0Wrym4Zbn82wFwgzm+bCiCaXrRg+b0SkwpenNoDKjahUKIAfLgFnJQI1aBzEHGS0TWdZE8RcqMY+66A2f8jaF750X1InnGZtTqwQvtGmO1Z3pEEKzRQAO0k5i9s4a1QQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=FsvrqnEq7pF7Vpg4g5Sx+l/FpRonrTp9qhfnUIh4vyY=; b=VFeEUjCdJzQOHuDlKDALgLvBnltKB6U+oni7pwMnioo64G5FXDt5BwPhbgdsKUINxaEddgbm3xu3D1Q1gXhyURbOE82boyErYvEC9NbDGxDiLd3t3C2CAcwf77NUarhetGKwaj/b9s6W1+9RnJoOqw0gU1HNi1NCifWRcJbPPUT2i5p+ld20BN0HuH5C2A4vZXL4zP//fnOXIaxicbjwCnzRR3Oao7F0tLm3hdF58Qi8Zg6fDxvxXot1gABYU5qY72pSJhKmq+Iu6Yrf3xhcAcA7XmUKYUTmQGIjYtk5HpBDKDiS2o7mjWahtasSBe7ds76l8nGYKBvU9ogYLxSucA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none Original-Received: from PAXP192MB1608.EURP192.PROD.OUTLOOK.COM (2603:10a6:102:28c::22) by GV1P192MB2001.EURP192.PROD.OUTLOOK.COM (2603:10a6:150:85::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7113.26; Sun, 24 Dec 2023 21:13:11 +0000 Original-Received: from PAXP192MB1608.EURP192.PROD.OUTLOOK.COM ([fe80::fee7:9deb:373a:4055]) by PAXP192MB1608.EURP192.PROD.OUTLOOK.COM ([fe80::fee7:9deb:373a:4055%7]) with mapi id 15.20.7113.023; Sun, 24 Dec 2023 21:13:11 +0000 Thread-Topic: using ses programatically (was: a ses question) Thread-Index: AQHaDyaIFxl+uTQAXkSovHGVyH2ZGrBrhKoNgABOFwCAAB8A5YAALdsAgBSj6giAAVoZAIAAPkBXgAADb8GAABTQgIA0PI/6gAIxQoCAAFqNoA== In-Reply-To: Accept-Language: fr-FR, en-US Content-Language: fr-FR x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [MPByOIZr0Vjs/YvR84lp6mN/Vhphuobx] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PAXP192MB1608:EE_|GV1P192MB2001:EE_ x-ms-office365-filtering-correlation-id: 0dae94c5-ef31-4d2d-a189-08dc04c52251 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: F5H+jCbZGuVQzmwS1eXXTHp/a6RZYCukYZXlBwDqjvkc7WDHwLUIGZTURiOvwKQjEDHnhbih1rliWBjE5UbhIpGf0+0a/tXOsYK9TjTX1rs/LTHiwwsvlVf3yZhw0+vQ8ANTVhatNuLGE28sE6+7iHknyWSqxFW1trbt1rwz5Fx2Qn99ILOBryRpngEHsj6GthfDka+lcktoSYP8SanVC9ygleGaugIKFXHY7D7NsEsmM4+nYoMOSALFc370EGyIrN9+pJlpiQq4Xnc0wxg7yQ2TyANaXi2Nl7uxFasJW/dkJUP7s5cfvT9mcSPAq9GuZsgKitw0GPm1bY0rvZ7sBwSv8joFapJqupiCttUPBClk2TShb2+NQuHjCdqSoduRPMmvi9XAIJwVPd9F0RwjRvANeaPO0dNbykmAtTSOS8dk2aIcVG+TaobwUidze3/yGevdxu5DVKkTVTzCIxft/h3WjHVnk7ZoLo78lXqL3DONHEtcKBCcr8YnWKcrwaQLwP5AZjG61PtT21HfsaDE0VJ8ateenFsnocBkSHO2AKVZa4txIVJKVZNwiqkszC8lCiIfck/G5hNgkieZU8qxG0G0xQUPkqdYz/TKNqXDlfOfW6Bm7ESIPnTeExcHsgrz2urEDPEaX5ld8029NFfYukgZhd6udMj7f3c50huGpJOrsoZV5+wWaQoN4Yaio8x/tyZhftdeKW/Z1W+UVXQdTzCquDdxH16OaygJAvcGFj4DRLKxTKMWO+VPlogtB 4qIWN1MnYa3V3/Xiv2/hYGG+9/qSDA/ja0SbMR93r+cOFY= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?CAI0bKgq8r6ZyrUob2fFrrALrIaz1n1ZSsCUu5Hl/HW8n4IdP3xxbcN/Ag?= =?iso-8859-1?Q?ZlW9hGfITIuZks9fVf6Vc8c6mfeHy9Q8XN9OlXOpjMt+aQzpKlk48rzelR?= =?iso-8859-1?Q?7TIR6e3HOcPp/UUVX7d5dg5iCojARwjHClJiIbPT8uW4QlBbSrvLJU4Qp3?= =?iso-8859-1?Q?ipOEaFUuw4zPYSs1GXnLiu1hXJCtQYEw/4L1aM5UwPaOdFU0rVvs8EnKlY?= =?iso-8859-1?Q?jXDmrt3jxWNzTMxGMDmMYo8+RF1k3ZL2IxecEwO0TAw/oSABbiKxzUqyGb?= =?iso-8859-1?Q?oDsGk8twZTlbgtxRQ2t14u098PFkwuojsNy/v+UTXNX1EVrTud56M5Tu4U?= =?iso-8859-1?Q?CbOZh1FZ5AjN2Ove+f1ZbQGkx/xD42fWXvo2db7pKB45mndZ7l9D9hGWVp?= =?iso-8859-1?Q?kDp2a3ah46sHfqvB8gNhOCNha0yW7WiUE1cSHR7nsjN3d2t2f+takoORYA?= =?iso-8859-1?Q?sKHXnL4+L4SOODvBca1BSaKwyDwD6zIzEZ+OB8HlxU/FSHlqsNJ1e18rfO?= =?iso-8859-1?Q?owztN97v5pvP0vt3bmNdsb8YgmNY2foVpL2rxE2ewzEplBJ9Wl8Ec2HKu8?= =?iso-8859-1?Q?t4RTvYje4Vm0pQr8LVwZL6iekrHDWaLPUK6Jmy2fX1X5blCHLXPCZGyWly?= =?iso-8859-1?Q? X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-fb43a.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PAXP192MB1608.EURP192.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 0dae94c5-ef31-4d2d-a189-08dc04c52251 X-MS-Exchange-CrossTenant-originalarrivaltime: 24 Dec 2023 21:13:11.0365 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV1P192MB2001 Received-SPF: pass client-ip=40.92.59.54; envelope-from=vincent.b.1@hotmail.fr; helo=EUR03-AM7-obe.outbound.protection.outlook.com X-Spam_score_int: -5 X-Spam_score: -0.6 X-Spam_bar: / X-Spam_report: (-0.6 / 5.0 requ) BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_FROM=0.001, FREEMAIL_REPLY=1, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_REMOTE_IMAGE=0.01, T_SCC_BODY_TEXT_LINE=-0.01, URIBL_SBL_A=0.1 autolearn=no autolearn_force=no X-Spam_action: no action X-Mailman-Approved-At: Sun, 24 Dec 2023 22:20:32 -0500 X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.devel:314197 Archived-At: --_000_PAXP192MB16082462DE71B69A33593E3E849AAPAXP192MB1608EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you Andr=E8s for the feedback, I have just pushed to master the improvement in ses+ documentation, and two= other fixes. One is just an optimisation of ses-insert-row that was not re= ally optimizing anything, and the other is about ses-formula-record, that w= as not recording anything, so the ' (ses-read-symbol) auto completion was n= ot working. Vincent. PS : Now the head of my dev branch is this [https://res-h3.public.cdn.offic= e.net/assets/mail/file-icon/png/generic_16x16.png] ses.el ________________________________ De : andr=E9s ram=EDrez Envoy=E9 : dimanche 24 d=E9cembre 2023 16:44 =C0 : Vincent Bela=EFche Cc : emacs-devel ; boruch_baum@gmx.com Objet : Re: using ses programatically (was: a ses question) Hi. Vincent. >>>>> "Vincent" =3D=3D Vincent Bela=EFche writes: Vincent> Hello Andr=E8s, Vincent> That is a good point that ses+ needs better documentation : I = attached an update of Vincent> ses.texi, [cid:55adc5ac-b103-461e-8604-536c90cae07a] Vincent> ses.texi.diff[cid:240f77ca-5cdb-40fb-b4c2-ee89a0eba1d4]ses.texi. Vincent> Do you think it is OK ? The documentation change is Ok. Vincent> Concerning the ses-setq and change of ses-range, I realized th= at this makes a Vincent> regression on ses-insert-range and ses-select, I have made a f= ix to ses-insert-range Vincent> here : [cid:c43f099d-1b5e-4b57-a9f0-7feb40546350] Vincent> ses.el, I st= ill need to fix Vincent> ses-select, since this is not a macro I use, it will take me s= ome more time. Also, Vincent> documenting this and writing tests is still needed before I me= rge my local dev branch Vincent> to master. Take your time. And let me know when that part is completed. Andr=E9s Ram=EDrez ps: I have a second case (improvement) for discussion (about keyboard macros and ses) --_000_PAXP192MB16082462DE71B69A33593E3E849AAPAXP192MB1608EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you Andr=E8= s for the feedback,

I have just pushe= d to master the improvement in ses+ documentation, and two other fixes. One= is just an optimisation of ses-insert-row that was not really optimizing anything, and the other is about ses-formula-rec= ord, that was not recording anything, so the ' (ses-read-symbol) auto compl= etion was not working.

   Vinc= ent.

PS : Now the head= of my dev branch is this 3D""ses.el

De : andr=E9s ram=EDrez <= ;rrandresf@hotmail.com>
Envoy=E9 : dimanche 24 d=E9cembre 2023 16:44
=C0 : Vincent Bela=EFche <vincent.b.1@hotmail.fr>
Cc : emacs-devel <emacs-devel@gnu.org>; boruch_baum@gmx.c= om <boruch_baum@gmx.com>
Objet : Re: using ses programatically (was: a ses question)
 
Hi. Vincent.

>>>>> "Vincent" =3D=3D Vincent Bela=EFche <vinc= ent.b.1@hotmail.fr> writes:

    Vincent> Hello Andr=E8s,

    Vincent> That is a good point that ses+ needs better = documentation : I attached an update of
    Vincent> ses.texi, [cid:55adc5ac-b103-461e-8604-536c9= 0cae07a]
    Vincent> ses.texi.diff<https://1d= rv.ms/u/s!AkDIBBjRAOVwg3ZPAidBAE7SrkLK>[cid:240f77ca-5cdb-40fb-b4c2-ee89= a0eba1d4]ses.texi<https://1drv.ms/u/s!AkDIBBjRAOVwg3UshpzT9ZLCIiDf&g= t;.
    Vincent> Do you think it is OK ?

The documentation change is Ok.

    Vincent> Concerning the ses-setq and change of ses-ra= nge, I realized that this makes a
    Vincent> regression on ses-insert-range and ses-selec= t, I have made a fix to ses-insert-range
    Vincent> here : [cid:c43f099d-1b5e-4b57-a9f0-7feb4054= 6350]
    Vincent> ses.el<https://1drv.ms/u/s!AkDIBBjRAOVwg3f1R7Le1n3L7qVe= >, I still need to fix
    Vincent> ses-select, since this is not a macro I use,= it will take me some more time. Also,
    Vincent> documenting this and writing tests is still = needed before I merge my local dev branch
    Vincent> to master.

Take your time. And let me know when that part is completed.

Andr=E9s Ram=EDrez
ps: I have a second case (improvement) for discussion (about keyboard
macros and ses)
--_000_PAXP192MB16082462DE71B69A33593E3E849AAPAXP192MB1608EURP_--