Episode 3 is here, and this one's all about making your report output look polished without any manual cleanup.

RW.Tools.Suppress controls what shows up. RW.Tools.PageBreak controls where it lands. RW.Tools.Resize makes sure it all fits.


        

            
        
    

RW.Tools.Resize auto-fits row height or column width at report generation time, based on where you place the formula in your template. It handles the scenarios standard Excel auto-fit misses - narrative cells that vary in length by recipient, wrapped text that expands at runtime, and merged cell layouts that don't size cleanly on their own.

Quick heads up on naming
RWResize changes to RW.Tools.Resize in the next official release (v5.0.0.91), but RWResize will still function as expected. No need to convert your existing templates to the new name. 
We've attached two Excel files for a more detailed walkthrough of the formula in action.

Two files attached:

RW.Tools.Resize_Examples — for v5.0.0.91 or later
RWResize_Examples — for current versions

You can create a simple job in Reportworq and use the file as your report source to see the formula work in a real job run. Just select Excel in the distribution screen and run the test — no other modification to the job is needed.
Let us know what you think and if you have any questions!

• You need to login to have access to uploads.