From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id qK6zIm1slWJzJAEAbAwnHQ (envelope-from ) for ; Tue, 31 May 2022 03:16:29 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id eC+LIm1slWIRXgAAauVa8A (envelope-from ) for ; Tue, 31 May 2022 03:16:29 +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 330662C607 for ; Tue, 31 May 2022 03:16:29 +0200 (CEST) Received: from localhost ([::1]:52576 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nvqUl-00017S-Kx for larch@yhetil.org; Mon, 30 May 2022 21:16:27 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:58352) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nvqSx-000173-Hd for emacs-orgmode@gnu.org; Mon, 30 May 2022 21:14:35 -0400 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]:47079) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nvqSv-0004JI-KK for emacs-orgmode@gnu.org; Mon, 30 May 2022 21:14:35 -0400 Received: by mail-ej1-x629.google.com with SMTP id rs12so23622628ejb.13 for ; Mon, 30 May 2022 18:14:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=eBOQoUBAq+hfZ3enk73rVIDHl7CCODpS6pF1UHp1Tzo=; b=HnBMUIzxw3hcyWhBNN+WllbdxBfoGZx5eoc6cXFdaS7DIxEuhiRB4+uxwbJyLtWdlT XeIIXCkjn05lUzL7wWDB0gffnDTnPuql7xKf95dGiAu2HWiYn6Rmr2IoXocX2BRZp3gj 13HhPb2rXJi+S5S9VQKoLWEEiBPrwCfI8JLsO8cGdJqVXpckXzcbvv9ij4puIIFbTo5O HuZhdDi6DOZSbG/G3osb+BanNYnF2g0qzy5DHVFMcuYiFa+lJwEAfa3Fp6XI2Nb4ddha EeRBU5EQt9onntvuy3Orb+gMzxOQ1X1UQfGLhAmTLiHW/AHRbYFuSclR75nDVWq1sAwu 7SnA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=eBOQoUBAq+hfZ3enk73rVIDHl7CCODpS6pF1UHp1Tzo=; b=25xO7YPOESDLN+1UbdYU3CnZmZnB/nNeTxAr/rOeLe3YbxD9rxzF42nsUzB593asV6 RBId5UlePhjRF63+5IJL+eHZ9iSxybeyhGvjsher36CqUdR4pFhSE7Z5F1QhetigcILt tOmp9CIo7vi3jp/kPUtu/VDm1qPZQzxUxQTTZCet+4S+09+RMjR+cNl56Xb6uvOf/Hr5 8GhfXjryC9BIpkGnaV/XSou7PYxJnMmZ7mDIOxlJPw+omxtgC0sibGQBJMYV9hwSwR9d jrA5iZ+ty8weT4FWi/pqnsxGAfKVbc2sm3FOQgvVSLK08ybwnlGdz+dmMiJq1Mzh+fS6 7JUA== X-Gm-Message-State: AOAM532TzXupkrLekgd4Xt2ABhfG7q8E7sJ2oyHo6lJofJb4tmE0OUft 8mOI6niVlWplYVJdh4ciP8T+MjqXYDRZXyErhsE= X-Google-Smtp-Source: ABdhPJzYtv8zGLmKpSsqGIHRvnMdLyB+n9lRLh+6gtb4yuFgsfXGfXyd8RsDvECWNp4W7PzE99nHBMZwgp9Z+Qcxjcs= X-Received: by 2002:a17:906:6a23:b0:6fe:dccb:d9af with SMTP id qw35-20020a1709066a2300b006fedccbd9afmr37329776ejc.406.1653959671629; Mon, 30 May 2022 18:14:31 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a17:906:478b:b0:6fe:f76c:8596 with HTTP; Mon, 30 May 2022 18:14:31 -0700 (PDT) In-Reply-To: <87bkve3eeu.fsf@gmail.com> References: <871qwbc98q.fsf@mat.ucm.es> <87bkve3eeu.fsf@gmail.com> From: Samuel Wales Date: Mon, 30 May 2022 18:14:31 -0700 Message-ID: Subject: Re: export a org table to ascii format (tabs) are not conserved, culprit orgtbl-to-tsv? To: Tim Cross Cc: emacs-orgmode@gnu.org Content-Type: text/plain; charset="UTF-8" Received-SPF: pass client-ip=2a00:1450:4864:20::629; envelope-from=samologist@gmail.com; helo=mail-ej1-x629.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=1653959789; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=eBOQoUBAq+hfZ3enk73rVIDHl7CCODpS6pF1UHp1Tzo=; b=PbGRdk7800CDZrKUEXWelnTm6F1oVprMEqRs+i9a9WrcJv6Ymud8bsWuXZ/nctVWnohTnR YPB4Yc3wcLatg4Nx7NsySOgp+zHq95OkJhP+Z5JNy5UqPwy8HNsRM41Uuzib3oCEaDHasK 5Kck/Fas5EBNvSoFsbsRylLm6H2MRshK/ZLd5ptOe/G/R7wRc/y+3OdmYJzrHf3WxtA13q 4Wi3zTFiXmqcD7zguQoVt9vN4UkVc72N9RbGymP0wvqS80iDuigsd+Ql4GI/u/dKA3wJnB 2Pq56hegKP2jyql1KXZovpnb6f8iJZC9qqxVpcw27EKNpvD2zkxt9D0K/nKGvA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653959789; a=rsa-sha256; cv=none; b=WMRZFi7/JM06T4BvtOE+Hbcd6heAnGYMq4/Nroq/qp7emEQy0q0QcUMDQ32YY1W0cLvUDH qzqlVHWpeu4PrNqd5IjGCQT4uD+S00DMwvRz9NoMfwuyu5IR/eoUMJq+pTWyTWLRWyLWW9 UMlKgu3q2hb9YPJEQSyX3MUgw3pLcDM48M0raPf1fuEmrkaQEhEi5xkNczMobkFjJYaLmc O9anCwVEbLzttD8mS83YVYBcZrHaYzgveoKmnr/ChGejuBIxyppK/gdgr63dumjTlXhwJy 62HuRi9k2jYslnW4EqIAcaf0nRRHs5WOD8jh+uvD4R799zrRzZlrMW0q64Lq3w== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=HnBMUIzx; 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: -4.13 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=HnBMUIzx; 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: 330662C607 X-Spam-Score: -4.13 X-Migadu-Scanner: scn0.migadu.com X-TUID: yGtEjSfLlv/G some web ui support some subset of html. i think blogger does. then you might have a div. which i think [not sure] might enforce line breaks and also be monospace, or something like that. [pardon my html ignorance.] On 5/30/22, Tim Cross wrote: > > 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. > > -- The Kafka Pandemic A blog about science, health, human rights, and misopathy: https://thekafkapandemic.blogspot.com