openformula_kernel/
extensions.rs1use core::cmp::Ordering;
4
5use crate::registry::required_scalar;
6use crate::{
7 coerce_number, Argument, CalcError, CalcResult, CoercionPolicy, EvalContext, FunctionRegistry,
8 Value,
9};
10
11pub fn register_kitu_examples(registry: &mut FunctionRegistry) -> CalcResult<()> {
15 registry.register_extension(
16 "KITU",
17 "CLAMP",
18 "Kitu extension example; not an OpenFormula standard function",
19 clamp,
20 )
21}
22
23fn clamp(
24 arguments: &[Argument],
25 _context: &mut dyn EvalContext,
26 policy: CoercionPolicy,
27) -> CalcResult {
28 if arguments.len() != 3 {
29 return Err(CalcError::value("KITU.CLAMP expects 3 arguments"));
30 }
31 let value = coerce_number(required_scalar(&arguments[0], "value")?, policy)?;
32 let minimum = coerce_number(required_scalar(&arguments[1], "minimum")?, policy)?;
33 let maximum = coerce_number(required_scalar(&arguments[2], "maximum")?, policy)?;
34 if minimum.partial_cmp(&maximum) == Some(Ordering::Greater) {
35 return Err(CalcError::num("KITU.CLAMP minimum exceeds maximum"));
36 }
37 let result = if value.partial_cmp(&minimum) == Some(Ordering::Less) {
38 minimum
39 } else if value.partial_cmp(&maximum) == Some(Ordering::Greater) {
40 maximum
41 } else {
42 value
43 };
44 Ok(Value::Number(result))
45}