From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id AAn6Hx+ujGQo5QAASxT56A (envelope-from ) for ; Fri, 16 Jun 2023 20:46:55 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id IEsCHx+ujGQR/gAAG6o9tA (envelope-from ) for ; Fri, 16 Jun 2023 20:46:55 +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 2462110AB4 for ; Fri, 16 Jun 2023 20:46:55 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qAESl-0002TX-N7; Fri, 16 Jun 2023 14:46:23 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qAESe-0002QV-9b for emacs-orgmode@gnu.org; Fri, 16 Jun 2023 14:46:16 -0400 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1qAESc-00029d-7U for emacs-orgmode@gnu.org; Fri, 16 Jun 2023 14:46:15 -0400 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-3090d3e9c92so845239f8f.2 for ; Fri, 16 Jun 2023 11:46:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1686941172; x=1689533172; h=mime-version:date:references:in-reply-to:subject:to:from:message-id :from:to:cc:subject:date:message-id:reply-to; bh=iHoYowJ/qkybgYEaJGa/uJIS6PhlTx8hQ33E1Ihqyzc=; b=TUZnlD0pkz7pq3pWMiMhZHXqBINid6gEAJ9Gjm2IsMhkH6q1IzDNKnlbLxIN2p68/x izYTi9bYqe/Dx30hWXY2LyVo3NQk3qbSmkq0wp+G2W6aHfJS+DE7gVnw66WUNggZ2+r2 2GDhSzHZYnhsLtS8exVW+5rb1e4fLIRWEr8QwgKaFbwwkdWSjgIozk3nhyqOf+lKWB07 gUZCzZAUWIANlWtdnih8THnJGeo+3v6q0/X1+DVEJYdhqDo+pls+FIhQGCfSn5BP5M0m AXY4MfeA/g5eudLKeeAXPUyjOvFeH6ljvESNt6L9r4qaYP/9kkBrDAAXPF6XEDskCsXt Ayeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686941172; x=1689533172; h=mime-version:date:references:in-reply-to:subject:to:from:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=iHoYowJ/qkybgYEaJGa/uJIS6PhlTx8hQ33E1Ihqyzc=; b=emTjan0sqQSPAepdntOXzQR0xlSB/FzdNgmIZBAboIiSadTGCkM6yDsES20URIt6b0 oq8onE5WEUE0jyrpSGbPaE+VVHUknM+/4j8OBFh54tjiF3rBHv7L3sGMokGskiddZ9M4 Jp1CoHILX65aWOl4uaWp/jxVJKsOffNGSJOPN/4eEetdAkB8wRcyJZTcGshGLOANf2AK RwxI9hbzOUDqjvU3CuqbjN6b7fU4N6BePNDvf+9Q17RhlcTR8V9xn7e3zKEKTxDyZOci f3dieITZWiT+VRg+U2QJDj3jTN77Zx/sJLeKvnsSaGMRF8mMNJIDZueTi2Mfr6krrpWd R0UQ== X-Gm-Message-State: AC+VfDzIgi0UHW3OZIHHUTdb0G0DN7n8uXH6YinT2AnlhNHDxCK5kGLg 1+GtLvH6WNRoii/sSK1t0wQ= X-Google-Smtp-Source: ACHHUZ5asNG3Es/B9znx7BE6Wijm1XBEgidaYibis76xLxeSrj/z9mYCVqmPYo4QemZbfAZiU7ajGg== X-Received: by 2002:a05:6000:104f:b0:311:110d:5573 with SMTP id c15-20020a056000104f00b00311110d5573mr2042713wrx.64.1686941171785; Fri, 16 Jun 2023 11:46:11 -0700 (PDT) Received: from keynux ([2a01:e0a:505:3460:169:7511:f49a:58eb]) by smtp.gmail.com with ESMTPSA id m4-20020a056000180400b0030633152664sm24226144wrh.87.2023.06.16.11.46.09 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 16 Jun 2023 11:46:11 -0700 (PDT) Message-ID: <648cadf3.050a0220.db2ee.5e96@mx.google.com> Received: by keynux (sSMTP sendmail emulation); Fri, 16 Jun 2023 20:46:09 +0200 From: Bruno Barbier To: Uwe Brauer , emacs-orgmode@gnu.org Subject: Re: org-table, empty cells and nan In-Reply-To: <87cz1vibxm.fsf@mat.ucm.es> References: <87cz1vibxm.fsf@mat.ucm.es> Date: Fri, 16 Jun 2023 20:46:09 +0200 MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2a00:1450:4864:20::430; envelope-from=brubar.cs@gmail.com; helo=mail-wr1-x430.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, MSGID_FROM_MTA_HEADER=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-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1686941215; 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=iHoYowJ/qkybgYEaJGa/uJIS6PhlTx8hQ33E1Ihqyzc=; b=iOBTYoe3EAmvOBxDFQU97YxVWPp4Tt0guACLdGp+MIRcYMpIJKmmzyCgaFl2N/FwW75HZA C2THvXsb9BnvsVfRHagsOHOXAbHSxymWmW1jjenzvRt2zNQq6AcFDcnnVbaB5VpXQT2hV1 +k1plTELAaWOXND5FiGnV+CQjPJqav6fU2rGo2uqEQskHzgC+35BzgpuG7GAfQz0NyjWQG LSZ4OjNbDNVFQf+2zYOlF/ZYDkqMt1inWlR0K7rHzfQlcY2BisXeIYL5Dgi9gVnu+dKNZO ga2lSM+Ea/EOeGZ8kdW/NJCs/A5dTUUGY8iCkKwvj0FdbFygoZ1r/Qfi/JT/ow== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20221208 header.b=TUZnlD0p; 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" ARC-Seal: i=1; s=key1; d=yhetil.org; t=1686941215; a=rsa-sha256; cv=none; b=O/fsh8Rvl6g0HCDQ2Bou8tdgPBIDHQmBw+mktCmvAGcU11V9Az2kPjC/14uQJBN8/Yz46l nFMB/fqhqabdEBvDoIf8irvs5qwEvVlZSHumzeFtpA4qr1jiV1dHu2j42o/5lvPiiFxfRV DN6KjOkFfbQr/I7rkGuyzfyN0VuSqlB+lEuJMp+qIVAwsNT+/Qp7OIzaWjmE62kDoHK+w9 usrZju8q+nHo99ftTTe8aAWjWYW/0n/35GMYMTWiJYpJtNHVOq5lW5Jc6Ck+XoN/h+qUWn O7kvxRH0NJYWftAwOGLSItjO6IEvDslFpANm2WHC91sW6ABZUs3KmgmdCv9cEw== X-Migadu-Scanner: scn1.migadu.com X-Migadu-Spam-Score: -4.89 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20221208 header.b=TUZnlD0p; 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: 2462110AB4 X-Spam-Score: -4.89 X-TUID: YE2CnOe8kxeL Hi, Uwe Brauer writes: > A solution is to put 0 in colum 4, but for some reasons which are a > complicated to explain, I want to avoid that. > > | Name | Exam1 | Exam2 | Exercises | Ex1_Ex2 | Total | > |-------+-------+-------+-----------+---------+-------| > | Smith | 5.9 | 7.90 | 0 | 5.81 | 5.8 | > #+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+$4); E f-1 > > > > Any idea how to deal with the situation? Maybe this formula? #+TBLFM: $6=if("$2" == "nan", string("NP"), 0.65*$2+0.25*$3+ if("$4" == "nan", 0, $4)); E f-1 Regards, Bruno