[gentoo-user] How do I zap a specific area of a gnumeric spreadsheet page?

[Walter Dnes <waltdnes@waltdnes.org>]

  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