{ "_id": "6a4797fe2f27a93436c0f94c", "Package": "forgts", "Title": "Convert Formatted Spreadsheets to Presentation-Ready Display\nTables", "Version": "0.0.1.9000", "Authors@R": "person(\"Luis D.\", \"Verde Arregoitia\", , \"luis@liomys.mx\", role = c(\"aut\", \"cre\", \"cph\"),\ncomment = c(ORCID = \"0000-0001-9520-6543\"))", "Description": "Reads cell contents plus formatting from a spreadsheet\nfile and creates an editable 'gt' object with the same data and\nformatting. Supports the most commonly-used cell and text\nstyles including colors, fills, font weights and decorations,\nand borders.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2.9000", "Config/testthat/edition": "3", "URL": "https://github.com/luisDVA/forgts,\nhttps://luisdva.github.io/forgts/", "BugReports": "https://github.com/luisDVA/forgts/issues", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev libxml2-dev\nlibssl-dev libnode-dev", "Repository": "https://luisdva.r-universe.dev", "Date/Publication": "2025-02-04 18:54:51 UTC", "RemoteUrl": "https://github.com/luisdva/forgts", "RemoteRef": "HEAD", "RemoteSha": "7576ca253b998c730d8933c9042dd6d515083ab3", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-03 08:11:59 UTC", "User": "root" }, "Author": "Luis D. Verde Arregoitia [aut, cre, cph] (ORCID:\n)", "Maintainer": "Luis D. Verde Arregoitia ", "_user": "luisdva", "_type": "src", "_file": "forgts_0.0.1.9000.tar.gz", "_fileid": "https://r2.ropensci.org/b5d09866b3ceeabebd6de3d42ce0e8c5d3e76d3dde8b1ddd303408762989d1af", "_filesize": 767094, "_sha256": "b5d09866b3ceeabebd6de3d42ce0e8c5d3e76d3dde8b1ddd303408762989d1af", "_expires": "2026-10-11T11:07:42.000Z", "_created": "2026-07-03T08:11:59.000Z", "_published": "2026-07-03T11:07:42.661Z", "_jobs": [ { "job": 84987046545, "time": 154, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "8061341160" }, { "job": 84987046854, "time": 145, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "8061338319" }, { "job": 84987046609, "time": 203, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "8061344290" }, { "job": 84987046416, "time": 158, "config": "macos-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "8061334289" }, { "job": 84987046267, "time": 188, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8061287102" }, { "job": 84987046652, "time": 157, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8061342457" }, { "job": 84987046819, "time": 85, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "8061318368" }, { "job": 84987046741, "time": 74, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "8061314641" }, { "job": 84987046932, "time": 87, "config": "windows-release", "r": "4.6.1", "check": "NOTE", "artifact": "8061319085" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616", "_status": "success", "_upstream": "https://github.com/luisdva/forgts", "_commit": { "id": "7576ca253b998c730d8933c9042dd6d515083ab3", "author": "LuisDVA ", "committer": "LuisDVA ", "message": "add badges\n", "time": 1738695291 }, "_maintainer": { "name": "Luis D. Verde Arregoitia", "email": "luis@liomys.mx", "login": "luisdva", "bluesky": "@liomys.mx", "linkedin": "in/luis-d-verde-arregoitia-a20339209", "orcid": "0000-0001-9520-6543", "description": "mammalogist", "uuid": 5580938 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "dplyr", "role": "Imports" }, { "package": "gt", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "readxl", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "tidyxl", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "luisdva", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 25, "_contributors": [ { "user": "luisdva", "count": 26, "uuid": 5580938 }, { "user": "ddiannae", "count": 1, "uuid": 15936920 } ], "_userbio": { "uuid": 5580938, "type": "user", "name": "Luis Verde Arregoitia", "followers": 163, "description": "mammalogist" }, "_downloads": { "count": 241, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/forgts" }, "_devurl": "https://github.com/luisdva/forgts", "_pkgdown": "https://luisdva.github.io/forgts/", "_searchresults": 5, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/forgts.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_homeurl": "https://github.com/luisdva/forgts", "_realowner": "luisdva", "_cranurl": true, "_releases": [ { "version": "0.0.1", "date": "2025-01-31" } ], "_exports": [ "apply_styling", "forgts", "get_formatting", "translate_defs" ], "_help": [ { "page": "apply_styling", "title": "Apply Spreadsheet Formatting to gt Table", "topics": [ "apply_styling" ] }, { "page": "forgts", "title": "Creat gt from spreadsheet", "topics": [ "forgts" ] }, { "page": "get_formatting", "title": "Get Spreadsheet Formatting", "topics": [ "get_formatting" ] }, { "page": "rodentsheet.xlsx", "title": "rodentsheet.xlsx spreadsheet", "topics": [ "rodentsheet.xlsx" ] }, { "page": "target_var_fmt", "title": "Colwise formatting", "topics": [ "target_var_fmt" ] }, { "page": "translate_defs", "title": "Translate Formatting Definitions", "topics": [ "translate_defs" ] } ], "_pkglogo": "https://github.com/luisdva/forgts/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/luisdva/forgts/raw/HEAD/README.md", "_rundeps": [ "base64enc", "bigD", "bitops", "bslib", "cachem", "cellranger", "cli", "commonmark", "cpp11", "crayon", "curl", "digest", "dplyr", "evaluate", "farver", "fastmap", "fontawesome", "fs", "generics", "glue", "gt", "highr", "hms", "htmltools", "htmlwidgets", "jquerylib", "jsonlite", "juicyjuice", "knitr", "labeling", "lifecycle", "litedown", "magrittr", "markdown", "memoise", "mime", "pillar", "piton", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "rappdirs", "RColorBrewer", "Rcpp", "reactable", "reactR", "readxl", "rematch", "rlang", "rmarkdown", "sass", "scales", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "tidyxl", "tinytex", "utf8", "V8", "vctrs", "viridisLite", "withr", "xfun", "xml2", "yaml" ], "_vignettes": [ { "source": "getting-started.Rmd", "filename": "getting-started.html", "title": "Getting started", "engine": "knitr::rmarkdown", "headings": [], "created": "2025-01-28 17:16:13", "modified": "2025-01-28 17:22:43", "commits": 2 } ], "_score": 5.096910013008056, "_indexed": true, "_nocasepkg": "forgts", "_universes": [ "luisdva" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.1.9000", "date": "2026-07-03T08:14:29.000Z", "distro": "resolute", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/315e24e5b13bb9648d224dc71fecb93b3211c0899523d0cc8f0ae3abbd9f68a3", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" }, { "r": "4.6.1", "os": "linux", "version": "0.0.1.9000", "date": "2026-07-03T08:14:22.000Z", "distro": "resolute", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/ce026256b973ceeac9975976b40abcd66b624cb130c0ae67880b8700becfc882", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" }, { "r": "4.5.3", "os": "mac", "version": "0.0.1.9000", "date": "2026-07-03T08:14:40.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/085abb37af7e6bf54751970281c42e19ec45973d88e316712fb8bd34d42833d2", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" }, { "r": "4.6.1", "os": "mac", "version": "0.0.1.9000", "date": "2026-07-03T08:14:13.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/8997ed1ffacfa9c9ddbcc04d8143969e4626579ec72522036d83df60b8ef520e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.1.9000", "date": "2026-07-03T08:14:54.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/4efcaa518c52b9e22b478a2becaa64341f2325baa7a860a12272d38913166368", "status": "success", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" }, { "r": "4.7.0", "os": "win", "version": "0.0.1.9000", "date": "2026-07-03T08:13:17.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/2565adcb5bfa99b59395c3868f74d25beae978b94652ccd6d204b202644cf289", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" }, { "r": "4.5.3", "os": "win", "version": "0.0.1.9000", "date": "2026-07-03T08:13:08.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/e6d0f2891262059b6937d684dc7612bf1a982683ef4f2799c0545662b051e87f", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" }, { "r": "4.6.1", "os": "win", "version": "0.0.1.9000", "date": "2026-07-03T08:13:20.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "https://r2.ropensci.org/0cf453191d8859b029938bddf7c719a7454955c47167479ddc99c9566dae74ea", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/28647440616" } ] }