v2.5.1
Latest Release
Added & Enhanced
✨
Workflow Pipeline: Accounting & Number Cleaning Controls
Integrated high-precision financial number cleaning directly into the Regional Format step editor inside the Workflow & Pipeline tool.
- Clean Invisible Characters & Spaces: Strips non-breaking whitespace (CHAR 160), hidden tab stops, carriage returns, and invisible formula artifacts.
- Normalize Accounting Negatives: Automatically converts SAP/ERP trailing minus signs (e.g., 54000- ➔ -54000) and ledger parenthesized negatives ((1,250.00) ➔ -1250.00).
- Strip Currency Symbols: Reliably scrubs currency strings (Rp, IDR, $, USD, EUR, €) while maintaining raw decimal values.
- Force Text-to-Number Conversion: Instantly clears green triangle "Number Stored as Text" warning flags across entire columns.
📑
Smart Single-Sheet Merge & Dynamic Worksheet Naming
Upgraded the master merge engine with intelligent schema heuristics:
- Smart Layout Auto-Detection: Worksheets with matching table headers stack sequentially without duplicating column titles (ideal for pivot tables). Heterogeneous sheets automatically receive clean, bold section headers to prevent field misalignment.
- Dynamic Worksheet Naming: Output tabs no longer use the static Merged_Data title; they dynamically adopt the name of the primary source sheet (e.g., Sales or Financial_Ledger).
- Cover Page Guard: Automatically detects and skips non-data title and cover sheets (1 column or ≤3 rows), ensuring headers are captured from true data tables.
🗂️
Consolidate by Sheet Name Merge Mode (by_sheet)
Added a dedicated consolidation mode across both Merge Workbooks and Workflow Pipeline. Consolidates multiple branch or regional workbooks by tab identity—merging all Sales tabs into a unified Sales tab, all Expenses into an Expenses tab, preserving independent column definitions per sheet.
Fixes & Performance
🔬
Scientific Exponential Notation Normalization
Resolved an issue where scientific exponential strings (such as 1.25E+06 or 3.5E-02) remained unformatted text. A dedicated regex normalizer now safely restores exponential strings to numeric values while preserving leading-zero identifiers (e.g., product code 00510).
Changed
⚡
Safe Mode Priority & UI Reordering
Reordered Processing Engine selection in the Workflow Pipeline so that Safe Mode (MS Excel COM — 100% Visual Styling Preserved) is presented first and selected by default, followed by Fast Mode (Pandas).