R is for
Authoring!!

OOH Session #145…
Embedded
Spreadsheets

Open Office Hours
(September 01, 2026)






Reminder – check it out!!

Fantastic resource!!

Recap of Session
#144:

Customized Presentation Slides

…for example:

…or:

  1. Find “similar” template to what you envision
  2. Grab the source code
  3. Modify .scss file
  4. Call out in your :
---
title: "Awesome Slidez"
format: revealjs
theme: yourlook.scss
---
/*-- scss:defaults --*/        

@import url('https://fonts.googleapis.com/css?family=Irish Grover');   
@import url('https://fonts.googleapis.com/css?family=UnifrakturMaguntia');  

// Include theme-specific fonts
$systemFontsSansSerif: UnifrakturMaguntia, Irish Grover, arial;
$systemFontsMono: UnifrakturMaguntia, Irish Grover, arial;

$background: #353E43;
$foreground: #ffffe4;
$selection: #44475a;
$comment: #6272a4;
$red: #ff5555;
$orange: #ffb86c;
$yellow: #f1fa8c;
$green: #50fa7b;
$purple: #9D00FF;
$cyan: #8be9fd;
$pink: #ff79c6;
$badass: #bada55;

// Override theme settings
$body-color: $foreground !default;
$presentation-heading-color: $cyan !default;
$presentation-font-size-root: 60px !default;
$presentation-heading-text-shadow: none !default;
$presentation-heading-text-transform: none !default;
$body-bg: $background !default;
$link-color: $pink !default;
$link-color-hover: $badass !default;
$selection-bg: $selection !default;
$code-color: $green !default;
$presentation-list-bullet-color: $foreground !default;

$font-family-sans-serif: $systemFontsSansSerif !default;
$font-family-monospace: "Fira Code", $systemFontsMono !default;

// Change text colors against light slide backgrounds
$light-bg-text-color: $body-bg !default;

/*-- scss:rules --*/

// Define additional color effects based on Dracula spec
// https://spec.draculatheme.com/
:root {
  --r-bold-color: #{$badass};
  --r-italic-color: #{$yellow};
  --r-inline-code-color: #{$code-color};
  --r-list-bullet-color: #{$presentation-list-bullet-color};
}

.reveal {
  strong,
  b {
    &:not(.callout-title strong, .callout-tile b) {
      color: var(--r-bold-color);
    }
  }
  em,
  i,
  blockquote {
    color: var(--r-italic-color);
  }
  code {
    color: var(--r-inline-code-color);
  }
  // Dracula colored list bullets and numbers
  ul,
  ol {
    li::marker {
      color: var(--r-list-bullet-color);
    }
  }
}

/**
 * Dracula colors by Zeno Rocha
 * https://draculatheme.com/contribute
 */
html * {
  color-profile: sRGB;
  rendering-intent: auto;
}
  1. Sequence of scss:defaults vs scss:rules important for Quarto docs
  2. Easy way to grab fonts – requires internet connection

Today…

Embedded Spreadsheets

…you can also simply specify an iframe w/in an html doc – embedded file will update as you edit the spreadsheet:

<iframe
  width="100%"
  height="500"
  src="https://docs.google.com/spreadsheets/d/1kLD8C7x5ko_tbypM6Xd4PJEsrPxrJpIlZhC8V7FADkc/edit?usp=sharing"
  title="Spreadsheet">
</iframe>

& Session Info (September 01, 2026) Rendering:

R version 4.5.0 (2025-04-11 ucrt)
Platform: x86_64-w64-mingw32/x64
Running under: Windows 10 x64 (build 19045)

Matrix products: default
  LAPACK version 3.12.1

locale:
[1] LC_COLLATE=English_United States.utf8 
[2] LC_CTYPE=English_United States.utf8   
[3] LC_MONETARY=English_United States.utf8
[4] LC_NUMERIC=C                          
[5] LC_TIME=English_United States.utf8    

time zone: America/Chicago
tzcode source: internal

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

loaded via a namespace (and not attached):
 [1] compiler_4.5.0    fastmap_1.2.0     cli_3.6.5         tools_4.5.0      
 [5] htmltools_0.5.9   otel_0.2.0        rstudioapi_0.18.0 yaml_2.3.12      
 [9] rmarkdown_2.31    knitr_1.51        jsonlite_2.0.0    xfun_0.57        
[13] digest_0.6.39     rlang_1.1.7       evaluate_1.0.5

Quarto version 1.10.18