Disable visual markdown editor on RStudio

Question

I'm working on a book project with Quarto using RStudio 2022.02.2+485. Whenever I open a mardown .qmd file, RStudio automatically opens the file using the Visual markdown editor, what takes time to load. Even if I move to the Source pane, RStudio moves back again to Visual editor after and I make an edit to the file or whenever I open a new file.

Is there a way to disable the visual markdown editor on RStudio?

Rstudio version

RStudio 2022.02.2+485 "Prairie Trillium" Release (8acbd38b0d4ca3c86c570cf4112a8180c48cc6fb, 2022-04-19) for Windows Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) QtWebEngine/5.12.8 Chrome/69.0.3497.128 Safari/537.36

Answer 1

See below answer, and my final solution to include Market Cap data.

  url = 'https://api.coingecko.com/api/v3/coins/invictus/market_chart?vs_currency=usd&days=30&interval=daily'
  var json = JSON.parse(UrlFetchApp.fetch(url).getContentText())
  var data = json.prices
  var data2 = json.market_caps
  var sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('ChartData')
  sh.getRange(2,1,data.length,data[0].length).setValues(data)
  sh.getRange(2,3,data2.length,data2[0].length).setValues(data2)
}```