Struct FormulaTranslator 

pub struct FormulaTranslator { /* private fields */ }

Translates YAML row formulas to Excel cell formulas

Implementations

impl FormulaTranslator

pub fn new(column_map: HashMap<String, String>) -> Self

Create a new formula translator with column mappings (legacy, for backwards compat)

pub const fn new_with_tables( column_map: HashMap<String, String>, table_column_maps: HashMap<String, HashMap<String, String>>, table_row_counts: HashMap<String, usize>, ) -> Self

Create a new formula translator with full table knowledge

pub fn translate_row_formula( &self, formula: &str, excel_row: u32, ) -> ForgeResult<String>

Translate a row formula to an Excel cell formula for a specific row

Example:

• Input: =revenue - cogs, row_idx 0, excel_row 2
• Output: =A2-B2

Errors

Returns an error if a column reference cannot be resolved.

Panics

Panics if a regex capture group 0 is missing (should never occur).

pub fn translate_scalar_formula( &self, formula: &str, scalar_row_map: &HashMap<String, u32>, ) -> ForgeResult<String>

Translate a scalar formula to an Excel formula

Examples:

• =SUM(table.column) → =SUM(table!A2:A4)
• =table.column[0] → =table!A2
• =scalar_name / 100 → =B3 / 100

Errors

Returns an error if a regex compilation fails.

Panics

Panics if a regex capture group 0 is missing (should never occur).

pub fn column_index_to_letter(index: usize) -> String

Convert a column name to an Excel column letter

Examples:

• 0 → A
• 1 → B
• 25 → Z
• 26 → AA