Migration from 0.104 to 0.105

IXLRangeBase.Hyperlinks

Property `IXLRangeBase.Hyperlinks` has been moved to `IXLWorksheet.Hyperlinks`. The original place could only list hyperlinks and didn’t provide correct functionality (e.g. removal of hyperlinks).

IXLHyperlinks

IXLHyperlinks.Add was removed

The method was removed, because there is no way to actually use it. It has a parameter `XLHyperlink`, but doesn’t have an range where should hyperlink be created. `XLHyperlink` can’t have a `XLHyperlink.Cell` property set to a valid value, because that would mean hyperlink is already attached to a worksheet.

IXLHyperlinks.TryDelete was removed

It worked same way as `IXLHyperlinks.Delete`.

IXLHyperlinks.Delete returns bool

Originally, it returned `void`. The `bool` value indicates if a hyperlink was present and thus removed.

Trim formula and remove equal sign

The setters `IXLCell.FormulaA1`, `IXLCell.FormulaR1C1` and `IXLRangeBase.FormulaArrayA1` now trim the formula and remove the starting `=` sign (i.e. ` = A1+B4 ` will turn into `A1+B4`). A formula starting with an equals sign is not a valid formula per formula grammar and causes problems with parsing.

Functions

CHAR now uses win1252 to interpret passed values (values were previously interpreted as unicode codepoints).

DOLLAR now uses culture of a workbook, not ambient culture from CultureInfo.CurrentCulture. Reminder: XLWorkbook.EvaluateExpr uses invariant culture, not ambient culture.

The formula setters (`IXLCell.FormulaA1`, `IXLCell.FormulaR1C1`, `IXLRangeBase.FormulaA1`, `IXLRangeBase.FormulaR1C1`, `IXLRangeBase.ArrayFormulaA1`) now automatically add prefix for future functions (e.g. `CONCAT` is turned to `_xlfn.CONCAT`). The Excel requires use of prefixed name in formulas, though they are hidden from users.