https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image1_icon300.png

Spill Manager For Excel

par JKP Application Development Services

Spill Manager ensures formatting of Dynamic array formulas also spill and resize

Spill Manager is an Excel add-in that lets you watch a dynamic array spill range and automatically replicate formatting whenever the spill expands. Optionally, it can also clean up formatting when the spill shrinks.

Key features

Watch any dynamic array spill (select any cell inside the spill)

Copy formatting Across columns, Down rows, or Both

Optional Header and Totals row/column support (for Across columns / Down rows)

Optional cleanup when a spill shrinks

Optional live updates while you edit the workbook

All state stored within workbook defined names, so watches travel with the file (no hidden sheets, no custom XML)

Explicit Add mode and Edit mode behavior for predictable watch updates

Manage list self-heals broken watch references that contain #REF!

Fonctionnalités de l’application

Lorsque cette application est utilisée, elle
  • Peut lire votre document et y apporter des modifications
  • Peut envoyer des données via Internet

Vue d’ensemble

https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image3_spillmgrtryit.png
https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image2_spillmgreditwatch.png
https://catalogartifact.azureedge.net/publicartifacts/80931690.71d8f277-6cbf-4ef6-91ea-b6ea467bf367-1f816a5c-41f7-4e53-a423-bb53f1f3c666/image0_spillmgrmanage.png