Released: Jun 11, 2025

V1.8 버젼 업데이트

기능

• Spilled Arrays
  • Formulas can now run arithmetic operations on whole ranges and return two-dimensional arrays as results. Elements from such arrays are assigned to adjacent cells to the one that calculates the formula. For example, you could show element-wise sum of ranges by setting a single formula in =A1:C3+E1:F3 format. If a cell from the spill range already contains a value, the formula returns a #SPILL error. Apart from arithmetic calculations, spilled arrays can also be returned by following new functions.
  • Spilled Array Functions
    • FILTER returns an array of filtered rows from specified source range.
    • SORT returns an array of sorted rows or columns from specified source range.
    • UNIQUE returns an array of unique values from the specified range.
    • XLOOKUP searches for a value in a range and returns the matching row or column from specified results range.
• Set the ShowLeadingApostrophes property to stop hiding escaping leading apostrophe (used to treat remaining cell content as text).
• Improved compatibility with Excel of VLOOKUP function in undefined cases (when lookup value is missing and source range is not sorted).
• YEARFRAC function calculates the ratio between days in specified interval to the number of days in a year.
• SUMIF/COUNTIF criteria are now case-insensitive for compatibility with Excel.
• [h], [m] and [s] format specifiers allow displaying time totals with more than 24 hours or 60 minutes / seconds respectively.

수정사항

• DATEDIF function fix for calculating month difference.
• Formula bar preserves original text when evaluation is disabled.