See also https://github.com/alekrutkowski/ExcelLambdaTools
Convert 1-column range monthly dates in the format yyyy-mm, e.g. 2023-11, to 2-column range:
=LAMBDA(rng,
LET(
| ############### | |
| ##################################### | |
| ################################################## | |
| ######################################################## | |
| ############################ ############### | |
| ##################### ########## | |
| ################### ####### | |
| ################# ################################### ###### | |
| ################# ###################################### ##### | |
| ############### ####################################### ##### |
Click the extension button to translate text inside paragraphs, headings (h1–h6), and list items into the language defined in MY_LANG while preserving inline markup and links.
Made with ChatGPT 5 (after a few iterations).
| #### Prerequisites -- in Linux terminal: | |
| # Once: | |
| # pipx install libretranslate | |
| # Run in the background: | |
| # libretranslate | |
| #### Test: | |
| # Open the following page in a web browser | |
| # (but first modify your.shiny-server.domain and your_translate_app_name): | |
| # https://your.shiny-server.domain/your_translate_app_name/?url=https://example.com/&from=en&to=fr |
| # Save it as /srv/shiny-server/your_app_name/app.R | |
| library(shiny) | |
| ui <- function(request) { | |
| query <- parseQueryString(request$QUERY_STRING) | |
| txt <- query$txt | |
| a <- as.numeric(query$a) | |
| b <- as.numeric(query$b) |
| # Shiny app that serves a transformed RSS feed immediately at "/". | |
| # It fetches the source RSS on every request, appends a single space to the end | |
| # of each line, and returns it with the correct RSS content type so feed readers | |
| # can subscribe directly. | |
| # This particular app fixes the annoying problem in Inoreader, which concatenates | |
| # the words in the descriptions of new R packages. | |
| library(shiny) |
| --- | |
| toc: false | |
| theme: [dashboard] | |
| footer: "" | |
| --- | |
| <link href="https://unpkg.com/gridjs/dist/theme/mermaid.min.css" rel="stylesheet" /> | |
| <script src="https://unpkg.com/gridjs/dist/gridjs.umd.js"></script> |
| --- | |
| toc: false | |
| theme: [dashboard] | |
| footer: "" | |
| --- | |
| # My Dashboard | |
| ```js | |
| // Message displayed before the first Excel file upload |
| --- | |
| toc: false | |
| --- | |
| ```js | |
| function DoubleRange({ | |
| min = 0, | |
| max = 100, | |
| step = 1, | |
| value = [min, max], |
| <!-- https://tom-select.js.org/#:~:text=Additional%20CLI%20usage-,jsDelivr,-The%20fastest%20way --> | |
| <link href="https://cdn.jsdelivr.net/npm/tom-select@2.4.3/dist/css/tom-select.css" rel="stylesheet"> | |
| <script src="https://cdn.jsdelivr.net/npm/tom-select@2.4.3/dist/js/tom-select.complete.min.js"></script> <!-- Leave space below! --> | |
| <!-- https://tom-select.js.org/examples/#:~:text=%3C-,select%20multiple,-%3E --> | |
| ```js | |
| const mystates = | |
| view(html`<select id="select-state" name="state[]" multiple placeholder="Select a state..." autocomplete="on"> | |
| <option value="">Select a state...</option> | |
| <option value="AL">Alabama</option> |