Compare commits
5 Commits
feature/br
...
feature/ni
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
b0ad2848ba | ||
|
|
b079d98908 | ||
|
|
1c731e11fd | ||
|
|
8e6af0cd74 | ||
|
|
835137fa30 |
115
.github/workflows/npm.yml
vendored
@@ -31,38 +31,82 @@ jobs:
|
||||
- host: ubuntu-latest
|
||||
target: x86_64-unknown-linux-gnu
|
||||
docker: ghcr.io/napi-rs/napi-rs/nodejs-rust:lts-debian
|
||||
build: yarn build --target x86_64-unknown-linux-gnu
|
||||
build: |
|
||||
set -e &&
|
||||
rustup toolchain install 1.90.0 &&
|
||||
rustup default 1.90.0 &&
|
||||
yarn build --target x86_64-unknown-linux-gnu
|
||||
- host: ubuntu-latest
|
||||
target: x86_64-unknown-linux-musl
|
||||
docker: ghcr.io/napi-rs/napi-rs/nodejs-rust:lts-alpine
|
||||
build: yarn build --target x86_64-unknown-linux-musl
|
||||
build: |
|
||||
set -e &&
|
||||
rustup toolchain install 1.90.0 &&
|
||||
rustup default 1.90.0 &&
|
||||
yarn build --target x86_64-unknown-linux-musl
|
||||
- host: macos-latest
|
||||
target: aarch64-apple-darwin
|
||||
build: yarn build --target aarch64-apple-darwin
|
||||
build: |
|
||||
set -e &&
|
||||
rustup toolchain install 1.90.0 &&
|
||||
rustup default 1.90.0 &&
|
||||
yarn build --target aarch64-apple-darwin
|
||||
- host: ubuntu-latest
|
||||
target: aarch64-unknown-linux-gnu
|
||||
docker: ghcr.io/napi-rs/napi-rs/nodejs-rust:lts-debian-aarch64
|
||||
build: yarn build --target aarch64-unknown-linux-gnu
|
||||
build: |
|
||||
set -e &&
|
||||
rustup toolchain install 1.90.0 &&
|
||||
rustup default 1.90.0 &&
|
||||
rustup target add aarch64-unknown-linux-gnu &&
|
||||
yarn build --target aarch64-unknown-linux-gnu
|
||||
- host: ubuntu-latest
|
||||
target: armv7-unknown-linux-gnueabihf
|
||||
setup: |
|
||||
sudo apt-get update
|
||||
sudo apt-get install gcc-arm-linux-gnueabihf -y
|
||||
build: yarn build --target armv7-unknown-linux-gnueabihf
|
||||
- host: ubuntu-latest
|
||||
target: armv7-unknown-linux-musleabihf
|
||||
build: yarn build --target armv7-unknown-linux-musleabihf
|
||||
sudo apt-get install -y gcc-arm-linux-gnueabihf libc6-dev-armhf-cross
|
||||
build: |
|
||||
set -e
|
||||
rustup toolchain install 1.90.0
|
||||
rustup default 1.90.0
|
||||
export CC_armv7_unknown_linux_gnueabihf=arm-linux-gnueabihf-gcc
|
||||
export AR_armv7_unknown_linux_gnueabihf=arm-linux-gnueabihf-ar
|
||||
export CARGO_TARGET_ARMV7_UNKNOWN_LINUX_GNUEABIHF_LINKER=arm-linux-gnueabihf-gcc
|
||||
export PKG_CONFIG_ALLOW_CROSS=1
|
||||
yarn build --target armv7-unknown-linux-gnueabihf
|
||||
# - host: ubuntu-latest
|
||||
# target: armv7-unknown-linux-musleabihf
|
||||
# build: |
|
||||
# set -e
|
||||
# rustup toolchain install 1.90.0
|
||||
# rustup default 1.90.0
|
||||
# # Use Zig as the MUSL cross C toolchain
|
||||
# export CC_armv7_unknown_linux_musleabihf="zig cc -target armv7-linux-musleabihf -mfpu=vfpv3-d16 -mfloat-abi=hard"
|
||||
# export CARGO_TARGET_ARMV7_UNKNOWN_LINUX_MUSLEABIHF_LINKER="zig cc -target armv7-linux-musleabihf -mfpu=vfpv3-d16 -mfloat-abi=hard"
|
||||
# export AR_armv7_unknown_linux_musleabihf="zig ar"
|
||||
# export PKG_CONFIG_ALLOW_CROSS=1
|
||||
# yarn build --target armv7-unknown-linux-musleabihf
|
||||
- host: ubuntu-latest
|
||||
target: aarch64-linux-android
|
||||
build: yarn build --target aarch64-linux-android
|
||||
build: |
|
||||
set -e &&
|
||||
rustup toolchain install 1.90.0 &&
|
||||
rustup default 1.90.0 &&
|
||||
yarn build --target aarch64-linux-android
|
||||
- host: ubuntu-latest
|
||||
target: armv7-linux-androideabi
|
||||
build: yarn build --target armv7-linux-androideabi
|
||||
build: |
|
||||
set -e &&
|
||||
rustup toolchain install 1.90.0 &&
|
||||
rustup default 1.90.0 &&
|
||||
yarn build --target armv7-linux-androideabi
|
||||
- host: ubuntu-latest
|
||||
target: aarch64-unknown-linux-musl
|
||||
docker: ghcr.io/napi-rs/napi-rs/nodejs-rust:lts-alpine
|
||||
build: |-
|
||||
set -e &&
|
||||
rustup toolchain install 1.90.0 &&
|
||||
rustup default 1.90.0 &&
|
||||
rustup target add aarch64-unknown-linux-musl &&
|
||||
yarn build --target aarch64-unknown-linux-musl
|
||||
- host: windows-latest
|
||||
@@ -92,7 +136,7 @@ jobs:
|
||||
uses: dtolnay/rust-toolchain@stable
|
||||
if: ${{ !matrix.settings.docker }}
|
||||
with:
|
||||
toolchain: stable
|
||||
toolchain: 1.90.0
|
||||
targets: ${{ matrix.settings.target }}
|
||||
- name: Cache cargo
|
||||
uses: actions/cache@v4
|
||||
@@ -144,7 +188,6 @@ jobs:
|
||||
- host: windows-latest
|
||||
target: x86_64-pc-windows-msvc
|
||||
node:
|
||||
- '18'
|
||||
- '20'
|
||||
runs-on: ${{ matrix.settings.host }}
|
||||
defaults:
|
||||
@@ -179,7 +222,6 @@ jobs:
|
||||
fail-fast: false
|
||||
matrix:
|
||||
node:
|
||||
- '18'
|
||||
- '20'
|
||||
runs-on: ubuntu-latest
|
||||
defaults:
|
||||
@@ -213,7 +255,6 @@ jobs:
|
||||
fail-fast: false
|
||||
matrix:
|
||||
node:
|
||||
- '18'
|
||||
- '20'
|
||||
runs-on: ubuntu-latest
|
||||
defaults:
|
||||
@@ -249,7 +290,6 @@ jobs:
|
||||
fail-fast: false
|
||||
matrix:
|
||||
node:
|
||||
- '18'
|
||||
- '20'
|
||||
runs-on: ubuntu-latest
|
||||
defaults:
|
||||
@@ -320,48 +360,6 @@ jobs:
|
||||
run: |
|
||||
set -e
|
||||
yarn test
|
||||
test-linux-arm-gnueabihf-binding:
|
||||
name: Test bindings on armv7-unknown-linux-gnueabihf - node@${{ matrix.node }}
|
||||
needs:
|
||||
- build
|
||||
strategy:
|
||||
fail-fast: false
|
||||
matrix:
|
||||
node:
|
||||
- '18'
|
||||
- '20'
|
||||
runs-on: ubuntu-latest
|
||||
defaults:
|
||||
run:
|
||||
working-directory: ./bindings/nodejs
|
||||
steps:
|
||||
- uses: actions/checkout@v4
|
||||
- name: Download artifacts
|
||||
uses: actions/download-artifact@v4
|
||||
with:
|
||||
name: bindings-armv7-unknown-linux-gnueabihf
|
||||
path: bindings/nodejs/
|
||||
- name: List packages
|
||||
run: ls -R .
|
||||
shell: bash
|
||||
- name: Install dependencies
|
||||
run: |
|
||||
yarn config set supportedArchitectures.cpu "arm"
|
||||
yarn install
|
||||
- name: Set up QEMU
|
||||
uses: docker/setup-qemu-action@v3
|
||||
with:
|
||||
platforms: arm
|
||||
- run: docker run --rm --privileged multiarch/qemu-user-static --reset -p yes
|
||||
- name: Setup and run tests
|
||||
uses: addnab/docker-run-action@v3
|
||||
with:
|
||||
image: node:${{ matrix.node }}-bullseye-slim
|
||||
options: '--platform linux/arm/v7 -v ${{ github.workspace }}:/build -w /build/bindings/nodejs'
|
||||
run: |
|
||||
set -e
|
||||
yarn test
|
||||
ls -la
|
||||
universal-macOS:
|
||||
name: Build universal macOS binary
|
||||
needs:
|
||||
@@ -410,7 +408,6 @@ jobs:
|
||||
- test-linux-x64-musl-binding
|
||||
- test-linux-aarch64-gnu-binding
|
||||
- test-linux-aarch64-musl-binding
|
||||
- test-linux-arm-gnueabihf-binding
|
||||
- universal-macOS
|
||||
steps:
|
||||
- uses: actions/checkout@v4
|
||||
|
||||
74
Cargo.lock
generated
@@ -218,9 +218,9 @@ checksum = "245097e9a4535ee1e3e3931fcfcd55a796a44c643e8596ff6566d68f09b87bbc"
|
||||
|
||||
[[package]]
|
||||
name = "convert_case"
|
||||
version = "0.6.0"
|
||||
version = "0.8.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "ec182b0ca2f35d8fc196cf3404988fd8b8c739a4d270ff118a398feb0cbec1ca"
|
||||
checksum = "baaaa0ecca5b51987b9423ccdc971514dd8b0bb7b4060b983d3664dad3f1f89f"
|
||||
dependencies = [
|
||||
"unicode-segmentation",
|
||||
]
|
||||
@@ -288,14 +288,20 @@ dependencies = [
|
||||
|
||||
[[package]]
|
||||
name = "ctor"
|
||||
version = "0.2.9"
|
||||
version = "0.5.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "32a2785755761f3ddc1492979ce1e48d2c00d09311c39e4466429188f3dd6501"
|
||||
checksum = "67773048316103656a637612c4a62477603b777d91d9c62ff2290f9cde178fdb"
|
||||
dependencies = [
|
||||
"quote",
|
||||
"syn",
|
||||
"ctor-proc-macro",
|
||||
"dtor",
|
||||
]
|
||||
|
||||
[[package]]
|
||||
name = "ctor-proc-macro"
|
||||
version = "0.0.6"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "e2931af7e13dc045d8e9d26afccc6fa115d64e115c9c84b1166288b46f6782c2"
|
||||
|
||||
[[package]]
|
||||
name = "deranged"
|
||||
version = "0.3.11"
|
||||
@@ -316,6 +322,21 @@ dependencies = [
|
||||
"subtle",
|
||||
]
|
||||
|
||||
[[package]]
|
||||
name = "dtor"
|
||||
version = "0.1.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "e58a0764cddb55ab28955347b45be00ade43d4d6f3ba4bf3dc354e4ec9432934"
|
||||
dependencies = [
|
||||
"dtor-proc-macro",
|
||||
]
|
||||
|
||||
[[package]]
|
||||
name = "dtor-proc-macro"
|
||||
version = "0.0.6"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "f678cf4a922c215c63e0de95eb1ff08a958a81d47e485cf9da1e27bf6305cfa5"
|
||||
|
||||
[[package]]
|
||||
name = "either"
|
||||
version = "1.10.0"
|
||||
@@ -537,33 +558,34 @@ dependencies = [
|
||||
|
||||
[[package]]
|
||||
name = "napi"
|
||||
version = "2.16.13"
|
||||
version = "3.3.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "214f07a80874bb96a8433b3cdfc84980d56c7b02e1a0d7ba4ba0db5cef785e2b"
|
||||
checksum = "f1b74e3dce5230795bb4d2821b941706dee733c7308752507254b0497f39cad7"
|
||||
dependencies = [
|
||||
"bitflags",
|
||||
"ctor",
|
||||
"napi-derive",
|
||||
"napi-build",
|
||||
"napi-sys",
|
||||
"once_cell",
|
||||
"nohash-hasher",
|
||||
"rustc-hash",
|
||||
"serde",
|
||||
"serde_json",
|
||||
]
|
||||
|
||||
[[package]]
|
||||
name = "napi-build"
|
||||
version = "2.1.4"
|
||||
version = "2.2.3"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "db836caddef23662b94e16bf1f26c40eceb09d6aee5d5b06a7ac199320b69b19"
|
||||
checksum = "dcae8ad5609d14afb3a3b91dee88c757016261b151e9dcecabf1b2a31a6cab14"
|
||||
|
||||
[[package]]
|
||||
name = "napi-derive"
|
||||
version = "2.16.13"
|
||||
version = "3.2.5"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "7cbe2585d8ac223f7d34f13701434b9d5f4eb9c332cccce8dee57ea18ab8ab0c"
|
||||
checksum = "7552d5a579b834614bbd496db5109f1b9f1c758f08224b0dee1e408333adf0d0"
|
||||
dependencies = [
|
||||
"cfg-if",
|
||||
"convert_case",
|
||||
"ctor",
|
||||
"napi-derive-backend",
|
||||
"proc-macro2",
|
||||
"quote",
|
||||
@@ -572,28 +594,32 @@ dependencies = [
|
||||
|
||||
[[package]]
|
||||
name = "napi-derive-backend"
|
||||
version = "1.0.75"
|
||||
version = "2.2.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "1639aaa9eeb76e91c6ae66da8ce3e89e921cd3885e99ec85f4abacae72fc91bf"
|
||||
checksum = "5f6a81ac7486b70f2532a289603340862c06eea5a1e650c1ffeda2ce1238516a"
|
||||
dependencies = [
|
||||
"convert_case",
|
||||
"once_cell",
|
||||
"proc-macro2",
|
||||
"quote",
|
||||
"regex",
|
||||
"semver",
|
||||
"syn",
|
||||
]
|
||||
|
||||
[[package]]
|
||||
name = "napi-sys"
|
||||
version = "2.4.0"
|
||||
version = "3.0.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "427802e8ec3a734331fec1035594a210ce1ff4dc5bc1950530920ab717964ea3"
|
||||
checksum = "3e4e7135a8f97aa0f1509cce21a8a1f9dcec1b50d8dee006b48a5adb69a9d64d"
|
||||
dependencies = [
|
||||
"libloading",
|
||||
]
|
||||
|
||||
[[package]]
|
||||
name = "nohash-hasher"
|
||||
version = "0.2.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "2bf50223579dc7cdcfb3bfcacf7069ff68243f8c363f62ffa99cf000a6b9c451"
|
||||
|
||||
[[package]]
|
||||
name = "num-conv"
|
||||
version = "0.1.0"
|
||||
@@ -871,6 +897,12 @@ version = "0.19.0"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "3cd14fd5e3b777a7422cca79358c57a8f6e3a703d9ac187448d0daf220c2407f"
|
||||
|
||||
[[package]]
|
||||
name = "rustc-hash"
|
||||
version = "2.1.1"
|
||||
source = "registry+https://github.com/rust-lang/crates.io-index"
|
||||
checksum = "357703d41365b4b27c590e3ed91eabb1b663f07c4c084095e60cbed4362dff0d"
|
||||
|
||||
[[package]]
|
||||
name = "rustversion"
|
||||
version = "1.0.21"
|
||||
|
||||
|
Before Width: | Height: | Size: 8.1 KiB After Width: | Height: | Size: 5.1 KiB |
|
Before Width: | Height: | Size: 18 KiB After Width: | Height: | Size: 15 KiB |
|
Before Width: | Height: | Size: 7.4 KiB After Width: | Height: | Size: 4.7 KiB |
|
Before Width: | Height: | Size: 538 B After Width: | Height: | Size: 441 B |
|
Before Width: | Height: | Size: 1019 B After Width: | Height: | Size: 729 B |
|
Before Width: | Height: | Size: 15 KiB After Width: | Height: | Size: 15 KiB |
BIN
assets/logo.png
|
Before Width: | Height: | Size: 18 KiB After Width: | Height: | Size: 33 KiB |
@@ -550,14 +550,6 @@ fn args_signature_irr(arg_count: usize) -> Vec<Signature> {
|
||||
}
|
||||
}
|
||||
|
||||
fn args_signature_fvschedule(arg_count: usize) -> Vec<Signature> {
|
||||
if arg_count == 2 {
|
||||
vec![Signature::Scalar, Signature::Vector]
|
||||
} else {
|
||||
vec![Signature::Error; arg_count]
|
||||
}
|
||||
}
|
||||
|
||||
fn args_signature_xirr(arg_count: usize) -> Vec<Signature> {
|
||||
if arg_count == 2 {
|
||||
vec![Signature::Vector; arg_count]
|
||||
@@ -760,7 +752,6 @@ fn get_function_args_signature(kind: &Function, arg_count: usize) -> Vec<Signatu
|
||||
Function::Dollarfr => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Effect => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Fv => args_signature_scalars(arg_count, 3, 2),
|
||||
Function::Fvschedule => args_signature_fvschedule(arg_count),
|
||||
Function::Ipmt => args_signature_scalars(arg_count, 4, 2),
|
||||
Function::Irr => args_signature_irr(arg_count),
|
||||
Function::Ispmt => args_signature_scalars(arg_count, 4, 0),
|
||||
@@ -768,20 +759,9 @@ fn get_function_args_signature(kind: &Function, arg_count: usize) -> Vec<Signatu
|
||||
Function::Nominal => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Nper => args_signature_scalars(arg_count, 3, 2),
|
||||
Function::Npv => args_signature_npv(arg_count),
|
||||
Function::Duration => args_signature_scalars(arg_count, 5, 1),
|
||||
Function::Mduration => args_signature_scalars(arg_count, 5, 1),
|
||||
Function::Pduration => args_signature_scalars(arg_count, 3, 0),
|
||||
Function::Accrint => args_signature_scalars(arg_count, 6, 2),
|
||||
Function::Accrintm => args_signature_scalars(arg_count, 4, 1),
|
||||
Function::Coupdaybs => args_signature_scalars(arg_count, 3, 1),
|
||||
Function::Coupdays => args_signature_scalars(arg_count, 3, 1),
|
||||
Function::Coupdaysnc => args_signature_scalars(arg_count, 3, 1),
|
||||
Function::Coupncd => args_signature_scalars(arg_count, 3, 1),
|
||||
Function::Coupnum => args_signature_scalars(arg_count, 3, 1),
|
||||
Function::Couppcd => args_signature_scalars(arg_count, 3, 1),
|
||||
Function::Pmt => args_signature_scalars(arg_count, 3, 2),
|
||||
Function::Ppmt => args_signature_scalars(arg_count, 4, 2),
|
||||
Function::Price => args_signature_scalars(arg_count, 6, 1),
|
||||
Function::Pv => args_signature_scalars(arg_count, 3, 2),
|
||||
Function::Rate => args_signature_scalars(arg_count, 3, 3),
|
||||
Function::Rri => args_signature_scalars(arg_count, 3, 0),
|
||||
@@ -790,14 +770,6 @@ fn get_function_args_signature(kind: &Function, arg_count: usize) -> Vec<Signatu
|
||||
Function::Tbilleq => args_signature_scalars(arg_count, 3, 0),
|
||||
Function::Tbillprice => args_signature_scalars(arg_count, 3, 0),
|
||||
Function::Tbillyield => args_signature_scalars(arg_count, 3, 0),
|
||||
Function::Yield => args_signature_scalars(arg_count, 6, 1),
|
||||
Function::Pricedisc => args_signature_scalars(arg_count, 4, 1),
|
||||
Function::Pricemat => args_signature_scalars(arg_count, 5, 1),
|
||||
Function::Yielddisc => args_signature_scalars(arg_count, 4, 1),
|
||||
Function::Yieldmat => args_signature_scalars(arg_count, 5, 1),
|
||||
Function::Disc => args_signature_scalars(arg_count, 4, 1),
|
||||
Function::Received => args_signature_scalars(arg_count, 4, 1),
|
||||
Function::Intrate => args_signature_scalars(arg_count, 4, 1),
|
||||
Function::Xirr => args_signature_xirr(arg_count),
|
||||
Function::Xnpv => args_signature_xnpv(arg_count),
|
||||
Function::Besseli => args_signature_scalars(arg_count, 2, 0),
|
||||
@@ -862,48 +834,6 @@ fn get_function_args_signature(kind: &Function, arg_count: usize) -> Vec<Signatu
|
||||
Function::Geomean => vec![Signature::Vector; arg_count],
|
||||
Function::Networkdays => args_signature_networkdays(arg_count),
|
||||
Function::NetworkdaysIntl => args_signature_networkdays_intl(arg_count),
|
||||
Function::Acot => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Acoth => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Cot => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Coth => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Csc => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Csch => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Sec => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Sech => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Exp => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Fact => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Factdouble => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Sign => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Radians => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Degrees => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Int => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Even => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Odd => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Ceiling => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::CeilingMath => args_signature_scalars(arg_count, 1, 2),
|
||||
Function::CeilingPrecise => args_signature_scalars(arg_count, 1, 1),
|
||||
Function::Floor => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::FloorMath => args_signature_scalars(arg_count, 1, 2),
|
||||
Function::FloorPrecise => args_signature_scalars(arg_count, 1, 1),
|
||||
Function::IsoCeiling => args_signature_scalars(arg_count, 1, 1),
|
||||
Function::Mod => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Quotient => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Mround => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Trunc => args_signature_scalars(arg_count, 1, 1),
|
||||
Function::Gcd => vec![Signature::Vector; arg_count],
|
||||
Function::Lcm => vec![Signature::Vector; arg_count],
|
||||
Function::Base => args_signature_scalars(arg_count, 2, 1),
|
||||
Function::Decimal => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Roman => args_signature_scalars(arg_count, 1, 1),
|
||||
Function::Arabic => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Combin => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Combina => args_signature_scalars(arg_count, 2, 0),
|
||||
Function::Sumsq => vec![Signature::Vector; arg_count],
|
||||
|
||||
Function::N => args_signature_scalars(arg_count, 1, 0),
|
||||
Function::Sheets => args_signature_scalars(arg_count, 0, 1),
|
||||
Function::Cell => args_signature_scalars(arg_count, 1, 1),
|
||||
Function::Info => args_signature_scalars(arg_count, 1, 1),
|
||||
}
|
||||
}
|
||||
|
||||
@@ -1044,7 +974,6 @@ fn static_analysis_on_function(kind: &Function, args: &[Node]) -> StaticResult {
|
||||
Function::Dollarfr => not_implemented(args),
|
||||
Function::Effect => not_implemented(args),
|
||||
Function::Fv => not_implemented(args),
|
||||
Function::Fvschedule => not_implemented(args),
|
||||
Function::Ipmt => not_implemented(args),
|
||||
Function::Irr => not_implemented(args),
|
||||
Function::Ispmt => not_implemented(args),
|
||||
@@ -1052,20 +981,9 @@ fn static_analysis_on_function(kind: &Function, args: &[Node]) -> StaticResult {
|
||||
Function::Nominal => not_implemented(args),
|
||||
Function::Nper => not_implemented(args),
|
||||
Function::Npv => not_implemented(args),
|
||||
Function::Duration => not_implemented(args),
|
||||
Function::Mduration => not_implemented(args),
|
||||
Function::Pduration => not_implemented(args),
|
||||
Function::Accrint => not_implemented(args),
|
||||
Function::Accrintm => not_implemented(args),
|
||||
Function::Coupdaybs => not_implemented(args),
|
||||
Function::Coupdays => not_implemented(args),
|
||||
Function::Coupdaysnc => not_implemented(args),
|
||||
Function::Coupncd => not_implemented(args),
|
||||
Function::Coupnum => not_implemented(args),
|
||||
Function::Couppcd => not_implemented(args),
|
||||
Function::Pmt => not_implemented(args),
|
||||
Function::Ppmt => not_implemented(args),
|
||||
Function::Price => not_implemented(args),
|
||||
Function::Pv => not_implemented(args),
|
||||
Function::Rate => not_implemented(args),
|
||||
Function::Rri => not_implemented(args),
|
||||
@@ -1074,14 +992,6 @@ fn static_analysis_on_function(kind: &Function, args: &[Node]) -> StaticResult {
|
||||
Function::Tbilleq => not_implemented(args),
|
||||
Function::Tbillprice => not_implemented(args),
|
||||
Function::Tbillyield => not_implemented(args),
|
||||
Function::Yield => not_implemented(args),
|
||||
Function::Pricedisc => not_implemented(args),
|
||||
Function::Pricemat => not_implemented(args),
|
||||
Function::Yielddisc => not_implemented(args),
|
||||
Function::Yieldmat => not_implemented(args),
|
||||
Function::Disc => not_implemented(args),
|
||||
Function::Received => not_implemented(args),
|
||||
Function::Intrate => not_implemented(args),
|
||||
Function::Xirr => not_implemented(args),
|
||||
Function::Xnpv => not_implemented(args),
|
||||
Function::Besseli => scalar_arguments(args),
|
||||
@@ -1146,46 +1056,5 @@ fn static_analysis_on_function(kind: &Function, args: &[Node]) -> StaticResult {
|
||||
Function::Geomean => not_implemented(args),
|
||||
Function::Networkdays => not_implemented(args),
|
||||
Function::NetworkdaysIntl => not_implemented(args),
|
||||
Function::Acot => scalar_arguments(args),
|
||||
Function::Acoth => scalar_arguments(args),
|
||||
Function::Cot => scalar_arguments(args),
|
||||
Function::Coth => scalar_arguments(args),
|
||||
Function::Csc => scalar_arguments(args),
|
||||
Function::Csch => scalar_arguments(args),
|
||||
Function::Sec => scalar_arguments(args),
|
||||
Function::Sech => scalar_arguments(args),
|
||||
Function::Exp => scalar_arguments(args),
|
||||
Function::Fact => scalar_arguments(args),
|
||||
Function::Factdouble => scalar_arguments(args),
|
||||
Function::Sign => scalar_arguments(args),
|
||||
Function::Radians => scalar_arguments(args),
|
||||
Function::Degrees => scalar_arguments(args),
|
||||
Function::Int => scalar_arguments(args),
|
||||
Function::Even => scalar_arguments(args),
|
||||
Function::Odd => scalar_arguments(args),
|
||||
Function::Ceiling => scalar_arguments(args),
|
||||
Function::CeilingMath => scalar_arguments(args),
|
||||
Function::CeilingPrecise => scalar_arguments(args),
|
||||
Function::Floor => scalar_arguments(args),
|
||||
Function::FloorMath => scalar_arguments(args),
|
||||
Function::FloorPrecise => scalar_arguments(args),
|
||||
Function::IsoCeiling => scalar_arguments(args),
|
||||
Function::Mod => scalar_arguments(args),
|
||||
Function::Quotient => scalar_arguments(args),
|
||||
Function::Mround => scalar_arguments(args),
|
||||
Function::Trunc => scalar_arguments(args),
|
||||
Function::Gcd => not_implemented(args),
|
||||
Function::Lcm => not_implemented(args),
|
||||
Function::Base => scalar_arguments(args),
|
||||
Function::Decimal => scalar_arguments(args),
|
||||
Function::Roman => scalar_arguments(args),
|
||||
Function::Arabic => scalar_arguments(args),
|
||||
Function::Combin => scalar_arguments(args),
|
||||
Function::Combina => scalar_arguments(args),
|
||||
Function::Sumsq => StaticResult::Scalar,
|
||||
Function::N => scalar_arguments(args),
|
||||
Function::Sheets => scalar_arguments(args),
|
||||
Function::Cell => scalar_arguments(args),
|
||||
Function::Info => scalar_arguments(args),
|
||||
}
|
||||
}
|
||||
|
||||
@@ -520,7 +520,6 @@ fn stringify(
|
||||
let x = match **left {
|
||||
BooleanKind(_)
|
||||
| NumberKind(_)
|
||||
| UnaryKind { .. }
|
||||
| StringKind(_)
|
||||
| ReferenceKind { .. }
|
||||
| RangeKind { .. }
|
||||
@@ -536,6 +535,7 @@ fn stringify(
|
||||
| FunctionKind { .. }
|
||||
| InvalidFunctionKind { .. }
|
||||
| ArrayKind(_)
|
||||
| UnaryKind { .. }
|
||||
| ErrorKind(_)
|
||||
| ParseErrorKind { .. }
|
||||
| OpSumKind { .. }
|
||||
@@ -630,6 +630,7 @@ fn stringify(
|
||||
| OpRangeKind { .. }
|
||||
| OpConcatenateKind { .. }
|
||||
| OpProductKind { .. }
|
||||
| OpPowerKind { .. }
|
||||
| FunctionKind { .. }
|
||||
| InvalidFunctionKind { .. }
|
||||
| ArrayKind(_)
|
||||
@@ -642,7 +643,7 @@ fn stringify(
|
||||
| ParseErrorKind { .. }
|
||||
| EmptyArgKind => false,
|
||||
|
||||
OpPowerKind { .. } | OpSumKind { .. } | UnaryKind { .. } => true,
|
||||
OpSumKind { .. } | UnaryKind { .. } => true,
|
||||
};
|
||||
if needs_parentheses {
|
||||
format!(
|
||||
|
||||
@@ -3,7 +3,6 @@ mod test_arrays;
|
||||
mod test_general;
|
||||
mod test_implicit_intersection;
|
||||
mod test_issue_155;
|
||||
mod test_issue_483;
|
||||
mod test_move_formula;
|
||||
mod test_ranges;
|
||||
mod test_stringify;
|
||||
|
||||
@@ -1,27 +0,0 @@
|
||||
#![allow(clippy::panic)]
|
||||
|
||||
use std::collections::HashMap;
|
||||
|
||||
use crate::expressions::parser::stringify::to_string;
|
||||
use crate::expressions::parser::{Node, Parser};
|
||||
use crate::expressions::types::CellReferenceRC;
|
||||
|
||||
#[test]
|
||||
fn issue_483_parser() {
|
||||
let worksheets = vec!["Sheet1".to_string()];
|
||||
let mut parser = Parser::new(worksheets, vec![], HashMap::new());
|
||||
|
||||
// Reference cell is Sheet1!A1
|
||||
let cell_reference = CellReferenceRC {
|
||||
sheet: "Sheet1".to_string(),
|
||||
row: 2,
|
||||
column: 2,
|
||||
};
|
||||
let t = parser.parse("-(A1^1.22)", &cell_reference);
|
||||
assert!(matches!(t, Node::UnaryKind { .. }));
|
||||
assert_eq!(to_string(&t, &cell_reference), "-(A1^1.22)");
|
||||
|
||||
let t = parser.parse("-A1^1.22", &cell_reference);
|
||||
assert!(matches!(t, Node::OpPowerKind { .. }));
|
||||
assert_eq!(to_string(&t, &cell_reference), "-A1^1.22");
|
||||
}
|
||||
@@ -259,23 +259,15 @@ pub fn is_valid_identifier(name: &str) -> bool {
|
||||
fn name_needs_quoting(name: &str) -> bool {
|
||||
let chars = name.chars();
|
||||
// it contains any of these characters: ()'$,;-+{} or space
|
||||
for (i, char) in chars.enumerate() {
|
||||
for char in chars {
|
||||
if [' ', '(', ')', '\'', '$', ',', ';', '-', '+', '{', '}'].contains(&char) {
|
||||
return true;
|
||||
}
|
||||
// if it starts with a number
|
||||
if i == 0 && char.is_ascii_digit() {
|
||||
return true;
|
||||
}
|
||||
}
|
||||
if parse_reference_a1(name).is_some() {
|
||||
// cell reference in A1 notation, e.g. B1048576 is quoted, B1048577 is not
|
||||
return true;
|
||||
}
|
||||
if parse_reference_r1c1(name).is_some() {
|
||||
// cell reference in R1C1 notation, e.g. RC, RC2, R5C, R-4C, RC-8, R, C
|
||||
return true;
|
||||
}
|
||||
// TODO:
|
||||
// cell reference in A1 notation, e.g. B1048576 is quoted, B1048577 is not
|
||||
// cell reference in R1C1 notation, e.g. RC, RC2, R5C, R-4C, RC-8, R, C
|
||||
// integers
|
||||
false
|
||||
}
|
||||
|
||||
@@ -287,32 +279,3 @@ pub fn quote_name(name: &str) -> String {
|
||||
};
|
||||
name.to_string()
|
||||
}
|
||||
|
||||
#[cfg(test)]
|
||||
mod tests {
|
||||
use super::*;
|
||||
|
||||
#[test]
|
||||
fn test_quote_name() {
|
||||
assert_eq!(quote_name("Sheet1"), "Sheet1");
|
||||
assert_eq!(quote_name("Sheet 1"), "'Sheet 1'");
|
||||
// escape and quote
|
||||
assert_eq!(quote_name("Sheet1'"), "'Sheet1'''");
|
||||
assert_eq!(quote_name("Data(2024)"), "'Data(2024)'");
|
||||
assert_eq!(quote_name("Data$2024"), "'Data$2024'");
|
||||
assert_eq!(quote_name("Data-2024"), "'Data-2024'");
|
||||
assert_eq!(quote_name("Data+2024"), "'Data+2024'");
|
||||
assert_eq!(quote_name("Data,2024"), "'Data,2024'");
|
||||
assert_eq!(quote_name("Data;2024"), "'Data;2024'");
|
||||
assert_eq!(quote_name("Data{2024}"), "'Data{2024}'");
|
||||
|
||||
assert_eq!(quote_name("2024"), "'2024'");
|
||||
assert_eq!(quote_name("1Data"), "'1Data'");
|
||||
assert_eq!(quote_name("A1"), "'A1'");
|
||||
assert_eq!(quote_name("R1C1"), "'R1C1'");
|
||||
assert_eq!(quote_name("MySheet"), "MySheet");
|
||||
|
||||
assert_eq!(quote_name("B1048576"), "'B1048576'");
|
||||
assert_eq!(quote_name("B1048577"), "B1048577");
|
||||
}
|
||||
}
|
||||
|
||||
@@ -154,11 +154,16 @@ pub fn format_number(value_original: f64, format: &str, locale: &Locale) -> Form
|
||||
ParsePart::Date(p) => {
|
||||
let tokens = &p.tokens;
|
||||
let mut text = "".to_string();
|
||||
let time_fract = value.fract();
|
||||
let hours = (time_fract * 24.0).floor();
|
||||
let minutes = ((time_fract * 24.0 - hours) * 60.0).floor();
|
||||
let seconds = ((((time_fract * 24.0 - hours) * 60.0) - minutes) * 60.0).round();
|
||||
let date = from_excel_date(value as i64).ok();
|
||||
let date = match from_excel_date(value as i64) {
|
||||
Ok(d) => d,
|
||||
Err(e) => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(e),
|
||||
}
|
||||
}
|
||||
};
|
||||
for token in tokens {
|
||||
match token {
|
||||
TextToken::Literal(c) => {
|
||||
@@ -182,44 +187,15 @@ pub fn format_number(value_original: f64, format: &str, locale: &Locale) -> Form
|
||||
}
|
||||
TextToken::Digit(_) => {}
|
||||
TextToken::Period => {}
|
||||
TextToken::Day => match date {
|
||||
Some(date) => {
|
||||
let day = date.day() as usize;
|
||||
text = format!("{text}{day}");
|
||||
}
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
},
|
||||
TextToken::Day => {
|
||||
let day = date.day() as usize;
|
||||
text = format!("{text}{day}");
|
||||
}
|
||||
TextToken::DayPadded => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let day = date.day() as usize;
|
||||
text = format!("{text}{day:02}");
|
||||
}
|
||||
TextToken::DayNameShort => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let mut day = date.weekday().number_from_monday() as usize;
|
||||
if day == 7 {
|
||||
day = 0;
|
||||
@@ -227,16 +203,6 @@ pub fn format_number(value_original: f64, format: &str, locale: &Locale) -> Form
|
||||
text = format!("{}{}", text, &locale.dates.day_names_short[day]);
|
||||
}
|
||||
TextToken::DayName => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let mut day = date.weekday().number_from_monday() as usize;
|
||||
if day == 7 {
|
||||
day = 0;
|
||||
@@ -244,144 +210,32 @@ pub fn format_number(value_original: f64, format: &str, locale: &Locale) -> Form
|
||||
text = format!("{}{}", text, &locale.dates.day_names[day]);
|
||||
}
|
||||
TextToken::Month => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let month = date.month() as usize;
|
||||
text = format!("{text}{month}");
|
||||
}
|
||||
TextToken::MonthPadded => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let month = date.month() as usize;
|
||||
text = format!("{text}{month:02}");
|
||||
}
|
||||
TextToken::MonthNameShort => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let month = date.month() as usize;
|
||||
text = format!("{}{}", text, &locale.dates.months_short[month - 1]);
|
||||
}
|
||||
TextToken::MonthName => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let month = date.month() as usize;
|
||||
text = format!("{}{}", text, &locale.dates.months[month - 1]);
|
||||
}
|
||||
TextToken::MonthLetter => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
let month = date.month() as usize;
|
||||
let months_letter = &locale.dates.months_letter[month - 1];
|
||||
text = format!("{text}{months_letter}");
|
||||
}
|
||||
TextToken::YearShort => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
text = format!("{}{}", text, date.format("%y"));
|
||||
}
|
||||
TextToken::Year => {
|
||||
let date = match date {
|
||||
Some(d) => d,
|
||||
None => {
|
||||
return Formatted {
|
||||
text: "#VALUE!".to_owned(),
|
||||
color: None,
|
||||
error: Some(format!("Invalid date value: '{value}'")),
|
||||
}
|
||||
}
|
||||
};
|
||||
text = format!("{}{}", text, date.year());
|
||||
}
|
||||
TextToken::Hour => {
|
||||
let mut hour = hours as i32;
|
||||
if p.use_ampm {
|
||||
if hour == 0 {
|
||||
hour = 12;
|
||||
} else if hour > 12 {
|
||||
hour -= 12;
|
||||
}
|
||||
}
|
||||
text = format!("{text}{hour}");
|
||||
}
|
||||
TextToken::HourPadded => {
|
||||
let mut hour = hours as i32;
|
||||
if p.use_ampm {
|
||||
if hour == 0 {
|
||||
hour = 12;
|
||||
} else if hour > 12 {
|
||||
hour -= 12;
|
||||
}
|
||||
}
|
||||
text = format!("{text}{hour:02}");
|
||||
}
|
||||
TextToken::Second => {
|
||||
let second = seconds as i32;
|
||||
text = format!("{text}{second}");
|
||||
}
|
||||
TextToken::SecondPadded => {
|
||||
let second = seconds as i32;
|
||||
text = format!("{text}{second:02}");
|
||||
}
|
||||
TextToken::AMPM => {
|
||||
let ampm = if hours < 12.0 { "AM" } else { "PM" };
|
||||
text = format!("{text}{ampm}");
|
||||
}
|
||||
TextToken::Minute => {
|
||||
let minute = minutes as i32;
|
||||
text = format!("{text}{minute}");
|
||||
}
|
||||
TextToken::MinutePadded => {
|
||||
let minute = minutes as i32;
|
||||
text = format!("{text}{minute:02}");
|
||||
}
|
||||
}
|
||||
}
|
||||
Formatted {
|
||||
@@ -568,13 +422,6 @@ pub fn format_number(value_original: f64, format: &str, locale: &Locale) -> Form
|
||||
TextToken::MonthLetter => {}
|
||||
TextToken::YearShort => {}
|
||||
TextToken::Year => {}
|
||||
TextToken::Hour => {}
|
||||
TextToken::HourPadded => {}
|
||||
TextToken::Minute => {}
|
||||
TextToken::MinutePadded => {}
|
||||
TextToken::Second => {}
|
||||
TextToken::SecondPadded => {}
|
||||
TextToken::AMPM => {}
|
||||
}
|
||||
}
|
||||
Formatted {
|
||||
|
||||
@@ -26,23 +26,19 @@ pub enum Token {
|
||||
Scientific, // E+
|
||||
ScientificMinus, // E-
|
||||
General, // General
|
||||
// Dates and time
|
||||
// Dates
|
||||
Day, // d
|
||||
DayPadded, // dd
|
||||
DayNameShort, // ddd
|
||||
DayName, // dddd+
|
||||
Month, // m (or minute)
|
||||
MonthPadded, // mm (or minute padded)
|
||||
Month, // m
|
||||
MonthPadded, // mm
|
||||
MonthNameShort, // mmm
|
||||
MonthName, // mmmm or mmmmmm+
|
||||
MonthLetter, // mmmmm
|
||||
YearShort, // y or yy
|
||||
Year, // yyy+
|
||||
Hour, // h
|
||||
HourPadded, // hh
|
||||
Second, // s
|
||||
SecondPadded, // ss
|
||||
AMPM, // AM/PM (or A/P)
|
||||
// TODO: Hours Minutes and Seconds
|
||||
ILLEGAL,
|
||||
EOF,
|
||||
}
|
||||
@@ -365,8 +361,8 @@ impl Lexer {
|
||||
self.read_next_char();
|
||||
}
|
||||
match m {
|
||||
1 => Token::Month, // (or minute)
|
||||
2 => Token::MonthPadded, // (or minute padded)
|
||||
1 => Token::Month,
|
||||
2 => Token::MonthPadded,
|
||||
3 => Token::MonthNameShort,
|
||||
4 => Token::MonthName,
|
||||
5 => Token::MonthLetter,
|
||||
@@ -385,63 +381,6 @@ impl Lexer {
|
||||
Token::Year
|
||||
}
|
||||
}
|
||||
'h' => {
|
||||
let mut h = 1;
|
||||
while let Some('h') = self.peek_char() {
|
||||
h += 1;
|
||||
self.read_next_char();
|
||||
}
|
||||
if h == 1 {
|
||||
Token::Hour
|
||||
} else if h == 2 {
|
||||
Token::HourPadded
|
||||
} else {
|
||||
self.set_error("Unexpected character after 'h'");
|
||||
Token::ILLEGAL
|
||||
}
|
||||
}
|
||||
's' => {
|
||||
let mut s = 1;
|
||||
while let Some('s') = self.peek_char() {
|
||||
s += 1;
|
||||
self.read_next_char();
|
||||
}
|
||||
if s == 1 {
|
||||
Token::Second
|
||||
} else if s == 2 {
|
||||
Token::SecondPadded
|
||||
} else {
|
||||
self.set_error("Unexpected character after 's'");
|
||||
Token::ILLEGAL
|
||||
}
|
||||
}
|
||||
'A' | 'a' => {
|
||||
if let Some('M') | Some('m') = self.peek_char() {
|
||||
self.read_next_char();
|
||||
} else {
|
||||
self.set_error("Unexpected character after 'A'");
|
||||
return Token::ILLEGAL;
|
||||
}
|
||||
if let Some('/') = self.peek_char() {
|
||||
self.read_next_char();
|
||||
} else {
|
||||
self.set_error("Unexpected character after 'AM'");
|
||||
return Token::ILLEGAL;
|
||||
}
|
||||
if let Some('P') | Some('p') = self.peek_char() {
|
||||
self.read_next_char();
|
||||
} else {
|
||||
self.set_error("Unexpected character after 'AM'");
|
||||
return Token::ILLEGAL;
|
||||
}
|
||||
if let Some('M') | Some('m') = self.peek_char() {
|
||||
self.read_next_char();
|
||||
} else {
|
||||
self.set_error("Unexpected character after 'AMP'");
|
||||
return Token::ILLEGAL;
|
||||
}
|
||||
Token::AMPM
|
||||
}
|
||||
'g' | 'G' => {
|
||||
for c in "eneral".chars() {
|
||||
let cc = self.read_next_char();
|
||||
|
||||
@@ -27,13 +27,6 @@ pub enum TextToken {
|
||||
MonthLetter,
|
||||
YearShort,
|
||||
Year,
|
||||
Hour,
|
||||
HourPadded,
|
||||
Minute,
|
||||
MinutePadded,
|
||||
Second,
|
||||
SecondPadded,
|
||||
AMPM,
|
||||
}
|
||||
pub struct NumberPart {
|
||||
pub color: Option<i32>,
|
||||
@@ -52,7 +45,6 @@ pub struct NumberPart {
|
||||
|
||||
pub struct DatePart {
|
||||
pub color: Option<i32>,
|
||||
pub use_ampm: bool,
|
||||
pub tokens: Vec<TextToken>,
|
||||
}
|
||||
|
||||
@@ -109,7 +101,6 @@ impl Parser {
|
||||
let mut digit_count = 0;
|
||||
let mut precision = 0;
|
||||
let mut is_date = false;
|
||||
let mut use_ampm = false;
|
||||
let mut is_number = false;
|
||||
let mut found_decimal_dot = false;
|
||||
let mut use_thousands = false;
|
||||
@@ -125,7 +116,6 @@ impl Parser {
|
||||
let mut number = 'i';
|
||||
let mut index = 0;
|
||||
let mut currency = None;
|
||||
let mut is_time = false;
|
||||
|
||||
while token != Token::EOF && token != Token::Separator {
|
||||
let next_token = self.lexer.next_token();
|
||||
@@ -210,9 +200,6 @@ impl Parser {
|
||||
index += 1;
|
||||
}
|
||||
Token::Literal(value) => {
|
||||
if value == ':' {
|
||||
is_time = true;
|
||||
}
|
||||
tokens.push(TextToken::Literal(value));
|
||||
}
|
||||
Token::Text(value) => {
|
||||
@@ -249,22 +236,12 @@ impl Parser {
|
||||
tokens.push(TextToken::MonthName);
|
||||
}
|
||||
Token::Month => {
|
||||
if is_time {
|
||||
// minute
|
||||
tokens.push(TextToken::Minute);
|
||||
} else {
|
||||
is_date = true;
|
||||
tokens.push(TextToken::Month);
|
||||
}
|
||||
is_date = true;
|
||||
tokens.push(TextToken::Month);
|
||||
}
|
||||
Token::MonthPadded => {
|
||||
if is_time {
|
||||
// minute padded
|
||||
tokens.push(TextToken::MinutePadded);
|
||||
} else {
|
||||
is_date = true;
|
||||
tokens.push(TextToken::MonthPadded);
|
||||
}
|
||||
is_date = true;
|
||||
tokens.push(TextToken::MonthPadded);
|
||||
}
|
||||
Token::MonthLetter => {
|
||||
is_date = true;
|
||||
@@ -278,32 +255,6 @@ impl Parser {
|
||||
is_date = true;
|
||||
tokens.push(TextToken::Year);
|
||||
}
|
||||
Token::Hour => {
|
||||
is_date = true;
|
||||
is_time = true;
|
||||
tokens.push(TextToken::Hour);
|
||||
}
|
||||
Token::HourPadded => {
|
||||
is_date = true;
|
||||
is_time = true;
|
||||
tokens.push(TextToken::HourPadded);
|
||||
}
|
||||
Token::Second => {
|
||||
is_date = true;
|
||||
is_time = true;
|
||||
tokens.push(TextToken::Second);
|
||||
}
|
||||
Token::SecondPadded => {
|
||||
is_date = true;
|
||||
is_time = true;
|
||||
tokens.push(TextToken::SecondPadded);
|
||||
}
|
||||
|
||||
Token::AMPM => {
|
||||
is_date = true;
|
||||
use_ampm = true;
|
||||
tokens.push(TextToken::AMPM);
|
||||
}
|
||||
Token::Scientific => {
|
||||
if !is_scientific {
|
||||
index = 0;
|
||||
@@ -331,11 +282,7 @@ impl Parser {
|
||||
if is_number {
|
||||
return ParsePart::Error(ErrorPart {});
|
||||
}
|
||||
ParsePart::Date(DatePart {
|
||||
color,
|
||||
use_ampm,
|
||||
tokens,
|
||||
})
|
||||
ParsePart::Date(DatePart { color, tokens })
|
||||
} else {
|
||||
ParsePart::Number(NumberPart {
|
||||
color,
|
||||
|
||||
@@ -1,3 +1,2 @@
|
||||
mod test_general;
|
||||
mod test_parse_formatted_number;
|
||||
mod test_time;
|
||||
|
||||
@@ -1,32 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::{
|
||||
formatter::format::format_number,
|
||||
locale::{get_locale, Locale},
|
||||
};
|
||||
|
||||
fn get_default_locale() -> &'static Locale {
|
||||
get_locale("en").unwrap()
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn simple_test() {
|
||||
let locale = get_default_locale();
|
||||
let format = "h:mm AM/PM";
|
||||
let value = 16.001_423_611_111_11; // =1/86400 => 12:02 AM
|
||||
let formatted = format_number(value, format, locale);
|
||||
assert_eq!(formatted.text, "12:02 AM");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn padded_vs_unpadded() {
|
||||
let locale = get_default_locale();
|
||||
let padded_format = "hh:mm:ss AM/PM";
|
||||
let unpadded_format = "h:m:s AM/PM";
|
||||
let value = 0.25351851851851853; // => 6:05:04 AM (21904/(24*60*60)) where 21904 = 6 * 3600 + 5*60 + 4
|
||||
let formatted = format_number(value, padded_format, locale);
|
||||
assert_eq!(formatted.text, "06:05:04 AM");
|
||||
|
||||
let formatted = format_number(value, unpadded_format, locale);
|
||||
assert_eq!(formatted.text, "6:5:4 AM");
|
||||
}
|
||||
@@ -1,6 +1,6 @@
|
||||
use crate::{
|
||||
calc_result::CalcResult,
|
||||
expressions::{parser::Node, token::Error, types::CellReferenceIndex, utils::number_to_column},
|
||||
expressions::{parser::Node, token::Error, types::CellReferenceIndex},
|
||||
model::{Model, ParsedDefinedName},
|
||||
};
|
||||
|
||||
@@ -320,150 +320,4 @@ impl Model {
|
||||
message: "Invalid name".to_string(),
|
||||
}
|
||||
}
|
||||
|
||||
pub(crate) fn fn_n(&mut self, args: &[Node], cell: CellReferenceIndex) -> CalcResult {
|
||||
let arg_count = args.len();
|
||||
if arg_count != 1 {
|
||||
return CalcResult::new_args_number_error(cell);
|
||||
}
|
||||
let value = match self.evaluate_node_in_context(&args[0], cell) {
|
||||
CalcResult::Number(n) => n,
|
||||
CalcResult::String(_) => 0.0,
|
||||
CalcResult::Boolean(f) => {
|
||||
if f {
|
||||
1.0
|
||||
} else {
|
||||
0.0
|
||||
}
|
||||
}
|
||||
CalcResult::EmptyCell | CalcResult::EmptyArg => 0.0,
|
||||
error @ CalcResult::Error { .. } => return error,
|
||||
CalcResult::Range { .. } => {
|
||||
return CalcResult::Error {
|
||||
error: Error::NIMPL,
|
||||
origin: cell,
|
||||
message: "Arrays not supported yet".to_string(),
|
||||
}
|
||||
}
|
||||
CalcResult::Array(_) => {
|
||||
return CalcResult::Error {
|
||||
error: Error::NIMPL,
|
||||
origin: cell,
|
||||
message: "Arrays not supported yet".to_string(),
|
||||
}
|
||||
}
|
||||
};
|
||||
|
||||
CalcResult::Number(value)
|
||||
}
|
||||
|
||||
pub(crate) fn fn_sheets(&mut self, args: &[Node], cell: CellReferenceIndex) -> CalcResult {
|
||||
let arg_count = args.len();
|
||||
if arg_count > 1 {
|
||||
return CalcResult::new_args_number_error(cell);
|
||||
}
|
||||
if arg_count == 1 {
|
||||
return CalcResult::Error {
|
||||
error: Error::NIMPL,
|
||||
origin: cell,
|
||||
message: "Sheets function with an argument is not implemented".to_string(),
|
||||
};
|
||||
}
|
||||
let sheet_count = self.workbook.worksheets.len() as f64;
|
||||
CalcResult::Number(sheet_count)
|
||||
}
|
||||
|
||||
pub(crate) fn fn_cell(&mut self, args: &[Node], cell: CellReferenceIndex) -> CalcResult {
|
||||
let arg_count = args.len();
|
||||
if arg_count == 0 || arg_count > 2 {
|
||||
return CalcResult::new_args_number_error(cell);
|
||||
}
|
||||
let reference = if arg_count == 2 {
|
||||
match self.evaluate_node_with_reference(&args[1], cell) {
|
||||
CalcResult::Range { left, right: _ } => {
|
||||
// we just take the left cell of the range
|
||||
left
|
||||
}
|
||||
_ => {
|
||||
return CalcResult::Error {
|
||||
error: Error::VALUE,
|
||||
origin: cell,
|
||||
message: "Argument must be a reference".to_string(),
|
||||
}
|
||||
}
|
||||
}
|
||||
} else {
|
||||
CellReferenceIndex {
|
||||
sheet: cell.sheet,
|
||||
row: cell.row,
|
||||
column: cell.column,
|
||||
}
|
||||
};
|
||||
let info_type = match self.get_string(&args[0], cell) {
|
||||
Ok(s) => s.to_uppercase(),
|
||||
Err(e) => return e,
|
||||
};
|
||||
match info_type.as_str() {
|
||||
"ADDRESS" => {
|
||||
if reference.sheet != cell.sheet {
|
||||
return CalcResult::Error {
|
||||
error: Error::NIMPL,
|
||||
origin: cell,
|
||||
message: "References to other sheets not implemented".to_string(),
|
||||
};
|
||||
}
|
||||
let column = match number_to_column(reference.column) {
|
||||
Some(c) => c,
|
||||
None => {
|
||||
return CalcResult::Error {
|
||||
error: Error::VALUE,
|
||||
origin: cell,
|
||||
message: "Invalid column".to_string(),
|
||||
}
|
||||
}
|
||||
};
|
||||
let address = format!("${}${}", column, reference.row);
|
||||
CalcResult::String(address)
|
||||
}
|
||||
"COL" => CalcResult::Number(reference.column as f64),
|
||||
"COLOR" | "FILENAME" | "FORMAT" | "PARENTHESES" | "PREFIX" | "PROTECT" | "WIDTH" => {
|
||||
CalcResult::Error {
|
||||
error: Error::VALUE,
|
||||
origin: cell,
|
||||
message: "info_type not implemented".to_string(),
|
||||
}
|
||||
}
|
||||
"CONTENTS" => self.evaluate_cell(reference),
|
||||
"ROW" => CalcResult::Number(reference.row as f64),
|
||||
"TYPE" => {
|
||||
let cell_type = match self.evaluate_cell(reference) {
|
||||
CalcResult::EmptyCell => "b",
|
||||
CalcResult::String(_) => "l",
|
||||
CalcResult::Number(_) => "v",
|
||||
CalcResult::Boolean(_) => "v",
|
||||
CalcResult::Error { .. } => "v",
|
||||
CalcResult::Range { .. } => "v",
|
||||
CalcResult::EmptyArg => "v",
|
||||
CalcResult::Array(_) => "v",
|
||||
};
|
||||
CalcResult::String(cell_type.to_string())
|
||||
}
|
||||
_ => CalcResult::Error {
|
||||
error: Error::VALUE,
|
||||
origin: cell,
|
||||
message: "Invalid info_type".to_string(),
|
||||
},
|
||||
}
|
||||
}
|
||||
|
||||
pub(crate) fn fn_info(&mut self, args: &[Node], cell: CellReferenceIndex) -> CalcResult {
|
||||
if args.is_empty() || args.len() > 2 {
|
||||
return CalcResult::new_args_number_error(cell);
|
||||
}
|
||||
CalcResult::Error {
|
||||
error: Error::NIMPL,
|
||||
origin: cell,
|
||||
message: "Info function not implemented".to_string(),
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
@@ -1,200 +0,0 @@
|
||||
/// Parse Roman (classic or Excel variants) → number
|
||||
pub fn from_roman(s: &str) -> Result<u32, String> {
|
||||
if s.is_empty() {
|
||||
return Err("empty numeral".into());
|
||||
}
|
||||
fn val(c: char) -> Option<u32> {
|
||||
Some(match c {
|
||||
'I' => 1,
|
||||
'V' => 5,
|
||||
'X' => 10,
|
||||
'L' => 50,
|
||||
'C' => 100,
|
||||
'D' => 500,
|
||||
'M' => 1000,
|
||||
_ => return None,
|
||||
})
|
||||
}
|
||||
|
||||
// Accept the union of subtractive pairs used by the tables above (Excel-compatible).
|
||||
fn allowed_subtractive(a: char, b: char) -> bool {
|
||||
matches!(
|
||||
(a, b),
|
||||
// classic:
|
||||
('I','V')|('I','X')|('X','L')|('X','C')|('C','D')|('C','M')
|
||||
// Excel forms:
|
||||
|('V','L')|('L','D')|('L','M') // VL, LD, LM
|
||||
|('X','D')|('X','M') // XD, XM
|
||||
|('V','M') // VM
|
||||
|('I','L')|('I','C')|('I','D')|('I','M') // IL, IC, ID, IM
|
||||
|('V','D')|('V','C') // VD, VC
|
||||
)
|
||||
}
|
||||
|
||||
let chars: Vec<char> = s.chars().map(|c| c.to_ascii_uppercase()).collect();
|
||||
let mut total = 0u32;
|
||||
let mut i = 0usize;
|
||||
|
||||
// Repetition rules similar to classic Romans:
|
||||
// V, L, D cannot repeat; I, X, C, M max 3 in a row.
|
||||
let mut last_char: Option<char> = None;
|
||||
let mut run_len = 0usize;
|
||||
|
||||
while i < chars.len() {
|
||||
let c = chars[i];
|
||||
let v = val(c).ok_or_else(|| format!("invalid character '{c}'"))?;
|
||||
|
||||
if Some(c) == last_char {
|
||||
run_len += 1;
|
||||
match c {
|
||||
'V' | 'L' | 'D' => return Err(format!("invalid repetition of '{c}'")),
|
||||
_ if run_len >= 3 => return Err(format!("invalid repetition of '{c}'")),
|
||||
_ => {}
|
||||
}
|
||||
} else {
|
||||
last_char = Some(c);
|
||||
run_len = 0;
|
||||
}
|
||||
|
||||
if i + 1 < chars.len() {
|
||||
let c2 = chars[i + 1];
|
||||
let v2 = val(c2).ok_or_else(|| format!("invalid character '{c2}'"))?;
|
||||
if v < v2 {
|
||||
if !allowed_subtractive(c, c2) {
|
||||
return Err(format!("invalid subtractive pair '{c}{c2}'"));
|
||||
}
|
||||
// Disallow stacked subtractives like IIV, XXL:
|
||||
if run_len > 0 {
|
||||
return Err(format!("malformed numeral near position {i}"));
|
||||
}
|
||||
total += v2 - v;
|
||||
i += 2;
|
||||
last_char = None;
|
||||
run_len = 0;
|
||||
continue;
|
||||
}
|
||||
}
|
||||
|
||||
total += v;
|
||||
i += 1;
|
||||
}
|
||||
Ok(total)
|
||||
}
|
||||
|
||||
/// Classic Roman (strict) encoder used as a base for all forms.
|
||||
fn to_roman(mut n: u32) -> Result<String, String> {
|
||||
if !(1..=3999).contains(&n) {
|
||||
return Err("value out of range (must be 1..=3999)".into());
|
||||
}
|
||||
|
||||
const MAP: &[(u32, &str)] = &[
|
||||
(1000, "M"),
|
||||
(900, "CM"),
|
||||
(500, "D"),
|
||||
(400, "CD"),
|
||||
(100, "C"),
|
||||
(90, "XC"),
|
||||
(50, "L"),
|
||||
(40, "XL"),
|
||||
(10, "X"),
|
||||
(9, "IX"),
|
||||
(5, "V"),
|
||||
(4, "IV"),
|
||||
(1, "I"),
|
||||
];
|
||||
|
||||
let mut out = String::with_capacity(15);
|
||||
for &(val, sym) in MAP {
|
||||
while n >= val {
|
||||
out.push_str(sym);
|
||||
n -= val;
|
||||
}
|
||||
if n == 0 {
|
||||
break;
|
||||
}
|
||||
}
|
||||
Ok(out)
|
||||
}
|
||||
|
||||
/// Excel/Google Sheets compatible ROMAN(number, [form]) encoder.
|
||||
/// `form`: 0..=4 (0=Classic, 4=Simplified).
|
||||
pub fn to_roman_with_form(n: u32, form: i32) -> Result<String, String> {
|
||||
let mut s = to_roman(n)?;
|
||||
if form == 0 {
|
||||
return Ok(s);
|
||||
}
|
||||
if !(0..=4).contains(&form) {
|
||||
return Err("form must be between 0 and 4".into());
|
||||
}
|
||||
|
||||
// Base rules (apply for all f >= 1)
|
||||
let base_rules: &[(&str, &str)] = &[
|
||||
// C(D|M)XC -> L$1XL
|
||||
("CDXC", "LDXL"),
|
||||
("CMXC", "LMXL"),
|
||||
// C(D|M)L -> L$1
|
||||
("CDL", "LD"),
|
||||
("CML", "LM"),
|
||||
// X(L|C)IX -> V$1IV
|
||||
("XLIX", "VLIV"),
|
||||
("XCIX", "VCIV"),
|
||||
// X(L|C)V -> V$1
|
||||
("XLV", "VL"),
|
||||
("XCV", "VC"),
|
||||
];
|
||||
|
||||
// Level 2 extra rules
|
||||
let lvl2_rules: &[(&str, &str)] = &[
|
||||
// V(L|C)IV -> I$1
|
||||
("VLIV", "IL"),
|
||||
("VCIV", "IC"),
|
||||
// L(D|M)XL -> X$1
|
||||
("LDXL", "XD"),
|
||||
("LMXL", "XM"),
|
||||
// L(D|M)VL -> X$1V
|
||||
("LDVL", "XDV"),
|
||||
("LMVL", "XMV"),
|
||||
// L(D|M)IL -> X$1IX
|
||||
("LDIL", "XDIX"),
|
||||
("LMIL", "XMIX"),
|
||||
];
|
||||
|
||||
// Level 3 extra rules
|
||||
let lvl3_rules: &[(&str, &str)] = &[
|
||||
// X(D|M)V -> V$1
|
||||
("XDV", "VD"),
|
||||
("XMV", "VM"),
|
||||
// X(D|M)IX -> V$1IV
|
||||
("XDIX", "VDIV"),
|
||||
("XMIX", "VMIV"),
|
||||
];
|
||||
|
||||
// Level 4 extra rules
|
||||
let lvl4_rules: &[(&str, &str)] = &[
|
||||
// V(D|M)IV -> I$1
|
||||
("VDIV", "ID"),
|
||||
("VMIV", "IM"),
|
||||
];
|
||||
|
||||
// Helper to apply a batch of (from -> to) globally, in order.
|
||||
fn apply_rules(mut t: String, rules: &[(&str, &str)]) -> String {
|
||||
for (from, to) in rules {
|
||||
if t.contains(from) {
|
||||
t = t.replace(from, to);
|
||||
}
|
||||
}
|
||||
t
|
||||
}
|
||||
|
||||
s = apply_rules(s, base_rules);
|
||||
if form >= 2 {
|
||||
s = apply_rules(s, lvl2_rules);
|
||||
}
|
||||
if form >= 3 {
|
||||
s = apply_rules(s, lvl3_rules);
|
||||
}
|
||||
if form >= 4 {
|
||||
s = apply_rules(s, lvl4_rules);
|
||||
}
|
||||
Ok(s)
|
||||
}
|
||||
@@ -16,7 +16,6 @@ mod information;
|
||||
mod logical;
|
||||
mod lookup_and_reference;
|
||||
mod macros;
|
||||
mod math_util;
|
||||
mod mathematical;
|
||||
mod statistical;
|
||||
mod subtotal;
|
||||
@@ -77,43 +76,6 @@ pub enum Function {
|
||||
Sumifs,
|
||||
Tan,
|
||||
Tanh,
|
||||
Acot,
|
||||
Acoth,
|
||||
Cot,
|
||||
Coth,
|
||||
Csc,
|
||||
Csch,
|
||||
Sec,
|
||||
Sech,
|
||||
Exp,
|
||||
Fact,
|
||||
Factdouble,
|
||||
Sign,
|
||||
Radians,
|
||||
Degrees,
|
||||
Int,
|
||||
Even,
|
||||
Odd,
|
||||
Ceiling,
|
||||
CeilingMath,
|
||||
CeilingPrecise,
|
||||
Floor,
|
||||
FloorMath,
|
||||
FloorPrecise,
|
||||
IsoCeiling,
|
||||
Mod,
|
||||
Quotient,
|
||||
Mround,
|
||||
Trunc,
|
||||
Gcd,
|
||||
Lcm,
|
||||
Base,
|
||||
Decimal,
|
||||
Roman,
|
||||
Arabic,
|
||||
Combin,
|
||||
Combina,
|
||||
Sumsq,
|
||||
|
||||
// Information
|
||||
ErrorType,
|
||||
@@ -134,11 +96,6 @@ pub enum Function {
|
||||
Sheet,
|
||||
Type,
|
||||
|
||||
Sheets,
|
||||
N,
|
||||
Cell,
|
||||
Info,
|
||||
|
||||
// Lookup and reference
|
||||
Hlookup,
|
||||
Index,
|
||||
@@ -217,14 +174,6 @@ pub enum Function {
|
||||
Isoweeknum,
|
||||
|
||||
// Financial
|
||||
Accrint,
|
||||
Accrintm,
|
||||
Coupdaybs,
|
||||
Coupdays,
|
||||
Coupdaysnc,
|
||||
Coupncd,
|
||||
Coupnum,
|
||||
Couppcd,
|
||||
Cumipmt,
|
||||
Cumprinc,
|
||||
Db,
|
||||
@@ -233,7 +182,6 @@ pub enum Function {
|
||||
Dollarfr,
|
||||
Effect,
|
||||
Fv,
|
||||
Fvschedule,
|
||||
Ipmt,
|
||||
Irr,
|
||||
Ispmt,
|
||||
@@ -241,12 +189,9 @@ pub enum Function {
|
||||
Nominal,
|
||||
Nper,
|
||||
Npv,
|
||||
Duration,
|
||||
Mduration,
|
||||
Pduration,
|
||||
Pmt,
|
||||
Ppmt,
|
||||
Price,
|
||||
Pv,
|
||||
Rate,
|
||||
Rri,
|
||||
@@ -255,16 +200,8 @@ pub enum Function {
|
||||
Tbilleq,
|
||||
Tbillprice,
|
||||
Tbillyield,
|
||||
Pricedisc,
|
||||
Pricemat,
|
||||
Yielddisc,
|
||||
Yieldmat,
|
||||
Disc,
|
||||
Received,
|
||||
Intrate,
|
||||
Xirr,
|
||||
Xnpv,
|
||||
Yield,
|
||||
|
||||
// Engineering: Bessel and transcendental functions
|
||||
Besseli,
|
||||
@@ -333,7 +270,7 @@ pub enum Function {
|
||||
}
|
||||
|
||||
impl Function {
|
||||
pub fn into_iter() -> IntoIter<Function, 276> {
|
||||
pub fn into_iter() -> IntoIter<Function, 215> {
|
||||
[
|
||||
Function::And,
|
||||
Function::False,
|
||||
@@ -366,44 +303,12 @@ impl Function {
|
||||
Function::Sqrt,
|
||||
Function::Sqrtpi,
|
||||
Function::Atan2,
|
||||
Function::Acot,
|
||||
Function::Acoth,
|
||||
Function::Cot,
|
||||
Function::Coth,
|
||||
Function::Csc,
|
||||
Function::Csch,
|
||||
Function::Sec,
|
||||
Function::Sech,
|
||||
Function::Power,
|
||||
Function::Exp,
|
||||
Function::Fact,
|
||||
Function::Factdouble,
|
||||
Function::Sign,
|
||||
Function::Int,
|
||||
Function::Even,
|
||||
Function::Odd,
|
||||
Function::Ceiling,
|
||||
Function::CeilingMath,
|
||||
Function::CeilingPrecise,
|
||||
Function::Floor,
|
||||
Function::FloorMath,
|
||||
Function::FloorPrecise,
|
||||
Function::IsoCeiling,
|
||||
Function::Mod,
|
||||
Function::Quotient,
|
||||
Function::Mround,
|
||||
Function::Trunc,
|
||||
Function::Gcd,
|
||||
Function::Lcm,
|
||||
Function::Base,
|
||||
Function::Decimal,
|
||||
Function::Max,
|
||||
Function::Min,
|
||||
Function::Product,
|
||||
Function::Rand,
|
||||
Function::Randbetween,
|
||||
Function::Radians,
|
||||
Function::Degrees,
|
||||
Function::Round,
|
||||
Function::Rounddown,
|
||||
Function::Roundup,
|
||||
@@ -494,23 +399,18 @@ impl Function {
|
||||
Function::WorkdayIntl,
|
||||
Function::Yearfrac,
|
||||
Function::Isoweeknum,
|
||||
Function::Accrint,
|
||||
Function::Accrintm,
|
||||
Function::Pmt,
|
||||
Function::Pv,
|
||||
Function::Rate,
|
||||
Function::Nper,
|
||||
Function::Fv,
|
||||
Function::Fvschedule,
|
||||
Function::Ppmt,
|
||||
Function::Price,
|
||||
Function::Ipmt,
|
||||
Function::Npv,
|
||||
Function::Mirr,
|
||||
Function::Irr,
|
||||
Function::Xirr,
|
||||
Function::Xnpv,
|
||||
Function::Yield,
|
||||
Function::Rept,
|
||||
Function::Textafter,
|
||||
Function::Textbefore,
|
||||
@@ -522,25 +422,10 @@ impl Function {
|
||||
Function::Syd,
|
||||
Function::Nominal,
|
||||
Function::Effect,
|
||||
Function::Duration,
|
||||
Function::Mduration,
|
||||
Function::Pduration,
|
||||
Function::Coupdaybs,
|
||||
Function::Coupdays,
|
||||
Function::Coupdaysnc,
|
||||
Function::Coupncd,
|
||||
Function::Coupnum,
|
||||
Function::Couppcd,
|
||||
Function::Tbillyield,
|
||||
Function::Tbillprice,
|
||||
Function::Tbilleq,
|
||||
Function::Pricedisc,
|
||||
Function::Pricemat,
|
||||
Function::Yielddisc,
|
||||
Function::Yieldmat,
|
||||
Function::Disc,
|
||||
Function::Received,
|
||||
Function::Intrate,
|
||||
Function::Dollarde,
|
||||
Function::Dollarfr,
|
||||
Function::Ddb,
|
||||
@@ -602,15 +487,6 @@ impl Function {
|
||||
Function::Delta,
|
||||
Function::Gestep,
|
||||
Function::Subtotal,
|
||||
Function::Roman,
|
||||
Function::Arabic,
|
||||
Function::Combin,
|
||||
Function::Combina,
|
||||
Function::Sumsq,
|
||||
Function::N,
|
||||
Function::Cell,
|
||||
Function::Info,
|
||||
Function::Sheets,
|
||||
]
|
||||
.into_iter()
|
||||
}
|
||||
@@ -653,18 +529,6 @@ impl Function {
|
||||
Function::Sheet => "_xlfn.SHEET".to_string(),
|
||||
Function::Formulatext => "_xlfn.FORMULATEXT".to_string(),
|
||||
Function::Isoweeknum => "_xlfn.ISOWEEKNUM".to_string(),
|
||||
Function::Ceiling => "_xlfn.CEILING".to_string(),
|
||||
Function::CeilingMath => "_xlfn.CEILING.MATH".to_string(),
|
||||
Function::CeilingPrecise => "_xlfn.CEILING.PRECISE".to_string(),
|
||||
Function::FloorMath => "_xlfn.FLOOR.MATH".to_string(),
|
||||
Function::FloorPrecise => "_xlfn.FLOOR.PRECISE".to_string(),
|
||||
Function::IsoCeiling => "_xlfn.ISO.CEILING".to_string(),
|
||||
Function::Base => "_xlfn.BASE".to_string(),
|
||||
Function::Decimal => "_xlfn.DECIMAL".to_string(),
|
||||
Function::Arabic => "_xlfn.ARABIC".to_string(),
|
||||
Function::Combina => "_xlfn.COMBINA".to_string(),
|
||||
Function::Sheets => "_xlfn.SHEETS".to_string(),
|
||||
|
||||
_ => self.to_string(),
|
||||
}
|
||||
}
|
||||
@@ -687,61 +551,34 @@ impl Function {
|
||||
"SWITCH" | "_XLFN.SWITCH" => Some(Function::Switch),
|
||||
"TRUE" => Some(Function::True),
|
||||
"XOR" | "_XLFN.XOR" => Some(Function::Xor),
|
||||
|
||||
"SIN" => Some(Function::Sin),
|
||||
"COS" => Some(Function::Cos),
|
||||
"TAN" => Some(Function::Tan),
|
||||
|
||||
"ASIN" => Some(Function::Asin),
|
||||
"ACOS" => Some(Function::Acos),
|
||||
"ATAN" => Some(Function::Atan),
|
||||
|
||||
"SINH" => Some(Function::Sinh),
|
||||
"COSH" => Some(Function::Cosh),
|
||||
"TANH" => Some(Function::Tanh),
|
||||
|
||||
"ASINH" => Some(Function::Asinh),
|
||||
"ACOSH" => Some(Function::Acosh),
|
||||
"ATANH" => Some(Function::Atanh),
|
||||
"ACOT" => Some(Function::Acot),
|
||||
"COTH" => Some(Function::Coth),
|
||||
"COT" => Some(Function::Cot),
|
||||
"CSC" => Some(Function::Csc),
|
||||
"CSCH" => Some(Function::Csch),
|
||||
"SEC" => Some(Function::Sec),
|
||||
"SECH" => Some(Function::Sech),
|
||||
"ACOTH" => Some(Function::Acoth),
|
||||
"FACT" => Some(Function::Fact),
|
||||
"FACTDOUBLE" => Some(Function::Factdouble),
|
||||
"EXP" => Some(Function::Exp),
|
||||
"SIGN" => Some(Function::Sign),
|
||||
"RADIANS" => Some(Function::Radians),
|
||||
"DEGREES" => Some(Function::Degrees),
|
||||
"INT" => Some(Function::Int),
|
||||
"EVEN" => Some(Function::Even),
|
||||
"ODD" => Some(Function::Odd),
|
||||
"CEILING" | "_XLFN.CEILING" => Some(Function::Ceiling),
|
||||
"CEILING.MATH" | "_XLFN.CEILING.MATH" => Some(Function::CeilingMath),
|
||||
"CEILING.PRECISE" | "_XLFN.CEILING.PRECISE" => Some(Function::CeilingPrecise),
|
||||
"FLOOR" => Some(Function::Floor),
|
||||
"FLOOR.MATH" | "_XLFN.FLOOR.MATH" => Some(Function::FloorMath),
|
||||
"FLOOR.PRECISE" | "_XLFN.FLOOR.PRECISE" => Some(Function::FloorPrecise),
|
||||
"ISO.CEILING" | "_XLFN.ISO.CEILING" => Some(Function::IsoCeiling),
|
||||
"MOD" => Some(Function::Mod),
|
||||
"QUOTIENT" => Some(Function::Quotient),
|
||||
"MROUND" => Some(Function::Mround),
|
||||
"TRUNC" => Some(Function::Trunc),
|
||||
"GCD" => Some(Function::Gcd),
|
||||
"LCM" => Some(Function::Lcm),
|
||||
"BASE" | "_XLFN.BASE" => Some(Function::Base),
|
||||
"DECIMAL" | "_XLFN.DECIMAL" => Some(Function::Decimal),
|
||||
"ROMAN" => Some(Function::Roman),
|
||||
"ARABIC" | "_XLFN.ARABIC" => Some(Function::Arabic),
|
||||
|
||||
"PI" => Some(Function::Pi),
|
||||
"ABS" => Some(Function::Abs),
|
||||
"SQRT" => Some(Function::Sqrt),
|
||||
"SQRTPI" => Some(Function::Sqrtpi),
|
||||
"POWER" => Some(Function::Power),
|
||||
"ATAN2" => Some(Function::Atan2),
|
||||
|
||||
"LN" => Some(Function::Ln),
|
||||
"LOG" => Some(Function::Log),
|
||||
"LOG10" => Some(Function::Log10),
|
||||
|
||||
"MAX" => Some(Function::Max),
|
||||
"MIN" => Some(Function::Min),
|
||||
"PRODUCT" => Some(Function::Product),
|
||||
@@ -753,9 +590,6 @@ impl Function {
|
||||
"SUM" => Some(Function::Sum),
|
||||
"SUMIF" => Some(Function::Sumif),
|
||||
"SUMIFS" => Some(Function::Sumifs),
|
||||
"COMBIN" => Some(Function::Combin),
|
||||
"COMBINA" | "_XLFN.COMBINA" => Some(Function::Combina),
|
||||
"SUMSQ" => Some(Function::Sumsq),
|
||||
|
||||
// Lookup and Reference
|
||||
"CHOOSE" => Some(Function::Choose),
|
||||
@@ -853,20 +687,15 @@ impl Function {
|
||||
"YEARFRAC" => Some(Function::Yearfrac),
|
||||
"ISOWEEKNUM" | "_XLFN.ISOWEEKNUM" => Some(Function::Isoweeknum),
|
||||
// Financial
|
||||
"ACCRINT" => Some(Function::Accrint),
|
||||
"ACCRINTM" => Some(Function::Accrintm),
|
||||
"PMT" => Some(Function::Pmt),
|
||||
"PV" => Some(Function::Pv),
|
||||
"RATE" => Some(Function::Rate),
|
||||
"NPER" => Some(Function::Nper),
|
||||
"FV" => Some(Function::Fv),
|
||||
"FVSCHEDULE" => Some(Function::Fvschedule),
|
||||
"PPMT" => Some(Function::Ppmt),
|
||||
"PRICE" => Some(Function::Price),
|
||||
"IPMT" => Some(Function::Ipmt),
|
||||
"NPV" => Some(Function::Npv),
|
||||
"XNPV" => Some(Function::Xnpv),
|
||||
"YIELD" => Some(Function::Yield),
|
||||
"MIRR" => Some(Function::Mirr),
|
||||
"IRR" => Some(Function::Irr),
|
||||
"XIRR" => Some(Function::Xirr),
|
||||
@@ -877,27 +706,11 @@ impl Function {
|
||||
"SYD" => Some(Function::Syd),
|
||||
"NOMINAL" => Some(Function::Nominal),
|
||||
"EFFECT" => Some(Function::Effect),
|
||||
"DURATION" => Some(Function::Duration),
|
||||
"MDURATION" => Some(Function::Mduration),
|
||||
"PDURATION" | "_XLFN.PDURATION" => Some(Function::Pduration),
|
||||
|
||||
"COUPDAYBS" => Some(Function::Coupdaybs),
|
||||
"COUPDAYS" => Some(Function::Coupdays),
|
||||
"COUPDAYSNC" => Some(Function::Coupdaysnc),
|
||||
"COUPNCD" => Some(Function::Coupncd),
|
||||
"COUPNUM" => Some(Function::Coupnum),
|
||||
"COUPPCD" => Some(Function::Couppcd),
|
||||
|
||||
"TBILLYIELD" => Some(Function::Tbillyield),
|
||||
"TBILLPRICE" => Some(Function::Tbillprice),
|
||||
"TBILLEQ" => Some(Function::Tbilleq),
|
||||
"PRICEDISC" => Some(Function::Pricedisc),
|
||||
"PRICEMAT" => Some(Function::Pricemat),
|
||||
"YIELDDISC" => Some(Function::Yielddisc),
|
||||
"YIELDMAT" => Some(Function::Yieldmat),
|
||||
"DISC" => Some(Function::Disc),
|
||||
"RECEIVED" => Some(Function::Received),
|
||||
"INTRATE" => Some(Function::Intrate),
|
||||
|
||||
"DOLLARDE" => Some(Function::Dollarde),
|
||||
"DOLLARFR" => Some(Function::Dollarfr),
|
||||
@@ -964,12 +777,6 @@ impl Function {
|
||||
"GESTEP" => Some(Function::Gestep),
|
||||
|
||||
"SUBTOTAL" => Some(Function::Subtotal),
|
||||
|
||||
"N" => Some(Function::N),
|
||||
"CELL" => Some(Function::Cell),
|
||||
"INFO" => Some(Function::Info),
|
||||
"SHEETS" | "_XLFN.SHEETS" => Some(Function::Sheets),
|
||||
|
||||
_ => None,
|
||||
}
|
||||
}
|
||||
@@ -1004,14 +811,6 @@ impl fmt::Display for Function {
|
||||
Function::Asinh => write!(f, "ASINH"),
|
||||
Function::Acosh => write!(f, "ACOSH"),
|
||||
Function::Atanh => write!(f, "ATANH"),
|
||||
Function::Acot => write!(f, "ACOT"),
|
||||
Function::Acoth => write!(f, "ACOTH"),
|
||||
Function::Cot => write!(f, "COT"),
|
||||
Function::Coth => write!(f, "COTH"),
|
||||
Function::Csc => write!(f, "CSC"),
|
||||
Function::Csch => write!(f, "CSCH"),
|
||||
Function::Sec => write!(f, "SEC"),
|
||||
Function::Sech => write!(f, "SECH"),
|
||||
Function::Abs => write!(f, "ABS"),
|
||||
Function::Pi => write!(f, "PI"),
|
||||
Function::Sqrt => write!(f, "SQRT"),
|
||||
@@ -1076,6 +875,7 @@ impl fmt::Display for Function {
|
||||
Function::Isformula => write!(f, "ISFORMULA"),
|
||||
Function::Type => write!(f, "TYPE"),
|
||||
Function::Sheet => write!(f, "SHEET"),
|
||||
|
||||
Function::Average => write!(f, "AVERAGE"),
|
||||
Function::Averagea => write!(f, "AVERAGEA"),
|
||||
Function::Averageif => write!(f, "AVERAGEIF"),
|
||||
@@ -1113,23 +913,18 @@ impl fmt::Display for Function {
|
||||
Function::WorkdayIntl => write!(f, "WORKDAY.INTL"),
|
||||
Function::Yearfrac => write!(f, "YEARFRAC"),
|
||||
Function::Isoweeknum => write!(f, "ISOWEEKNUM"),
|
||||
Function::Accrint => write!(f, "ACCRINT"),
|
||||
Function::Accrintm => write!(f, "ACCRINTM"),
|
||||
Function::Pmt => write!(f, "PMT"),
|
||||
Function::Pv => write!(f, "PV"),
|
||||
Function::Rate => write!(f, "RATE"),
|
||||
Function::Nper => write!(f, "NPER"),
|
||||
Function::Fv => write!(f, "FV"),
|
||||
Function::Fvschedule => write!(f, "FVSCHEDULE"),
|
||||
Function::Ppmt => write!(f, "PPMT"),
|
||||
Function::Price => write!(f, "PRICE"),
|
||||
Function::Ipmt => write!(f, "IPMT"),
|
||||
Function::Npv => write!(f, "NPV"),
|
||||
Function::Mirr => write!(f, "MIRR"),
|
||||
Function::Irr => write!(f, "IRR"),
|
||||
Function::Xirr => write!(f, "XIRR"),
|
||||
Function::Xnpv => write!(f, "XNPV"),
|
||||
Function::Yield => write!(f, "YIELD"),
|
||||
Function::Rept => write!(f, "REPT"),
|
||||
Function::Textafter => write!(f, "TEXTAFTER"),
|
||||
Function::Textbefore => write!(f, "TEXTBEFORE"),
|
||||
@@ -1141,25 +936,10 @@ impl fmt::Display for Function {
|
||||
Function::Syd => write!(f, "SYD"),
|
||||
Function::Nominal => write!(f, "NOMINAL"),
|
||||
Function::Effect => write!(f, "EFFECT"),
|
||||
Function::Duration => write!(f, "DURATION"),
|
||||
Function::Mduration => write!(f, "MDURATION"),
|
||||
Function::Pduration => write!(f, "PDURATION"),
|
||||
Function::Coupdaybs => write!(f, "COUPDAYBS"),
|
||||
Function::Coupdays => write!(f, "COUPDAYS"),
|
||||
Function::Coupdaysnc => write!(f, "COUPDAYSNC"),
|
||||
Function::Coupncd => write!(f, "COUPNCD"),
|
||||
Function::Coupnum => write!(f, "COUPNUM"),
|
||||
Function::Couppcd => write!(f, "COUPPCD"),
|
||||
Function::Tbillyield => write!(f, "TBILLYIELD"),
|
||||
Function::Tbillprice => write!(f, "TBILLPRICE"),
|
||||
Function::Tbilleq => write!(f, "TBILLEQ"),
|
||||
Function::Pricedisc => write!(f, "PRICEDISC"),
|
||||
Function::Pricemat => write!(f, "PRICEMAT"),
|
||||
Function::Yielddisc => write!(f, "YIELDDISC"),
|
||||
Function::Yieldmat => write!(f, "YIELDMAT"),
|
||||
Function::Disc => write!(f, "DISC"),
|
||||
Function::Received => write!(f, "RECEIVED"),
|
||||
Function::Intrate => write!(f, "INTRATE"),
|
||||
Function::Dollarde => write!(f, "DOLLARDE"),
|
||||
Function::Dollarfr => write!(f, "DOLLARFR"),
|
||||
Function::Ddb => write!(f, "DDB"),
|
||||
@@ -1220,41 +1000,8 @@ impl fmt::Display for Function {
|
||||
Function::Convert => write!(f, "CONVERT"),
|
||||
Function::Delta => write!(f, "DELTA"),
|
||||
Function::Gestep => write!(f, "GESTEP"),
|
||||
Function::Subtotal => write!(f, "SUBTOTAL"),
|
||||
Function::Exp => write!(f, "EXP"),
|
||||
Function::Fact => write!(f, "FACT"),
|
||||
Function::Factdouble => write!(f, "FACTDOUBLE"),
|
||||
Function::Sign => write!(f, "SIGN"),
|
||||
Function::Radians => write!(f, "RADIANS"),
|
||||
Function::Degrees => write!(f, "DEGREES"),
|
||||
Function::Int => write!(f, "INT"),
|
||||
Function::Even => write!(f, "EVEN"),
|
||||
Function::Odd => write!(f, "ODD"),
|
||||
Function::Ceiling => write!(f, "CEILING"),
|
||||
Function::CeilingMath => write!(f, "CEILING.MATH"),
|
||||
Function::CeilingPrecise => write!(f, "CEILING.PRECISE"),
|
||||
Function::Floor => write!(f, "FLOOR"),
|
||||
Function::FloorMath => write!(f, "FLOOR.MATH"),
|
||||
Function::FloorPrecise => write!(f, "FLOOR.PRECISE"),
|
||||
Function::IsoCeiling => write!(f, "ISO.CEILING"),
|
||||
Function::Mod => write!(f, "MOD"),
|
||||
Function::Quotient => write!(f, "QUOTIENT"),
|
||||
Function::Mround => write!(f, "MROUND"),
|
||||
Function::Trunc => write!(f, "TRUNC"),
|
||||
Function::Gcd => write!(f, "GCD"),
|
||||
Function::Lcm => write!(f, "LCM"),
|
||||
Function::Base => write!(f, "BASE"),
|
||||
Function::Decimal => write!(f, "DECIMAL"),
|
||||
Function::Roman => write!(f, "ROMAN"),
|
||||
Function::Arabic => write!(f, "ARABIC"),
|
||||
Function::Combin => write!(f, "COMBIN"),
|
||||
Function::Combina => write!(f, "COMBINA"),
|
||||
Function::Sumsq => write!(f, "SUMSQ"),
|
||||
|
||||
Function::N => write!(f, "N"),
|
||||
Function::Cell => write!(f, "CELL"),
|
||||
Function::Info => write!(f, "INFO"),
|
||||
Function::Sheets => write!(f, "SHEETS"),
|
||||
Function::Subtotal => write!(f, "SUBTOTAL"),
|
||||
}
|
||||
}
|
||||
}
|
||||
@@ -1283,6 +1030,7 @@ impl Model {
|
||||
cell: CellReferenceIndex,
|
||||
) -> CalcResult {
|
||||
match kind {
|
||||
// Logical
|
||||
Function::And => self.fn_and(args, cell),
|
||||
Function::False => self.fn_false(args, cell),
|
||||
Function::If => self.fn_if(args, cell),
|
||||
@@ -1294,27 +1042,34 @@ impl Model {
|
||||
Function::Switch => self.fn_switch(args, cell),
|
||||
Function::True => self.fn_true(args, cell),
|
||||
Function::Xor => self.fn_xor(args, cell),
|
||||
// Math and trigonometry
|
||||
Function::Log => self.fn_log(args, cell),
|
||||
Function::Log10 => self.fn_log10(args, cell),
|
||||
Function::Ln => self.fn_ln(args, cell),
|
||||
Function::Sin => self.fn_sin(args, cell),
|
||||
Function::Cos => self.fn_cos(args, cell),
|
||||
Function::Tan => self.fn_tan(args, cell),
|
||||
|
||||
Function::Asin => self.fn_asin(args, cell),
|
||||
Function::Acos => self.fn_acos(args, cell),
|
||||
Function::Atan => self.fn_atan(args, cell),
|
||||
|
||||
Function::Sinh => self.fn_sinh(args, cell),
|
||||
Function::Cosh => self.fn_cosh(args, cell),
|
||||
Function::Tanh => self.fn_tanh(args, cell),
|
||||
|
||||
Function::Asinh => self.fn_asinh(args, cell),
|
||||
Function::Acosh => self.fn_acosh(args, cell),
|
||||
Function::Atanh => self.fn_atanh(args, cell),
|
||||
|
||||
Function::Pi => self.fn_pi(args, cell),
|
||||
Function::Abs => self.fn_abs(args, cell),
|
||||
|
||||
Function::Sqrt => self.fn_sqrt(args, cell),
|
||||
Function::Sqrtpi => self.fn_sqrtpi(args, cell),
|
||||
Function::Atan2 => self.fn_atan2(args, cell),
|
||||
Function::Power => self.fn_power(args, cell),
|
||||
|
||||
Function::Max => self.fn_max(args, cell),
|
||||
Function::Min => self.fn_min(args, cell),
|
||||
Function::Product => self.fn_product(args, cell),
|
||||
@@ -1326,6 +1081,8 @@ impl Model {
|
||||
Function::Sum => self.fn_sum(args, cell),
|
||||
Function::Sumif => self.fn_sumif(args, cell),
|
||||
Function::Sumifs => self.fn_sumifs(args, cell),
|
||||
|
||||
// Lookup and Reference
|
||||
Function::Choose => self.fn_choose(args, cell),
|
||||
Function::Column => self.fn_column(args, cell),
|
||||
Function::Columns => self.fn_columns(args, cell),
|
||||
@@ -1339,6 +1096,7 @@ impl Model {
|
||||
Function::Rows => self.fn_rows(args, cell),
|
||||
Function::Vlookup => self.fn_vlookup(args, cell),
|
||||
Function::Xlookup => self.fn_xlookup(args, cell),
|
||||
// Text
|
||||
Function::Concatenate => self.fn_concatenate(args, cell),
|
||||
Function::Exact => self.fn_exact(args, cell),
|
||||
Function::Value => self.fn_value(args, cell),
|
||||
@@ -1356,6 +1114,7 @@ impl Model {
|
||||
Function::Trim => self.fn_trim(args, cell),
|
||||
Function::Unicode => self.fn_unicode(args, cell),
|
||||
Function::Upper => self.fn_upper(args, cell),
|
||||
// Information
|
||||
Function::Isnumber => self.fn_isnumber(args, cell),
|
||||
Function::Isnontext => self.fn_isnontext(args, cell),
|
||||
Function::Istext => self.fn_istext(args, cell),
|
||||
@@ -1373,6 +1132,7 @@ impl Model {
|
||||
Function::Isformula => self.fn_isformula(args, cell),
|
||||
Function::Type => self.fn_type(args, cell),
|
||||
Function::Sheet => self.fn_sheet(args, cell),
|
||||
// Statistical
|
||||
Function::Average => self.fn_average(args, cell),
|
||||
Function::Averagea => self.fn_averagea(args, cell),
|
||||
Function::Averageif => self.fn_averageif(args, cell),
|
||||
@@ -1385,6 +1145,7 @@ impl Model {
|
||||
Function::Maxifs => self.fn_maxifs(args, cell),
|
||||
Function::Minifs => self.fn_minifs(args, cell),
|
||||
Function::Geomean => self.fn_geomean(args, cell),
|
||||
// Date and Time
|
||||
Function::Year => self.fn_year(args, cell),
|
||||
Function::Day => self.fn_day(args, cell),
|
||||
Function::Eomonth => self.fn_eomonth(args, cell),
|
||||
@@ -1411,23 +1172,18 @@ impl Model {
|
||||
Function::Yearfrac => self.fn_yearfrac(args, cell),
|
||||
Function::Isoweeknum => self.fn_isoweeknum(args, cell),
|
||||
// Financial
|
||||
Function::Accrint => self.fn_accrint(args, cell),
|
||||
Function::Accrintm => self.fn_accrintm(args, cell),
|
||||
Function::Pmt => self.fn_pmt(args, cell),
|
||||
Function::Pv => self.fn_pv(args, cell),
|
||||
Function::Rate => self.fn_rate(args, cell),
|
||||
Function::Nper => self.fn_nper(args, cell),
|
||||
Function::Fv => self.fn_fv(args, cell),
|
||||
Function::Fvschedule => self.fn_fvschedule(args, cell),
|
||||
Function::Ppmt => self.fn_ppmt(args, cell),
|
||||
Function::Price => self.fn_price(args, cell),
|
||||
Function::Ipmt => self.fn_ipmt(args, cell),
|
||||
Function::Npv => self.fn_npv(args, cell),
|
||||
Function::Mirr => self.fn_mirr(args, cell),
|
||||
Function::Irr => self.fn_irr(args, cell),
|
||||
Function::Xirr => self.fn_xirr(args, cell),
|
||||
Function::Xnpv => self.fn_xnpv(args, cell),
|
||||
Function::Yield => self.fn_yield(args, cell),
|
||||
Function::Rept => self.fn_rept(args, cell),
|
||||
Function::Textafter => self.fn_textafter(args, cell),
|
||||
Function::Textbefore => self.fn_textbefore(args, cell),
|
||||
@@ -1439,31 +1195,17 @@ impl Model {
|
||||
Function::Syd => self.fn_syd(args, cell),
|
||||
Function::Nominal => self.fn_nominal(args, cell),
|
||||
Function::Effect => self.fn_effect(args, cell),
|
||||
Function::Duration => self.fn_duration(args, cell),
|
||||
Function::Mduration => self.fn_mduration(args, cell),
|
||||
Function::Pduration => self.fn_pduration(args, cell),
|
||||
Function::Coupdaybs => self.fn_coupdaybs(args, cell),
|
||||
Function::Coupdays => self.fn_coupdays(args, cell),
|
||||
Function::Coupdaysnc => self.fn_coupdaysnc(args, cell),
|
||||
Function::Coupncd => self.fn_coupncd(args, cell),
|
||||
Function::Coupnum => self.fn_coupnum(args, cell),
|
||||
Function::Couppcd => self.fn_couppcd(args, cell),
|
||||
Function::Tbillyield => self.fn_tbillyield(args, cell),
|
||||
Function::Tbillprice => self.fn_tbillprice(args, cell),
|
||||
Function::Tbilleq => self.fn_tbilleq(args, cell),
|
||||
Function::Pricedisc => self.fn_pricedisc(args, cell),
|
||||
Function::Pricemat => self.fn_pricemat(args, cell),
|
||||
Function::Yielddisc => self.fn_yielddisc(args, cell),
|
||||
Function::Yieldmat => self.fn_yieldmat(args, cell),
|
||||
Function::Disc => self.fn_disc(args, cell),
|
||||
Function::Received => self.fn_received(args, cell),
|
||||
Function::Intrate => self.fn_intrate(args, cell),
|
||||
Function::Dollarde => self.fn_dollarde(args, cell),
|
||||
Function::Dollarfr => self.fn_dollarfr(args, cell),
|
||||
Function::Ddb => self.fn_ddb(args, cell),
|
||||
Function::Db => self.fn_db(args, cell),
|
||||
Function::Cumprinc => self.fn_cumprinc(args, cell),
|
||||
Function::Cumipmt => self.fn_cumipmt(args, cell),
|
||||
// Engineering
|
||||
Function::Besseli => self.fn_besseli(args, cell),
|
||||
Function::Besselj => self.fn_besselj(args, cell),
|
||||
Function::Besselk => self.fn_besselk(args, cell),
|
||||
@@ -1518,48 +1260,8 @@ impl Model {
|
||||
Function::Convert => self.fn_convert(args, cell),
|
||||
Function::Delta => self.fn_delta(args, cell),
|
||||
Function::Gestep => self.fn_gestep(args, cell),
|
||||
|
||||
Function::Subtotal => self.fn_subtotal(args, cell),
|
||||
Function::Acot => self.fn_acot(args, cell),
|
||||
Function::Acoth => self.fn_acoth(args, cell),
|
||||
Function::Cot => self.fn_cot(args, cell),
|
||||
Function::Coth => self.fn_coth(args, cell),
|
||||
Function::Csc => self.fn_csc(args, cell),
|
||||
Function::Csch => self.fn_csch(args, cell),
|
||||
Function::Sec => self.fn_sec(args, cell),
|
||||
Function::Sech => self.fn_sech(args, cell),
|
||||
Function::Exp => self.fn_exp(args, cell),
|
||||
Function::Fact => self.fn_fact(args, cell),
|
||||
Function::Factdouble => self.fn_factdouble(args, cell),
|
||||
Function::Sign => self.fn_sign(args, cell),
|
||||
Function::Radians => self.fn_radians(args, cell),
|
||||
Function::Degrees => self.fn_degrees(args, cell),
|
||||
Function::Int => self.fn_int(args, cell),
|
||||
Function::Even => self.fn_even(args, cell),
|
||||
Function::Odd => self.fn_odd(args, cell),
|
||||
Function::Ceiling => self.fn_ceiling(args, cell),
|
||||
Function::CeilingMath => self.fn_ceiling_math(args, cell),
|
||||
Function::CeilingPrecise => self.fn_ceiling_precise(args, cell),
|
||||
Function::Floor => self.fn_floor(args, cell),
|
||||
Function::FloorMath => self.fn_floor_math(args, cell),
|
||||
Function::FloorPrecise => self.fn_floor_precise(args, cell),
|
||||
Function::IsoCeiling => self.fn_iso_ceiling(args, cell),
|
||||
Function::Mod => self.fn_mod(args, cell),
|
||||
Function::Quotient => self.fn_quotient(args, cell),
|
||||
Function::Mround => self.fn_mround(args, cell),
|
||||
Function::Trunc => self.fn_trunc(args, cell),
|
||||
Function::Gcd => self.fn_gcd(args, cell),
|
||||
Function::Lcm => self.fn_lcm(args, cell),
|
||||
Function::Base => self.fn_base(args, cell),
|
||||
Function::Decimal => self.fn_decimal(args, cell),
|
||||
Function::Roman => self.fn_roman(args, cell),
|
||||
Function::Arabic => self.fn_arabic(args, cell),
|
||||
Function::Combin => self.fn_combin(args, cell),
|
||||
Function::Combina => self.fn_combina(args, cell),
|
||||
Function::Sumsq => self.fn_sumsq(args, cell),
|
||||
Function::N => self.fn_n(args, cell),
|
||||
Function::Cell => self.fn_cell(args, cell),
|
||||
Function::Info => self.fn_info(args, cell),
|
||||
Function::Sheets => self.fn_sheets(args, cell),
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
@@ -9,21 +9,15 @@ mod test_currency;
|
||||
mod test_date_and_time;
|
||||
mod test_datedif_leap_month_end;
|
||||
mod test_days360_month_end;
|
||||
mod test_degrees_radians;
|
||||
mod test_error_propagation;
|
||||
mod test_fn_accrint;
|
||||
mod test_fn_accrintm;
|
||||
mod test_fn_average;
|
||||
mod test_fn_averageifs;
|
||||
mod test_fn_choose;
|
||||
mod test_fn_concatenate;
|
||||
mod test_fn_count;
|
||||
mod test_fn_coupon;
|
||||
mod test_fn_day;
|
||||
mod test_fn_duration;
|
||||
mod test_fn_exact;
|
||||
mod test_fn_financial;
|
||||
mod test_fn_financial_bonds;
|
||||
mod test_fn_formulatext;
|
||||
mod test_fn_if;
|
||||
mod test_fn_maxifs;
|
||||
@@ -68,21 +62,18 @@ mod test_escape_quotes;
|
||||
mod test_extend;
|
||||
mod test_fn_fv;
|
||||
mod test_fn_round;
|
||||
mod test_fn_fvschedule;
|
||||
mod test_fn_type;
|
||||
mod test_frozen_rows_and_columns;
|
||||
mod test_geomean;
|
||||
mod test_get_cell_content;
|
||||
mod test_implicit_intersection;
|
||||
mod test_issue_155;
|
||||
mod test_issue_483;
|
||||
mod test_ln;
|
||||
mod test_log;
|
||||
mod test_log10;
|
||||
mod test_networkdays;
|
||||
mod test_percentage;
|
||||
mod test_set_functions_error_handling;
|
||||
mod test_sheet_names;
|
||||
mod test_today;
|
||||
mod test_types;
|
||||
mod user_model;
|
||||
|
||||
@@ -1,22 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::test::util::new_empty_model;
|
||||
|
||||
#[test]
|
||||
fn fn_degrees_radians_arguments() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DEGREES()");
|
||||
model._set("A2", "=RADIANS()");
|
||||
model._set("A3", "=RADIANS(180)");
|
||||
model._set("A4", "=RADIANS(180, 2)");
|
||||
model._set("A5", "=DEGREES(RADIANS(180))");
|
||||
model._set("A6", "=DEGREES(1, 2)");
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("A1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A3"), *"3.141592654");
|
||||
assert_eq!(model._get_text("A4"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A5"), *"180");
|
||||
assert_eq!(model._get_text("A6"), *"#ERROR!");
|
||||
}
|
||||
@@ -1,134 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::{cell::CellValue, test::util::new_empty_model};
|
||||
|
||||
#[test]
|
||||
fn fn_accrint() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2020,1,1)");
|
||||
model._set("A3", "=DATE(2020,1,31)");
|
||||
model._set("A4", "10%");
|
||||
model._set("A5", "$1,000");
|
||||
model._set("A6", "2");
|
||||
|
||||
model._set("B1", "=ACCRINT(A1,A2,A3,A4,A5,A6)");
|
||||
model._set("C1", "=ACCRINT(A1)");
|
||||
model._set("C2", "=ACCRINT(A1,A2,A3,A4,A5,3)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
match model.get_cell_value_by_ref("Sheet1!B1") {
|
||||
Ok(CellValue::Number(v)) => {
|
||||
assert!((v - 8.333333333333334).abs() < 1e-9);
|
||||
}
|
||||
other => unreachable!("Expected number for B1, got {:?}", other),
|
||||
}
|
||||
assert_eq!(model._get_text("C1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("C2"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_accrint_parameters() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2020,1,1)");
|
||||
model._set("A3", "=DATE(2020,7,1)");
|
||||
model._set("A4", "8%");
|
||||
model._set("A5", "1000");
|
||||
|
||||
model._set("B1", "=ACCRINT(A1,A2,A3,A4,A5,2,0,TRUE)");
|
||||
model._set("B2", "=ACCRINT(A1,A2,A3,A4,A5,2,1,TRUE)");
|
||||
model._set("B3", "=ACCRINT(A1,A2,A3,A4,A5,2,4,TRUE)");
|
||||
model._set("B4", "=ACCRINT(A1,A2,A3,A4,A5,1)");
|
||||
model._set("B5", "=ACCRINT(A1,A2,A3,A4,A5,4)");
|
||||
model._set("B6", "=ACCRINT(A1,A2,A3,A4,A5,2)");
|
||||
model._set("B7", "=ACCRINT(A1,A2,A3,A4,A5,2,0)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
match model.get_cell_value_by_ref("Sheet1!B1") {
|
||||
Ok(CellValue::Number(v)) => {
|
||||
assert!((v - 40.0).abs() < 1e-9);
|
||||
}
|
||||
other => unreachable!("Expected number for B1, got {:?}", other),
|
||||
}
|
||||
|
||||
match (
|
||||
model.get_cell_value_by_ref("Sheet1!B1"),
|
||||
model.get_cell_value_by_ref("Sheet1!B6"),
|
||||
) {
|
||||
(Ok(CellValue::Number(v1)), Ok(CellValue::Number(v2))) => {
|
||||
assert!((v1 - v2).abs() < 1e-12);
|
||||
}
|
||||
other => unreachable!("Expected matching numbers, got {:?}", other),
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_accrint_errors() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2020,1,1)");
|
||||
model._set("A3", "=DATE(2020,7,1)");
|
||||
model._set("A4", "8%");
|
||||
model._set("A5", "1000");
|
||||
|
||||
model._set("B1", "=ACCRINT()");
|
||||
model._set("B2", "=ACCRINT(A1,A2,A3,A4,A5)");
|
||||
model._set("B3", "=ACCRINT(A1,A2,A3,A4,A5,2,0,TRUE,1)");
|
||||
model._set("C1", "=ACCRINT(A1,A2,A3,A4,A5,0)");
|
||||
model._set("C2", "=ACCRINT(A1,A2,A3,A4,A5,3)");
|
||||
model._set("C3", "=ACCRINT(A1,A2,A3,A4,A5,-1)");
|
||||
model._set("D1", "=ACCRINT(A1,A2,A3,A4,A5,2,-1)");
|
||||
model._set("D2", "=ACCRINT(A1,A2,A3,A4,A5,2,5)");
|
||||
model._set("E1", "=ACCRINT(A3,A2,A1,A4,A5,2)");
|
||||
model._set("E2", "=ACCRINT(A1,A3,A1,A4,A5,2)");
|
||||
model._set("F1", "=ACCRINT(A1,A2,A3,A4,0,2)");
|
||||
model._set("F2", "=ACCRINT(A1,A2,A3,A4,-1000,2)");
|
||||
model._set("F3", "=ACCRINT(A1,A2,A3,-8%,A5,2)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B3"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("C1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C3"), *"#NUM!");
|
||||
assert_eq!(model._get_text("D1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("D2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("E1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("E2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("F2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("F3"), *"#NUM!");
|
||||
|
||||
match model.get_cell_value_by_ref("Sheet1!F1") {
|
||||
Ok(CellValue::Number(v)) => {
|
||||
assert!((v - 0.0).abs() < 1e-9);
|
||||
}
|
||||
other => unreachable!("Expected 0 for F1, got {:?}", other),
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_accrint_combined() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2018,10,15)");
|
||||
model._set("A2", "=DATE(2019,2,1)");
|
||||
model._set("A3", "5%");
|
||||
model._set("A4", "1000");
|
||||
|
||||
model._set("B1", "=ACCRINT(A1,A1,A2,A3,A4,2)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
match model.get_cell_value_by_ref("Sheet1!B1") {
|
||||
Ok(CellValue::Number(v)) => {
|
||||
assert!((v - 14.722222222222221).abs() < 1e-9);
|
||||
}
|
||||
other => unreachable!("Expected number for B1, got {:?}", other),
|
||||
}
|
||||
}
|
||||
@@ -1,122 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::{cell::CellValue, test::util::new_empty_model};
|
||||
|
||||
#[test]
|
||||
fn fn_accrintm() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2020,7,1)");
|
||||
model._set("A3", "10%");
|
||||
model._set("A4", "$1,000");
|
||||
|
||||
model._set("B1", "=ACCRINTM(A1,A2,A3,A4)");
|
||||
model._set("C1", "=ACCRINTM(A1)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
match model.get_cell_value_by_ref("Sheet1!B1") {
|
||||
Ok(CellValue::Number(v)) => {
|
||||
assert!((v - 50.0).abs() < 1e-9);
|
||||
}
|
||||
other => unreachable!("Expected number for B1, got {:?}", other),
|
||||
}
|
||||
assert_eq!(model._get_text("C1"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_accrintm_parameters() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2020,7,1)");
|
||||
model._set("A3", "8%");
|
||||
model._set("A4", "1000");
|
||||
|
||||
model._set("B1", "=ACCRINTM(A1,A2,A3,A4,0)");
|
||||
model._set("B2", "=ACCRINTM(A1,A2,A3,A4,1)");
|
||||
model._set("B3", "=ACCRINTM(A1,A2,A3,A4,4)");
|
||||
model._set("C1", "=ACCRINTM(A1,A2,A3,A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
match (
|
||||
model.get_cell_value_by_ref("Sheet1!B1"),
|
||||
model.get_cell_value_by_ref("Sheet1!B2"),
|
||||
) {
|
||||
(Ok(CellValue::Number(v1)), Ok(CellValue::Number(v2))) => {
|
||||
assert!(v1 > 0.0 && v2 > 0.0);
|
||||
}
|
||||
other => unreachable!("Expected numbers for basis test, got {:?}", other),
|
||||
}
|
||||
|
||||
match (
|
||||
model.get_cell_value_by_ref("Sheet1!B1"),
|
||||
model.get_cell_value_by_ref("Sheet1!C1"),
|
||||
) {
|
||||
(Ok(CellValue::Number(v1)), Ok(CellValue::Number(v2))) => {
|
||||
assert!((v1 - v2).abs() < 1e-12);
|
||||
}
|
||||
other => unreachable!(
|
||||
"Expected matching numbers for default test, got {:?}",
|
||||
other
|
||||
),
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_accrintm_errors() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2020,7,1)");
|
||||
model._set("A3", "8%");
|
||||
model._set("A4", "1000");
|
||||
|
||||
model._set("B1", "=ACCRINTM()");
|
||||
model._set("B2", "=ACCRINTM(A1,A2,A3)");
|
||||
model._set("B3", "=ACCRINTM(A1,A2,A3,A4,0,1)");
|
||||
model._set("C1", "=ACCRINTM(A1,A2,A3,A4,-1)");
|
||||
model._set("C2", "=ACCRINTM(A1,A2,A3,A4,5)");
|
||||
model._set("D1", "=ACCRINTM(A2,A1,A3,A4)");
|
||||
model._set("E1", "=ACCRINTM(A1,A2,A3,0)");
|
||||
model._set("E2", "=ACCRINTM(A1,A2,A3,-1000)");
|
||||
model._set("E3", "=ACCRINTM(A1,A2,-8%,A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B3"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("C1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("D1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("E2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("E3"), *"#NUM!");
|
||||
|
||||
match model.get_cell_value_by_ref("Sheet1!E1") {
|
||||
Ok(CellValue::Number(v)) => {
|
||||
assert!((v - 0.0).abs() < 1e-9);
|
||||
}
|
||||
other => unreachable!("Expected 0 for E1, got {:?}", other),
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_accrintm_combined() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("C1", "=DATE(2016,4,5)");
|
||||
model._set("C2", "=DATE(2019,2,1)");
|
||||
model._set("A3", "5%");
|
||||
model._set("A4", "1000");
|
||||
model._set("B2", "=ACCRINTM(C1,C2,A3,A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
match model.get_cell_value_by_ref("Sheet1!B2") {
|
||||
Ok(CellValue::Number(v)) => {
|
||||
assert!((v - 141.11111111111111).abs() < 1e-9);
|
||||
}
|
||||
other => unreachable!("Expected number for B2, got {:?}", other),
|
||||
}
|
||||
}
|
||||
@@ -1,260 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::{cell::CellValue, test::util::new_empty_model};
|
||||
|
||||
#[test]
|
||||
fn fn_coupon_functions() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test with basis 1 (original test)
|
||||
model._set("A1", "=DATE(2001,1,25)");
|
||||
model._set("A2", "=DATE(2001,11,15)");
|
||||
model._set("B1", "=COUPDAYBS(A1,A2,2,1)");
|
||||
model._set("B2", "=COUPDAYS(A1,A2,2,1)");
|
||||
model._set("B3", "=COUPDAYSNC(A1,A2,2,1)");
|
||||
model._set("B4", "=COUPNCD(A1,A2,2,1)");
|
||||
model._set("B5", "=COUPNUM(A1,A2,2,1)");
|
||||
model._set("B6", "=COUPPCD(A1,A2,2,1)");
|
||||
|
||||
// Test with basis 3 for better coverage
|
||||
model._set("C1", "=COUPDAYBS(DATE(2001,1,25),DATE(2001,11,15),2,3)");
|
||||
model._set("C2", "=COUPDAYS(DATE(2001,1,25),DATE(2001,11,15),2,3)");
|
||||
model._set("C3", "=COUPDAYSNC(DATE(2001,1,25),DATE(2001,11,15),2,3)");
|
||||
model._set("C4", "=COUPNCD(DATE(2001,1,25),DATE(2001,11,15),2,3)");
|
||||
model._set("C5", "=COUPNUM(DATE(2007,1,25),DATE(2008,11,15),2,1)");
|
||||
model._set("C6", "=COUPPCD(DATE(2001,1,25),DATE(2001,11,15),2,3)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// Test basis 1
|
||||
assert_eq!(model._get_text("B1"), "71");
|
||||
assert_eq!(model._get_text("B2"), "181");
|
||||
assert_eq!(model._get_text("B3"), "110");
|
||||
assert_eq!(
|
||||
model.get_cell_value_by_ref("Sheet1!B4"),
|
||||
Ok(CellValue::Number(37026.0))
|
||||
);
|
||||
assert_eq!(model._get_text("B5"), "2");
|
||||
assert_eq!(
|
||||
model.get_cell_value_by_ref("Sheet1!B6"),
|
||||
Ok(CellValue::Number(36845.0))
|
||||
);
|
||||
|
||||
// Test basis 3 (more comprehensive coverage)
|
||||
assert_eq!(model._get_text("C1"), "71");
|
||||
assert_eq!(model._get_text("C2"), "181"); // Fixed: actual days
|
||||
assert_eq!(model._get_text("C3"), "110");
|
||||
assert_eq!(model._get_text("C4"), "37026");
|
||||
assert_eq!(model._get_text("C5"), "4");
|
||||
assert_eq!(model._get_text("C6"), "36845");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_coupon_functions_error_cases() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test invalid frequency
|
||||
model._set("E1", "=COUPDAYBS(DATE(2001,1,25),DATE(2001,11,15),3,1)");
|
||||
// Test invalid basis
|
||||
model._set("E2", "=COUPDAYS(DATE(2001,1,25),DATE(2001,11,15),2,5)");
|
||||
// Test settlement >= maturity
|
||||
model._set("E3", "=COUPDAYSNC(DATE(2001,11,15),DATE(2001,1,25),2,1)");
|
||||
// Test too few arguments
|
||||
model._set("E4", "=COUPNCD(DATE(2001,1,25),DATE(2001,11,15))");
|
||||
// Test too many arguments
|
||||
model._set("E5", "=COUPNUM(DATE(2001,1,25),DATE(2001,11,15),2,1,1)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// All should return errors
|
||||
assert_eq!(model._get_text("E1"), "#NUM!");
|
||||
assert_eq!(model._get_text("E2"), "#NUM!");
|
||||
assert_eq!(model._get_text("E3"), "#NUM!");
|
||||
assert_eq!(model._get_text("E4"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("E5"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_coupdays_actual_day_count_fix() {
|
||||
// Verify COUPDAYS correctly distinguishes between fixed vs actual day count methods
|
||||
// Bug: basis 2&3 were incorrectly using fixed calculations like basis 0&4
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2023,1,15)");
|
||||
model._set("A2", "=DATE(2023,7,15)");
|
||||
|
||||
model._set("B1", "=COUPDAYS(A1,A2,2,0)"); // 30/360: uses 360/freq
|
||||
model._set("B2", "=COUPDAYS(A1,A2,2,2)"); // Actual/360: uses actual days
|
||||
model._set("B3", "=COUPDAYS(A1,A2,2,3)"); // Actual/365: uses actual days
|
||||
model._set("B4", "=COUPDAYS(A1,A2,2,4)"); // 30/360 European: uses 360/freq
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// Basis 0&4: theoretical 360/2 = 180 days
|
||||
assert_eq!(model._get_text("B1"), "180");
|
||||
assert_eq!(model._get_text("B4"), "180");
|
||||
|
||||
// Basis 2&3: actual days between Jan 15 and Jul 15 = 181 days
|
||||
assert_eq!(model._get_text("B2"), "181");
|
||||
assert_eq!(model._get_text("B3"), "181");
|
||||
}
|
||||
|
||||
// =============================================================================
|
||||
// FEBRUARY EDGE CASE TESTS - Day Count Convention Compliance
|
||||
// =============================================================================
|
||||
// These tests verify that financial functions correctly handle February dates
|
||||
// according to the official 30/360 day count convention specifications.
|
||||
|
||||
#[test]
|
||||
fn test_coupon_functions_february_consistency() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test that coupon functions behave consistently between US and European methods
|
||||
// when February dates are involved
|
||||
|
||||
// Settlement: Last day of February (non-leap year)
|
||||
// Maturity: Some date in following year that creates a clear test case
|
||||
model._set("A1", "=DATE(2023,2,28)"); // Last day of Feb, non-leap year
|
||||
model._set("A2", "=DATE(2024,2,28)"); // Same day next year
|
||||
|
||||
// Test COUPDAYS with different basis values
|
||||
model._set("B1", "=COUPDAYS(A1,A2,2,0)"); // US 30/360 - should treat Feb 28 as day 30
|
||||
model._set("B2", "=COUPDAYS(A1,A2,2,4)"); // European 30/360 - should treat Feb 28 as day 28
|
||||
model._set("B3", "=COUPDAYS(A1,A2,2,1)"); // Actual/actual - should use real days
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// All should return valid numbers (no errors)
|
||||
assert_ne!(model._get_text("B1"), *"#NUM!");
|
||||
assert_ne!(model._get_text("B2"), *"#NUM!");
|
||||
assert_ne!(model._get_text("B3"), *"#NUM!");
|
||||
|
||||
// US and European 30/360 should potentially give different results for February dates
|
||||
// (though the exact difference depends on the specific coupon calculation logic)
|
||||
let us_result = model._get_text("B1");
|
||||
let european_result = model._get_text("B2");
|
||||
let actual_result = model._get_text("B3");
|
||||
|
||||
// Verify all are numeric
|
||||
assert!(us_result.parse::<f64>().is_ok());
|
||||
assert!(european_result.parse::<f64>().is_ok());
|
||||
assert!(actual_result.parse::<f64>().is_ok());
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn test_february_edge_cases_leap_vs_nonleap() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test leap year vs non-leap year February handling
|
||||
|
||||
// Feb 28 in non-leap year (this IS the last day of February)
|
||||
model._set("A1", "=DATE(2023,2,28)");
|
||||
model._set("A2", "=DATE(2023,8,28)");
|
||||
|
||||
// Feb 28 in leap year (this is NOT the last day of February)
|
||||
model._set("A3", "=DATE(2024,2,28)");
|
||||
model._set("A4", "=DATE(2024,8,28)");
|
||||
|
||||
// Feb 29 in leap year (this IS the last day of February)
|
||||
model._set("A5", "=DATE(2024,2,29)");
|
||||
model._set("A6", "=DATE(2024,8,29)");
|
||||
|
||||
// Test with basis 0 (US 30/360) - should have special February handling
|
||||
model._set("B1", "=COUPDAYS(A1,A2,2,0)"); // Feb 28 non-leap (last day)
|
||||
model._set("B2", "=COUPDAYS(A3,A4,2,0)"); // Feb 28 leap year (not last day)
|
||||
model._set("B3", "=COUPDAYS(A5,A6,2,0)"); // Feb 29 leap year (last day)
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// All should succeed
|
||||
assert_ne!(model._get_text("B1"), *"#NUM!");
|
||||
assert_ne!(model._get_text("B2"), *"#NUM!");
|
||||
assert_ne!(model._get_text("B3"), *"#NUM!");
|
||||
|
||||
// Verify they're all numeric
|
||||
assert!(model._get_text("B1").parse::<f64>().is_ok());
|
||||
assert!(model._get_text("B2").parse::<f64>().is_ok());
|
||||
assert!(model._get_text("B3").parse::<f64>().is_ok());
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn test_us_nasd_both_february_rule() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test the specific US/NASD rule: "If both date A and B fall on the last day of February,
|
||||
// then date B will be changed to the 30th"
|
||||
|
||||
// Case 1: Both dates are Feb 28 in non-leap years (both are last day of February)
|
||||
model._set("A1", "=DATE(2023,2,28)"); // Last day of Feb 2023
|
||||
model._set("A2", "=DATE(2025,2,28)"); // Last day of Feb 2025
|
||||
|
||||
// Case 2: Both dates are Feb 29 in leap years (both are last day of February)
|
||||
model._set("A3", "=DATE(2024,2,29)"); // Last day of Feb 2024
|
||||
model._set("A4", "=DATE(2028,2,29)"); // Last day of Feb 2028
|
||||
|
||||
// Case 3: Mixed - Feb 28 non-leap to Feb 29 leap (both are last day of February)
|
||||
model._set("A5", "=DATE(2023,2,28)"); // Last day of Feb 2023
|
||||
model._set("A6", "=DATE(2024,2,29)"); // Last day of Feb 2024
|
||||
|
||||
// Case 4: Control - Feb 28 in leap year (NOT last day) to Feb 29 (IS last day)
|
||||
model._set("A7", "=DATE(2024,2,28)"); // NOT last day of Feb 2024
|
||||
model._set("A8", "=DATE(2024,2,29)"); // IS last day of Feb 2024
|
||||
|
||||
// Test using coupon functions that should apply US/NASD 30/360 (basis 0)
|
||||
model._set("B1", "=COUPDAYS(A1,A2,1,0)"); // Both last day Feb - Rule 1 should apply
|
||||
model._set("B2", "=COUPDAYS(A3,A4,1,0)"); // Both last day Feb - Rule 1 should apply
|
||||
model._set("B3", "=COUPDAYS(A5,A6,1,0)"); // Both last day Feb - Rule 1 should apply
|
||||
model._set("B4", "=COUPDAYS(A7,A8,1,0)"); // Only end is last day Feb - Rule 1 should NOT apply
|
||||
|
||||
// Compare with European method (basis 4) - should behave differently
|
||||
model._set("C1", "=COUPDAYS(A1,A2,1,4)"); // European - no special Feb handling
|
||||
model._set("C2", "=COUPDAYS(A3,A4,1,4)"); // European - no special Feb handling
|
||||
model._set("C3", "=COUPDAYS(A5,A6,1,4)"); // European - no special Feb handling
|
||||
model._set("C4", "=COUPDAYS(A7,A8,1,4)"); // European - no special Feb handling
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// All should succeed without errors
|
||||
for row in ["B1", "B2", "B3", "B4", "C1", "C2", "C3", "C4"] {
|
||||
assert_ne!(model._get_text(row), *"#NUM!", "Failed for {row}");
|
||||
assert!(
|
||||
model._get_text(row).parse::<f64>().is_ok(),
|
||||
"Non-numeric result for {row}"
|
||||
);
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn test_coupon_functions_february_edge_cases() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test that coupon functions handle February dates correctly without errors
|
||||
|
||||
// Settlement: February 28, 2023 (non-leap), Maturity: February 28, 2024 (leap)
|
||||
model._set("A1", "=DATE(2023,2,28)");
|
||||
model._set("A2", "=DATE(2024,2,28)");
|
||||
|
||||
// Test with basis 0 (US 30/360 - should use special February handling)
|
||||
model._set("B1", "=COUPDAYBS(A1,A2,2,0)");
|
||||
model._set("B2", "=COUPDAYS(A1,A2,2,0)");
|
||||
model._set("B3", "=COUPDAYSNC(A1,A2,2,0)");
|
||||
|
||||
// Test with basis 4 (European 30/360 - should NOT use special February handling)
|
||||
model._set("C1", "=COUPDAYBS(A1,A2,2,4)");
|
||||
model._set("C2", "=COUPDAYS(A1,A2,2,4)");
|
||||
model._set("C3", "=COUPDAYSNC(A1,A2,2,4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// With US method (basis 0), February dates should be handled specially
|
||||
// With European method (basis 4), February dates should use actual dates
|
||||
// Key point: both should work without errors
|
||||
|
||||
// We're ensuring functions complete successfully with February dates
|
||||
assert_ne!(model._get_text("B1"), *"#NUM!");
|
||||
assert_ne!(model._get_text("B2"), *"#NUM!");
|
||||
assert_ne!(model._get_text("B3"), *"#NUM!");
|
||||
assert_ne!(model._get_text("C1"), *"#NUM!");
|
||||
assert_ne!(model._get_text("C2"), *"#NUM!");
|
||||
assert_ne!(model._get_text("C3"), *"#NUM!");
|
||||
}
|
||||
@@ -1,350 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
#![allow(clippy::panic)]
|
||||
|
||||
use crate::{cell::CellValue, test::util::new_empty_model};
|
||||
|
||||
// Test constants for realistic bond scenarios
|
||||
const BOND_SETTLEMENT: &str = "=DATE(2020,1,1)";
|
||||
const BOND_MATURITY_4Y: &str = "=DATE(2024,1,1)";
|
||||
const BOND_MATURITY_INVALID: &str = "=DATE(2016,1,1)"; // Before settlement
|
||||
const BOND_MATURITY_SAME: &str = "=DATE(2020,1,1)"; // Same as settlement
|
||||
const BOND_MATURITY_1DAY: &str = "=DATE(2020,1,2)"; // Very short term
|
||||
|
||||
// Standard investment-grade corporate bond parameters
|
||||
const STD_COUPON: f64 = 0.08; // 8% annual coupon rate
|
||||
const STD_YIELD: f64 = 0.09; // 9% yield (discount bond scenario)
|
||||
const STD_FREQUENCY: i32 = 2; // Semi-annual payments (most common)
|
||||
|
||||
// Helper function to reduce test repetition
|
||||
fn assert_numerical_result(model: &crate::Model, cell_ref: &str, should_be_positive: bool) {
|
||||
if let Ok(CellValue::Number(v)) = model.get_cell_value_by_ref(cell_ref) {
|
||||
if should_be_positive {
|
||||
assert!(v > 0.0, "Expected positive value at {cell_ref}, got {v}");
|
||||
}
|
||||
// Value is valid - test passes
|
||||
} else {
|
||||
panic!("Expected numerical result at {cell_ref}");
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_arguments() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test argument count validation
|
||||
model._set("A1", "=DURATION()");
|
||||
model._set("A2", "=DURATION(1,2,3,4)");
|
||||
model._set("A3", "=DURATION(1,2,3,4,5,6,7)");
|
||||
|
||||
model._set("B1", "=MDURATION()");
|
||||
model._set("B2", "=MDURATION(1,2,3,4)");
|
||||
model._set("B3", "=MDURATION(1,2,3,4,5,6,7)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// Too few or too many arguments should result in errors
|
||||
assert_eq!(model._get_text("A1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B3"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_settlement_maturity_errors() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", BOND_SETTLEMENT);
|
||||
model._set("A2", BOND_MATURITY_INVALID); // Before settlement
|
||||
model._set("A3", BOND_MATURITY_SAME); // Same as settlement
|
||||
|
||||
// Both settlement > maturity and settlement = maturity should error
|
||||
model._set(
|
||||
"B1",
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"B2",
|
||||
&format!("=DURATION(A1,A3,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"B3",
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"B4",
|
||||
&format!("=MDURATION(A1,A3,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B3"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B4"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_negative_values_errors() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", BOND_SETTLEMENT);
|
||||
model._set("A2", BOND_MATURITY_4Y);
|
||||
|
||||
// Test negative coupon (coupons must be >= 0)
|
||||
model._set(
|
||||
"B1",
|
||||
&format!("=DURATION(A1,A2,-0.01,{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"B2",
|
||||
&format!("=MDURATION(A1,A2,-0.01,{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
|
||||
// Test negative yield (yields must be >= 0)
|
||||
model._set(
|
||||
"C1",
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},-0.01,{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"C2",
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},-0.01,{STD_FREQUENCY})"),
|
||||
);
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C2"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_invalid_frequency_errors() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", BOND_SETTLEMENT);
|
||||
model._set("A2", BOND_MATURITY_4Y);
|
||||
|
||||
// Only 1, 2, and 4 are valid frequencies (annual, semi-annual, quarterly)
|
||||
let invalid_frequencies = [0, 3, 5, 12]; // Common invalid values
|
||||
|
||||
for (i, &freq) in invalid_frequencies.iter().enumerate() {
|
||||
let row = i + 1;
|
||||
model._set(
|
||||
&format!("B{row}"),
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},{STD_YIELD},{freq})"),
|
||||
);
|
||||
model._set(
|
||||
&format!("C{row}"),
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},{STD_YIELD},{freq})"),
|
||||
);
|
||||
}
|
||||
|
||||
model.evaluate();
|
||||
|
||||
for i in 1..=invalid_frequencies.len() {
|
||||
assert_eq!(model._get_text(&format!("B{i}")), *"#NUM!");
|
||||
assert_eq!(model._get_text(&format!("C{i}")), *"#NUM!");
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_frequency_variations() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", BOND_SETTLEMENT);
|
||||
model._set("A2", BOND_MATURITY_4Y);
|
||||
|
||||
// Test all valid frequencies: 1=annual, 2=semi-annual, 4=quarterly
|
||||
let valid_frequencies = [1, 2, 4];
|
||||
|
||||
for (i, &freq) in valid_frequencies.iter().enumerate() {
|
||||
let row = i + 1;
|
||||
model._set(
|
||||
&format!("B{row}"),
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},{STD_YIELD},{freq})"),
|
||||
);
|
||||
model._set(
|
||||
&format!("C{row}"),
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},{STD_YIELD},{freq})"),
|
||||
);
|
||||
}
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// All should return positive numerical values
|
||||
for i in 1..=valid_frequencies.len() {
|
||||
assert_numerical_result(&model, &format!("Sheet1!B{i}"), true);
|
||||
assert_numerical_result(&model, &format!("Sheet1!C{i}"), true);
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_basis_variations() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", BOND_SETTLEMENT);
|
||||
model._set("A2", BOND_MATURITY_4Y);
|
||||
|
||||
// Test all valid basis values (day count conventions)
|
||||
// 0=30/360 US, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=30/360 European
|
||||
for basis in 0..=4 {
|
||||
let row = basis + 1;
|
||||
model._set(
|
||||
&format!("B{row}"),
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY},{basis})"),
|
||||
);
|
||||
model._set(
|
||||
&format!("C{row}"),
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY},{basis})"),
|
||||
);
|
||||
}
|
||||
|
||||
// Test default basis (should be 0)
|
||||
model._set(
|
||||
"D1",
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"D2",
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// All basis values should work
|
||||
for row in 1..=5 {
|
||||
assert_numerical_result(&model, &format!("Sheet1!B{row}"), true);
|
||||
assert_numerical_result(&model, &format!("Sheet1!C{row}"), true);
|
||||
}
|
||||
|
||||
// Default basis should match basis 0
|
||||
if let (Ok(CellValue::Number(d1)), Ok(CellValue::Number(b1))) = (
|
||||
model.get_cell_value_by_ref("Sheet1!D1"),
|
||||
model.get_cell_value_by_ref("Sheet1!B1"),
|
||||
) {
|
||||
assert!(
|
||||
(d1 - b1).abs() < 1e-10,
|
||||
"Default basis should match basis 0"
|
||||
);
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_edge_cases() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", BOND_SETTLEMENT);
|
||||
model._set("A2", BOND_MATURITY_1DAY); // Very short term (1 day)
|
||||
model._set("A3", BOND_MATURITY_4Y); // Standard term
|
||||
|
||||
// Edge case scenarios with explanations
|
||||
let test_cases = [
|
||||
("B", "A1", "A2", STD_COUPON, STD_YIELD, "short_term"), // 1-day bond
|
||||
("C", "A1", "A3", 0.0, STD_YIELD, "zero_coupon"), // Zero coupon bond
|
||||
("D", "A1", "A3", STD_COUPON, 0.0, "zero_yield"), // Zero yield
|
||||
("E", "A1", "A3", 1.0, 0.5, "high_rates"), // High coupon/yield (100%/50%)
|
||||
];
|
||||
|
||||
for (col, settlement, maturity, coupon, yield_rate, _scenario) in test_cases {
|
||||
model._set(
|
||||
&format!("{col}1"),
|
||||
&format!("=DURATION({settlement},{maturity},{coupon},{yield_rate},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
&format!("{col}2"),
|
||||
&format!("=MDURATION({settlement},{maturity},{coupon},{yield_rate},{STD_FREQUENCY})"),
|
||||
);
|
||||
}
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// All edge cases should return positive values
|
||||
for col in ["B", "C", "D", "E"] {
|
||||
assert_numerical_result(&model, &format!("Sheet1!{col}1"), true);
|
||||
assert_numerical_result(&model, &format!("Sheet1!{col}2"), true);
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_relationship() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", BOND_SETTLEMENT);
|
||||
model._set("A2", BOND_MATURITY_4Y);
|
||||
|
||||
// Test mathematical relationship: MDURATION = DURATION / (1 + yield/frequency)
|
||||
model._set(
|
||||
"B1",
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"B2",
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set("B3", &format!("=B1/(1+{STD_YIELD}/{STD_FREQUENCY})")); // Manual calculation
|
||||
|
||||
// Test with quarterly frequency and different yield
|
||||
model._set("C1", &format!("=DURATION(A1,A2,{STD_COUPON},0.12,4)"));
|
||||
model._set("C2", &format!("=MDURATION(A1,A2,{STD_COUPON},0.12,4)"));
|
||||
model._set("C3", "=C1/(1+0.12/4)"); // Manual calculation for quarterly
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// MDURATION should equal DURATION / (1 + yield/frequency) for both scenarios
|
||||
if let (Ok(CellValue::Number(md)), Ok(CellValue::Number(manual))) = (
|
||||
model.get_cell_value_by_ref("Sheet1!B2"),
|
||||
model.get_cell_value_by_ref("Sheet1!B3"),
|
||||
) {
|
||||
assert!(
|
||||
(md - manual).abs() < 1e-10,
|
||||
"MDURATION should equal DURATION/(1+yield/freq)"
|
||||
);
|
||||
}
|
||||
|
||||
if let (Ok(CellValue::Number(md)), Ok(CellValue::Number(manual))) = (
|
||||
model.get_cell_value_by_ref("Sheet1!C2"),
|
||||
model.get_cell_value_by_ref("Sheet1!C3"),
|
||||
) {
|
||||
assert!(
|
||||
(md - manual).abs() < 1e-10,
|
||||
"MDURATION should equal DURATION/(1+yield/freq) for quarterly"
|
||||
);
|
||||
}
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_duration_mduration_regression() {
|
||||
// Original regression test with known expected values
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2016,1,1)");
|
||||
model._set("A2", "=DATE(2020,1,1)");
|
||||
model._set(
|
||||
"B1",
|
||||
&format!("=DURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
model._set(
|
||||
"B2",
|
||||
&format!("=MDURATION(A1,A2,{STD_COUPON},{STD_YIELD},{STD_FREQUENCY})"),
|
||||
);
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// Verify exact values for regression testing
|
||||
if let Ok(CellValue::Number(v1)) = model.get_cell_value_by_ref("Sheet1!B1") {
|
||||
assert!(
|
||||
(v1 - 3.410746844012284).abs() < 1e-9,
|
||||
"DURATION regression test failed"
|
||||
);
|
||||
} else {
|
||||
panic!("Unexpected value for DURATION");
|
||||
}
|
||||
if let Ok(CellValue::Number(v2)) = model.get_cell_value_by_ref("Sheet1!B2") {
|
||||
assert!(
|
||||
(v2 - 3.263872578002186).abs() < 1e-9,
|
||||
"MDURATION regression test failed"
|
||||
);
|
||||
} else {
|
||||
panic!("Unexpected value for MDURATION");
|
||||
}
|
||||
}
|
||||
@@ -1,5 +1,4 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
#![allow(clippy::panic)]
|
||||
|
||||
use crate::{cell::CellValue, test::util::new_empty_model};
|
||||
|
||||
@@ -26,10 +25,6 @@ fn fn_arguments() {
|
||||
model._set("E2", "=RATE(1,1)");
|
||||
model._set("E3", "=RATE(1,1,1,1,1,1)");
|
||||
|
||||
model._set("F1", "=FVSCHEDULE()");
|
||||
model._set("F2", "=FVSCHEDULE(1)");
|
||||
model._set("F3", "=FVSCHEDULE(1,1,1)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("A1"), *"#ERROR!");
|
||||
@@ -51,10 +46,6 @@ fn fn_arguments() {
|
||||
assert_eq!(model._get_text("E1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("E2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("E3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("F1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("F2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("F3"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
@@ -477,18 +468,3 @@ fn fn_db_misc() {
|
||||
|
||||
assert_eq!(model._get_text("B1"), "$0.00");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_fvschedule() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "1000");
|
||||
model._set("A2", "0.08");
|
||||
model._set("A3", "0.09");
|
||||
model._set("A4", "0.1");
|
||||
|
||||
model._set("B1", "=FVSCHEDULE(A1, A2:A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "1294.92");
|
||||
}
|
||||
|
||||
@@ -1,615 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::{cell::CellValue, test::util::new_empty_model};
|
||||
|
||||
#[test]
|
||||
fn fn_price_yield() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
model._set("A3", "5%");
|
||||
|
||||
model._set("B1", "=PRICE(A1,A2,A3,6%,100,1)");
|
||||
model._set("B2", "=YIELD(A1,A2,A3,B1,100,1)");
|
||||
|
||||
model.evaluate();
|
||||
assert_eq!(model._get_text("B1"), "99.056603774");
|
||||
assert_eq!(model._get_text("B2"), "0.06");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_price_frequencies() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=PRICE(A1,A2,5%,6%,100,1)");
|
||||
model._set("B2", "=PRICE(A1,A2,5%,6%,100,2)");
|
||||
model._set("B3", "=PRICE(A1,A2,5%,6%,100,4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
let annual: f64 = model._get_text("B1").parse().unwrap();
|
||||
let semi: f64 = model._get_text("B2").parse().unwrap();
|
||||
let quarterly: f64 = model._get_text("B3").parse().unwrap();
|
||||
|
||||
assert_ne!(annual, semi);
|
||||
assert_ne!(semi, quarterly);
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_yield_frequencies() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=YIELD(A1,A2,5%,99,100,1)");
|
||||
model._set("B2", "=YIELD(A1,A2,5%,99,100,2)");
|
||||
model._set("B3", "=YIELD(A1,A2,5%,99,100,4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
let annual: f64 = model._get_text("B1").parse().unwrap();
|
||||
let semi: f64 = model._get_text("B2").parse().unwrap();
|
||||
let quarterly: f64 = model._get_text("B3").parse().unwrap();
|
||||
|
||||
assert_ne!(annual, semi);
|
||||
assert_ne!(semi, quarterly);
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_price_argument_errors() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=PRICE()");
|
||||
model._set("B2", "=PRICE(A1,A2,5%,6%,100)");
|
||||
model._set("B3", "=PRICE(A1,A2,5%,6%,100,2,0,99)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B3"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_yield_argument_errors() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=YIELD()");
|
||||
model._set("B2", "=YIELD(A1,A2,5%,99,100)");
|
||||
model._set("B3", "=YIELD(A1,A2,5%,99,100,2,0,99)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B3"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_price_invalid_frequency() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=PRICE(A1,A2,5%,6%,100,0)");
|
||||
model._set("B2", "=PRICE(A1,A2,5%,6%,100,3)");
|
||||
model._set("B3", "=PRICE(A1,A2,5%,6%,100,5)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B3"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_pricedisc() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A2", "=DATE(2022,1,25)");
|
||||
model._set("A3", "=DATE(2022,11,15)");
|
||||
model._set("A4", "3.75%");
|
||||
model._set("A5", "100");
|
||||
|
||||
model._set("B1", "=PRICEDISC(A2,A3,A4,A5)");
|
||||
model._set("C1", "=PRICEDISC(A2,A3)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "96.979166667");
|
||||
assert_eq!(model._get_text("C1"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_pricemat() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2019,2,15)");
|
||||
model._set("A2", "=DATE(2025,4,13)");
|
||||
model._set("A3", "=DATE(2018,11,11)");
|
||||
model._set("A4", "5.75%");
|
||||
model._set("A5", "6.5%");
|
||||
|
||||
model._set("B1", "=PRICEMAT(A1,A2,A3,A4,A5)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "96.271187821");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_yielddisc() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2022,1,25)");
|
||||
model._set("A2", "=DATE(2022,11,15)");
|
||||
model._set("A3", "97");
|
||||
model._set("A4", "100");
|
||||
|
||||
model._set("B1", "=YIELDDISC(A1,A2,A3,A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "0.038393175");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_yieldmat() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2019,2,15)");
|
||||
model._set("A2", "=DATE(2025,4,13)");
|
||||
model._set("A3", "=DATE(2018,11,11)");
|
||||
model._set("A4", "5.75%");
|
||||
model._set("A5", "96.27");
|
||||
|
||||
model._set("B1", "=YIELDMAT(A1,A2,A3,A4,A5)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "0.065002762");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_disc() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2022,1,25)");
|
||||
model._set("A2", "=DATE(2022,11,15)");
|
||||
model._set("A3", "97");
|
||||
model._set("A4", "100");
|
||||
|
||||
model._set("B1", "=DISC(A1,A2,A3,A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "0.037241379");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_received() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2023,6,30)");
|
||||
model._set("A3", "20000");
|
||||
model._set("A4", "5%");
|
||||
model._set("A5", "3");
|
||||
|
||||
model._set("B1", "=RECEIVED(A1,A2,A3,A4,A5)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "24236.387782205");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_intrate() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2020,1,1)");
|
||||
model._set("A2", "=DATE(2023,6,30)");
|
||||
model._set("A3", "10000");
|
||||
model._set("A4", "12000");
|
||||
model._set("A5", "3");
|
||||
|
||||
model._set("B1", "=INTRATE(A1,A2,A3,A4,A5)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "0.057210031");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_bond_functions_arguments() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// PRICEDISC: 4-5 args
|
||||
model._set("A1", "=PRICEDISC()");
|
||||
model._set("A2", "=PRICEDISC(1,2,3)");
|
||||
model._set("A3", "=PRICEDISC(1,2,3,4,5,6)");
|
||||
|
||||
// PRICEMAT: 5-6 args
|
||||
model._set("B1", "=PRICEMAT()");
|
||||
model._set("B2", "=PRICEMAT(1,2,3,4)");
|
||||
model._set("B3", "=PRICEMAT(1,2,3,4,5,6,7)");
|
||||
|
||||
// YIELDDISC: 4-5 args
|
||||
model._set("C1", "=YIELDDISC()");
|
||||
model._set("C2", "=YIELDDISC(1,2,3)");
|
||||
model._set("C3", "=YIELDDISC(1,2,3,4,5,6)");
|
||||
|
||||
// YIELDMAT: 5-6 args
|
||||
model._set("D1", "=YIELDMAT()");
|
||||
model._set("D2", "=YIELDMAT(1,2,3,4)");
|
||||
model._set("D3", "=YIELDMAT(1,2,3,4,5,6,7)");
|
||||
|
||||
// DISC: 4-5 args
|
||||
model._set("E1", "=DISC()");
|
||||
model._set("E2", "=DISC(1,2,3)");
|
||||
model._set("E3", "=DISC(1,2,3,4,5,6)");
|
||||
|
||||
// RECEIVED: 4-5 args
|
||||
model._set("F1", "=RECEIVED()");
|
||||
model._set("F2", "=RECEIVED(1,2,3)");
|
||||
model._set("F3", "=RECEIVED(1,2,3,4,5,6)");
|
||||
|
||||
// INTRATE: 4-5 args
|
||||
model._set("G1", "=INTRATE()");
|
||||
model._set("G2", "=INTRATE(1,2,3)");
|
||||
model._set("G3", "=INTRATE(1,2,3,4,5,6)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("A1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("B3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("C1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("C2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("C3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("D1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("D2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("D3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("E1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("E2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("E3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("F1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("F2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("F3"), *"#ERROR!");
|
||||
|
||||
assert_eq!(model._get_text("G1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("G2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("G3"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_bond_functions_date_boundaries() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Date boundary values
|
||||
model._set("A1", "0"); // Below MINIMUM_DATE_SERIAL_NUMBER
|
||||
model._set("A2", "1"); // MINIMUM_DATE_SERIAL_NUMBER
|
||||
model._set("A3", "2958465"); // MAXIMUM_DATE_SERIAL_NUMBER
|
||||
model._set("A4", "2958466"); // Above MAXIMUM_DATE_SERIAL_NUMBER
|
||||
|
||||
// Test settlement < minimum
|
||||
model._set("B1", "=PRICEDISC(A1,A2,0.05,100)");
|
||||
model._set("B2", "=YIELDDISC(A1,A2,95,100)");
|
||||
model._set("B3", "=DISC(A1,A2,95,100)");
|
||||
model._set("B4", "=RECEIVED(A1,A2,1000,0.05)");
|
||||
model._set("B5", "=INTRATE(A1,A2,1000,1050)");
|
||||
|
||||
// Test maturity > maximum
|
||||
model._set("C1", "=PRICEDISC(A2,A4,0.05,100)");
|
||||
model._set("C2", "=YIELDDISC(A2,A4,95,100)");
|
||||
model._set("C3", "=DISC(A2,A4,95,100)");
|
||||
model._set("C4", "=RECEIVED(A2,A4,1000,0.05)");
|
||||
model._set("C5", "=INTRATE(A2,A4,1000,1050)");
|
||||
|
||||
// Test PRICEMAT/YIELDMAT with issue < minimum
|
||||
model._set("D1", "=PRICEMAT(A2,A3,A1,0.06,0.05)");
|
||||
model._set("D2", "=YIELDMAT(A2,A3,A1,0.06,99)");
|
||||
|
||||
// Test PRICEMAT/YIELDMAT with issue > maximum
|
||||
model._set("E1", "=PRICEMAT(A2,A3,A4,0.06,0.05)");
|
||||
model._set("E2", "=YIELDMAT(A2,A3,A4,0.06,99)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B3"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_yield_invalid_frequency() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=YIELD(A1,A2,5%,99,100,0)");
|
||||
model._set("B2", "=YIELD(A1,A2,5%,99,100,3)");
|
||||
model._set("B3", "=YIELD(A1,A2,5%,99,100,5)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B3"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_bond_functions_date_ordering() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2022,1,1)"); // settlement
|
||||
model._set("A2", "=DATE(2021,12,31)"); // maturity (before settlement)
|
||||
model._set("A3", "=DATE(2020,1,1)"); // issue
|
||||
|
||||
// Test settlement >= maturity
|
||||
model._set("B1", "=PRICEDISC(A1,A2,0.05,100)");
|
||||
model._set("B2", "=YIELDDISC(A1,A2,95,100)");
|
||||
model._set("B3", "=DISC(A1,A2,95,100)");
|
||||
model._set("B4", "=RECEIVED(A1,A2,1000,0.05)");
|
||||
model._set("B5", "=INTRATE(A1,A2,1000,1050)");
|
||||
model._set("B6", "=PRICEMAT(A1,A2,A3,0.06,0.05)");
|
||||
model._set("B7", "=YIELDMAT(A1,A2,A3,0.06,99)");
|
||||
|
||||
// Test settlement < issue for YIELDMAT/PRICEMAT
|
||||
model._set("A4", "=DATE(2023,1,1)"); // later issue date
|
||||
model._set("C1", "=PRICEMAT(A1,A2,A4,0.06,0.05)"); // settlement < issue
|
||||
model._set("C2", "=YIELDMAT(A1,A2,A4,0.06,99)"); // settlement < issue
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B3"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_price_invalid_dates() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=PRICE(A2,A1,5%,6%,100,2)");
|
||||
model._set("B2", "=PRICE(A1,A1,5%,6%,100,2)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_bond_functions_parameter_validation() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2022,1,1)");
|
||||
model._set("A2", "=DATE(2022,12,31)");
|
||||
model._set("A3", "=DATE(2021,1,1)");
|
||||
|
||||
// Test negative/zero prices and redemptions
|
||||
model._set("B1", "=PRICEDISC(A1,A2,0.05,0)"); // zero redemption
|
||||
model._set("B2", "=PRICEDISC(A1,A2,0,100)"); // zero discount
|
||||
model._set("B3", "=PRICEDISC(A1,A2,-0.05,100)"); // negative discount
|
||||
|
||||
model._set("C1", "=YIELDDISC(A1,A2,0,100)"); // zero price
|
||||
model._set("C2", "=YIELDDISC(A1,A2,95,0)"); // zero redemption
|
||||
model._set("C3", "=YIELDDISC(A1,A2,-95,100)"); // negative price
|
||||
|
||||
model._set("D1", "=DISC(A1,A2,0,100)"); // zero price
|
||||
model._set("D2", "=DISC(A1,A2,95,0)"); // zero redemption
|
||||
model._set("D3", "=DISC(A1,A2,-95,100)"); // negative price
|
||||
|
||||
model._set("E1", "=RECEIVED(A1,A2,0,0.05)"); // zero investment
|
||||
model._set("E2", "=RECEIVED(A1,A2,1000,0)"); // zero discount
|
||||
model._set("E3", "=RECEIVED(A1,A2,-1000,0.05)"); // negative investment
|
||||
|
||||
model._set("F1", "=INTRATE(A1,A2,0,1050)"); // zero investment
|
||||
model._set("F2", "=INTRATE(A1,A2,1000,0)"); // zero redemption
|
||||
model._set("F3", "=INTRATE(A1,A2,-1000,1050)"); // negative investment
|
||||
|
||||
model._set("G1", "=PRICEMAT(A1,A2,A3,-0.06,0.05)"); // negative rate
|
||||
model._set("G2", "=PRICEMAT(A1,A2,A3,0.06,-0.05)"); // negative yield
|
||||
|
||||
model._set("H1", "=YIELDMAT(A1,A2,A3,0.06,0)"); // zero price
|
||||
model._set("H2", "=YIELDMAT(A1,A2,A3,-0.06,99)"); // negative rate
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_yield_invalid_dates() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=YIELD(A2,A1,5%,99,100,2)");
|
||||
model._set("B2", "=YIELD(A1,A1,5%,99,100,2)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("B2"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_price_with_basis() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=PRICE(A1,A2,5%,6%,100,2,0)");
|
||||
model._set("B2", "=PRICE(A1,A2,5%,6%,100,2,1)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert!(model._get_text("B1").parse::<f64>().is_ok());
|
||||
assert!(model._get_text("B2").parse::<f64>().is_ok());
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_yield_with_basis() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2023,1,1)");
|
||||
model._set("A2", "=DATE(2024,1,1)");
|
||||
|
||||
model._set("B1", "=YIELD(A1,A2,5%,99,100,2,0)");
|
||||
model._set("B2", "=YIELD(A1,A2,5%,99,100,2,1)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert!(model._get_text("B1").parse::<f64>().is_ok());
|
||||
assert!(model._get_text("B2").parse::<f64>().is_ok());
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_price_yield_inverse_functions() {
|
||||
// Verifies PRICE and YIELD are mathematical inverses
|
||||
// Regression test for periods calculation type mismatch
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2023,1,15)");
|
||||
model._set("A2", "=DATE(2024,7,15)"); // ~1.5 years, fractional periods
|
||||
model._set("A3", "4.75%"); // coupon
|
||||
model._set("A4", "5.125%"); // yield
|
||||
|
||||
model._set("B1", "=PRICE(A1,A2,A3,A4,100,2)");
|
||||
model._set("B2", "=YIELD(A1,A2,A3,B1,100,2)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
let calculated_yield: f64 = model._get_text("B2").parse().unwrap();
|
||||
let expected_yield = 0.05125;
|
||||
|
||||
assert!(
|
||||
(calculated_yield - expected_yield).abs() < 1e-12,
|
||||
"YIELD should recover original yield: expected {expected_yield}, got {calculated_yield}"
|
||||
);
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_price_yield_round_trip_stability() {
|
||||
// Tests numerical stability through multiple PRICE->YIELD->PRICE cycles
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2023,3,10)");
|
||||
model._set("A2", "=DATE(2024,11,22)"); // Irregular period length
|
||||
model._set("A3", "3.25%"); // coupon rate
|
||||
model._set("A4", "4.875%"); // initial yield
|
||||
|
||||
// First round-trip
|
||||
model._set("B1", "=PRICE(A1,A2,A3,A4,100,4)");
|
||||
model._set("B2", "=YIELD(A1,A2,A3,B1,100,4)");
|
||||
|
||||
// Second round-trip
|
||||
model._set("B3", "=PRICE(A1,A2,A3,B2,100,4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
let price1: f64 = model._get_text("B1").parse().unwrap();
|
||||
let price2: f64 = model._get_text("B3").parse().unwrap();
|
||||
|
||||
assert!(
|
||||
(price1 - price2).abs() < 1e-10,
|
||||
"Round-trip should be stable: {price1} vs {price2}"
|
||||
);
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_bond_functions_basis_validation() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
model._set("A1", "=DATE(2022,1,1)");
|
||||
model._set("A2", "=DATE(2022,12,31)");
|
||||
model._set("A3", "=DATE(2021,1,1)");
|
||||
|
||||
// Test valid basis values (0-4)
|
||||
model._set("B1", "=PRICEDISC(A1,A2,0.05,100,0)");
|
||||
model._set("B2", "=PRICEDISC(A1,A2,0.05,100,1)");
|
||||
model._set("B3", "=PRICEDISC(A1,A2,0.05,100,2)");
|
||||
model._set("B4", "=PRICEDISC(A1,A2,0.05,100,3)");
|
||||
model._set("B5", "=PRICEDISC(A1,A2,0.05,100,4)");
|
||||
|
||||
// Test invalid basis values
|
||||
model._set("C1", "=PRICEDISC(A1,A2,0.05,100,-1)");
|
||||
model._set("C2", "=PRICEDISC(A1,A2,0.05,100,5)");
|
||||
model._set("C3", "=YIELDDISC(A1,A2,95,100,10)");
|
||||
model._set("C4", "=DISC(A1,A2,95,100,-5)");
|
||||
model._set("C5", "=RECEIVED(A1,A2,1000,0.05,99)");
|
||||
model._set("C6", "=INTRATE(A1,A2,1000,1050,-2)");
|
||||
model._set("C7", "=PRICEMAT(A1,A2,A3,0.06,0.05,7)");
|
||||
model._set("C8", "=YIELDMAT(A1,A2,A3,0.06,99,-3)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// Valid basis should work
|
||||
assert_ne!(model._get_text("B1"), *"#ERROR!");
|
||||
assert_ne!(model._get_text("B2"), *"#ERROR!");
|
||||
assert_ne!(model._get_text("B3"), *"#ERROR!");
|
||||
assert_ne!(model._get_text("B4"), *"#ERROR!");
|
||||
assert_ne!(model._get_text("B5"), *"#ERROR!");
|
||||
|
||||
// Invalid basis should error
|
||||
assert_eq!(model._get_text("C1"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C2"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C3"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C4"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C5"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C6"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C7"), *"#NUM!");
|
||||
assert_eq!(model._get_text("C8"), *"#NUM!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fn_bond_functions_relationships() {
|
||||
// Test mathematical relationships between functions
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=DATE(2021,1,1)");
|
||||
model._set("A2", "=DATE(2021,7,1)");
|
||||
|
||||
model._set("B1", "=PRICEDISC(A1,A2,5%,100)");
|
||||
model._set("B2", "=YIELDDISC(A1,A2,B1,100)");
|
||||
model._set("B3", "=DISC(A1,A2,B1,100)");
|
||||
model._set("B4", "=RECEIVED(A1,A2,1000,5%)");
|
||||
model._set("B5", "=INTRATE(A1,A2,1000,1050)");
|
||||
model._set("B6", "=PRICEMAT(A1,A2,DATE(2020,7,1),6%,5%)");
|
||||
model._set("B7", "=YIELDMAT(A1,A2,DATE(2020,7,1),6%,99)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(
|
||||
model.get_cell_value_by_ref("Sheet1!B1"),
|
||||
Ok(CellValue::Number(97.5))
|
||||
);
|
||||
if let Ok(CellValue::Number(v)) = model.get_cell_value_by_ref("Sheet1!B2") {
|
||||
assert!((v - 0.051282051).abs() < 1e-6);
|
||||
}
|
||||
if let Ok(CellValue::Number(v)) = model.get_cell_value_by_ref("Sheet1!B3") {
|
||||
assert!((v - 0.05).abs() < 1e-6);
|
||||
}
|
||||
if let Ok(CellValue::Number(v)) = model.get_cell_value_by_ref("Sheet1!B4") {
|
||||
assert!((v - 1025.641025).abs() < 1e-6);
|
||||
}
|
||||
if let Ok(CellValue::Number(v)) = model.get_cell_value_by_ref("Sheet1!B5") {
|
||||
assert!((v - 0.10).abs() < 1e-6);
|
||||
}
|
||||
if let Ok(CellValue::Number(v)) = model.get_cell_value_by_ref("Sheet1!B6") {
|
||||
assert!((v - 100.414634).abs() < 1e-6);
|
||||
}
|
||||
if let Ok(CellValue::Number(v)) = model.get_cell_value_by_ref("Sheet1!B7") {
|
||||
assert!((v - 0.078431372).abs() < 1e-6);
|
||||
}
|
||||
}
|
||||
@@ -1,127 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::{cell::CellValue, test::util::new_empty_model};
|
||||
|
||||
#[test]
|
||||
fn computation() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("B1", "0.1");
|
||||
model._set("B2", "0.2");
|
||||
model._set("A1", "=FVSCHEDULE(100,B1:B2)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("A1"), "132");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fvschedule_basic_with_precise_assertion() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "1000");
|
||||
model._set("B1", "0.09");
|
||||
model._set("B2", "0.11");
|
||||
model._set("B3", "0.1");
|
||||
|
||||
model._set("C1", "=FVSCHEDULE(A1,B1:B3)");
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(
|
||||
model.get_cell_value_by_ref("Sheet1!C1"),
|
||||
Ok(CellValue::Number(1330.89))
|
||||
);
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fvschedule_compound_rates() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "1");
|
||||
model._set("A2", "0.1");
|
||||
model._set("A3", "0.2");
|
||||
model._set("A4", "0.3");
|
||||
|
||||
model._set("B1", "=FVSCHEDULE(A1, A2:A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// 1 * (1+0.1) * (1+0.2) * (1+0.3) = 1 * 1.1 * 1.2 * 1.3 = 1.716
|
||||
assert_eq!(model._get_text("B1"), "1.716");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fvschedule_ignore_non_numbers() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "1");
|
||||
model._set("A2", "0.1");
|
||||
model._set("A3", "foo"); // non-numeric value should be ignored
|
||||
model._set("A4", "0.2");
|
||||
|
||||
model._set("B1", "=FVSCHEDULE(A1, A2:A4)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
// 1 * (1+0.1) * (1+0.2) = 1 * 1.1 * 1.2 = 1.32
|
||||
assert_eq!(model._get_text("B1"), "1.32");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fvschedule_argument_count() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "=FVSCHEDULE()");
|
||||
model._set("A2", "=FVSCHEDULE(1)");
|
||||
model._set("A3", "=FVSCHEDULE(1,1,1)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("A1"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A2"), *"#ERROR!");
|
||||
assert_eq!(model._get_text("A3"), *"#ERROR!");
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fvschedule_edge_cases() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test with zero principal
|
||||
model._set("A1", "0");
|
||||
model._set("A2", "0.1");
|
||||
model._set("A3", "0.2");
|
||||
model._set("B1", "=FVSCHEDULE(A1, A2:A3)");
|
||||
|
||||
// Test with negative principal
|
||||
model._set("C1", "-100");
|
||||
model._set("D1", "=FVSCHEDULE(C1, A2:A3)");
|
||||
|
||||
// Test with zero rates
|
||||
model._set("E1", "100");
|
||||
model._set("E2", "0");
|
||||
model._set("E3", "0");
|
||||
model._set("F1", "=FVSCHEDULE(E1, E2:E3)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "0"); // 0 * anything = 0
|
||||
assert_eq!(model._get_text("D1"), "-132"); // -100 * 1.1 * 1.2 = -132
|
||||
assert_eq!(model._get_text("F1"), "100"); // 100 * 1 * 1 = 100
|
||||
}
|
||||
|
||||
#[test]
|
||||
fn fvschedule_rate_validation() {
|
||||
let mut model = new_empty_model();
|
||||
|
||||
// Test with rate exactly -1 (should cause error due to validation in patch 1)
|
||||
model._set("A1", "100");
|
||||
model._set("A2", "-1");
|
||||
model._set("A3", "0.1");
|
||||
model._set("B1", "=FVSCHEDULE(A1, A2:A3)");
|
||||
|
||||
// Test with rate less than -1 (should cause error)
|
||||
model._set("C1", "100");
|
||||
model._set("C2", "-1.5");
|
||||
model._set("C3", "0.1");
|
||||
model._set("D1", "=FVSCHEDULE(C1, C2:C3)");
|
||||
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_text("B1"), "#NUM!");
|
||||
assert_eq!(model._get_text("D1"), "#NUM!");
|
||||
}
|
||||
@@ -1,13 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::test::util::new_empty_model;
|
||||
|
||||
#[test]
|
||||
fn issue_155() {
|
||||
let mut model = new_empty_model();
|
||||
model._set("A1", "123");
|
||||
model._set("D2", "=-(A1^1.22)");
|
||||
model.evaluate();
|
||||
|
||||
assert_eq!(model._get_formula("D2"), "=-(A1^1.22)".to_string());
|
||||
}
|
||||
@@ -1,16 +0,0 @@
|
||||
#![allow(clippy::unwrap_used)]
|
||||
|
||||
use crate::test::util::new_empty_model;
|
||||
|
||||
#[test]
|
||||
fn sheet_number_name() {
|
||||
let mut model = new_empty_model();
|
||||
model.new_sheet();
|
||||
model._set("A1", "7");
|
||||
model._set("A2", "=Sheet2!C3");
|
||||
model.evaluate();
|
||||
model.rename_sheet("Sheet2", "2024").unwrap();
|
||||
model.evaluate();
|
||||
assert_eq!(model.workbook.get_worksheet_names(), ["Sheet1", "2024"]);
|
||||
assert_eq!(model._get_text("A2"), "0");
|
||||
}
|
||||
@@ -8,8 +8,8 @@ crate-type = ["cdylib"]
|
||||
|
||||
[dependencies]
|
||||
# Default enable napi4 feature, see https://nodejs.org/api/n-api.html#node-api-version-matrix
|
||||
napi = { version = "2.12.2", default-features = false, features = ["napi4", "serde-json"] }
|
||||
napi-derive = "2.12.2"
|
||||
napi = { version = "3.3", default-features = false, features = ["napi4", "serde-json"] }
|
||||
napi-derive = "3.2"
|
||||
ironcalc = { path = "../../xlsx", version = "0.6.0" }
|
||||
serde = { version = "1.0", features = ["derive"] }
|
||||
|
||||
|
||||
16
bindings/nodejs/index.d.ts
vendored
@@ -1,8 +1,5 @@
|
||||
/* tslint:disable */
|
||||
/* eslint-disable */
|
||||
|
||||
/* auto-generated by NAPI-RS */
|
||||
|
||||
/* eslint-disable */
|
||||
export declare class Model {
|
||||
constructor(name: string, locale: string, timezone: string)
|
||||
static fromXlsx(filePath: string, locale: string, tz: string): Model
|
||||
@@ -39,8 +36,10 @@ export declare class Model {
|
||||
newDefinedName(name: string, scope: number | undefined | null, formula: string): void
|
||||
updateDefinedName(name: string, scope: number | undefined | null, newName: string, newScope: number | undefined | null, newFormula: string): void
|
||||
deleteDefinedName(name: string, scope?: number | undefined | null): void
|
||||
testPanic(): void
|
||||
moveColumn(sheet: number, column: number, delta: number): void
|
||||
moveRow(sheet: number, row: number, delta: number): void
|
||||
}
|
||||
|
||||
export declare class UserModel {
|
||||
constructor(name: string, locale: string, timezone: string)
|
||||
static fromBytes(bytes: Uint8Array): UserModel
|
||||
@@ -59,12 +58,13 @@ export declare class UserModel {
|
||||
setSheetColor(sheet: number, color: string): void
|
||||
rangeClearAll(sheet: number, startRow: number, startColumn: number, endRow: number, endColumn: number): void
|
||||
rangeClearContents(sheet: number, startRow: number, startColumn: number, endRow: number, endColumn: number): void
|
||||
rangeClearFormatting(sheet: number, startRow: number, startColumn: number, endRow: number, endColumn: number): void
|
||||
insertRows(sheet: number, row: number, rowCount: number): void
|
||||
insertColumns(sheet: number, column: number, columnCount: number): void
|
||||
deleteRows(sheet: number, row: number, rowCount: number): void
|
||||
deleteColumns(sheet: number, column: number, columnCount: number): void
|
||||
setRowHeight(sheet: number, row: number, height: number): void
|
||||
setColumnWidth(sheet: number, column: number, width: number): void
|
||||
setRowsHeight(sheet: number, rowStart: number, rowEnd: number, height: number): void
|
||||
setColumnsWidth(sheet: number, columnStart: number, columnEnd: number, width: number): void
|
||||
getRowHeight(sheet: number, row: number): number
|
||||
getColumnWidth(sheet: number, column: number): number
|
||||
setUserInput(sheet: number, row: number, column: number, input: string): void
|
||||
@@ -112,4 +112,6 @@ export declare class UserModel {
|
||||
newDefinedName(name: string, scope: number | undefined | null, formula: string): void
|
||||
updateDefinedName(name: string, scope: number | undefined | null, newName: string, newScope: number | undefined | null, newFormula: string): void
|
||||
deleteDefinedName(name: string, scope?: number | undefined | null): void
|
||||
moveColumn(sheet: number, column: number, delta: number): void
|
||||
moveRow(sheet: number, row: number, delta: number): void
|
||||
}
|
||||
|
||||
@@ -1,316 +1,579 @@
|
||||
/* tslint:disable */
|
||||
// prettier-ignore
|
||||
/* eslint-disable */
|
||||
/* prettier-ignore */
|
||||
|
||||
// @ts-nocheck
|
||||
/* auto-generated by NAPI-RS */
|
||||
|
||||
const { existsSync, readFileSync } = require('fs')
|
||||
const { join } = require('path')
|
||||
|
||||
const { platform, arch } = process
|
||||
const { createRequire } = require('node:module')
|
||||
require = createRequire(__filename)
|
||||
|
||||
const { readFileSync } = require('node:fs')
|
||||
let nativeBinding = null
|
||||
let localFileExisted = false
|
||||
let loadError = null
|
||||
const loadErrors = []
|
||||
|
||||
function isMusl() {
|
||||
// For Node 10
|
||||
if (!process.report || typeof process.report.getReport !== 'function') {
|
||||
try {
|
||||
const lddPath = require('child_process').execSync('which ldd').toString().trim()
|
||||
return readFileSync(lddPath, 'utf8').includes('musl')
|
||||
} catch (e) {
|
||||
return true
|
||||
const isMusl = () => {
|
||||
let musl = false
|
||||
if (process.platform === 'linux') {
|
||||
musl = isMuslFromFilesystem()
|
||||
if (musl === null) {
|
||||
musl = isMuslFromReport()
|
||||
}
|
||||
} else {
|
||||
const { glibcVersionRuntime } = process.report.getReport().header
|
||||
return !glibcVersionRuntime
|
||||
if (musl === null) {
|
||||
musl = isMuslFromChildProcess()
|
||||
}
|
||||
}
|
||||
return musl
|
||||
}
|
||||
|
||||
const isFileMusl = (f) => f.includes('libc.musl-') || f.includes('ld-musl-')
|
||||
|
||||
const isMuslFromFilesystem = () => {
|
||||
try {
|
||||
return readFileSync('/usr/bin/ldd', 'utf-8').includes('musl')
|
||||
} catch {
|
||||
return null
|
||||
}
|
||||
}
|
||||
|
||||
switch (platform) {
|
||||
case 'android':
|
||||
switch (arch) {
|
||||
case 'arm64':
|
||||
localFileExisted = existsSync(join(__dirname, 'nodejs.android-arm64.node'))
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.android-arm64.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-android-arm64')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
break
|
||||
case 'arm':
|
||||
localFileExisted = existsSync(join(__dirname, 'nodejs.android-arm-eabi.node'))
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.android-arm-eabi.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-android-arm-eabi')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
break
|
||||
default:
|
||||
throw new Error(`Unsupported architecture on Android ${arch}`)
|
||||
const isMuslFromReport = () => {
|
||||
let report = null
|
||||
if (typeof process.report?.getReport === 'function') {
|
||||
process.report.excludeNetwork = true
|
||||
report = process.report.getReport()
|
||||
}
|
||||
if (!report) {
|
||||
return null
|
||||
}
|
||||
if (report.header && report.header.glibcVersionRuntime) {
|
||||
return false
|
||||
}
|
||||
if (Array.isArray(report.sharedObjects)) {
|
||||
if (report.sharedObjects.some(isFileMusl)) {
|
||||
return true
|
||||
}
|
||||
break
|
||||
case 'win32':
|
||||
switch (arch) {
|
||||
case 'x64':
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.win32-x64-msvc.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.win32-x64-msvc.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-win32-x64-msvc')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
break
|
||||
case 'ia32':
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.win32-ia32-msvc.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.win32-ia32-msvc.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-win32-ia32-msvc')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
break
|
||||
case 'arm64':
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.win32-arm64-msvc.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.win32-arm64-msvc.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-win32-arm64-msvc')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
break
|
||||
default:
|
||||
throw new Error(`Unsupported architecture on Windows: ${arch}`)
|
||||
}
|
||||
break
|
||||
case 'darwin':
|
||||
localFileExisted = existsSync(join(__dirname, 'nodejs.darwin-universal.node'))
|
||||
}
|
||||
return false
|
||||
}
|
||||
|
||||
const isMuslFromChildProcess = () => {
|
||||
try {
|
||||
return require('child_process').execSync('ldd --version', { encoding: 'utf8' }).includes('musl')
|
||||
} catch (e) {
|
||||
// If we reach this case, we don't know if the system is musl or not, so is better to just fallback to false
|
||||
return false
|
||||
}
|
||||
}
|
||||
|
||||
function requireNative() {
|
||||
if (process.env.NAPI_RS_NATIVE_LIBRARY_PATH) {
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.darwin-universal.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-darwin-universal')
|
||||
return require(process.env.NAPI_RS_NATIVE_LIBRARY_PATH);
|
||||
} catch (err) {
|
||||
loadErrors.push(err)
|
||||
}
|
||||
} else if (process.platform === 'android') {
|
||||
if (process.arch === 'arm64') {
|
||||
try {
|
||||
return require('./nodejs.android-arm64.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
break
|
||||
} catch {}
|
||||
switch (arch) {
|
||||
case 'x64':
|
||||
localFileExisted = existsSync(join(__dirname, 'nodejs.darwin-x64.node'))
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.darwin-x64.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-darwin-x64')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-android-arm64')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-android-arm64/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
break
|
||||
case 'arm64':
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.darwin-arm64.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.darwin-arm64.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-darwin-arm64')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else if (process.arch === 'arm') {
|
||||
try {
|
||||
return require('./nodejs.android-arm-eabi.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-android-arm-eabi')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-android-arm-eabi/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
break
|
||||
default:
|
||||
throw new Error(`Unsupported architecture on macOS: ${arch}`)
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
loadErrors.push(new Error(`Unsupported architecture on Android ${process.arch}`))
|
||||
}
|
||||
break
|
||||
case 'freebsd':
|
||||
if (arch !== 'x64') {
|
||||
throw new Error(`Unsupported architecture on FreeBSD: ${arch}`)
|
||||
} else if (process.platform === 'win32') {
|
||||
if (process.arch === 'x64') {
|
||||
if (process.report?.getReport?.()?.header?.osName?.startsWith?.('MINGW')) {
|
||||
try {
|
||||
return require('./nodejs.win32-x64-gnu.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-win32-x64-gnu')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-win32-x64-gnu/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
try {
|
||||
return require('./nodejs.win32-x64-msvc.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-win32-x64-msvc')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-win32-x64-msvc/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
}
|
||||
} else if (process.arch === 'ia32') {
|
||||
try {
|
||||
return require('./nodejs.win32-ia32-msvc.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-win32-ia32-msvc')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-win32-ia32-msvc/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else if (process.arch === 'arm64') {
|
||||
try {
|
||||
return require('./nodejs.win32-arm64-msvc.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-win32-arm64-msvc')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-win32-arm64-msvc/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
loadErrors.push(new Error(`Unsupported architecture on Windows: ${process.arch}`))
|
||||
}
|
||||
localFileExisted = existsSync(join(__dirname, 'nodejs.freebsd-x64.node'))
|
||||
} else if (process.platform === 'darwin') {
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.freebsd-x64.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-freebsd-x64')
|
||||
}
|
||||
return require('./nodejs.darwin-universal.node')
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
loadErrors.push(e)
|
||||
}
|
||||
break
|
||||
case 'linux':
|
||||
switch (arch) {
|
||||
case 'x64':
|
||||
if (isMusl()) {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-x64-musl.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-x64-musl.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-x64-musl')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
} else {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-x64-gnu.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-x64-gnu.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-x64-gnu')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-darwin-universal')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-darwin-universal/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
if (process.arch === 'x64') {
|
||||
try {
|
||||
return require('./nodejs.darwin-x64.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-darwin-x64')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-darwin-x64/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
break
|
||||
case 'arm64':
|
||||
if (isMusl()) {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-arm64-musl.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-arm64-musl.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-arm64-musl')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
} else {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-arm64-gnu.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-arm64-gnu.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-arm64-gnu')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else if (process.arch === 'arm64') {
|
||||
try {
|
||||
return require('./nodejs.darwin-arm64.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-darwin-arm64')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-darwin-arm64/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
break
|
||||
case 'arm':
|
||||
if (isMusl()) {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-arm-musleabihf.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-arm-musleabihf.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-arm-musleabihf')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
} else {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-arm-gnueabihf.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-arm-gnueabihf.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-arm-gnueabihf')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
loadErrors.push(new Error(`Unsupported architecture on macOS: ${process.arch}`))
|
||||
}
|
||||
} else if (process.platform === 'freebsd') {
|
||||
if (process.arch === 'x64') {
|
||||
try {
|
||||
return require('./nodejs.freebsd-x64.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-freebsd-x64')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-freebsd-x64/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
break
|
||||
case 'riscv64':
|
||||
if (isMusl()) {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-riscv64-musl.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-riscv64-musl.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-riscv64-musl')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
} else {
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-riscv64-gnu.node')
|
||||
)
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-riscv64-gnu.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-riscv64-gnu')
|
||||
}
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else if (process.arch === 'arm64') {
|
||||
try {
|
||||
return require('./nodejs.freebsd-arm64.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-freebsd-arm64')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-freebsd-arm64/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
break
|
||||
case 's390x':
|
||||
localFileExisted = existsSync(
|
||||
join(__dirname, 'nodejs.linux-s390x-gnu.node')
|
||||
)
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
loadErrors.push(new Error(`Unsupported architecture on FreeBSD: ${process.arch}`))
|
||||
}
|
||||
} else if (process.platform === 'linux') {
|
||||
if (process.arch === 'x64') {
|
||||
if (isMusl()) {
|
||||
try {
|
||||
if (localFileExisted) {
|
||||
nativeBinding = require('./nodejs.linux-s390x-gnu.node')
|
||||
} else {
|
||||
nativeBinding = require('@ironcalc/nodejs-linux-s390x-gnu')
|
||||
}
|
||||
return require('./nodejs.linux-x64-musl.node')
|
||||
} catch (e) {
|
||||
loadError = e
|
||||
loadErrors.push(e)
|
||||
}
|
||||
break
|
||||
default:
|
||||
throw new Error(`Unsupported architecture on Linux: ${arch}`)
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-x64-musl')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-x64-musl/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
try {
|
||||
return require('./nodejs.linux-x64-gnu.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-x64-gnu')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-x64-gnu/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
}
|
||||
} else if (process.arch === 'arm64') {
|
||||
if (isMusl()) {
|
||||
try {
|
||||
return require('./nodejs.linux-arm64-musl.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-arm64-musl')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-arm64-musl/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
try {
|
||||
return require('./nodejs.linux-arm64-gnu.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-arm64-gnu')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-arm64-gnu/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
}
|
||||
} else if (process.arch === 'arm') {
|
||||
if (isMusl()) {
|
||||
try {
|
||||
return require('./nodejs.linux-arm-musleabihf.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-arm-musleabihf')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-arm-musleabihf/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
try {
|
||||
return require('./nodejs.linux-arm-gnueabihf.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-arm-gnueabihf')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-arm-gnueabihf/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
}
|
||||
} else if (process.arch === 'loong64') {
|
||||
if (isMusl()) {
|
||||
try {
|
||||
return require('./nodejs.linux-loong64-musl.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-loong64-musl')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-loong64-musl/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
try {
|
||||
return require('./nodejs.linux-loong64-gnu.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-loong64-gnu')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-loong64-gnu/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
}
|
||||
} else if (process.arch === 'riscv64') {
|
||||
if (isMusl()) {
|
||||
try {
|
||||
return require('./nodejs.linux-riscv64-musl.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-riscv64-musl')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-riscv64-musl/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
try {
|
||||
return require('./nodejs.linux-riscv64-gnu.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-riscv64-gnu')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-riscv64-gnu/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
}
|
||||
} else if (process.arch === 'ppc64') {
|
||||
try {
|
||||
return require('./nodejs.linux-ppc64-gnu.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-ppc64-gnu')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-ppc64-gnu/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else if (process.arch === 's390x') {
|
||||
try {
|
||||
return require('./nodejs.linux-s390x-gnu.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-linux-s390x-gnu')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-linux-s390x-gnu/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
loadErrors.push(new Error(`Unsupported architecture on Linux: ${process.arch}`))
|
||||
}
|
||||
break
|
||||
default:
|
||||
throw new Error(`Unsupported OS: ${platform}, architecture: ${arch}`)
|
||||
} else if (process.platform === 'openharmony') {
|
||||
if (process.arch === 'arm64') {
|
||||
try {
|
||||
return require('./nodejs.openharmony-arm64.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-openharmony-arm64')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-openharmony-arm64/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else if (process.arch === 'x64') {
|
||||
try {
|
||||
return require('./nodejs.openharmony-x64.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-openharmony-x64')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-openharmony-x64/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else if (process.arch === 'arm') {
|
||||
try {
|
||||
return require('./nodejs.openharmony-arm.node')
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
try {
|
||||
const binding = require('@ironcalc/nodejs-openharmony-arm')
|
||||
const bindingPackageVersion = require('@ironcalc/nodejs-openharmony-arm/package.json').version
|
||||
if (bindingPackageVersion !== '0.6.0' && process.env.NAPI_RS_ENFORCE_VERSION_CHECK && process.env.NAPI_RS_ENFORCE_VERSION_CHECK !== '0') {
|
||||
throw new Error(`Native binding package version mismatch, expected 0.6.0 but got ${bindingPackageVersion}. You can reinstall dependencies to fix this issue.`)
|
||||
}
|
||||
return binding
|
||||
} catch (e) {
|
||||
loadErrors.push(e)
|
||||
}
|
||||
} else {
|
||||
loadErrors.push(new Error(`Unsupported architecture on OpenHarmony: ${process.arch}`))
|
||||
}
|
||||
} else {
|
||||
loadErrors.push(new Error(`Unsupported OS: ${process.platform}, architecture: ${process.arch}`))
|
||||
}
|
||||
}
|
||||
|
||||
nativeBinding = requireNative()
|
||||
|
||||
if (!nativeBinding || process.env.NAPI_RS_FORCE_WASI) {
|
||||
let wasiBinding = null
|
||||
let wasiBindingError = null
|
||||
try {
|
||||
wasiBinding = require('./nodejs.wasi.cjs')
|
||||
nativeBinding = wasiBinding
|
||||
} catch (err) {
|
||||
if (process.env.NAPI_RS_FORCE_WASI) {
|
||||
wasiBindingError = err
|
||||
}
|
||||
}
|
||||
if (!nativeBinding) {
|
||||
try {
|
||||
wasiBinding = require('@ironcalc/nodejs-wasm32-wasi')
|
||||
nativeBinding = wasiBinding
|
||||
} catch (err) {
|
||||
if (process.env.NAPI_RS_FORCE_WASI) {
|
||||
wasiBindingError.cause = err
|
||||
loadErrors.push(err)
|
||||
}
|
||||
}
|
||||
}
|
||||
if (process.env.NAPI_RS_FORCE_WASI === 'error' && !wasiBinding) {
|
||||
const error = new Error('WASI binding not found and NAPI_RS_FORCE_WASI is set to error')
|
||||
error.cause = wasiBindingError
|
||||
throw error
|
||||
}
|
||||
}
|
||||
|
||||
if (!nativeBinding) {
|
||||
if (loadError) {
|
||||
throw loadError
|
||||
if (loadErrors.length > 0) {
|
||||
throw new Error(
|
||||
`Cannot find native binding. ` +
|
||||
`npm has a bug related to optional dependencies (https://github.com/npm/cli/issues/4828). ` +
|
||||
'Please try `npm i` again after removing both package-lock.json and node_modules directory.',
|
||||
{
|
||||
cause: loadErrors.reduce((err, cur) => {
|
||||
cur.cause = err
|
||||
return cur
|
||||
}),
|
||||
},
|
||||
)
|
||||
}
|
||||
throw new Error(`Failed to load native binding`)
|
||||
}
|
||||
|
||||
const { Model, UserModel } = nativeBinding
|
||||
|
||||
module.exports.Model = Model
|
||||
module.exports.UserModel = UserModel
|
||||
module.exports = nativeBinding
|
||||
module.exports.Model = nativeBinding.Model
|
||||
module.exports.UserModel = nativeBinding.UserModel
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-android-arm-eabi",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"android"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-android-arm64",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"android"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-darwin-arm64",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"darwin"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-darwin-universal",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"darwin"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-darwin-x64",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"darwin"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-linux-arm-gnueabihf",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"linux"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-linux-arm-musleabihf",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"linux"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-linux-arm64-gnu",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"linux"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-linux-arm64-musl",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"linux"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-linux-riscv64-gnu",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"linux"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-linux-x64-gnu",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"linux"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-linux-x64-musl",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"linux"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-win32-arm64-msvc",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"win32"
|
||||
],
|
||||
|
||||
@@ -1,6 +1,6 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs-win32-x64-msvc",
|
||||
"version": "0.2.0",
|
||||
"version": "0.6.0",
|
||||
"os": [
|
||||
"win32"
|
||||
],
|
||||
|
||||
2215
bindings/nodejs/package-lock.json
generated
@@ -1,29 +1,27 @@
|
||||
{
|
||||
"name": "@ironcalc/nodejs",
|
||||
"version": "0.5.1",
|
||||
"version": "0.6.0",
|
||||
"main": "index.js",
|
||||
"types": "index.d.ts",
|
||||
"napi": {
|
||||
"name": "nodejs",
|
||||
"triples": {
|
||||
"additional": [
|
||||
"aarch64-apple-darwin",
|
||||
"aarch64-linux-android",
|
||||
"aarch64-unknown-linux-gnu",
|
||||
"aarch64-unknown-linux-musl",
|
||||
"aarch64-pc-windows-msvc",
|
||||
"armv7-unknown-linux-gnueabihf",
|
||||
"armv7-unknown-linux-musleabihf",
|
||||
"x86_64-unknown-linux-musl",
|
||||
"armv7-linux-androideabi",
|
||||
"universal-apple-darwin",
|
||||
"riscv64gc-unknown-linux-gnu"
|
||||
]
|
||||
}
|
||||
"binaryName": "nodejs",
|
||||
"targets": [
|
||||
"aarch64-apple-darwin",
|
||||
"aarch64-linux-android",
|
||||
"aarch64-unknown-linux-gnu",
|
||||
"aarch64-unknown-linux-musl",
|
||||
"aarch64-pc-windows-msvc",
|
||||
"armv7-unknown-linux-gnueabihf",
|
||||
"armv7-unknown-linux-musleabihf",
|
||||
"x86_64-unknown-linux-musl",
|
||||
"armv7-linux-androideabi",
|
||||
"universal-apple-darwin",
|
||||
"riscv64gc-unknown-linux-gnu"
|
||||
]
|
||||
},
|
||||
"license": "MIT",
|
||||
"devDependencies": {
|
||||
"@napi-rs/cli": "^2.18.4",
|
||||
"@napi-rs/cli": "^3.3",
|
||||
"ava": "^6.0.1"
|
||||
},
|
||||
"ava": {
|
||||
@@ -38,7 +36,7 @@
|
||||
"build:debug": "napi build --platform",
|
||||
"prepublishOnly": "napi prepublish -t npm",
|
||||
"test": "ava",
|
||||
"universal": "napi universal",
|
||||
"universal": "napi universalize",
|
||||
"version": "napi version"
|
||||
}
|
||||
}
|
||||
1359
bindings/nodejs/pnpm-lock.yaml
generated
@@ -1,6 +1,6 @@
|
||||
#![deny(clippy::all)]
|
||||
|
||||
use napi::{self, bindgen_prelude::*, JsUnknown, Result};
|
||||
use napi::{self, bindgen_prelude::*, Result, Unknown};
|
||||
use serde::Serialize;
|
||||
|
||||
use ironcalc::{
|
||||
@@ -127,7 +127,7 @@ impl Model {
|
||||
sheet: u32,
|
||||
row: i32,
|
||||
column: i32,
|
||||
style: JsUnknown,
|
||||
style: Unknown,
|
||||
) -> Result<()> {
|
||||
let style: Style = env
|
||||
.from_js_value(style)
|
||||
@@ -140,12 +140,12 @@ impl Model {
|
||||
|
||||
#[napi(js_name = "getCellStyle")]
|
||||
pub fn get_cell_style(
|
||||
&mut self,
|
||||
&'_ self,
|
||||
env: Env,
|
||||
sheet: u32,
|
||||
row: i32,
|
||||
column: i32,
|
||||
) -> Result<JsUnknown> {
|
||||
) -> Result<Unknown<'_>> {
|
||||
let style = self
|
||||
.model
|
||||
.get_style_for_cell(sheet, row, column)
|
||||
@@ -246,11 +246,11 @@ impl Model {
|
||||
.map_err(to_js_error)
|
||||
}
|
||||
|
||||
// I don't _think_ serializing to JsUnknown can't fail
|
||||
// I don't _think_ serializing to Unknown can't fail
|
||||
// FIXME: Remove this clippy directive
|
||||
#[napi(js_name = "getWorksheetsProperties")]
|
||||
#[allow(clippy::unwrap_used)]
|
||||
pub fn get_worksheets_properties(&self, env: Env) -> JsUnknown {
|
||||
pub fn get_worksheets_properties(&'_ self, env: Env) -> Unknown<'_> {
|
||||
env
|
||||
.to_js_value(&self.model.get_worksheets_properties())
|
||||
.unwrap()
|
||||
@@ -288,7 +288,7 @@ impl Model {
|
||||
}
|
||||
|
||||
#[napi(js_name = "getDefinedNameList")]
|
||||
pub fn get_defined_name_list(&self, env: Env) -> Result<JsUnknown> {
|
||||
pub fn get_defined_name_list(&'_ self, env: Env) -> Result<Unknown<'_>> {
|
||||
let data: Vec<DefinedName> = self
|
||||
.model
|
||||
.workbook
|
||||
|
||||
@@ -2,7 +2,7 @@
|
||||
|
||||
use serde::Serialize;
|
||||
|
||||
use napi::{self, bindgen_prelude::*, JsUnknown, Result};
|
||||
use napi::{self, bindgen_prelude::*, Result, Unknown};
|
||||
|
||||
use ironcalc::base::{
|
||||
expressions::types::Area,
|
||||
@@ -305,7 +305,7 @@ impl UserModel {
|
||||
pub fn update_range_style(
|
||||
&mut self,
|
||||
env: Env,
|
||||
range: JsUnknown,
|
||||
range: Unknown,
|
||||
style_path: String,
|
||||
value: String,
|
||||
) -> Result<()> {
|
||||
@@ -320,12 +320,12 @@ impl UserModel {
|
||||
|
||||
#[napi(js_name = "getCellStyle")]
|
||||
pub fn get_cell_style(
|
||||
&mut self,
|
||||
&'_ mut self,
|
||||
env: Env,
|
||||
sheet: u32,
|
||||
row: i32,
|
||||
column: i32,
|
||||
) -> Result<JsUnknown> {
|
||||
) -> Result<Unknown<'_>> {
|
||||
let style = self
|
||||
.model
|
||||
.get_cell_style(sheet, row, column)
|
||||
@@ -337,7 +337,7 @@ impl UserModel {
|
||||
}
|
||||
|
||||
#[napi(js_name = "onPasteStyles")]
|
||||
pub fn on_paste_styles(&mut self, env: Env, styles: JsUnknown) -> Result<()> {
|
||||
pub fn on_paste_styles(&mut self, env: Env, styles: Unknown) -> Result<()> {
|
||||
let styles: &Vec<Vec<Style>> = &env
|
||||
.from_js_value(styles)
|
||||
.map_err(|e| to_js_error(e.to_string()))?;
|
||||
@@ -362,11 +362,11 @@ impl UserModel {
|
||||
)
|
||||
}
|
||||
|
||||
// I don't _think_ serializing to JsUnknown can't fail
|
||||
// I don't _think_ serializing to Unknown can't fail
|
||||
// FIXME: Remove this clippy directive
|
||||
#[napi(js_name = "getWorksheetsProperties")]
|
||||
#[allow(clippy::unwrap_used)]
|
||||
pub fn get_worksheets_properties(&self, env: Env) -> JsUnknown {
|
||||
pub fn get_worksheets_properties(&'_ self, env: Env) -> Unknown<'_> {
|
||||
env
|
||||
.to_js_value(&self.model.get_worksheets_properties())
|
||||
.unwrap()
|
||||
@@ -383,11 +383,11 @@ impl UserModel {
|
||||
vec![sheet as i32, row, column]
|
||||
}
|
||||
|
||||
// I don't _think_ serializing to JsUnknown can't fail
|
||||
// I don't _think_ serializing to Unknown can't fail
|
||||
// FIXME: Remove this clippy directive
|
||||
#[napi(js_name = "getSelectedView")]
|
||||
#[allow(clippy::unwrap_used)]
|
||||
pub fn get_selected_view(&self, env: Env) -> JsUnknown {
|
||||
pub fn get_selected_view(&'_ self, env: Env) -> Unknown<'_> {
|
||||
env.to_js_value(&self.model.get_selected_view()).unwrap()
|
||||
}
|
||||
|
||||
@@ -440,7 +440,7 @@ impl UserModel {
|
||||
}
|
||||
|
||||
#[napi(js_name = "autoFillRows")]
|
||||
pub fn auto_fill_rows(&mut self, env: Env, source_area: JsUnknown, to_row: i32) -> Result<()> {
|
||||
pub fn auto_fill_rows(&mut self, env: Env, source_area: Unknown, to_row: i32) -> Result<()> {
|
||||
let area: Area = env
|
||||
.from_js_value(source_area)
|
||||
.map_err(|e| to_js_error(e.to_string()))?;
|
||||
@@ -454,7 +454,7 @@ impl UserModel {
|
||||
pub fn auto_fill_columns(
|
||||
&mut self,
|
||||
env: Env,
|
||||
source_area: JsUnknown,
|
||||
source_area: Unknown,
|
||||
to_column: i32,
|
||||
) -> Result<()> {
|
||||
let area: Area = env
|
||||
@@ -536,8 +536,8 @@ impl UserModel {
|
||||
pub fn set_area_with_border(
|
||||
&mut self,
|
||||
env: Env,
|
||||
area: JsUnknown,
|
||||
border_area: JsUnknown,
|
||||
area: Unknown,
|
||||
border_area: Unknown,
|
||||
) -> Result<()> {
|
||||
let range: Area = env
|
||||
.from_js_value(area)
|
||||
@@ -568,7 +568,7 @@ impl UserModel {
|
||||
}
|
||||
|
||||
#[napi(js_name = "copyToClipboard")]
|
||||
pub fn copy_to_clipboard(&self, env: Env) -> Result<JsUnknown> {
|
||||
pub fn copy_to_clipboard(&'_ self, env: Env) -> Result<Unknown<'_>> {
|
||||
let data = self
|
||||
.model
|
||||
.copy_to_clipboard()
|
||||
@@ -584,8 +584,8 @@ impl UserModel {
|
||||
&mut self,
|
||||
env: Env,
|
||||
source_sheet: u32,
|
||||
source_range: JsUnknown,
|
||||
clipboard: JsUnknown,
|
||||
source_range: Unknown,
|
||||
clipboard: Unknown,
|
||||
is_cut: bool,
|
||||
) -> Result<()> {
|
||||
let source_range: (i32, i32, i32, i32) = env
|
||||
@@ -601,7 +601,7 @@ impl UserModel {
|
||||
}
|
||||
|
||||
#[napi(js_name = "pasteCsvText")]
|
||||
pub fn paste_csv_string(&mut self, env: Env, area: JsUnknown, csv: String) -> Result<()> {
|
||||
pub fn paste_csv_string(&mut self, env: Env, area: Unknown, csv: String) -> Result<()> {
|
||||
let range: Area = env
|
||||
.from_js_value(area)
|
||||
.map_err(|e| to_js_error(e.to_string()))?;
|
||||
@@ -612,7 +612,7 @@ impl UserModel {
|
||||
}
|
||||
|
||||
#[napi(js_name = "getDefinedNameList")]
|
||||
pub fn get_defined_name_list(&self, env: Env) -> Result<JsUnknown> {
|
||||
pub fn get_defined_name_list(&'_ self, env: Env) -> Result<Unknown<'_>> {
|
||||
let data: Vec<DefinedName> = self
|
||||
.model
|
||||
.get_defined_name_list()
|
||||
|
||||
@@ -5,11 +5,7 @@ use wasm_bindgen::{
|
||||
};
|
||||
|
||||
use ironcalc_base::{
|
||||
expressions::{
|
||||
lexer::util::get_tokens as tokenizer,
|
||||
types::Area,
|
||||
utils::{number_to_column, quote_name as quote_name_ic},
|
||||
},
|
||||
expressions::{lexer::util::get_tokens as tokenizer, types::Area, utils::number_to_column},
|
||||
types::{CellType, Style},
|
||||
worksheet::NavigationDirection,
|
||||
BorderArea, ClipboardData, UserModel as BaseModel,
|
||||
@@ -35,11 +31,6 @@ pub fn column_name_from_number(column: i32) -> Result<String, JsError> {
|
||||
}
|
||||
}
|
||||
|
||||
#[wasm_bindgen(js_name = "quoteName")]
|
||||
pub fn quote_name(name: &str) -> String {
|
||||
quote_name_ic(name)
|
||||
}
|
||||
|
||||
#[derive(Serialize)]
|
||||
struct DefinedName {
|
||||
name: String,
|
||||
|
||||
@@ -1,12 +1,10 @@
|
||||
services:
|
||||
server:
|
||||
image: ghcr.io/ironcalc/ironcalc-server:0.6.0
|
||||
build:
|
||||
context: .
|
||||
target: server-runtime
|
||||
|
||||
caddy:
|
||||
image: ghcr.io/ironcalc/ironcalc-caddy:0.6.0
|
||||
build:
|
||||
context: .
|
||||
target: caddy-runtime
|
||||
|
||||
1182
docs/package-lock.json
generated
@@ -6,7 +6,7 @@
|
||||
},
|
||||
"devDependencies": {
|
||||
"markdown-it-mathjax3": "^4.3.2",
|
||||
"vitepress": "^v2.0.0-alpha.12",
|
||||
"vitepress": "^v2.0.0-alpha.8",
|
||||
"vue": "^3.5.17"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -68,8 +68,6 @@ Using IronCalc, a complex number is a string of the form "1+j3".
|
||||
|
||||
## Arrays
|
||||
|
||||
## Ranges
|
||||
|
||||
## References
|
||||
|
||||
A reference is a pointer to a single cell or a range of cells. The reference can either be entered manually, for example "A4", or as the result of a calculation, such as the OFFSET Function or the INDIRECT Function. A reference can also be built, for example with the Colon (\:) Operator.
|
||||
@@ -6,28 +6,29 @@ lang: en-US
|
||||
|
||||
# Date and Time functions
|
||||
|
||||
All Date and Time functions are already supported in IronCalc.
|
||||
At the moment IronCalc only supports a few function in this section.
|
||||
You can track the progress in this [GitHub issue](https://github.com/ironcalc/IronCalc/issues/48).
|
||||
|
||||
| Function | Status | Documentation |
|
||||
| ---------------- | ---------------------------------------------- | ------------- |
|
||||
| DATE | <Badge type="tip" text="Available" /> | – |
|
||||
| DATEDIF | <Badge type="tip" text="Available" /> | – |
|
||||
| DATEVALUE | <Badge type="tip" text="Available" /> | – |
|
||||
| DATEDIF | <Badge type="tip" text="Available" /> | [DATEDIF](date_and_time/datedif) |
|
||||
| DATEVALUE | <Badge type="tip" text="Available" /> | [DATEVALUE](date_and_time/datevalue) |
|
||||
| DAY | <Badge type="tip" text="Available" /> | [DAY](date_and_time/day) |
|
||||
| DAYS | <Badge type="tip" text="Available" /> | – |
|
||||
| DAYS360 | <Badge type="tip" text="Available" /> | – |
|
||||
| EDATE | <Badge type="tip" text="Available" /> | – |
|
||||
| EOMONTH | <Badge type="tip" text="Available" /> | – |
|
||||
| HOUR | <Badge type="tip" text="Available" /> | – |
|
||||
| HOUR | <Badge type="tip" text="Available" /> | [HOUR](date_and_time/hour) |
|
||||
| ISOWEEKNUM | <Badge type="tip" text="Available" /> | – |
|
||||
| MINUTE | <Badge type="tip" text="Available" /> | – |
|
||||
| MINUTE | <Badge type="tip" text="Available" /> | [MINUTE](date_and_time/minute) |
|
||||
| MONTH | <Badge type="tip" text="Available" /> | [MONTH](date_and_time/month) |
|
||||
| NETWORKDAYS | <Badge type="tip" text="Available" /> | [NETWORKDAYS](date_and_time/networkdays) |
|
||||
| NETWORKDAYS.INTL | <Badge type="tip" text="Available" /> | [NETWORKDAYS.INTL](date_and_time/networkdays.intl) |
|
||||
| NOW | <Badge type="tip" text="Available" /> | – |
|
||||
| SECOND | <Badge type="tip" text="Available" /> | – |
|
||||
| TIME | <Badge type="tip" text="Available" /> | – |
|
||||
| TIMEVALUE | <Badge type="tip" text="Available" /> | – |
|
||||
| SECOND | <Badge type="tip" text="Available" /> | [SECOND](date_and_time/second) |
|
||||
| TIME | <Badge type="tip" text="Available" /> | [TIME](date_and_time/time) |
|
||||
| TIMEVALUE | <Badge type="tip" text="Available" /> | [TIMEVALUE](date_and_time/timevalue) |
|
||||
| TODAY | <Badge type="tip" text="Available" /> | – |
|
||||
| WEEKDAY | <Badge type="tip" text="Available" /> | – |
|
||||
| WEEKNUM | <Badge type="tip" text="Available" /> | – |
|
||||
|
||||
@@ -22,7 +22,7 @@ NETWORKDAYS.INTL is a function of the Date and Time category that calculates the
|
||||
* *start_date* ([number](/features/value-types#numbers), required). The start date expressed as a [serial number](/features/serial-numbers.md).
|
||||
* *end_date* ([number](/features/value-types#numbers), required). The end date expressed as a [serial number](/features/serial-numbers.md).
|
||||
* *weekend* ([number](/features/value-types#numbers) or [string](/features/value-types#strings), optional). Defines which days are considered weekends. Default is 1 (Saturday-Sunday).
|
||||
* *holidays* ([array](/features/value-types#arrays) or [range](/features/value-types#ranges), optional). A list of dates to exclude from the calculation, expressed as serial numbers.
|
||||
* *holidays* ([array](/features/value-types#arrays) or [range](/features/ranges), optional). A list of dates to exclude from the calculation, expressed as serial numbers.
|
||||
|
||||
### Weekend parameter options
|
||||
The _weekend_ parameter can be specified in two ways:
|
||||
|
||||
@@ -21,7 +21,7 @@ NETWORKDAYS is a function of the Date and Time category that calculates the numb
|
||||
### Argument descriptions
|
||||
* *start_date* ([number](/features/value-types#numbers), required). The start date expressed as a [serial number](/features/serial-numbers.md).
|
||||
* *end_date* ([number](/features/value-types#numbers), required). The end date expressed as a [serial number](/features/serial-numbers.md).
|
||||
* *holidays* ([array](/features/value-types#arrays) or [range](/features/value-types#ranges), optional). A list of dates to exclude from the calculation, expressed as serial numbers.
|
||||
* *holidays* ([array](/features/value-types#arrays) or [range](/features/ranges), optional). A list of dates to exclude from the calculation, expressed as serial numbers.
|
||||
|
||||
### Additional guidance
|
||||
- If the supplied _start_date_ and _end_date_ arguments have fractional parts, NETWORKDAYS uses their [floor values](https://en.wikipedia.org/wiki/Floor_and_ceiling_functions).
|
||||
|
||||
@@ -11,32 +11,32 @@ You can track the progress in this [GitHub issue](https://github.com/ironcalc/Ir
|
||||
|
||||
| Function | Status | Documentation |
|
||||
| ---------- | ---------------------------------------------- | ------------------ |
|
||||
| ACCRINT | <Badge type="tip" text="Available" /> | [ACCRINT](financial/accrint) |
|
||||
| ACCRINTM | <Badge type="tip" text="Available" /> | [ACCRINTM](financial/accrintm) |
|
||||
| ACCRINT | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| ACCRINTM | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| AMORDEGRC | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| AMORLINC | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| COUPDAYBS | <Badge type="tip" text="Available" /> | – |
|
||||
| COUPDAYS | <Badge type="tip" text="Available" /> | – |
|
||||
| COUPDAYSNC | <Badge type="tip" text="Available" /> | – |
|
||||
| COUPNCD | <Badge type="tip" text="Available" /> | – |
|
||||
| COUPNUM | <Badge type="tip" text="Available" /> | – |
|
||||
| COUPPCD | <Badge type="tip" text="Available" /> | – |
|
||||
| COUPDAYBS | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| COUPDAYS | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| COUPDAYSNC | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| COUPNCD | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| COUPNUM | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| COUPPCD | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| CUMIPMT | <Badge type="tip" text="Available" /> | – |
|
||||
| CUMPRINC | <Badge type="tip" text="Available" /> | – |
|
||||
| DB | <Badge type="tip" text="Available" /> | – |
|
||||
| DDB | <Badge type="tip" text="Available" /> | – |
|
||||
| DISC | <Badge type="tip" text="Available" /> | – |
|
||||
| DISC | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| DOLLARDE | <Badge type="tip" text="Available" /> | – |
|
||||
| DOLLARFR | <Badge type="tip" text="Available" /> | – |
|
||||
| DURATION | <Badge type="tip" text="Available" /> | – |
|
||||
| DURATION | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| EFFECT | <Badge type="tip" text="Available" /> | – |
|
||||
| FV | <Badge type="tip" text="Available" /> | [FV](financial/fv) |
|
||||
| FVSCHEDULE | <Badge type="tip" text="Available" /> | [FVSCHEDULE](financial/fvschedule) |
|
||||
| INTRATE | <Badge type="tip" text="Available" /> | – |
|
||||
| FVSCHEDULE | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| INTRATE | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| IPMT | <Badge type="tip" text="Available" /> | – |
|
||||
| IRR | <Badge type="tip" text="Available" /> | – |
|
||||
| ISPMT | <Badge type="tip" text="Available" /> | – |
|
||||
| MDURATION | <Badge type="tip" text="Available" /> | – |
|
||||
| MDURATION | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| MIRR | <Badge type="tip" text="Available" /> | – |
|
||||
| NOMINAL | <Badge type="tip" text="Available" /> | – |
|
||||
| NPER | <Badge type="tip" text="Available" /> | – |
|
||||
@@ -48,12 +48,12 @@ You can track the progress in this [GitHub issue](https://github.com/ironcalc/Ir
|
||||
| PDURATION | <Badge type="tip" text="Available" /> | – |
|
||||
| PMT | <Badge type="tip" text="Available" /> | – |
|
||||
| PPMT | <Badge type="tip" text="Available" /> | – |
|
||||
| PRICE | <Badge type="tip" text="Available" /> | – |
|
||||
| PRICEDISC | <Badge type="tip" text="Available" /> | – |
|
||||
| PRICEMAT | <Badge type="tip" text="Available" /> | – |
|
||||
| PRICE | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| PRICEDISC | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| PRICEMAT | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| PV | <Badge type="tip" text="Available" /> | [PV](financial/pv) |
|
||||
| RATE | <Badge type="tip" text="Available" /> | – |
|
||||
| RECEIVED | <Badge type="tip" text="Available" /> | – |
|
||||
| RECEIVED | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| RRI | <Badge type="tip" text="Available" /> | - |
|
||||
| SLN | <Badge type="tip" text="Available" /> | – |
|
||||
| SYD | <Badge type="tip" text="Available" /> | – |
|
||||
@@ -63,9 +63,6 @@ You can track the progress in this [GitHub issue](https://github.com/ironcalc/Ir
|
||||
| VDB | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| XIRR | <Badge type="tip" text="Available" /> | – |
|
||||
| XNPV | <Badge type="tip" text="Available" /> | – |
|
||||
| YIELD | <Badge type="tip" text="Available" /> | – |
|
||||
| YIELD | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| YIELDDISC | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| YIELDMAT | <Badge type="info" text="Not implemented yet" /> | – |
|
||||
| YIELD | <Badge type="tip" text="Available" /> | – |
|
||||
| YIELDDISC | <Badge type="tip" text="Available" /> | – |
|
||||
| YIELDMAT | <Badge type="tip" text="Available" /> | – |
|
||||
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# ACCRINT
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# ACCRINTM
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# COUPDAYBS
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# COUPDAYS
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# COUPDAYSNC
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# COUPNCD
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# COUPNUM
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# COUPPCD
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# DISC
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# DURATION
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# FVSCHEDULE
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# INTRATE
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# MDURATION
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# PRICE
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# PRICEDISC
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# PRICEMAT
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# RECEIVED
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# YIELD
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# YIELDDISC
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
@@ -7,5 +7,6 @@ lang: en-US
|
||||
# YIELDMAT
|
||||
|
||||
::: warning
|
||||
🚧 This function is implemented but currently lacks detailed documentation. For guidance, you may refer to the equivalent functionality in [Microsoft Excel documentation](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).
|
||||
🚧 This function is not yet available in IronCalc.
|
||||
[Follow development here](https://github.com/ironcalc/IronCalc/labels/Functions)
|
||||
:::
|
||||
2
webapp/IronCalc/package-lock.json
generated
@@ -40,7 +40,7 @@
|
||||
},
|
||||
"../../bindings/wasm/pkg": {
|
||||
"name": "@ironcalc/wasm",
|
||||
"version": "0.6.0",
|
||||
"version": "0.5.0",
|
||||
"license": "MIT/Apache-2.0"
|
||||
},
|
||||
"node_modules/@adobe/css-tools": {
|
||||
|
||||
@@ -1,12 +1,6 @@
|
||||
import { Button, Menu, MenuItem, styled } from "@mui/material";
|
||||
import type { MenuItemProps } from "@mui/material";
|
||||
import {
|
||||
ChevronDown,
|
||||
EyeOff,
|
||||
PaintBucket,
|
||||
TextCursorInput,
|
||||
Trash2,
|
||||
} from "lucide-react";
|
||||
import { ChevronDown } from "lucide-react";
|
||||
import { useRef, useState } from "react";
|
||||
import { useTranslation } from "react-i18next";
|
||||
import { theme } from "../../theme";
|
||||
@@ -104,8 +98,7 @@ function SheetTab(props: SheetTabProps) {
|
||||
handleClose();
|
||||
}}
|
||||
>
|
||||
<TextCursorInput />
|
||||
{t("sheet_tab.rename")}
|
||||
Rename
|
||||
</StyledMenuItem>
|
||||
<StyledMenuItem
|
||||
onClick={() => {
|
||||
@@ -113,8 +106,16 @@ function SheetTab(props: SheetTabProps) {
|
||||
handleClose();
|
||||
}}
|
||||
>
|
||||
<PaintBucket />
|
||||
{t("sheet_tab.change_color")}
|
||||
Change Color
|
||||
</StyledMenuItem>
|
||||
<StyledMenuItem
|
||||
disabled={!props.canDelete}
|
||||
onClick={() => {
|
||||
handleOpenDeleteDialog();
|
||||
handleClose();
|
||||
}}
|
||||
>
|
||||
Delete
|
||||
</StyledMenuItem>
|
||||
<StyledMenuItem
|
||||
disabled={!props.canDelete}
|
||||
@@ -123,20 +124,8 @@ function SheetTab(props: SheetTabProps) {
|
||||
handleClose();
|
||||
}}
|
||||
>
|
||||
<EyeOff />
|
||||
{t("sheet_tab.hide_sheet")}
|
||||
Hide sheet
|
||||
</StyledMenuItem>
|
||||
<MenuDivider />
|
||||
<DeleteButton
|
||||
disabled={!props.canDelete}
|
||||
onClick={() => {
|
||||
handleOpenDeleteDialog();
|
||||
handleClose();
|
||||
}}
|
||||
>
|
||||
<Trash2 />
|
||||
{t("sheet_tab.delete")}
|
||||
</DeleteButton>
|
||||
</StyledMenu>
|
||||
<SheetRenameDialog
|
||||
open={renameDialogOpen}
|
||||
@@ -189,9 +178,7 @@ const StyledMenu = styled(Menu)`
|
||||
|
||||
const StyledMenuItem = styled(MenuItem)<MenuItemProps>(() => ({
|
||||
display: "flex",
|
||||
justifyContent: "flex-start",
|
||||
alignItems: "center",
|
||||
gap: "8px",
|
||||
justifyContent: "space-between",
|
||||
fontSize: "12px",
|
||||
width: "calc(100% - 8px)",
|
||||
margin: "0px 4px",
|
||||
@@ -201,11 +188,6 @@ const StyledMenuItem = styled(MenuItem)<MenuItemProps>(() => ({
|
||||
"&:disabled": {
|
||||
color: "#BDBDBD",
|
||||
},
|
||||
"& svg": {
|
||||
width: "16px",
|
||||
height: "16px",
|
||||
color: `${theme.palette.grey[600]}`,
|
||||
},
|
||||
}));
|
||||
|
||||
const TabWrapper = styled("div")<{ $color: string; $selected: boolean }>`
|
||||
@@ -251,25 +233,4 @@ const Name = styled("div")`
|
||||
user-select: none;
|
||||
`;
|
||||
|
||||
const MenuDivider = styled("div")`
|
||||
width: 100%;
|
||||
margin: auto;
|
||||
margin-top: 4px;
|
||||
margin-bottom: 4px;
|
||||
border-top: 1px solid ${theme.palette.grey[200]};
|
||||
`;
|
||||
|
||||
const DeleteButton = styled(StyledMenuItem)`
|
||||
color: ${theme.palette.error.main};
|
||||
svg {
|
||||
color: ${theme.palette.error.main};
|
||||
}
|
||||
&:hover {
|
||||
background-color: ${theme.palette.error.main}1A;
|
||||
}
|
||||
&:active {
|
||||
background-color: ${theme.palette.error.main}1A;
|
||||
}
|
||||
`;
|
||||
|
||||
export default SheetTab;
|
||||
|
||||
@@ -1,9 +1,7 @@
|
||||
import { styled } from "@mui/material";
|
||||
import { Tooltip } from "@mui/material";
|
||||
import { Menu, Plus } from "lucide-react";
|
||||
import { useState } from "react";
|
||||
import { useTranslation } from "react-i18next";
|
||||
import { IronCalcLogo } from "../../icons";
|
||||
import { theme } from "../../theme";
|
||||
import { StyledButton } from "../Toolbar/Toolbar";
|
||||
import { NAVIGATION_HEIGHT } from "../constants";
|
||||
@@ -51,16 +49,20 @@ function SheetTabBar(props: SheetTabBarProps) {
|
||||
return (
|
||||
<Container>
|
||||
<LeftButtonsContainer>
|
||||
<Tooltip title={t("navigation.add_sheet")}>
|
||||
<StyledButton $pressed={false} onClick={props.onAddBlankSheet}>
|
||||
<Plus />
|
||||
</StyledButton>
|
||||
</Tooltip>
|
||||
<Tooltip title={t("navigation.sheet_list")}>
|
||||
<StyledButton onClick={handleClick} $pressed={false}>
|
||||
<Menu />
|
||||
</StyledButton>
|
||||
</Tooltip>
|
||||
<StyledButton
|
||||
title={t("navigation.add_sheet")}
|
||||
$pressed={false}
|
||||
onClick={props.onAddBlankSheet}
|
||||
>
|
||||
<Plus />
|
||||
</StyledButton>
|
||||
<StyledButton
|
||||
onClick={handleClick}
|
||||
title={t("navigation.sheet_list")}
|
||||
$pressed={false}
|
||||
>
|
||||
<Menu />
|
||||
</StyledButton>
|
||||
</LeftButtonsContainer>
|
||||
<VerticalDivider />
|
||||
<Sheets>
|
||||
@@ -88,15 +90,9 @@ function SheetTabBar(props: SheetTabBarProps) {
|
||||
))}
|
||||
</SheetInner>
|
||||
</Sheets>
|
||||
<RightContainer>
|
||||
<Tooltip title={t("navigation.link")}>
|
||||
<LogoLink
|
||||
onClick={() => window.open("https://www.ironcalc.com", "_blank")}
|
||||
>
|
||||
<IronCalcLogo />
|
||||
</LogoLink>
|
||||
</Tooltip>
|
||||
</RightContainer>
|
||||
<Advert href="https://www.ironcalc.com" target="_blank">
|
||||
ironcalc.com
|
||||
</Advert>
|
||||
<SheetListMenu
|
||||
anchorEl={anchorEl}
|
||||
open={open}
|
||||
@@ -123,11 +119,14 @@ const Container = styled("div")`
|
||||
display: flex;
|
||||
height: ${NAVIGATION_HEIGHT}px;
|
||||
align-items: center;
|
||||
padding: 0px;
|
||||
padding: 0px 12px;
|
||||
font-family: Inter;
|
||||
overflow: hidden;
|
||||
background-color: ${theme.palette.common.white};
|
||||
border-top: 1px solid ${theme.palette.grey["300"]};
|
||||
@media (max-width: 769px) {
|
||||
padding-right: 0px;
|
||||
padding-left: 8px;
|
||||
}
|
||||
`;
|
||||
|
||||
const Sheets = styled("div")`
|
||||
@@ -144,15 +143,30 @@ const SheetInner = styled("div")`
|
||||
display: flex;
|
||||
`;
|
||||
|
||||
const Advert = styled("a")`
|
||||
display: flex;
|
||||
align-items: center;
|
||||
color: ${theme.palette.primary.main};
|
||||
padding: 0px 0px 0px 12px;
|
||||
font-size: 12px;
|
||||
text-decoration: none;
|
||||
border-left: 1px solid ${theme.palette.grey["300"]};
|
||||
transition: color 0.2s ease-in-out;
|
||||
&:hover {
|
||||
text-decoration: underline;
|
||||
}
|
||||
@media (max-width: 769px) {
|
||||
display: none;
|
||||
}
|
||||
`;
|
||||
|
||||
const LeftButtonsContainer = styled("div")`
|
||||
display: flex;
|
||||
flex-direction: row;
|
||||
align-items: center;
|
||||
height: 100%;
|
||||
gap: 4px;
|
||||
padding: 0px 12px;
|
||||
padding-right: 12px;
|
||||
@media (max-width: 769px) {
|
||||
padding: 0px 8px;
|
||||
padding-right: 8px;
|
||||
}
|
||||
`;
|
||||
|
||||
@@ -164,29 +178,4 @@ const VerticalDivider = styled("div")`
|
||||
}
|
||||
`;
|
||||
|
||||
const RightContainer = styled("a")`
|
||||
display: flex;
|
||||
align-items: center;
|
||||
color: ${theme.palette.primary.main};
|
||||
height: 100%;
|
||||
padding: 0px 8px;
|
||||
@media (max-width: 769px) {
|
||||
display: none;
|
||||
}
|
||||
`;
|
||||
|
||||
const LogoLink = styled("div")`
|
||||
display: flex;
|
||||
align-items: center;
|
||||
padding: 8px;
|
||||
border-radius: 4px;
|
||||
svg {
|
||||
height: 14px;
|
||||
width: auto;
|
||||
}
|
||||
&:hover {
|
||||
background-color: ${theme.palette.grey["100"]};
|
||||
}
|
||||
`;
|
||||
|
||||
export default SheetTabBar;
|
||||
|
||||
@@ -1,12 +1,36 @@
|
||||
import type { Area, Cell } from "./types";
|
||||
|
||||
import {
|
||||
type SelectedView,
|
||||
columnNameFromNumber,
|
||||
quoteName,
|
||||
} from "@ironcalc/wasm";
|
||||
import { type SelectedView, columnNameFromNumber } from "@ironcalc/wasm";
|
||||
import { LAST_COLUMN, LAST_ROW } from "./WorksheetCanvas/constants";
|
||||
|
||||
// FIXME: Use the `quoteName` function from the wasm module
|
||||
function nameNeedsQuoting(name: string): boolean {
|
||||
// it contains any of these characters: ()'$,;-+{} or space
|
||||
for (const char of name) {
|
||||
if (" ()'$,;-+{}".includes(char)) {
|
||||
return true;
|
||||
}
|
||||
}
|
||||
|
||||
// TODO:
|
||||
// - cell reference in A1 notation, e.g. B1048576 is quoted, B1048577 is not
|
||||
// - cell reference in R1C1 notation, e.g. RC, RC2, R5C, R-4C, RC-8, R, C
|
||||
// - integers
|
||||
|
||||
return false;
|
||||
}
|
||||
|
||||
/**
|
||||
* Quotes a string sheet name if it needs to
|
||||
* NOTE: Invalid characters in a sheet name: \, /, *, [, ], :, ?
|
||||
*/
|
||||
export function quoteName(name: string): string {
|
||||
if (nameNeedsQuoting(name)) {
|
||||
return `'${name.replace(/'/g, "''")}'`;
|
||||
}
|
||||
return name;
|
||||
}
|
||||
|
||||
/**
|
||||
* Returns true if the keypress should start editing
|
||||
*/
|
||||
|
||||
@@ -81,12 +81,6 @@
|
||||
"confirm": "Yes, delete sheet",
|
||||
"cancel": "Cancel"
|
||||
},
|
||||
"sheet_tab": {
|
||||
"rename": "Rename",
|
||||
"change_color": "Change Color",
|
||||
"delete": "Delete",
|
||||
"hide_sheet": "Hide sheet"
|
||||
},
|
||||
"formula_input": {
|
||||
"update": "Update",
|
||||
"label": "Formula",
|
||||
@@ -94,8 +88,7 @@
|
||||
},
|
||||
"navigation": {
|
||||
"add_sheet": "Add sheet",
|
||||
"sheet_list": "Sheet list",
|
||||
"link": "Open ironcalc.com"
|
||||
"sheet_list": "Sheet list"
|
||||
},
|
||||
"name_manager_dialog": {
|
||||
"title": "Named Ranges",
|
||||
|
||||
@@ -2,12 +2,7 @@
|
||||
<html lang="en">
|
||||
<head>
|
||||
<meta charset="UTF-8" />
|
||||
<link rel="icon" type="image/x-icon" href="/favicon.ico?v=1" />
|
||||
<link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png?v=1" />
|
||||
<link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png?v=1" />
|
||||
<link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png?v=1" />
|
||||
<link rel="icon" type="image/png" sizes="192x192" href="/android-chrome-192x192.png?v=1" />
|
||||
<link rel="icon" type="image/png" sizes="512x512" href="/android-chrome-512x512.png?v=1" />
|
||||
<link rel="icon" type="image/svg+xml" href="/ironcalc.svg" />
|
||||
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
|
||||
<!-- <meta name="theme-color" content="#1bb566"> -->
|
||||
<meta name="theme-color" media="(prefers-color-scheme: light)" content="#F2994A" />
|
||||
|
||||
@@ -75,16 +75,6 @@ function App() {
|
||||
start();
|
||||
}, []);
|
||||
|
||||
// biome-ignore lint/correctness/useExhaustiveDependencies: localStorageId needed to detect name changes (model mutates internally)
|
||||
useEffect(() => {
|
||||
if (model) {
|
||||
const workbookName = model.getName();
|
||||
document.title = workbookName ? `${workbookName} - IronCalc` : "IronCalc";
|
||||
} else {
|
||||
document.title = "IronCalc";
|
||||
}
|
||||
}, [model, localStorageId]);
|
||||
|
||||
if (!model) {
|
||||
return (
|
||||
<Loading>
|
||||
|
||||
@@ -8,19 +8,6 @@ type ModelsMetadata = Record<
|
||||
{ name: string; createdAt: number; pinned?: boolean }
|
||||
>;
|
||||
|
||||
function randomUUID(): string {
|
||||
try {
|
||||
return crypto.randomUUID();
|
||||
} catch {
|
||||
// Fallback for environments without crypto.randomUUID()
|
||||
return "xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx".replace(/[xy]/g, (c) => {
|
||||
const r = (Math.random() * 16) | 0;
|
||||
const v = c === "x" ? r : (r & 0x3) | 0x8;
|
||||
return v.toString(16);
|
||||
});
|
||||
}
|
||||
}
|
||||
|
||||
export function updateNameSelectedWorkbook(model: Model, newName: string) {
|
||||
const uuid = localStorage.getItem("selected");
|
||||
if (uuid) {
|
||||
@@ -90,7 +77,7 @@ export function createNewModel(): Model {
|
||||
const name = getNewName(Object.values(models).map((m) => m.name));
|
||||
|
||||
const model = new Model(name, "en", "UTC");
|
||||
const uuid = randomUUID();
|
||||
const uuid = crypto.randomUUID();
|
||||
localStorage.setItem("selected", uuid);
|
||||
localStorage.setItem(uuid, bytesToBase64(model.toBytes()));
|
||||
|
||||
@@ -134,7 +121,7 @@ export function saveSelectedModelInStorage(model: Model) {
|
||||
}
|
||||
|
||||
export function saveModelToStorage(model: Model) {
|
||||
const uuid = randomUUID();
|
||||
const uuid = crypto.randomUUID();
|
||||
localStorage.setItem("selected", uuid);
|
||||
localStorage.setItem(uuid, bytesToBase64(model.toBytes()));
|
||||
let modelsJson = localStorage.getItem("models");
|
||||
@@ -241,7 +228,7 @@ export function duplicateModel(uuid: string): Model | null {
|
||||
|
||||
duplicatedModel.setName(newName);
|
||||
|
||||
const newUuid = randomUUID();
|
||||
const newUuid = crypto.randomUUID();
|
||||
localStorage.setItem("selected", newUuid);
|
||||
localStorage.setItem(newUuid, bytesToBase64(duplicatedModel.toBytes()));
|
||||
|
||||
|
||||