{ "_id": "6a4b71dfa6574ff277f9b0cd", "Package": "spaghetti", "Title": "Bidirectional Spreadsheet-Formula to OOXML Translator", "Version": "0.3.0", "Authors@R": "c(\nperson(\"Jan Marvin\", \"Garbuszus\", email = \"jan.garbuszus@ruhr-uni-bochum.de\", role = c(\"aut\", \"cre\"))\n)", "Description": "Translates spreadsheet formulas between the user-facing\nformat (as displayed to the end user) and the OOXML storage\nformat (as found in .xlsx XML source). Handles future function\nprefixes (_xlfn.), web-service namespaces (_xlfn._xlws.),\nLAMBDA parameter prefixes (_xlpm.), spilled range operators\n(ANCHORARRAY), implicit intersection (SINGLE), and optional\nlocalised function name translation across the locales in the\nMicrosoft Terminology Collection (run setup_terminology() once\nto download and cache the translations).", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "Config/testthat/edition": "3", "Config/roxygen2/version": "8.0.0", "NeedsCompilation": "no", "Repository": "https://janmarvin.r-universe.dev", "Date/Publication": "2026-07-06 06:10:53 UTC", "RemoteUrl": "https://github.com/JanMarvin/spaghetti", "RemoteRef": "HEAD", "RemoteSha": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "Packaged": { "Date": "2026-07-06 09:11:16 UTC", "User": "root" }, "Author": "Jan Marvin Garbuszus [aut, cre]", "Maintainer": "Jan Marvin Garbuszus ", "_user": "janmarvin", "_type": "src", "_file": "spaghetti_0.3.0.tar.gz", "_fileid": "https://r2.ropensci.org/adea3cb746e183d17440cdd04149fb4650cb9e4b9e4ef53ffc19857322bc3de0", "_filesize": 171801, "_sha256": "adea3cb746e183d17440cdd04149fb4650cb9e4b9e4ef53ffc19857322bc3de0", "_expires": "2026-10-14T09:14:06.000Z", "_created": "2026-07-06T09:11:16.000Z", "_published": "2026-07-06T09:14:07.623Z", "_jobs": [ { "job": 85335187710, "time": 113, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8104568293" }, { "job": 85335187716, "time": 139, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8104577991" }, { "job": 85335187744, "time": 67, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8104568791" }, { "job": 85335187613, "time": 104, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8104566310" }, { "job": 85334692356, "time": 151, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8104522187" }, { "job": 85335187607, "time": 131, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8104574739" }, { "job": 85335187715, "time": 67, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8104549943" }, { "job": 85335187653, "time": 64, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8104549119" }, { "job": 85335187680, "time": 70, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8104550926" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431", "_status": "success", "_upstream": "https://github.com/JanMarvin/spaghetti", "_commit": { "id": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "author": "Jan Marvin Garbuszus ", "committer": "Jan Marvin Garbuszus ", "message": "update actions\n", "time": 1783318253 }, "_maintainer": { "name": "Jan Marvin Garbuszus", "email": "jan.garbuszus@ruhr-uni-bochum.de", "login": "janmarvin", "linkedin": "in/jan-marvin-garbuszus", "description": "", "uuid": 1645626 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.0.0", "role": "Depends" }, { "package": "utils", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "openxlsx2", "role": "Suggests" }, { "package": "digest", "role": "Suggests" } ], "_owner": "janmarvin", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-14", "n": 5 }, { "week": "2026-15", "n": 12 }, { "week": "2026-19", "n": 1 }, { "week": "2026-20", "n": 23 }, { "week": "2026-25", "n": 1 }, { "week": "2026-28", "n": 1 } ], "_tags": [ { "name": "v0.3.0", "date": "2026-05-13" } ], "_topics": [ "openxlsx2", "xlsx" ], "_stars": 0, "_contributors": [ { "user": "janmarvin", "count": 43, "uuid": 1645626 } ], "_userbio": { "uuid": 1645626, "type": "user", "name": "Jan Marvin Garbuszus", "followers": 75 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/spaghetti" }, "_devurl": "https://github.com/janmarvin/spaghetti", "_searchresults": 1, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/spaghetti.html", "LICENSE", "manual.pdf" ], "_cranurl": false, "_exports": [ "check_formula", "clear_terminology", "from_xml", "function_description", "function_prefix", "function_table", "has_terminology", "is_ooxml", "round_trip", "setup_terminology", "supported_locales", "terminology_info", "to_xml", "xlex" ], "_help": [ { "page": "check_formula", "title": "Check a formula for unknown function names", "topics": [ "check_formula" ] }, { "page": "clear_terminology", "title": "Remove the cached terminology RDS.", "topics": [ "clear_terminology" ] }, { "page": "from_xml", "title": "Convert an OOXML storage formula to user-facing format", "topics": [ "from_xml" ] }, { "page": "function_description", "title": "Look up the English description for a function.", "topics": [ "function_description" ] }, { "page": "function_prefix", "title": "Identify what prefix a function will receive", "topics": [ "function_prefix" ] }, { "page": "function_table", "title": "Return the full function translation table.", "topics": [ "function_table" ] }, { "page": "has_terminology", "title": "Check whether locale terminology has been loaded.", "topics": [ "has_terminology" ] }, { "page": "is_ooxml", "title": "Check whether a formula is already in OOXML storage format", "topics": [ "is_ooxml" ] }, { "page": "round_trip", "title": "Round-trip a formula through OOXML and back", "topics": [ "round_trip" ] }, { "page": "setup_terminology", "title": "Download and parse the Microsoft Terminology Collection.", "topics": [ "setup_terminology" ] }, { "page": "supported_locales", "title": "List supported locale codes.", "topics": [ "supported_locales" ] }, { "page": "terminology_info", "title": "Metadata about the currently loaded terminology cache.", "topics": [ "terminology_info" ] }, { "page": "to_xml", "title": "Convert a user-facing formula to OOXML storage format", "topics": [ "to_xml" ] }, { "page": "xlex", "title": "Tokenise and display a formula as an ASCII tree", "topics": [ "xlex" ] } ], "_readme": "https://github.com/JanMarvin/spaghetti/raw/HEAD/README.md", "_rundeps": [], "_score": 2.4771212547196626, "_indexed": true, "_nocasepkg": "spaghetti", "_universes": [ "janmarvin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0", "date": "2026-07-06T09:13:12.000Z", "distro": "resolute", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/5b0411ebad0f2f7dc96032c54e29c3f94d9d0d8500974befd811ed3698c17b68", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" }, { "r": "4.6.1", "os": "linux", "version": "0.3.0", "date": "2026-07-06T09:13:36.000Z", "distro": "resolute", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/7b146345f9bfc2cf136e769f2fb47612d81b99a9709538cd43603af5135cea9f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0", "date": "2026-07-06T09:13:30.000Z", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/cac9e1ae1f0ad2524e2cd9097c1fca89b779e2bd23cd498be6a7dc3b7c9a980c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" }, { "r": "4.6.1", "os": "mac", "version": "0.3.0", "date": "2026-07-06T09:13:07.000Z", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/e71db7e16617ebe44b69a4c3cabdddcf17629552269f8510cca8cabc3afbcc5f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0", "date": "2026-07-06T09:13:40.000Z", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/9e8354b140183902f7a00106269f61558fd43e91f46d86f08c866fa2a574ea19", "status": "success", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" }, { "r": "4.7.0", "os": "win", "version": "0.3.0", "date": "2026-07-06T09:12:19.000Z", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/4b8d03744344097dc71e491b1d6f46652b7baed866725e8950aac954326f2d32", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" }, { "r": "4.5.3", "os": "win", "version": "0.3.0", "date": "2026-07-06T09:12:17.000Z", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/233cda388798511156c4da3e928603ff6ec1bcbba424909e9bcd23241428b0ba", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" }, { "r": "4.6.1", "os": "win", "version": "0.3.0", "date": "2026-07-06T09:12:21.000Z", "commit": "b2cdf20f3a7200ef58a0a476273adf1cb8f4f19e", "fileid": "https://r2.ropensci.org/1e4eafaa6e525d63b015bad2cd02c71201a897fb3f4ba06e13513e0c696baf6c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/28780472431" } ] }