truecalc-core 7.1.1

Formula engine with exact Google Sheets semantics — stateless, embeddable evaluator
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

use super::super::*;
use crate::types::Value;

#[test]
fn zero_chars() {
    assert_eq!(
        left_fn(&[Value::Text("Hello".to_string()), Value::Number(0.0)]),
        Value::Text("".to_string())
    );
}

#[test]
fn clamp_beyond_length() {
    assert_eq!(
        left_fn(&[Value::Text("Hello".to_string()), Value::Number(100.0)]),
        Value::Text("Hello".to_string())
    );
}

#[test]
fn empty_string() {
    assert_eq!(
        left_fn(&[Value::Text("".to_string()), Value::Number(3.0)]),
        Value::Text("".to_string())
    );
}

// Google Sheets indexes LEFT by UTF-16 code unit, not Unicode codepoint. See
// #848: LEFT of 2 units on an astral character (e.g. 😀 = surrogate pair)
// returns the whole character; LEFT of 1 unit splits the surrogate pair.
#[test]
fn whole_astral_character_takes_two_utf16_units() {
    assert_eq!(
        left_fn(&[Value::Text("😀X".to_string()), Value::Number(2.0)]),
        Value::Text("😀".to_string())
    );
}

#[test]
fn splits_surrogate_pair_by_utf16_unit_position() {
    assert_eq!(
        left_fn(&[Value::Text("😀X".to_string()), Value::Number(1.0)]),
        Value::Text("\u{FFFD}".to_string())
    );
}