Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
use crate::{calc_result::Range, expressions::types::CellReferenceIndex};
/// It returns the closest cell from cell_reference to range in the same column/row
/// Examples
/// * i_i(B5, A2:A9) -> B5
/// * i_i(B5, A7:A9) -> None
/// * i_i(B5, A2:D2) -> B2
///
/// Excel-parity, cross-sheet:
/// * a 1x1 range always dereferences, regardless of the consuming cell's
/// position or sheet (Excel: `=@Sheet2!D5` and OFFSET/INDIRECT results in
/// scalar context return the single cell's value);
/// * row/column-aligned intersection works across sheets — the intersection
/// happens in the range's own coordinate space (Excel: `=Data!D1:D5`
/// entered on another sheet's C3 returns Data!D3). The resulting reference
/// lives on the RANGE's sheet.
pub(crate) fn implicit_intersection(
cell_reference: &CellReferenceIndex,
range: &Range,
) -> Option<CellReferenceIndex> {
let left = &range.left;
let right = &range.right;
// A range spanning two sheets never intersects.
if left.sheet != right.sheet {
return None;
}
let sheet = left.sheet;
// Single-cell range: always dereference (position- and sheet-independent).
if left.row == right.row && left.column == right.column {
return Some(CellReferenceIndex {
sheet,
row: left.row,
column: left.column,
});
}
let row = cell_reference.row;
let column = cell_reference.column;
if row >= left.row && row <= right.row {
if left.column != right.column {
return None;
}
return Some(CellReferenceIndex {
sheet,
row,
column: left.column,
});
} else if column >= left.column && column <= right.column {
if left.row != right.row {
return None;
}
return Some(CellReferenceIndex {
sheet,
row: left.row,
column,
});
}
None
}