From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.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 kAYkDpE1lWLgQQEAbAwnHQ (envelope-from ) for ; Mon, 30 May 2022 23:22:25 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id iA8ADpE1lWI3fwEAauVa8A (envelope-from ) for ; Mon, 30 May 2022 23:22:25 +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 A76F5360DF for ; Mon, 30 May 2022 23:22:21 +0200 (CEST) Received: from localhost ([::1]:51556 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nvmqC-0004MR-SC for larch@yhetil.org; Mon, 30 May 2022 17:22:20 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:54124) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nvmpC-0004MF-Hs for emacs-orgmode@gnu.org; Mon, 30 May 2022 17:21:18 -0400 Received: from mail-pl1-x62c.google.com ([2607:f8b0:4864:20::62c]:33310) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nvmp9-0006Q9-Pu for emacs-orgmode@gnu.org; Mon, 30 May 2022 17:21:17 -0400 Received: by mail-pl1-x62c.google.com with SMTP id f18so11247928plg.0 for ; Mon, 30 May 2022 14:21:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=references:user-agent:from:to:subject:date:in-reply-to:message-id :mime-version; bh=79SBLxWzsatIDenbPrPOqZPtwotW+48GNR1GyHkpzTw=; b=YEDqmhXpfCW8E4RYfoWxcwMd8dLSxXecz80gzWyEFOn4fiQ7xzZ4TNW0e66Uy+22gc Lgot6wFXsRMoxN2XgMpcYNELtE5eLWjHINTbREudOqOc9lNSwTN0PX80empLF/nvFXkt ewaL8WORhwVCYx0BH5Ag+RomxXIdCPxkazOam87H/aUTiDkInbjrP3TO9zVox95I9I0l vBpCkaLPPKbCdd5cel5mT8/MTlzmxOKumTLWwYtARtZ1O19RAVD8qa9R5MK2mk1e3JLA 6kiw/bfVjHAZPnwq7oFVdrdEoW5+SK7cT06r0ZYXg+8Y24CVL0XmnmgWy30/Wfshurrg +gNQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:references:user-agent:from:to:subject:date :in-reply-to:message-id:mime-version; bh=79SBLxWzsatIDenbPrPOqZPtwotW+48GNR1GyHkpzTw=; b=4Nle8czel4OeMTdtEaxSpmvqzawKrDX+0kExKopjaApwMLduBHgbjqAR0KZ+kl2ism UX007hhwgk46vXMNidrk/AGiOxFRYZqDDSXuNqawZ0Q0drBavtZ7I2acp9p4MB1iLfTu rsKkXZKZz/pVUan/1aIZw+HqHAb/f2xxevqx+RBC2k8V2GVG1xZshJ9rfpmAXHMJsYs1 CZEorb1ybOZgajtYCvDxIjfX4EmGT5Fkw3xVvL7BuQsBD9v3eijP1hhfki02Wf4w8Y/b Sh6U6djQTkPXDNMrfDpFJ0TZYBTEKqmptrPsic3K/+y52ZnFJO/0c3yV+ZDCLZ9ELyOp nZ1w== X-Gm-Message-State: AOAM5316Z/QgcAk7Ehl0phOGhaWDFFR0YT1gIx0w/plSwm76j9h20IB1 rdHKne9dePLSs+btLahIwIamKk20iUk= X-Google-Smtp-Source: ABdhPJxCdE9C/Qj9KtLTEwA7pR0j5kO/gBuVCZfonaHZGX3NrekMftnDBeTwn0pzWrXiSwPqJGTqPA== X-Received: by 2002:a17:90b:3141:b0:1e0:6062:9c10 with SMTP id ip1-20020a17090b314100b001e060629c10mr24884595pjb.84.1653945673857; Mon, 30 May 2022 14:21:13 -0700 (PDT) Received: from dingbat (220-235-29-41.dyn.iinet.net.au. [220.235.29.41]) by smtp.gmail.com with ESMTPSA id t190-20020a6381c7000000b003db141a5f26sm8980386pgd.1.2022.05.30.14.21.12 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 30 May 2022 14:21:13 -0700 (PDT) References: <871qwbc98q.fsf@mat.ucm.es> User-agent: mu4e 1.7.24; emacs 28.1.50 From: Tim Cross To: emacs-orgmode@gnu.org Subject: Re: export a org table to ascii format (tabs) are not conserved, culprit orgtbl-to-tsv? Date: Tue, 31 May 2022 07:10:37 +1000 In-reply-to: <871qwbc98q.fsf@mat.ucm.es> Message-ID: <87bkve3eeu.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::62c; envelope-from=theophilusx@gmail.com; helo=mail-pl1-x62c.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, 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=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1653945741; 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=79SBLxWzsatIDenbPrPOqZPtwotW+48GNR1GyHkpzTw=; b=Gr0Lphsw4Q49y+mkoIYk9TEbqphxWyRE/qDBx1d6OqywgLJCfrFAS6Q8muuyCGShlTdsBs BeAYUHI5YKx0ZA1jHMWpSbfMUOVu010thBVBMAuxpjAqzF+Mr/tVOrfu6hpv75l2baYCft ijN5g9UJh5igzb0oJtGJCod8K8pQIKBrG2dGdaCvzByqSc3/s8mZUJwdlyeVNPYjqhHrCq FU+fYFpD7wnrwB3sHxmXE0LaNMH0Mcn6+COI0m4MuRuyp4DrrF+izFUJruFVjKf16cqics wLHcN4b+janZyaQCrj07d+Hg86eYooN3qpF9bpUm7UVM4al1MnjaYvugpqSqcA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653945741; a=rsa-sha256; cv=none; b=nNxYz8wH2/iOsmsInampORfLiRjxku9tErYAVaNuTbxnQvYD5eU5BJf2qVNnkbzD2KOVFg UuOkOVHuB9Kxn8KUp34pNFAf0MTMBROUppd/oNAcKGqPVzdbyUuDBGlm7Py605Jrpm9w4V zQ2JpLVf5r2WbgtyYX/bXLapN5/YRowXt8B4YiTFS/QaegRQQ9x5L78qfbfb9C2nB/4IY1 0QcPburuvzzOuE6wq0fKiOeJdqAZhqVwEHz8ViOm0FeW6Hwxx8csFIIVHKyUVDwT8pqhgZ Kx1MuW3EQncuaCf9THkA7zYNhxPhLV8dxq7Jne7yQpDLRFC1StILiDQpo00zMg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=YEDqmhXp; dmarc=pass (policy=none) header.from=gmail.com; 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.13 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=YEDqmhXp; dmarc=pass (policy=none) header.from=gmail.com; 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: A76F5360DF X-Spam-Score: -8.13 X-Migadu-Scanner: scn0.migadu.com X-TUID: 750R2KzIc53R Uwe Brauer writes: > Hi > > I wanted to export a 4x4 table to ascii to insert it into a web fill in > interface. However the column get distorted. I tried to tabify or > untabify the buffer but it did not help. > > > The problem also occurs when I export the table using the > orgtbl-to-tsv > > #+begin_example > | Course | L | M | X | J | V | > |------------------------------+-------------+-------------+-------------+-------------+-------------| > | Statistics | 10:30-11:30 | | 10:00-11:20 | | 10:30-11:30 | > | Differential Equations | 12:30-13:30 | | 13:00-14:15 | | 12:30-13:30 | > | Master | 14:30-15:30 | | 15:30-16:30 | 14:30-15:30 | | > | Numerical Analysis :00-19:00 | 18:00-19:00 | 18:00-19:00 | 18:00-19:00 | | 7.5 | > | | | | | 19:00-20:00 | | > |------------------------------+-------------+-------------+-------------+-------------+-------------| > | | | | | | | > > #+end_example > > > Converted to > > #+begin_example > Course L M X J V > Statistics 10:30-11:30 10:00-11:20 10:30-11:30 > Differential Equations 12:30-13:30 13:00-14:15 12:30-13:30 > Master 14:30-15:30 15:30-16:30 14:30-15:30 > Numerical Analysis 18:00-19:00 18:00-19:00 18:00-19:00 18:00-19:00 > 19:00-20:00 > #+end_example > > > Any idea what is wrong here? > > I think you might be working under a false expectation. A quick look at the exported table example and it looks to be correct to me - values are tab separated, with is what a tsv format is. There is no requirement that the columns should be aligned, only that they are separated by tabs. With regards to more formatted output options, a common issue is with respect to the fonts people use. If the font being used to view th eoutput is a proportional font rather than a fixed width one, then all formatting will be broken. Most web interfaces tend to use proportional fonts due to their more pleasing look for most people. This is also why tables sent via email often don't look right for the recipient - they are using a proportional or condensed font. As you have no control over the fonts used by those viewing your ASCII content, you cannot reliably make it look well formatted. Either you have to do HTML, some form of markdown or some other format with enforces tgable alignment. If your entering data into a web UI, I would not have any expectations regarding the final formatting as that will depend heavily on what the backend does to the supplied input and how the data is presented to anyone looking at that output.