Excel add-in
🚀 New
-
With the new BC.WRITEBACK function, you can update lines for any modifiable object exposed via Common API v2 or web services in Business Central. We extended the functionality of BC.EXPANDOBJECTRANGE to provide information on object modifiability. (RD-6935)
-
Balance functions now support dimensions with Dimension Value Types
TotalandEnd-Total. When you use these codes in your filters, Velixo automatically expands them to the underlying dimension values. (RD-5540)
✨ 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)
-
BC.WRITEBACKBUDGET and BC.WRITEBACKJOURNAL functions now support dynamic (spill) ranges in supported arguments, so your templates can resize automatically when you add, remove, or change values. (RD-5807)
🔨 Fixed
-
Fixed an issue where BC.WRITEBACKBUDGET could not clear budget dimension values when updating existing lines by entry number. (RD-8410)
-
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)