Implement TRIMRANGE function

[Jython1415]

Overview

Implement the TRIMRANGE function for the named-functions library.

Description

Returns the array after excluding all empty rows and/or columns from the outer edges of a range.

Value Proposition

• Similar to existing DENSIFY but focuses on edges only (not interior empty rows/columns)
• Common data cleaning pattern: remove surrounding whitespace/empty cells
• Useful for cleaning imported data that has padding
• More targeted than DENSIFY for edge-trimming use cases

Priority

HIGH

Category

Array Manipulation

Implementation Notes

• Should remove empty rows from top and bottom
• Should remove empty columns from left and right
• Consider parameter to control which edges to trim (all, rows-only, columns-only)
• Define "empty": truly empty vs. whitespace vs. zero-length strings
• Different behavior than DENSIFY which removes all empty rows/columns

Related

Part of Excel function implementation initiative (#51)

[Jython1415]

Implemented in #124