docs/migrations/migrate-to-0.105.rst
############################# 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
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.
It worked same way as IXLHyperlinks.Delete.
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.