From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 8EE9415808B for ; Sat, 9 Apr 2022 15:36:58 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id B8090E0958; Sat, 9 Apr 2022 15:36:51 +0000 (UTC) Received: from mail-wm1-x331.google.com (mail-wm1-x331.google.com [IPv6:2a00:1450:4864:20::331]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 426F4E091D for ; Sat, 9 Apr 2022 15:36:51 +0000 (UTC) Received: by mail-wm1-x331.google.com with SMTP id 123-20020a1c1981000000b0038b3616a71aso7395930wmz.4 for ; Sat, 09 Apr 2022 08:36:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:mime-version:content-transfer-encoding:message-id:date:to :subject; bh=6i0APHZZcUZpSr9nNjfTvxV5G+WaFLR7h/DqwNxD1TY=; b=AGqLLnKjHcT0emw5VtcvMS8hiFwG7FqGMJkVqwkd5h6dmAGv2hpc9Wl1A4r0wkw2Uq aGgcJ7SBnedvyQ4UQtuxVUW/cS9QNxM96iPnIJXNu6iQh1+4uBKDIsoPINERg5ElKCdY odEIXoMtWFnzt9XMwBwul5YZ/1qLiO52G8kCtMvbje1X4Yy4anRx9mr+YEEtZcP7y3Gz XBKlinP6LZGE+HqXT+CRlbDPyF3ZV9JKrOV8lb/uiX9XHzfGdGQmIKdYE9vIFcuUMMWC 9xqW+fFK7ZoTVjBNfT37ISpkW+5WkKhjtwkgUSPbzhWom+aShk5KOorIsBidZeEdkaki 9Tyw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:mime-version:content-transfer-encoding :message-id:date:to:subject; bh=6i0APHZZcUZpSr9nNjfTvxV5G+WaFLR7h/DqwNxD1TY=; b=a+GWQvoy65g7t63PCwMT+Aq1R121pyzXMnHtxiY1PHPV9QAUQHi6ESbQQwHSyDihAk f+7nNtVSh4vbyZJVau6W9Ke+pyWTxfOL+pD1PnnvU+WPV/Y2S64fVNzSuszifM7rZt1t ZBb25L9vfkNivwZK1XnGbIGp4gDUzt40sImTJBN4Av+Z0rEOD1yrdM4fBclyNYHcIJCw qiKpq1iYnirbxEXKYw3gx3Yo7Tx7tprII2xBGBL0wDN+bxhMpMCzrBnY9BEIZ1JR7VK0 /7IKUFH0W+7+l+mV0jc1QAVE5YEIQKh8scprtEYvu3jKpXVgw721BHJt4drudpDsR0Qz wXYQ== X-Gm-Message-State: AOAM531L6MoHyuoMqEFLE5vrXEpUcZQFoU380thc2W7sohcr81Z6sFpr S+mOfhCq6zGD3Kvumza/fcrL+b7JIJc= X-Google-Smtp-Source: ABdhPJyhe+YKwyvLxmqF/LHe7lw29/27jbOlH2GatAOQlP4ZJ3TVX5/0xHfSpozMOOOJp6TtTEr5Sw== X-Received: by 2002:a05:600c:35d0:b0:38e:3564:e795 with SMTP id r16-20020a05600c35d000b0038e3564e795mr22612815wmq.112.1649518610044; Sat, 09 Apr 2022 08:36:50 -0700 (PDT) Received: from gmail.com (p200300df0711f618db38eac356951d70.dip0.t-ipconnect.de. [2003:df:711:f618:db38:eac3:5695:1d70]) by smtp.gmail.com with ESMTPSA id ay24-20020a05600c1e1800b0038eb51fbb2bsm1284304wmb.45.2022.04.09.08.36.49 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 09 Apr 2022 08:36:49 -0700 (PDT) From: Dr Rainer Woitok X-Google-Original-From: Dr Rainer Woitok Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org X-Auto-Response-Suppress: DR, RN, NRN, OOF, AutoReply MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <25169.43020.201048.999635@tux.local> Date: Sat, 9 Apr 2022 17:36:44 +0200 To: gentoo-user@lists.gentoo.org Subject: [gentoo-user] Footer line with LibreOffice's Calc? X-Mailer: VM 8.0.12-devo-585 under 21.5 (beta34) "kale" XEmacs Lucid (x86_64-pc-linux) X-Archives-Salt: 2b498bb5-bf95-45b3-8403-0d8d085a5a35 X-Archives-Hash: b4afaf9696a1eeaafd8b07403ae25eb7 Greetings, are there any LibreOffice Calc experts on this list? I have some "*.xlsx" files which were created with Excel under Windows. These feature a "footer" line, which for instance compute the sums for various columns. If you use Excel under Windows and insert a new row before this footer line, the sum in the footer line will be updated acc- ordingly. Using "Calc" this line is a normal line, and inserting anoth- er line before it does NOT adjust the row numbers in its formulas. Googling for "libreoffice calc footer" pointed me to clicking on "Head- ers and Footers" in the "Insert" pulldown menu. However, this is greyed out. Do I need special USE flags to activate that? Or are ther other methods to update the formulas in a row when another row is inserted be- fore it? Any help appreciated :-) Sincerely, Rainer