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) server-digest SHA256) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 6BF32158041 for ; Thu, 21 Mar 2024 21:46:35 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 1BF3EE29B1; Thu, 21 Mar 2024 21:46:28 +0000 (UTC) Received: from out.packetderm.com (out.packetderm.com [173.166.91.13]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id A1A31E29A5 for ; Thu, 21 Mar 2024 21:46:27 +0000 (UTC) Received: from localhost (localhost[127.0.0.1]) (authenticated bits=0) by smtp (5.7.4/5.7.4) with ESMTPSA id 42LLkOv8089155 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO) for ; Thu, 21 Mar 2024 17:46:26 -0400 (EDT) (envelope-from waltdnes@waltdnes.org) Date: Thu, 21 Mar 2024 17:46:31 -0400 From: Walter Dnes To: Gentoo Users List Subject: [gentoo-user] How do I zap a specific area of a gnumeric spreadsheet page? Message-ID: 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-Disposition: inline X-Archives-Salt: 5669a4f0-bf04-44de-bcfa-bee5d8e5513b X-Archives-Hash: 9002f102744439b7c51adcaa949ab811 The province of Ontario does weekly Covid data updates which I summarize and post on the DSLReports Canchat subforum, e.g. https://www.dslreports.com/forum/r33854514-#google_vignette Note the data gap in the pink and brown lines on the 3rd and 4th graphs. That's actual missing data. In the underlying spreadsheet page those gaps initially show up as zeros. I manually blank out region B1258:C1299 (i.e. 2023/09/09 to 2023/10/20) every week when I update so that it doesn't show up as zero hospitalizations. How do I set up and execute a macro to to zap the contents of region B1258:C1299 on a page? I've recently solved another problem with the COVID data that I mentioned in the past. The data files could be downloaded by a browser but "wget" was being rejected. The data keepers seem to be filtering based on the default "wget" user agent. I've bypassed that by faking a valid browser user agent... any valid browser user agent. #!/bin/bash rm -rf conposcovidloc.csv wget --user-agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0" https://data.ontario.ca/dataset/f4112442-bdc8-45d2-be3c-12efae72fb27/resource/455fd63b-603d-4608-8216-7d8647f43350/download/conposcovidloc.csv #!/bin/bash rm -rf region_hospital_icu_covid_data.csv wget --user-agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0" https://data.ontario.ca/dataset/8f3a449b-bde5-4631-ada6-8bd94dbc7d15/resource/e760480e-1f95-4634-a923-98161cfb02fa/download/region_hospital_icu_covid_data.csv Note that I have to first remove the previous week's file, because wget won't overwrite it, and skips the download altogether. -- Roses are red Roses are blue Depending on their velocity Relative to you