From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id qCAXOXfL3mB0pwAAgWs5BA (envelope-from ) for ; Fri, 02 Jul 2021 10:16:55 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id NNy5NHfL3mDqfwAAB5/wlQ (envelope-from ) for ; Fri, 02 Jul 2021 08:16:55 +0000 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 EEC7C22898 for ; Fri, 2 Jul 2021 10:16:54 +0200 (CEST) Received: from localhost ([::1]:50246 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lzEM0-0007Ui-PT for larch@yhetil.org; Fri, 02 Jul 2021 04:16:52 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:52548) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lzEL8-0007QX-JR for emacs-orgmode@gnu.org; Fri, 02 Jul 2021 04:16:02 -0400 Received: from mail-eopbgr140094.outbound.protection.outlook.com ([40.107.14.94]:45219 helo=EUR01-VE1-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 1lzEL2-0004Vc-2k for emacs-orgmode@gnu.org; Fri, 02 Jul 2021 04:15:57 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=URmH0wmRvWrj+2ezzmVNPgW/6ilLvDidr+TV4vVUsSVGbWrhJirSwwBCxGBwKYtWUte9IqJV7fGp0VfHeL7eKJcD6eYjwGzNU7Hj0OXsz4KTJlGdzxJUDOPN6N4bfIEWfuPXaD4JzylPdXD3vEaQ/7OC1F16lQBtOu5U4kC8vzMIFzKOm4IFtW/O91eZUWafStEGbQzIxfSZjksWEOQXOZ5XFkiRZIEoaKyicZqIEp1bwSOGPJRSSewdMPDYEDUPX1IVU/+hRXDkY+hsTHja68E7OgzhrmXf/pZ12t8gNH3XNh+1lmbGxm718QeBvvM8mjudwPspAMwwFYrK5gEr9A== 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-SenderADCheck; bh=SpDEcKDAH/qA2Vjx/a0tYQk0SOQyPhozV2zvukxy1cA=; b=OvAUMh4XjP+mtHuavXe5opiKBmBaiYEHRvPObcibDMKAN1KD7jTbTHU4qu5PGQuOe+kiYYEhfODGKUQvgONMMjoJt1thlpY/eVEcgRtY4lRfwBsEV8jfbk7e5XhZhxTsT6OH7/feQ74ZS0LVrKTOSC+q05J6Ut76JOUJPq7CSc9m/57t9Ja/tCzFX50M5iHWGvr7QBBAkibUlYO2GuycWN/nSiTY0x75FPp6Z4yZ9WQIovF9pUgnGULhEuxximark8uwDWKXUh9gPht+b0Yuibd435lDRYLGrnKdb8gMuMLGOIEXSmYupVx41a8W7tAVZjxGod/bvxp2vF658JVWrg== 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=SpDEcKDAH/qA2Vjx/a0tYQk0SOQyPhozV2zvukxy1cA=; b=eDYxsOD3Zx900H3wANFiNRdau2TIKxdZxVUAiCeP8Eu7TrmRav+zBF/vtKzEhFJhlyIZCnruEz29ijWdTmvmKrl/HxpCzvRAe2s81jDCrMaldjIdhlHYJGcl2TLnJZZRVokVGa0fIbzdrnSmCqRpl6rbfAJUFdBjKeIHIjSwDbU= Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) by PR3PR01MB8065.eurprd01.prod.exchangelabs.com (2603:10a6:102:174::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4242.16; Fri, 2 Jul 2021 08:15:44 +0000 Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::49c5:c7a4:70:85f]) by PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::49c5:c7a4:70:85f%4]) with mapi id 15.20.4287.024; Fri, 2 Jul 2021 08:15:44 +0000 From: Eric S Fraga To: emacs-orgmode@gnu.org Subject: Re: how to use complex excel formula in org Organization: On the Interweb somewhere References: <87pmw2577u.fsf@mat.ucm.es> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Fri, 02 Jul 2021 09:15:43 +0100 In-Reply-To: <87pmw2577u.fsf@mat.ucm.es> (Uwe Brauer's message of "Thu, 01 Jul 2021 18:28:37 +0200") Message-ID: <87tuldm8r4.fsf@ucl.ac.uk> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Content-Type: text/plain X-Originating-IP: [2.29.174.230] X-ClientProxiedBy: LO4P123CA0145.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:188::6) To PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from t3610 (2.29.174.230) by LO4P123CA0145.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:188::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.22 via Frontend Transport; Fri, 2 Jul 2021 08:15:43 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: e4d01c5a-5fb4-4e6a-c62c-08d93d319693 X-MS-TrafficTypeDiagnostic: PR3PR01MB8065: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:8882; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: VhRDlwKpuaHenDO4795qLdnHWR/MvDpWha4u8MUexYQCysuJtTpnMqUj9IDt2m2RoQkMGbXeP4LBtMiPWFbOuI3/ejJdsjFtIzCafag+Jz1inCDeQYPUY6NMzCb1Bs1Ne+xWc5EM1LwUvp49okrqPOfnSkql/k+DaUWEte4FKCkf799r44rhnla9RsZL5n0ISTShaIlXihD3h59dmRy60A1Dm+TyBFScMKuznYxjMUBPwrgWjxqtX8Nl6sjr1IF/ebZ0N6H8W4y0dKqdJD+J8Sp0MuP4mzAX5o2oiiL2ngLanlujNPNlmbERtcOPvBR6nU46/fNx1eRQedGBUEj3aK2L7UW64pjgweLuRCs1sEA0W/X01xSBpy/9lEGhhccj1ZsbWrB3jDc/tZfzvBxispglx/OijbFWW1zulMMVbTHAcdFoFxIaVl7icc8XUqG/H22oA3fYYdYlv/0Vhn2ol8T7QSAzfpOYQVraucfmBPJCjsYv3gXfD9m0EjmLzf5sqxafn6Gd59Jx10dvSfFuJ4Oes69+FLGH59+T5HP4mrtql4tyvjS/ia3O4dIhLWwKuww21igiELfZw36RoBje71AGgMs4r4ns8u1ct1HVpoDZUulS/ahlCVUEwM01AbX9Zq1DyVIpMaws3Jy0MGNUS+bFCTLKGWZfly9RJKnjY48dRXyTaQ8qfQc3vESonPDGXxFCuXs9PIKrbW4X017pRAszidsfDcB/Av6zm/GKABDz6n8DrScLqarPPEKzDBnokpO0Kecgmg5DWo2QeHYEh0NFaMl5/JS7uH5t/SEScNxHIkpZZBhvNYx0inKbGV+BCA+v4vm+jhgX6VuQ8b8Adg== X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:PAXPR01MB8415.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(4636009)(39860400002)(396003)(376002)(346002)(366004)(136003)(66556008)(786003)(38100700002)(966005)(478600001)(316002)(66946007)(38350700002)(8676002)(66476007)(52116002)(4744005)(2906002)(86362001)(6496006)(36916002)(36756003)(6916009)(8936002)(6486002)(5660300002)(186003)(956004)(26005)(16526019)(2616005); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?Rbq2OFqIRtd4rgEf3sMi0JedR+S3kNRC5lBaXawjz3dWP6lB2srst+lVfWw8?= =?us-ascii?Q?Ggx2uqQr/d5XedgkZ67qA1XMVQNagFrUlZ7h6Sq0QWjgo0zXn2s2UuRquD5G?= =?us-ascii?Q?kOByKZH1qNlo3xpfReuzRHAeeTYCV8gkZMv8wVnLojBQoRCt1xM/aghqpSI+?= =?us-ascii?Q?D9znwC/y6y1F3DGqCporU0CBNvl4T9zzMPPHebGRzRh5gG8qViYAeMDsBPP+?= =?us-ascii?Q?SfHkwmfDVQjF5kPhuExn3C6cm/NSVWzP9nnXdB4W8McA9VHz4uir4F6tccqO?= =?us-ascii?Q?hLbHt2hnckBLPtzatYHK7ohS37bRpdVru/a+pczieOrC7vA8MQ58p/nrCCOJ?= =?us-ascii?Q?/KjkdDohq9vz1TuVZ8lfxJPPcTwD0Un8oRukduDDh/RTG/wJ/ZCguM0wVPsU?= =?us-ascii?Q?Bxf7fpHUGgiCOmAEXFAu1Cc8dndLrYruXM/letlukU8T4a62WiePIeFkr/BC?= =?us-ascii?Q?xv/6ip29kzxxfW+ZbSm0CqVWMA3ulKhtPL7ySiNBSRKXkP5TkGzBQFhh5Pv4?= =?us-ascii?Q?WSW5uWjKyvIoWBCLaiqzhKLhQhUXh37GDl6j7JIItTvNin2/LRdQkIhsXDjD?= =?us-ascii?Q?tNjfPw86UDZO4Yj3jpy/sB/sIwbN8nbXP68CxZ3NFzOcyBValcz8zBWXFhbX?= =?us-ascii?Q?5kJMuUVWnRQdaPWCKCoDD6o6HZxi23eNrWxr+0ALFOQFu90gNJl32p/FYjUB?= =?us-ascii?Q?rxMrO7lx9LO/6Nb8RCAQgJe2PnbGDmQwrI/MnQMTWz6/W/xfX119GjKX50Rw?= =?us-ascii?Q?B6h6fwo5FZT8BhWPeUmm6tpSlYhlBA1I2S9kTkrNAXIwVFlrDwKMwk2dkQb1?= =?us-ascii?Q?qDfa5PaQFyMQy98NEkvcbdIJ4f/Rfvm43zwooMHgzQ2mv+then5eBh0Z0asQ?= =?us-ascii?Q?nyEBs4tedFuJnY3PdTE1kWyfN97fCrmvoygXkppFpb0XS9PYwm3U+smvoW2x?= =?us-ascii?Q?6B5H4hcp7dyTkbt70yBmOTZBrUmwi77S5eTOKevTIriYveW1jCnjSc0eY/Fu?= =?us-ascii?Q?HgHXn0KDbsffbNyi64z7JE3B3g+0/XCPkvbgaicwt6J91/avys4n/i8Ow1Cp?= =?us-ascii?Q?Z+0NbXDJVR6v9bu4pj58kVHNJlKYUI60E5KT30C1plsv66hrjjMoQJfH4+oe?= =?us-ascii?Q?4HYr89bhrUPCBsY1JFFXO+h6bK8iNxCsV94T+ClMg3QEiJ2UKw28WwWEJkGM?= =?us-ascii?Q?xAVzHe5fkLxMneJJYO2W/1ascnipOq8NiIMOYrw7nP8edgPxX14Js2RXo2Pf?= =?us-ascii?Q?nEN4LOxK2vFToZmCUKwtXxs6BpHRdm1fKjQPJHy8fHTfFElt1/Qya0iw0OOw?= =?us-ascii?Q?xcGOOh0RekeHxvK88yk+1RgO?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: e4d01c5a-5fb4-4e6a-c62c-08d93d319693 X-MS-Exchange-CrossTenant-AuthSource: PAXPR01MB8415.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 02 Jul 2021 08:15:44.1621 (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: iA4iqCX6zNKNh+67JWfT25VbbmlbSBp8h9BsKQW979WUzD2gtKEOZn9GtFaOEEWT0k2jPDoDkslViiq2agAfLQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3PR01MB8065 Received-SPF: pass client-ip=40.107.14.94; envelope-from=e.fraga@ucl.ac.uk; helo=EUR01-VE1-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, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 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 ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1625213815; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=SpDEcKDAH/qA2Vjx/a0tYQk0SOQyPhozV2zvukxy1cA=; b=BtlbzBv6U1XqmggoX7+35TGCqBgAQc74Bj2omzEifUv3OxpZkkKV3NesJNm75Mx0jfwccf QMGWtIXQ6ZmhLF/M+Z22a0E6BnsDCViuyebtA3CYtCL9Bmrhlytugnc+7yd792QlxG4uIi Ttn0YSEDJ/xVH265IguQVLPyWDVmh5uCib28Jq+Lv6mVB2DVKGawYiKaRRj0MruzcnmLfN KbFeK89I5s4rX1C/6zVFu075y3jh6fW+zxpoOcSJMh+RukuXbY786AiFjM19hfgZaiyosx ePF7EAB8c9Yq4Ka10cD/tYKntY/vmLxTOUDvu2zMIrXXrAS27JZIJ9q9/LyskQ== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1625213815; a=rsa-sha256; cv=pass; b=ZRRGGAR7YfaIJGgdhbawsvv8BY7UCZ+09h1HUvquoAPBLcHBqEfoVgDsDrT46HpQyw4AEt ByODKHKoRraSBwkduIAhm8ysEAh39FBzVeRFvDAfvpPvL5+/AH7N3NssqUAJeVA7EvQhXT Wvoas0JjPFM+bvgK943BZJX4kI6FYStvs6osylOOZqw5n5/7Afiw2y3JJddYQC9VWy7v3u XGawcb3XRfa/mf5BJbjR+bWC+Qs1okGwML/lGUvCj4HNKS48S6uEJRlk7vKY9Ljh7Pg7kH btKFk2Agu7Dgk7z+rJNJfamQxBjyXxYhDrai2Vs8f0ips+ke9C/a7toz/ZVyKA== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=eDYxsOD3; 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@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -2.62 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=eDYxsOD3; 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@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: EEC7C22898 X-Spam-Score: -2.62 X-Migadu-Scanner: scn1.migadu.com X-TUID: /98uzDej1/CN On Thursday, 1 Jul 2021 at 18:28, Uwe Brauer wrote: > I currently have to collaborate with an excel file that contains quite a > bit of complex formula. Do you need bi-directional collaboration? If you do, I doubt there's a solution out there. Collaboration with people using MS based tools is challenging (being polite here). > I cannot simply import the file via xlsx-->csv-->org xlsx is XML based so you could, in principle, read the information directly from the xl/worksheets/sheetN.xml component in the file (the xlsx file itself should be a zip archive). The format will consist of entries such as FFXX... where FF would be the formula (and XX the value of that formula) for entry in A1. Lots of detail omitted in the above, mind you. -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-577-gf76d4d : Latest paper written in org: https://arxiv.org/abs/2106.05096