Excel add-in
✨ Improved
-
When using Slice with the Do not remove formulas option enabled, formulas that reference sheets not included in the new workbook are now automatically replaced with their last calculated values to avoid
#REF!errors. (RD-8196) -
The Formulas to review section in the Status panel is now automatically updated when formulas are edited or cleared, or when rows, columns, or sheets are inserted, deleted, or renamed, preventing resolved errors from lingering until a manual Clear or refresh. (RD-7202)
-
The new
legacysetting in theAPIargument of the SI.WRITEBACK function lets you write back to objects that use the legacy Sage Intacct API. (RD-8704) -
Account range filters (for example,
12701-300:12701-400) now only return accounts whose codes fully match the range. Shorter codes, such as12701, are no longer incorrectly included and no longer require wildcard workarounds. (RD-7854) -
You can now combine the filtering expressions
*?andnullwith other range filters in balance functions (for example, filtering using*?;-40600will retrieve data for all values (including empty), with the exception of the value40600). (RD-2597)
🔨 Fixed
-
You can now write back GL journal transactions to open financial periods even when the transaction date falls in a locked period. (RD-7285)
-
Fixed a bug where slicing a worksheet without removing formulas could still result in formulas being removed, especially when the copied workbook recalculated on open. (RD-8528)
-
Auto-hide zero rows now works reliably even on very large ranges or entire worksheets, instead of failing with a “Maximum call stack size exceeded” error. (RD-8518)