From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id qO0vF5hc+mIp2QAAbAwnHQ (envelope-from ) for ; Mon, 15 Aug 2022 16:47:52 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id MNG6Fphc+mK4ZQEAG6o9tA (envelope-from ) for ; Mon, 15 Aug 2022 16:47:52 +0200 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id CD08D385FA for ; Mon, 15 Aug 2022 16:47:51 +0200 (CEST) Received: from localhost ([::1]:56276 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1oNbNe-0001GU-UT for larch@yhetil.org; Mon, 15 Aug 2022 10:47:51 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:41592) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1oNbLJ-0001Fx-Ro for emacs-orgmode@gnu.org; Mon, 15 Aug 2022 10:45:25 -0400 Received: from mail-am5eur02on072a.outbound.protection.outlook.com ([2a01:111:f400:fe07::72a]:32065 helo=EUR02-AM5-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 1oNbLG-0007Qx-9f for emacs-orgmode@gnu.org; Mon, 15 Aug 2022 10:45:25 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=FWEcOETlbtvvdc+hto96pToXN6k/CbeSqVw0vG7uS4sIaRzUOXEd3Nlu7otlvrEaQA/Htyw1VTQNDq2U55Ci5ZJxUf1kdRZHh0zliiL9O9JTMxAklPWbKUpRbE1vBnWYho8vGx5EgeDvxlM5RFvItVJhWO+db4zu4wDtDgaEW55HowXVtNLKTH9C4VvZrqOWW7pbBm3mgL+xOfU/vPtcYvovSi255uaVGbgQ5iEzVaALjlgDU9M9ghr4dZ1jHCOPN3Bx0fHrwYKJidzHJvr+lbYpLY9XO/Ub2GTU2gnMGbliGX20YkiRcSp2odP2QxJcdSrUxLj6YW7j8i+2gmcH9Q== 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=mhJ9WeNjAfC0IQ2hVzcIICwnigpO51t+WJbNnKGhmj4=; b=QErcGRID/R9rcYuwF1ZubU+rrqCzeKWJ27OHVZ+bGKCZdboNHZS4TtJuI6Rjk338HswwA3lsCTqCEMZlMQO2x5QKNl0DfK+eH3RzRkES9G0yJAKzGn5Gu1MEvTKV/UUAhU5Do5b+D7alX5C9voHziPlVQLvakOPoy5w2/XoQoG6j60siBcKm1DnSQsL7trVJCJmxTfcfC3MKYdgp+y8nvdzZ0B2PlYJ1db4D9GhgWu1CO70Od01vrXX2bghpssVH+BYx7jZn3TYGbgD1HgO+86snSkwozLx6BwxvozIWjChkyDng8bDM/0ZmbGCIfencWYxHRVb/uQsfL0wPz7urVw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucl.ac.uk; dmarc=pass action=none header.from=ucl.ac.uk; dkim=pass header.d=ucl.ac.uk; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucl.ac.uk; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=mhJ9WeNjAfC0IQ2hVzcIICwnigpO51t+WJbNnKGhmj4=; b=mvAFKGjEeWrIq7Dz5z1HeMr/Z9Ybl6hdgTXScas1HgaQNuZVqJgfaxtqJF/hBCicf0OyFnE2AyNCgZb36QFqwhmL4j9fFxLfTCgngTnQmSseObxIPsc0V2XlrHdXYwZe6xBn68ogGPnLflhn64dAN/irQd1Ox5WWJtO6ZTMij/M= Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4fa::21) by AM0PR01MB6483.eurprd01.prod.exchangelabs.com (2603:10a6:20b:16d::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5504.22; Mon, 15 Aug 2022 14:40:15 +0000 Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::2da1:6fe4:9ec7:593e]) by AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::2da1:6fe4:9ec7:593e%4]) with mapi id 15.20.5525.011; Mon, 15 Aug 2022 14:40:15 +0000 From: "Fraga, Eric" To: "edgar@openmail.cc" CC: "emacs-orgmode@gnu.org" Subject: Re: how to concatenate string to spreadsheet formula Thread-Topic: how to concatenate string to spreadsheet formula Thread-Index: AQHYsK5VlX3as1uvyE2Ho8t6uqR8RQ== Date: Mon, 15 Aug 2022 14:40:15 +0000 Message-ID: <87o7wlbmeo.fsf@ucl.ac.uk> References: <20220815135059.Horde.0yrWgPRhFF6o7SxGXFD4fgW@www.vfemail.net> In-Reply-To: <20220815135059.Horde.0yrWgPRhFF6o7SxGXFD4fgW@www.vfemail.net> (edgar@openmail.cc's message of "Mon, 15 Aug 2022 13:50:59 +0000") Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) x-url: http://www.ucl.ac.uk/~ucecesf/ mail-followup-to: Org Mode List x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 6d3bc764-f478-49ed-302e-08da7ecc115a x-ms-traffictypediagnostic: AM0PR01MB6483:EE_ x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: yySU3BAT26sOPIzDGB1mBdInLpGPLANWul6s1mHyJXTIzXJX4i1nGb4Dr9Tj0xjANZYPHKmxUmzAU96rpnsUD/qwFkqqCJTyl8JLWPxc+m5xXUM+IFH6c9Fy7VnhHTf5UKRB1pWzRvijSBOrA4P8V4DCDiyK0WnSSnXnFRlK9zoGmrZOLFPWDu+0kNAL9oqX8WDx0ornnQLiMM6wYILIVWHMDAKMZi65Z0Dd+KWq7OwuR9MaL2Waz42k9rkWSUO6/nH7Hi7O8jbJAMR4Vd+IbELA97HaThAVImzeUuqGmsO1hp1Cexq7QY6qTtz1heIBJoR6cP6SXKXNjL4zhYhaOdA0f9RTPzr8/WyXkKUAjpM9NQRsfj/i5pcrFFPMesfoLYAm+QYXkbr7hS9Vh72zS0aPVxqbrv5SRX5bmcqhCMjN2vsfgp64L4rNSjXWEuYt46EL8SLbldj1NFXbnyGbUwo5rJJrTF6y0GhnqHFMNSGSnzsbg13xdamyaIISc0jWkdFEb7oxfao64X/srbKJtfj9iaOnkLQzzbia9k1/ZTdASgbhsvuL2Ycx1cabEwQ2AHfopV6HER355yqNirdaRu92GPn8Kpl8vLLoZSNWHBOecP6s0fhUHTS8wUW9MFC8H2z7BxRBaW1En9CIIClQ6hzQCaseV+ciROHrmsZ5KNYH4cmSFyX8B20tgnsZH6fs0w+Bnza/Y7UdjnM5PlVk2M7EuVKv6BJi2HHQlY26Xo6LI8i/utpUY3lReynlqRedWa5Dzk0z293RMtZ4IUHzZUEtt/Iyz+NpS+4hP3avyrupaIfDvW3KLBtCLILUp7Ms x-forefront-antispam-report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:AS4PR01MB10249.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(13230016)(4636009)(396003)(136003)(366004)(39860400002)(376002)(346002)(786003)(478600001)(26005)(6512007)(6506007)(186003)(2616005)(38070700005)(38100700002)(86362001)(122000001)(8936002)(36756003)(66476007)(66556008)(66946007)(91956017)(66446008)(64756008)(4326008)(5660300002)(2906002)(76116006)(8676002)(4744005)(316002)(71200400001)(41300700001)(6486002)(6916009); DIR:OUT; SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?3/xdqv0k6wWXczS0EGkBinbejJ7UBJsBLwhIhNRVlAcckUr7upA0FAt88p?= =?iso-8859-1?Q?udfJGaIOJNdF9UC9N5PmzO5QDquNhd3RZdOaOPIrNvAtagU4ribzWj+FLr?= =?iso-8859-1?Q?4IMS2XGzD4ga53yzxY9QZHG3KSDcU/LjAIN4kfXf+bvP3RHs7vBV/rNfyt?= =?iso-8859-1?Q?q9axc0auFm+/SGmKxjO+IBd8BVpGPsgcki1yDtE1wTBtqZPxsVbii4yoUL?= =?iso-8859-1?Q?+mTHtipDA60XVHA2yNW6IY+yMGgIRsp0tFF819VcVO0taJaylWnVHVsrNZ?= =?iso-8859-1?Q?LYdPKByKNUg3GBJ/miSYwsgIbSoZ+Wiyt6c6RM+xbWU3YlO5U3UXs8wZfF?= =?iso-8859-1?Q?OIbAwE6ugDyxP9K9CYBNUK9oimLTc01BM5N3Ms/eO5IFZzoUx9hPMV7QlH?= =?iso-8859-1?Q?HB/vH6HKZS33unxKN7wUbpib+kJU4r7HBwybSxEw2hG2iVhlLqH90SODEy?= =?iso-8859-1?Q?dcU0xs4m5o5d0RIFErpUgIrRR5wxWoMRrwOjn9zl9fpS/+Cd6sKUceM9D7?= =?iso-8859-1?Q?if+DXiiUcmsX+WTMvEs12r8VwE90fjoQOTg9dOqIqFLPFlvynBlQrEz0Qz?= =?iso-8859-1?Q?n8bB3BAVpMRSP12P0YZL5Gl8Uq0AhFqua7+JPPCEipmf0cp5vkeDCmYTeb?= =?iso-8859-1?Q?Ml/cN9+bHKT+Ej2ImErC3nRskcywTWzC2wnpC2Y/YZlLKwHQDaKtl85Bmu?= =?iso-8859-1?Q?v242xAZDw4UTjcq6/9Bji4j8vKDiOn8pXXdwovVv8oZiK84g5BYDTaji0p?= =?iso-8859-1?Q?+fI/+VNpOMi5l9/ScjVpS+ZMdnEgaavTssigKuf/iZqVUvvcvXBKaHL0bX?= =?iso-8859-1?Q?U6h9QKUQdBVXpAUP3cF2r7rckVbU6CgSuzXDuWORRYGf+Tf6n8rruI7XTb?= =?iso-8859-1?Q?B3DkyR20S4lJbfCE2ZS6uchCoTxA2ulYdadjYJbfgXw3mrOmaePd/0sqfK?= =?iso-8859-1?Q?isVYmEjz6OUUMaa3z98s9iEZRi0ihfc7ED6zDYM/brnPaqTmOjrZr1buGI?= =?iso-8859-1?Q?gC0PLWkcAOHG+j6erIQEofpMwK1wr4ZrPhPBN5PkMyPDWi5JkBanWIm02N?= =?iso-8859-1?Q?2OdpJqCUSrUQ9Na5ICAKK7BhBzjUSan+1Vp0C998GfBAYMYu2BMthy5llJ?= =?iso-8859-1?Q?B6+bZiNWAx4weu36uSHOr6sXd5q1JVONazDqwczUkLVIhi+MScn/dcdr0W?= =?iso-8859-1?Q?jzmBXK9b9NEwtPfPaY7RjdSkUX4TjrhVPDCumlEnoO17xFysa3Fyj3Cm7n?= =?iso-8859-1?Q?owXHcnc6khVDzIUI8OTz74Uyb962nQbX792D6XArwrcvizdiMGXQE1Mm6m?= =?iso-8859-1?Q?rVcSvsUovwVHc6csAkl2uryxBnc1/Es8kigX7/7ZHib50wMugNKfVXj79q?= =?iso-8859-1?Q?egeOWtW7BGi458Y9ATycinfcSOVR0ZWUm3aCR2tw3Z2mkG6vwsBcBJNQhU?= =?iso-8859-1?Q?eJjl/pG122cfcV9ljCYCFDB6r88UmeEXH1yfX6+NFwK06YrBDNZmG5tFGi?= =?iso-8859-1?Q?uDNGJo4DmH6k1JUnYi7q2F1g73KkGsuxcdMQgcbCyXtxzlY9jrV2/WV9aT?= =?iso-8859-1?Q?r3fb4K74VXmUWYv2m1r5WEiN2a/kLIyV5U7lqQqPN24MUuP2R8De0RbT3A?= =?iso-8859-1?Q?rPl9AfwURiYV8irFMwk7VWMNa3pio3nFzz?= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS4PR01MB10249.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-Network-Message-Id: 6d3bc764-f478-49ed-302e-08da7ecc115a X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Aug 2022 14:40:15.5585 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 1faf88fe-a998-4c5b-93c9-210a11d9a5c2 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: Y1tTFeJ1NFvsxKv1ROpJoD8upjL+66h5lQxbE3eP4cHV6du3FgjWHEvYcoeBnvv667XPRwS40xur4tKtSmNNnA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0PR01MB6483 Received-SPF: pass client-ip=2a01:111:f400:fe07::72a; envelope-from=e.fraga@ucl.ac.uk; helo=EUR02-AM5-obe.outbound.protection.outlook.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-To: larch@yhetil.org X-Migadu-Country: US ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1660574872; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=mhJ9WeNjAfC0IQ2hVzcIICwnigpO51t+WJbNnKGhmj4=; b=MMF6OBVsJiYnmuBEw5fuEaUFyeWgj9zBR8pl4J18jU8pE3JZNP2XQ+njKuL/KhYhRkVrKD esjdytCrY2FA+gNt5gDNgxDH85tgkzEV5B5gWoebvXVzHymRXirfCgMjplgzg0/5W7tyvA 3aQA6ggLKKiNHaf2tyOd7HXxgZuSy+lZfS3QEJif4xptgaBT/UvJ1pymFSYvxIx0FhmRDQ f1S2sHDnVIlQJDli04DkwOHQjuuWEfO9w5t7jUat6ZhQENOotNJOaNmaZL/dUXfM8hEjqg TqxqXA+dA/Y/7puL9H+gfCnkWzjXkDC88CXrxr70/v3Ux9sLswNyYvSfFpBTLA== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1660574872; a=rsa-sha256; cv=pass; b=Mj1HOpe/7X3zuoWCD3FLBD3wWiojYwVlAAEVpw46UovVGylPVjoCaIsomXtYSVzQuFsBrL 8zdOr2n7HeJhDFPeqmMX5QP9Iqd0Caen0+FbX1HP3Bb3Cy/eDYLHQoMkR/Lw2jMdJ3Fo97 6TfiaOSi8wm+r6ZmuXQHbjM8bGEn6rDkMu8WpDcD3LdMnHtMqnbfKtnYuRl2XXVC8nZ+b9 3HHwsWb3xgkPi7/Fl20rLTBjR87JpDYzUc/yllwXkR+E69HFs083h9PxsFe8K2YO56b/cS wZxFLW2IW3+bkqR+lRsUqEEsV2SVx8XL67dq3PYFi04JnVQlD+XDxBT1buPC8Q== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=mvAFKGjE; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -8.36 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=mvAFKGjE; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: CD08D385FA X-Spam-Score: -8.36 X-Migadu-Scanner: scn0.migadu.com X-TUID: 6WarzPJMzdoP Hi Edgar, I did not quite understand what you actually were calculating but maybe consider the following expression for table formulas: #+TBLFM: $3=3D'(format "%s\\textwidth" (/ (* 1.0 $2) $1));N If you specify ";N", the entries are treated as numbers. The problem with division is that if both numbers are integers, integer division is used so I multiply one of the arguments by 1.0 to ensure floating point numbers. HTH, eric --=20 : Eric S Fraga, with org release_9.5.4-720-g4db67d in Emacs 29.0.50=