Package: spaghetti 0.3.0
spaghetti: Bidirectional Spreadsheet-Formula to OOXML Translator
Translates spreadsheet formulas between the user-facing format (as displayed to the end user) and the OOXML storage format (as found in .xlsx XML source). Handles future function prefixes (_xlfn.), web-service namespaces (_xlfn._xlws.), LAMBDA parameter prefixes (_xlpm.), spilled range operators (ANCHORARRAY), implicit intersection (SINGLE), and optional localised function name translation across the locales in the Microsoft Terminology Collection (run setup_terminology() once to download and cache the translations).
Authors:
spaghetti_0.3.0.tar.gz
spaghetti_0.3.0.zip(r-4.7)spaghetti_0.3.0.zip(r-4.6)spaghetti_0.3.0.zip(r-4.5)
spaghetti_0.3.0.tgz(r-4.6-any)spaghetti_0.3.0.tgz(r-4.5-any)
spaghetti_0.3.0.tar.gz(r-4.7-any)spaghetti_0.3.0.tar.gz(r-4.6-any)
spaghetti_0.3.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
spaghetti/json (API)
NEWS
| # Install 'spaghetti' in R: |
| install.packages('spaghetti', repos = c('https://janmarvin.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/janmarvin/spaghetti/issues
Last updated from:b293ee7717. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 115 | ||
| source / vignettes | OK | 154 | ||
| linux-release-x86_64 | OK | 99 | ||
| macos-release-arm64 | OK | 73 | ||
| macos-oldrel-arm64 | OK | 101 | ||
| windows-devel | OK | 75 | ||
| windows-release | OK | 72 | ||
| windows-oldrel | OK | 68 | ||
| wasm-release | OK | 74 |
Exports:check_formulaclear_terminologyfrom_xmlfunction_descriptionfunction_prefixfunction_tablehas_terminologyis_ooxmlround_tripsetup_terminologysupported_localesterminology_infoto_xmlxlex
Dependencies:
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Check a formula for unknown function names | check_formula |
| Remove the cached terminology RDS. | clear_terminology |
| Convert an OOXML storage formula to user-facing format | from_xml |
| Look up the English description for a function. | function_description |
| Identify what prefix a function will receive | function_prefix |
| Return the full function translation table. | function_table |
| Check whether locale terminology has been loaded. | has_terminology |
| Check whether a formula is already in OOXML storage format | is_ooxml |
| Round-trip a formula through OOXML and back | round_trip |
| Download and parse the Microsoft Terminology Collection. | setup_terminology |
| List supported locale codes. | supported_locales |
| Metadata about the currently loaded terminology cache. | terminology_info |
| Convert a user-facing formula to OOXML storage format | to_xml |
| Tokenise and display a formula as an ASCII tree | xlex |
