From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id 6ORSNUo64mA8nwAAgWs5BA (envelope-from ) for ; Mon, 05 Jul 2021 00:46:34 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id YIcjMUo64mDoJwAA1q6Kng (envelope-from ) for ; Sun, 04 Jul 2021 22:46:34 +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 B059C2D24A for ; Mon, 5 Jul 2021 00:46:32 +0200 (CEST) Received: from localhost ([::1]:56638 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1m0Asg-0003MH-8T for larch@yhetil.org; Sun, 04 Jul 2021 18:46:30 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:58866) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1m0AsJ-0003M7-41 for emacs-orgmode@gnu.org; Sun, 04 Jul 2021 18:46:07 -0400 Received: from mail-pf1-x432.google.com ([2607:f8b0:4864:20::432]:42771) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1m0AsH-0004on-2e for emacs-orgmode@gnu.org; Sun, 04 Jul 2021 18:46:06 -0400 Received: by mail-pf1-x432.google.com with SMTP id y4so15048635pfi.9 for ; Sun, 04 Jul 2021 15:46:04 -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=ICKn2+iRZN6IYBQHLMEfQOZvqwWFQ7IZ6lfu5vY2FoI=; b=g0sSTXf4aQ4klPgonk1xzVZUfb7fjsM8xIs1vXObOFcugEDC5N0Qxs7Ms1ltPwbahF oBmsof+HAeA5TgBnuNBQhnYsxkFpqmVSP2plDpyvABWgCg2Jp/7CGVIW3FFxfP3T/Ayl s6M3bEub2k4N40nSwiYtZF8NnyuTKrLlfbln5C+JKbO0V+bmqwBruMAyM3X/sgMCONyB 2ETSxuuL9fzt8+W63P6iHAW45AZAwRph+NKR3c3t6qaToH1cMvoTW3JMl61Q0l8RKPS8 4g+JDahOPsfHAo5HGMkM0RM9syF5JcfPkB4Zc1G1R3f37oK0L52LjcjI6hPrgNZPLLUx taQg== 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=ICKn2+iRZN6IYBQHLMEfQOZvqwWFQ7IZ6lfu5vY2FoI=; b=A/IqytEhTIxWcv3MZwFp6D51hiGB3V4sNSNNFNVVMxbhEceIie6fankVzE55NfOZji 1H1pV5+0LK2GEYDfPNJ0eva+W9I/4vESgy5ltdQyfD36fhXpyYDuNldO0hiTApNLG09R iOUnkOqZ8iddSb/EQv5VdlM58o2cMnMGP0MWUWUQDWHDyQHtsKdLZHJcx9JKxLDwClXe C43DuXHjPYU5ZrMnSXzHzFcQKlooP3uIMW/X+2Lk0zEuewqSZCFkUN7ZrNvSgfrgHZep 8X0M5Q002233ZPF5Mr2H+mz4Q4hY+pSA2NRoasZa2gEy8V4NVvNrWTJYCID8KTxk/y78 gjuA== X-Gm-Message-State: AOAM533NRAE1nzjmqHKZ+8Fay4QZs5XsQHjWm+//Fc63HCvnggjEk29r 9xSoITQm+AqMgjAUHFSCI5gMR65dR+0= X-Google-Smtp-Source: ABdhPJylKcC0gZRr749ZuEWSJ8sjaL4aBuyJr9qUgMUtGO0GUjFY80+B0CbxBO6DX5EkrTyevTNRaQ== X-Received: by 2002:a62:bd1a:0:b029:2fe:eaf8:8012 with SMTP id a26-20020a62bd1a0000b02902feeaf88012mr11443034pff.45.1625438762675; Sun, 04 Jul 2021 15:46:02 -0700 (PDT) Received: from tim-desktop (106-69-128-130.dyn.iinet.net.au. [106.69.128.130]) by smtp.gmail.com with ESMTPSA id w123sm10475743pfb.109.2021.07.04.15.46.00 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 04 Jul 2021 15:46:02 -0700 (PDT) References: <87o8bickwk.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: Mon, 05 Jul 2021 08:00:56 +1000 In-reply-to: <87o8bickwk.fsf@mat.ucm.es> Message-ID: <87fswtn1ei.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::432; envelope-from=theophilusx@gmail.com; helo=mail-pf1-x432.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=1625438793; 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=ICKn2+iRZN6IYBQHLMEfQOZvqwWFQ7IZ6lfu5vY2FoI=; b=BUihvi7nFtuyDwItWWpBlSNgWT8lLsh1tdvDR5QPCpBxIpEZvLWk4E8KiW/eftcc8/k8xM s9XyAvdaSnIk5zbgSN2iQYJKbNVGkPImynkXXibjfzErxCQ7cvLkrI4KMbWmN9/ECZhW8c nhFdrkmU2pvaEEWWOzvUPRNdbNpB5OtnJYr556nCt0yLeM5iA+7wUQ9QLXP2KVRCZQoudb bQr7PaCWtsojCL9ePYhhzjr8VSSR8zQNl6X3bjui8p0JDewaMKqipYgAFOlrx5OriLauci +ahPZ5jqrEiiq0Zii6jSZnI1Lor+ByNBK2oxQMNIWV1ZTpbu5iSMGHEfQskuaA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1625438793; a=rsa-sha256; cv=none; b=FcsKeaFNom9PYISDn9IOrjXA/p6LqCpMSgAY18vm66WqkjaHuO2CEvjZr2sNW7BNvmu5FK xb5AXiS2wBWu+d04pxAqvnohEA6EHxHOJIVztIvEtitZH+suJYyFlWQO0xsGzAWkd0JVHM yVAyG5pam/utfGhRxZQQnxKVHCH7j5M+4zVXBDsvpaNTf0zwJFk1nh49d4zymfWs3JDcAm BOVDVvf10m7sSITCLlXYPZxdBUsYRqayBo4+C5zc8hhqHLWBKNAojeotQfBtkur3LzKIQc 7BgUQG6Q7U0korqGM3lZ4ufbfaaDaaFB6qchIaWS51Fy4kCzKUqEjxSfn7Em3w== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=g0sSTXf4; 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: -1.61 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=g0sSTXf4; 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: B059C2D24A X-Spam-Score: -1.61 X-Migadu-Scanner: scn0.migadu.com X-TUID: +J0yKucMCYfJ Uwe Brauer writes: > Hi > > A couple of days ago I asked about importing excel formula into org > tables, and they only ways seems to do it manually. > > I just realised that I need it also the other way around, exporting to > some spreadsheet format, like gnumerica or scalc or xlsx. > > But that look equally difficult, isn't. > > Some hints would be welcome. > 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. - Constantly having to do 'hand tweaking' to fix formulas and other 'meta' information (both directions). When exporting to Excel, I would have to open the spreadsheet in another program to 'clean it up' before sending it to colleagues. - Too many different Excel versions. This issue may not be as bad now, but back then, there were multiple xlsx versions and you would get different results depending on the version. In the end, I gave up and either just used LibreOffice (Linux) or an OSX program (I think it was called numerics, but too long ago to recall accurately - it was not an Apple program). In the end, my decision was to only use org if either I only needed the data (possibly adding formulas manually), would not need to export back to Excel (no collaboration) and only need export to org once. Otherwise, use LibreOffice or another program able to understand xlsx natively. One thing which we did use for a time was to connect the excel spreadsheets with a database. The excel spreadsheet would pull the data from the database and apply formulas/macros to that data. I was then able to pull data from the database into org and then export it back into the database. It took a bit to setup - used Visual Basic to manage data import/export into database and needed an Excel based UI to do some CRUD operations and then some scripts on the Linux side to extract/update the data from org. This sort of worked, but had issues with synchronisation of data. It really needed a much more sophisticated database API to make it work well which could handle versioning or resolve data conflicts and dependencies etc. To some extent, I guess Excel is a good example of what RMS was concerned about and the problem with closed proprietary standards. While someone can reverse engineer the formats and spend the time to develop converters, they remain at the mercy of MS who can simply change the formatting at their whim. Most efforts I've seen seem to run out of puff because of the efforts needed to maintain things. Of course, life would probably be better if so many project managers stopped using Excel for EVERYTHING! I've noticed over the last 10+ years a growing use of Excel in the 'enterprise' as the default 'tool' to collect and manage information. To many, it seems like a simple solution, but in reality, you end up with all sorts of valuable information floating around in multiple spreadsheets and spend far too much time entering/updating data using a crappy interface and tweaking format commands. I've seen more than one project almost hit the rocks because someone was working off an old excel spreadsheet with the wrong data. If you raise this concern, the likely outcome is a decision to use MS Project, then your really stuffed! -- Tim Cross