{ "_id": "6a1f1a18b401979e7341f0d9", "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-05-16 10:16:27 UTC", "RemoteUrl": "https://github.com/JanMarvin/spaghetti", "RemoteRef": "HEAD", "RemoteSha": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "Packaged": { "Date": "2026-05-16 11:04:30 UTC", "User": "root" }, "Author": "Jan Marvin Garbuszus [aut, cre]", "Maintainer": "Jan Marvin Garbuszus ", "MD5sum": "2f9effd2d1b53eef6c7259783efd285d", "_user": "janmarvin", "_type": "src", "_file": "spaghetti_0.3.0.tar.gz", "_fileid": "6ab705b643c787da17ca0b9418b4d48420eb6c23a31b3121ccea6ea8b58ce2ff", "_filesize": 168264, "_sha256": "6ab705b643c787da17ca0b9418b4d48420eb6c23a31b3121ccea6ea8b58ce2ff", "_created": "2026-05-16T11:04:30.000Z", "_published": "2026-06-02T17:59:52.422Z", "_distro": "noble", "_jobs": [ { "job": 79138034101, "time": 115, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7032894952" }, { "job": 79138033992, "time": 99, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7032893531" }, { "job": 79138033670, "time": 101, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7032893653" }, { "job": 79138033814, "time": 73, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7032890956" }, { "job": 79138033044, "time": 154, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7032884147" }, { "job": 79138033158, "time": 74, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7365818747" }, { "job": 79138033681, "time": 75, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7032891429" }, { "job": 79138034158, "time": 68, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7032890561" }, { "job": 79138034069, "time": 72, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7032890839" } ], "_buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/JanMarvin/spaghetti", "_commit": { "id": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "author": "Jan Marvin Garbuszus ", "committer": "Jan Marvin Garbuszus ", "message": "add .lintr and a few cleanups\n", "time": 1778926587 }, "_maintainer": { "name": "Jan Marvin Garbuszus", "email": "jan.garbuszus@ruhr-uni-bochum.de", "login": "janmarvin", "linkedin": "in/jan-marvin-garbuszus", "description": "", "uuid": 1645626 }, "_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 } ], "_tags": [ { "name": "v0.3.0", "date": "2026-05-13" } ], "_topics": [ "openxlsx2", "xlsx" ], "_stars": 0, "_contributors": [ { "user": "janmarvin", "count": 41, "uuid": 1645626 } ], "_userbio": { "uuid": 1645626, "type": "user", "name": "Jan Marvin Garbuszus" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/spaghetti" }, "_devurl": "https://github.com/janmarvin/spaghetti", "_searchresults": 0, "_rbuild": "4.6.0", "_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", "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.3010299956639813, "_indexed": true, "_nocasepkg": "spaghetti", "_universes": [ "janmarvin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0", "date": "2026-05-16T11:06:26.000Z", "distro": "noble", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "ebcf2c6ec87b554c19d7df9d06c56b5d6bb8f18d2d6d0d6cbf030799a8fe85bc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" }, { "r": "4.6.0", "os": "linux", "version": "0.3.0", "date": "2026-05-16T11:06:13.000Z", "distro": "noble", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "81f6ff1e5147d12bb54bf358d1288cb89ce6e4a82202102750b9d816632e4ed3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0", "date": "2026-05-16T11:06:17.000Z", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "bdc6d5ab6f5bcae1222083d6613dfdb96edcf3ae2ef4cbae7ee042225d6ac26b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" }, { "r": "4.6.0", "os": "mac", "version": "0.3.0", "date": "2026-05-16T11:05:49.000Z", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "0cdc232f33006eed6b50bbac022e782842645cd0d9b2811171d8540a77667ec8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" }, { "r": "4.7.0", "os": "win", "version": "0.3.0", "date": "2026-05-16T11:05:45.000Z", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "b443d8ea406af049d2ea0e876e84c6832056fee9cd6f2592345b1a928a5ac1bb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" }, { "r": "4.5.3", "os": "win", "version": "0.3.0", "date": "2026-05-16T11:05:36.000Z", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "2aa20070e88013a7f2da3715f89038032fedd9b37d34c413b565a7e642b0b737", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" }, { "r": "4.6.0", "os": "win", "version": "0.3.0", "date": "2026-05-16T11:05:38.000Z", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "a094b353cd52bd9cf21712ca73af445ca6e0dde4aa2586618778be1b5bf11b0b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0", "date": "2026-06-02T17:59:38.000Z", "commit": "b293ee7717dc26bb1ea007d2fcfbbd061e05aa04", "fileid": "f84ff2b7c48a3a849424485cea48685bb44223e26303408c1c5562d2a568d2a3", "status": "success", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/25960266230" } ] }