{ "_id": "6ac77e85de46216d5edd0d5b", "Package": "spaghetti", "Title": "Bidirectional Spreadsheet-Formula to OOXML Translator", "Version": "0.3.1", "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-08-09 17:30:45 UTC", "RemoteUrl": "https://github.com/JanMarvin/spaghetti", "RemoteRef": "HEAD", "RemoteSha": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "Packaged": { "Date": "2026-10-08 10:40:30 UTC", "User": "root" }, "Author": "Jan Marvin Garbuszus [aut, cre]", "Maintainer": "Jan Marvin Garbuszus ", "_user": "janmarvin", "_type": "src", "_file": "spaghetti_0.3.1.tar.gz", "_fileid": "https://r2.ropensci.org/79ffda236628614ec15cc9ee885171236a1b8dbff995fea550960aeb6920ba33", "_filesize": 168609, "_sha256": "79ffda236628614ec15cc9ee885171236a1b8dbff995fea550960aeb6920ba33", "_expires": "2027-01-16T11:29:07.000Z", "_created": "2026-10-08T10:40:30.000Z", "_published": "2026-10-08T11:29:09.606Z", "_buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 113270537103, "time": 97, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11544536033" }, { "job": 113270537136, "time": 97, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11543588066" }, { "job": 113270537247, "time": 74, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11546909197" }, { "job": 113270537332, "time": 85, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11547299520" }, { "job": 113269541370, "time": 161, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11543533953" }, { "job": 113270537077, "time": 81, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11544426178" }, { "job": 113270537108, "time": 78, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11543837404" }, { "job": 113270537174, "time": 65, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11543942391" }, { "job": 113270537276, "time": 79, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11543862691" } ], "_upstream": "https://github.com/JanMarvin/spaghetti", "_commit": { "id": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "author": "Jan Marvin Garbuszus ", "committer": "Jan Marvin Garbuszus ", "message": "fix lintr\n", "time": 1786296645 }, "_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 }, { "week": "2026-31", "n": 1 }, { "week": "2026-32", "n": 1 } ], "_tags": [ { "name": "v0.3.0", "date": "2026-05-13" } ], "_topics": [ "openxlsx2", "xlsx" ], "_stars": 0, "_contributors": [ { "user": "janmarvin", "count": 45, "uuid": 1645626 } ], "_userbio": { "uuid": 1645626, "type": "user", "name": "Jan Marvin Garbuszus", "followers": 81 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/spaghetti" }, "_devurl": "https://github.com/janmarvin/spaghetti", "_searchresults": 4, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/spaghetti.html", "LICENSE" ], "_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.6020599913279625, "_indexed": true, "_nocasepkg": "spaghetti", "_universes": [ "janmarvin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.1", "date": "2026-10-08T10:42:10.000Z", "distro": "resolute", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/2541d51cd175413b0d8c5ea623beb658918e765a02aac789e4fc7e893dee3916", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" }, { "r": "4.6.1", "os": "linux", "version": "0.3.1", "date": "2026-10-08T10:42:10.000Z", "distro": "resolute", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/bcb9c2a9ea58637813276f65d70edb8c57bc02ec8019e4d941e78282c028762d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" }, { "r": "4.5.3", "os": "mac", "version": "0.3.1", "date": "2026-10-08T11:28:37.000Z", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/d36586f9a77c8c82b7d1d25fc63b19c10633377de3c40d5f9731fc8c594d694a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" }, { "r": "4.6.1", "os": "mac", "version": "0.3.1", "date": "2026-10-08T11:28:38.000Z", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/c54f0e562584a93d5cb01ca8e10b3a0a57abbce63c4e4799b9f0488b52d15567", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.1", "date": "2026-10-08T10:42:06.000Z", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/1b6c3360d5bea49b21a4fdd409347fbce5b6c348a59901f7e48ea2da66b2086e", "status": "success", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" }, { "r": "4.7.0", "os": "win", "version": "0.3.1", "date": "2026-10-08T10:41:44.000Z", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/72ab736f59c8b1d803821aacbb0ba2b2f6019d413759261aec3008cb10e2858f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" }, { "r": "4.5.3", "os": "win", "version": "0.3.1", "date": "2026-10-08T10:41:39.000Z", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/c67f9ce6842297c3b708734ea24990138538428ed63672a5802a02aab7083bd5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" }, { "r": "4.6.1", "os": "win", "version": "0.3.1", "date": "2026-10-08T10:41:45.000Z", "commit": "e67e611a7a0efdf97799e92a80b9a86d339b8e29", "fileid": "https://r2.ropensci.org/baf9ba1efb6853abdd74e68df3bc75e5d2d6fd609bd2c7301e38c51e7d8a5332", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/37764718756" } ] }