From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id SA6+LNeI42CvAwAAgWs5BA (envelope-from ) for ; Tue, 06 Jul 2021 00:33:59 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id uCxDKNeI42CvKAAAbx9fmQ (envelope-from ) for ; Mon, 05 Jul 2021 22:33:59 +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 AD9EF20880 for ; Tue, 6 Jul 2021 00:33:58 +0200 (CEST) Received: from localhost ([::1]:45444 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1m0XA5-0003pC-Om for larch@yhetil.org; Mon, 05 Jul 2021 18:33:57 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:57556) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1m0X9i-0003oy-7T for emacs-orgmode@gnu.org; Mon, 05 Jul 2021 18:33:34 -0400 Received: from mail-pf1-x42d.google.com ([2607:f8b0:4864:20::42d]:46724) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1m0X9g-0000e0-Nd for emacs-orgmode@gnu.org; Mon, 05 Jul 2021 18:33:33 -0400 Received: by mail-pf1-x42d.google.com with SMTP id x16so17758551pfa.13 for ; Mon, 05 Jul 2021 15:33:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=references:user-agent:from:to:subject:date:in-reply-to:message-id :mime-version; bh=uAZNPLhj42GtukXPCofTr6/e1YwOYtE4TUf4s98GrHA=; b=BSlfrUXL/PSEFj51q8MQ9u6tSTEiLUXCVCbBE1sxhjioDakgB0zOGULs+EkuVB95Wn 4oFvx2O+du+XtBUoSNpgASRiS7C5dzsv5cMV+xg886rj4U0/1nOfT+lusZgICfPy53no lan2qm4AQ9vi2ONOoGJWtZzdO8W6WhJtpPt4o1GB3bjzIuZEZ4/GeVaQJdCRoASCrDsJ uEAwoFp8YpR/MGmmWq2zcUro/sCp61OT6IL/iAcHmc6TpwYtOKzpMm9fdJDoGW/j3dR9 Wd1LO7Ko6n/duaGPh+6SsTDMsBwqJ6Q6sH0L46fElL6YIvGMMB0bS4XIbP1r5v0lcB3w 5fjg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:references:user-agent:from:to:subject:date :in-reply-to:message-id:mime-version; bh=uAZNPLhj42GtukXPCofTr6/e1YwOYtE4TUf4s98GrHA=; b=Lr9ni7Oqj5GwLyi6A1E6+sPRpGORPtjRLsUYHEdc6RfhVxOFTnemywZM6Bwt+R9e+f RCn+JC+J+A6Sds50m+QlPIowRP3GcUcrBSFB8An4eGpwshCytCHejozWBEUQJbn2NeA7 mdjwPfz1Gz+Wubuy34i+w/6x4t//3o6MvSgOxx+Tsz3i9bVCZ7Kunlna4aCe98iYfozr IDU0RY5QcFzk3f9Cn0yvSJ9qsRB0zNz7SDghVmLgmspMM6YauoK3MWHD9O8HHtL5Yklz t8CPxTK0tdOmwhA/e4P3EyEYZ3doE26NCEy+AJY/F3DluE5yHBTcdFS0Mm5GqAG9Unl/ 4kZA== X-Gm-Message-State: AOAM5328rTrHziHadJHrWWtdMHvLO1VV1Aw1yo5ujiwb5jKgOMLGJskh ToT+TzfTZ9EZUvpoTfzYT90pQAXRCJk= X-Google-Smtp-Source: ABdhPJzeIMWedQDuO0oWQNRvqNHrFaQzhWGEaSlGVOsAK9niGjbM3pvu6AdJowADR4klq/CGQmZAPQ== X-Received: by 2002:a63:2313:: with SMTP id j19mr17801610pgj.42.1625524410931; Mon, 05 Jul 2021 15:33:30 -0700 (PDT) Received: from tim-desktop (220-235-1-69.dyn.iinet.net.au. [220.235.1.69]) by smtp.gmail.com with ESMTPSA id a31sm15702652pgm.73.2021.07.05.15.33.29 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 05 Jul 2021 15:33:30 -0700 (PDT) References: <87o8bickwk.fsf@mat.ucm.es> <87fswtn1ei.fsf@gmail.com> <87lf6k4xvm.fsf@mat.ucm.es> User-agent: mu4e 1.5.13; emacs 28.0.50 From: Tim Cross To: emacs-orgmode@gnu.org Subject: Re: export org table to other formats (gnumeric or scalc or xlsx) Date: Tue, 06 Jul 2021 08:29:55 +1000 In-reply-to: <87lf6k4xvm.fsf@mat.ucm.es> Message-ID: <87pmvwbdc8.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::42d; envelope-from=theophilusx@gmail.com; helo=mail-pf1-x42d.google.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, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=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=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1625524438; 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=uAZNPLhj42GtukXPCofTr6/e1YwOYtE4TUf4s98GrHA=; b=uYy2WaHbOW7oOZsi7PZwFC3bA0+hUUbSN8VMUCCtry7evzv3Vi/9AYniJAeqER6HBfJq9C tzzp5fKANqk7InbntrCgwmIPX0G2gGCHrsxZJB3U8ddDy6ea0rT53EecNZy/v72tm61Htd qMnYanWgsagMyFSJbjUs49RjulfyIk6/fp+PXtDrHw9gyD09tkOYR/u/6WeIeZDjSgBFpY WThxtFd9ow0qI150CoLGc/tYvoL7vLvYci9QKmwTXhkvKVSe6DT1au+a/iyCyI5NSsKw/q rqlXcJSoSThaGNjEMt3tmDlNiC6Rnv1BnGlk20tPhSKjWABfAM/IfOi+EmncSw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1625524438; a=rsa-sha256; cv=none; b=tm6wDN1LiOdXJhlqMQTinckc10hn+B1Lq5idhTwEM4wihbv34jY6HqCvw225EllycjusEP pHw60GJNDFd6oDfInSembCqF01r6ba2wJJOBoCjlwYR3VCiAqrrxQ23kmWkj+kNEa1q7Hr JvNmktqQCRVsI84hk69VLu66ZzGBgChKJz0SGNTwO4aJGAWjNDLDyv4lPP+XEe36ULIp+8 eTXWNKv5OdEsMZdFV/IcAoSPuMPn7TPMygdZ4aNkwwW8FErk/1sFeEaaFU9d5/sFvPyyIh CIXkrdXPEPNntCvSQBLqckR0O13y52ujyu1Bj6q4K0/dRgfd0iDCfphVK9j0eA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=BSlfrUXL; dmarc=pass (policy=none) header.from=gmail.com; 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: -3.11 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=BSlfrUXL; dmarc=pass (policy=none) header.from=gmail.com; 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: AD9EF20880 X-Spam-Score: -3.11 X-Migadu-Scanner: scn0.migadu.com X-TUID: KANM4KGHEAWY Uwe Brauer writes: > [[S/MIME Signed Part:Undecided]] > >> Uwe Brauer writes: > > >> The big problem here is that there is no single format understood by all >> these different programs which you can use. While CSV works OK for data, >> it does not support formulas and other meta data. In particular, >> translating formulas is a real challenge. > >> I went down this rabbit hole some years back i.e. having a workflow >> which allowed me to interact with others who used Excel and allowing me >> to use org mode. > >> It took hours and hours of additional work and never worked reliably >> because > >> - I never found a way of 'exporting' to a format which could be imported >> by Excel and included formulas > >> - None of the Excel export formats support full export of Excel - >> especially at the meta data level i.e. Visual Basic macros and other >> 'objects'. Workbooks were a real pain. > > So if I understand you correctly you exported/imported formulas > *manually*. Yes, that was the big stumbling block. (plus anything which was based on Visual Basic extensions is not exported by any of the Excel export formats). When collaborating with others, this becomes a real issue because there is no easy way to detect a formula has been updated/changed/added. I ended up spending more time working on improt/export than actually working on the data in the spreadsheets themselves. > > One of the problems I face is the fact that org-table formulas are > column based and show as such, while excel and friends only reveal the > formula for a cell and so one is forced to take care of this difference, > manually. Exactly and there is way too much scope for human error! -- Tim Cross