Spreadsheet Wrangler 1.9.0
New Features
Handbuilt Folder Support
- Added special handling for folders named "handbuilt" (case-insensitive)
- When a handbuilt folder contains exactly one spreadsheet, that spreadsheet is automatically combined with all other spreadsheet groups
- The handbuilt spreadsheet is always placed first in combinations to ensure its headers are used consistently
- This feature simplifies workflows where a master template needs to be combined with multiple spreadsheet groups
UI Improvements
- Added horizontal scrolling to both Backup Locations and Spreadsheet Folder Locations list views for better visibility of long paths
- Adjusted vertical sizing of list views:
- Backup Locations list view shows 1-2 rows minimum before scrolling
- Spreadsheet Folder Locations list view shows 3-4 rows minimum before scrolling
- Added tooltips to section headers ("Backup Locations" and "Spreadsheet Folder Locations") for improved usability
- Fixed tooltip behavior to consistently display instructions when hovering over list views
How It Works
- The application detects if any selected folder is named "handbuilt" (case-insensitive)
- If found, it checks if the handbuilt folder contains exactly one spreadsheet
- If exactly one spreadsheet is found, it's combined with all other spreadsheet groups
- The handbuilt spreadsheet's headers are used for all combinations
- If the handbuilt folder contains multiple spreadsheets or doesn't exist, the standard grouping logic is used
Bug Fixes
- Fixed lint warnings related to PowerShell automatic variables
- Fixed visibility issues with the Backup Locations list view
- Improved tooltip behavior throughout the application
Installation
Download the latest release and run the PowerShell script. Requires PowerShell 5.1 or higher and the ImportExcel module (will be automatically installed if missing).
Requirements
- Windows with PowerShell 5.1+
- ImportExcel module (auto-installed if missing)