public CIQUser Put(string id, [FromBody] CIQUser user)
        {
            updateUserData(user);
            var insertResult = user.Insert().Result;

            return(user);
        }
 private static void updateUserData(CIQUser user)
 {
     foreach (var column in user.Columns)
     {
         for (var i = 0; i < column.CellDatas.Count; i++)
         {
             var cell = user.GetCell(column.ColumnLetter, i);
             if (!string.IsNullOrEmpty(cell.Formula))
             {
                 cell.Data = processCell(user, cell);
             }
         }
     }
 }
        private static string processCell(CIQUser user, CellData cell)
        {
            if (cell.Formula[0] != '=')
            {
                return(cell.Formula);
            }

            var delimiters = new char[] { '=', '+', '-', '/', '*' };
            var tokens     = cell.Formula.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);
            var sum        = 0f;

            // Get operator tokens
            var operators = new List <char>();

            foreach (var c in cell.Formula)
            {
                if (c == '+' || c == '-' || c == '=' || c == '/')
                {
                    operators.Add(c);
                }
            }

            // Process cell index tokens
            for (var i = 0; i < tokens.Length; i++)
            {
                var token          = tokens[i];
                var column         = token[0];
                var indexStr       = token.Substring(1);
                var index          = int.Parse(indexStr);
                var additionalCell = user.GetCell(column, index);
                var valueParse     = float.TryParse(additionalCell.Data, out var cellValue);
                if (!valueParse)
                {
                    return("N/A");
                }
                if (i == 0)
                {
                    sum = cellValue;
                }
                else
                {
                    if (operators[i] == '+')
                    {
                        sum += cellValue;
                    }
                    else if (operators[i] == '-')
                    {
                        sum -= cellValue;
                    }
                    else if (operators[i] == '*')
                    {
                        sum *= cellValue;
                    }
                    else if (operators[i] == '/')
                    {
                        sum /= cellValue;
                    }
                    else
                    {
                        return("N/A");
                    }
                }
            }

            return(sum.ToString());
        }