LoadFromDataTable and Formulas

Mar 11, 2015 at 8:45 PM
After upgrading from version 3.1.xx I noticed the hyperlinks I was creating in stored procedures were no longer showing as hyperlinks but as plain text. So I add the if .. Set_Formula in ExcelRangeBase.LoadFromDataTable. It seems easy enough but I am curious if there is a reason you haven't done this? I know you have a lot more test cases then I do so I figured you might have a reason why this shouldn't be done.

Thanks for all your hard work on this tool, it is very helpful..
                if (value != null && value != DBNull.Value && !string.IsNullOrEmpty(value.ToString()))
                {
                           if (value.ToString().StartsWith("="))
                    {
                        Set_Formula(value, row, col++);
                    }
                    else
                    {
                        _worksheet._values.SetValue(row, col++, value);
                    }
                }
                else
                {
                    col++;
                }