{ "_id": "6a37b57c3efcd9bda4428ade", "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-06-21 09:01:01 UTC", "RemoteUrl": "https://github.com/JanMarvin/spaghetti", "RemoteRef": "HEAD", "RemoteSha": "8a5dfdea0639d6577987283ff7f32ca47831104b", "Packaged": { "Date": "2026-06-21 09:49:00 UTC", "User": "root" }, "Author": "Jan Marvin Garbuszus [aut, cre]", "Maintainer": "Jan Marvin Garbuszus ", "MD5sum": "76d70121383ca77d69be5174dba5eac5", "_user": "janmarvin", "_type": "src", "_file": "spaghetti_0.3.0.tar.gz", "_fileid": "64d08dc312ab28dfc2f249d19d3e3028d6e45a46d8ae25e0be3b59977a5d2c1c", "_filesize": 171792, "_sha256": "64d08dc312ab28dfc2f249d19d3e3028d6e45a46d8ae25e0be3b59977a5d2c1c", "_created": "2026-06-21T09:49:00.000Z", "_published": "2026-06-21T09:57:16.497Z", "_distro": "noble", "_jobs": [ { "job": 82560001666, "time": 96, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7774119494" }, { "job": 82560001686, "time": 105, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7774120714" }, { "job": 82560001692, "time": 90, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7774165907" }, { "job": 82560001691, "time": 80, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7774123040" }, { "job": 82559800780, "time": 191, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7774106675" }, { "job": 82560001690, "time": 79, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7774117213" }, { "job": 82560001711, "time": 67, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7774115524" }, { "job": 82560001717, "time": 65, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7774115481" }, { "job": 82560001716, "time": 71, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7774116256" } ], "_buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/JanMarvin/spaghetti", "_commit": { "id": "8a5dfdea0639d6577987283ff7f32ca47831104b", "author": "Jan Marvin Garbuszus ", "committer": "Jan Marvin Garbuszus ", "message": "fix readme\n\ncloses #1\n", "time": 1782032461 }, "_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 }, { "week": "2026-25", "n": 1 } ], "_tags": [ { "name": "v0.3.0", "date": "2026-05-13" } ], "_topics": [ "openxlsx2", "xlsx" ], "_stars": 0, "_contributors": [ { "user": "janmarvin", "count": 42, "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.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", "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.3979400086720375, "_indexed": true, "_nocasepkg": "spaghetti", "_universes": [ "janmarvin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0", "date": "2026-06-21T09:50:44.000Z", "distro": "noble", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "b3b9647d1c66db3e3c6d2ebcaf901964635c8ca75b1e83963668378b75c85f99", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" }, { "r": "4.6.0", "os": "linux", "version": "0.3.0", "date": "2026-06-21T09:50:50.000Z", "distro": "noble", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "0648e6e9f6917f2fc2825df9a1bd26dc93ff81b79458681c43d6fc49a648cf56", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0", "date": "2026-06-21T09:56:53.000Z", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "f03fc095f94209f0e926a2e3f1fece69d3f3b2b9ba38c7c52a6258276fa78dca", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" }, { "r": "4.6.0", "os": "mac", "version": "0.3.0", "date": "2026-06-21T09:51:09.000Z", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "bbdf35533dacfd7e683bbd80b78c05573eb23c47861a52b1118f861b1fbc40ae", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0", "date": "2026-06-21T09:50:35.000Z", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "53fbab5394dc6cb240d26fe4c2a08554e0cfad8ab5a3e701ddd1172e41597a58", "status": "success", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" }, { "r": "4.7.0", "os": "win", "version": "0.3.0", "date": "2026-06-21T09:50:06.000Z", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "d7974c911e648b583b0021e4cdc663ba2ff2e299c6e986431653690c921d42c7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" }, { "r": "4.5.3", "os": "win", "version": "0.3.0", "date": "2026-06-21T09:50:05.000Z", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "b8cf1f17104edaf740a387fdcaee22ceac6855e4d92edcf8fb1e79be7bd4413c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" }, { "r": "4.6.0", "os": "win", "version": "0.3.0", "date": "2026-06-21T09:50:10.000Z", "commit": "8a5dfdea0639d6577987283ff7f32ca47831104b", "fileid": "d6c877ca66b1c31af4a9a79e79234e5bdd06529a53fcd1b8a7d1a18b6228f442", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/janmarvin/actions/runs/27900485466" } ] }