Example #1
0
        internal void AdjustFormulas(XLCell baseCell, XLCell targetCell)
        {
            var keys = Values.Keys.ToList();

            foreach (var key in keys)
            {
                if (Values[key] == null || !Values[key].IsFormula)
                {
                    continue;
                }

                var r1c1 = baseCell.GetFormulaR1C1(Values[key].Value);
                Values[key] = new XLFormula {
                    _value = targetCell.GetFormulaA1(r1c1), IsFormula = true
                };
            }
        }