Skip to content

armgit / macro

Public Imported from GitHub
0

Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.

1.9 KB
Raw Blame
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
}