{ "_id": "6a2003eab401979e73446203", "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-06-03 10:34:33 UTC", "User": "root" }, "Author": "Luis D. Verde Arregoitia [aut, cre, cph] (ORCID:\n)", "Maintainer": "Luis D. Verde Arregoitia ", "MD5sum": "ef4c9021659daea4358878c897e0427d", "_user": "luisdva", "_type": "src", "_file": "forgts_0.0.1.9000.tar.gz", "_fileid": "6dd7c7c9369b3058973fd4d12556472c0bb11c8a6f937eb98d444f046d6a1ffa", "_filesize": 766592, "_sha256": "6dd7c7c9369b3058973fd4d12556472c0bb11c8a6f937eb98d444f046d6a1ffa", "_created": "2026-06-03T10:34:33.000Z", "_published": "2026-06-03T10:37:30.612Z", "_distro": "noble", "_jobs": [ { "job": 79274630409, "time": 134, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7382232596" }, { "job": 79274630413, "time": 138, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7382234054" }, { "job": 79274630378, "time": 110, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7382223642" }, { "job": 79274630450, "time": 98, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7382219738" }, { "job": 79274102838, "time": 190, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7382184299" }, { "job": 79274630400, "time": 145, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7382235883" }, { "job": 79274630481, "time": 85, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7382215043" }, { "job": 79274630426, "time": 105, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7382222799" }, { "job": 79274630397, "time": 79, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7382213131" } ], "_buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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", "description": "mammalogist" }, "_downloads": { "count": 115, "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.0", "_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", "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-06-03T10:36:45.000Z", "distro": "noble", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "4a7e4755edc3b2afad67724438bc4200b7ea2bb949dc6a01aa64863048d9e9be", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" }, { "r": "4.6.0", "os": "linux", "version": "0.0.1.9000", "date": "2026-06-03T10:36:49.000Z", "distro": "noble", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "2181cbdd9ad9b2621481b1ca5d68d20de1f05bd066d3466fdd3349d83a5a70de", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" }, { "r": "4.5.3", "os": "mac", "version": "0.0.1.9000", "date": "2026-06-03T10:36:19.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "0463a3a19a0accc6f68bd12918b993008cd6845bfcda55d8b574bd638c599825", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" }, { "r": "4.6.0", "os": "mac", "version": "0.0.1.9000", "date": "2026-06-03T10:36:15.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "e8c958ab51296a3ad739a39f4efa75979b70e54c98ae5b071e22fc4e1d1efece", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.1.9000", "date": "2026-06-03T10:37:13.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "757f3ab615c88b71128dc42e4a6078b89391c1048e7fd8677e249ecaf04a4fd3", "status": "success", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" }, { "r": "4.7.0", "os": "win", "version": "0.0.1.9000", "date": "2026-06-03T10:35:51.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "e05669c16b2bf85453effcd8f3766875070998cdff5f598a8243c62c5a2ab003", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" }, { "r": "4.5.3", "os": "win", "version": "0.0.1.9000", "date": "2026-06-03T10:36:14.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "2b3c6d929ca752b4dc7360dff21cf1070f273a49c85b0c8076bde4ff87b2ca0a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" }, { "r": "4.6.0", "os": "win", "version": "0.0.1.9000", "date": "2026-06-03T10:35:46.000Z", "commit": "7576ca253b998c730d8933c9042dd6d515083ab3", "fileid": "8fb7e89d0f2d7b625bd227a573d2e963089d177553af410c383552cf2ae1d8f3", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/luisdva/actions/runs/26879053095" } ] }