May 24th, 2024
PerfectXL Risk Finder – Version 1.2.2
- New inspection: External References Updated Without Warning
- New inspection: External References Never Updated
- New inspection: Multiple Sheet References
- (Temporarily) disable trimming to fix automatic license activation
- Textual updates
PerfectXL Compare – Version 1.7.2
- (Temporarily) disable trimming to fix automatic license activation
PerfectXL Explore – Version 1.5.2
- Fix centering of visualization
- (Temporarily) disable trimming to fix automatic license activation
May 10th, 2024
PerfectXL Risk Finder – Version 1.2.1
- Improved support for OneDrive files via protocol links
PerfectXL Compare – Version 1.7.1
- Improved support for OneDrive files via protocol links
PerfectXL Explore – Version 1.5.1
- Improved support for OneDrive files via protocol links
April 22nd, 2024
PerfectXL Risk Finder – Version 1.2.0
- VBA analysis: added 5 VBA inspections
- Updates in protocol to launch tool via protocol links
- Updated principles in library (also links to ICAEW principles)
- Minor changes to PDF report and front-end
- Small bugfixes and improvements
- Upgraded back-end
PerfectXL Compare – Version 1.7.0
- Small improvements in VBA analysis
- Updates in protocol to launch tool via protocol links
- Small bugfixes and improvements
- Upgraded back-end
PerfectXL Explore – Version 1.5.0
- New visualization mode: tab colors
- Small improvements in VBA analysis
- Updates in protocol to launch tool via protocol links
- Small bugfixes and improvements
- Upgraded back-end
December 21st, 2023
PerfectXL Risk Finder – Version 1.1.5
- Ability to create PDF reports with all issues, notes and assigned statuses
November 21th, 2023
PerfectXL Highlighter – Version 1.0.3
- Fixes a graphical glitch when resizing the panel
- Fixes typo
November 16th, 2023
PerfectXL Risk Finder – Version 1.1.4
- Ability to import notes and statuses from Risk Finder exports
- Fix links to Excel files on OneDrive
- Wait longer before concluding that the ‘Analysis engine is not available’
PerfectXL Compare – Version 1.6.3
- Fix links to Excel files on OneDrive
- Wait longer before concluding that the ‘Analysis engine is not available’
PerfectXL Explore – Version 1.4.4
- Fix links to Excel files on OneDrive
- Wait longer before concluding that the ‘Analysis engine is not available’
October 5th, 2023
PerfectXL Highlighter – Version 1.0.3
- Fixes a graphical glitch when resizing the panel
- Fixes typo
PerfectXL Risk Finder – Version 1.1.3
- Back button introduced (Navigation)
- Update Excel export
- Minor improvements in inspections and library
- Several general bug fixes
- Front-end improvements & update
- Ability to execute tool via protocol
- Refactorings related to new frontend infrastructure
- Fixes in handler to open links to Excel
- Code signing with extended validation (EV)
- Update back-end dependencies
- Various improvements for a narrow window
PerfectXL Compare – Version 1.6.2
- Complete new frontend (look and feel)
- Update Excel export
- Several bugfixes
- Various improvements for a narrow window
- Fixes in handler to open links to Excel
- Fix: incorrect links for cell changes due to structure changes
- Ability to execute tool via protocol and application arguments
PerfectXL Explore – Version 1.4.3
- Complete new frontend (look and feel)
- New Back button (Navigation)
- Improve performance of VBA analysis
- VBA analysis: detect references to worksheets and defined names
- Update Excel export
- Several bugfixes
- Various improvements for a narrow window
- Fixes in handler to open links to Excel
- Ability to execute tool via protocol and application arguments
- Code signing with extended validation (EV)
July 3, 2023
PerfectXL Risk Finder – Version 1.0.1
- Library now includes references to spreadsheet quality standards (FAST, ICAEW, …) and related principles
- Now supports multiple cell ranges for conditional format rules and data validation rules
- Improved support for LAMBDA-functions
- Updated underlying library for interpreting Excel files
- Link added to “Help” in menu to access release notes
PerfectXL Compare – Version 1.5.0
- Added new functionality: Excel integration
- Updated underlying library for interpreting Excel files
- Improved support for LAMBDA-functions
- Link added to “Help” in menu to access release notes
PerfectXL Explore – Version 1.3.1
- Now supports multiple cell ranges for conditional format rules and data validation rules
- Improved support for LAMBDA-functions
- Updated underlying library for interpreting Excel files
- Link added to “Help” in menu to access release notes
June 6, 2023
PerfectXL Explore – Version 1.3.0
- Export analysis result to Excel
- Export visualization to PDF, PNG and SVG
April 28th, 2023
PerfectXL Risk Finder – Version 1.0.0
This is the first public release of the PerfectXL Risk Finder!
April 25th, 2023
PerfectXL Risk Finder – Version 0.9.1
This is the pre-release version of the Risk Finder. Compared to the previous version, the following has been changed:
- Performance improvement of formula analysis
- Performance improvement of analyzing Unused Defined Names
- Performance improvement of Longer Cell Reference Expected
- Ability to create Microsoft Store package (for official release)
- Back-end fixes
- Front-end fixes
April 14th, 2023
PerfectXL Risk Finder – Version 0.9.0
This is the test version of the Risk Finder, intended for a rigorous testing period. Compared to the previous version, the following has been changed:
- Major rewrite of the front-end code
- New design (major changes to look and feel of the tool)
- Upgrade of the underlying functionality for front-end elements
- Added the ability to save results in the tool and continue in another session
- New inspection: Invisible Cell Value
- New inspection: Unnecessary Space
- New inspection: Hidden Defined Names
- New inspection: Unused Defined Names
- Other small fixes and improvements
April 3rd, 2023
PerfectXL Risk Finder – Version 0.8.4
This version contains the following:
- Changed the way the tool detects headers and footers in Excel
- More accurate clustering (grouping) of formulas
- Fixed certain incorrect file paths for external links.
- Small bugfixes
Improved the logic of 7 inspections:
- Double Count Inspection
- Excel Error Inspection
- Hardcoded Number in Formula Inspection
- Numeric Text Calculation Inspection
- Double Operator Inpspection
- Longer Cell Reference Expected Inspection
- Many Nested Functions Inspection
PerfectXL Compare – Version 1.4.5
Fixed certain incorrect file paths for external links.
PerfectXL Explore – Version 1.2.5
Fixed certain incorrect file paths for external links.
March 6th, 2023
PerfectXL Risk Finder – Version 0.8.3
- New inspection: Unprotected Formula
- Improved logic of 3 inspections: Excel Error, Deprecated Function, and Reference to Empty Cell
- The tool can now read Excel files even when in use by OneDrive
- Much more detailed error logging to improve the ability to provide support
- Small bugfixes
PerfectXL Compare – Version 1.4.4
- The tool can now read Excel files even when in use by OneDrive
- Much more detailed error logging to improve the ability to provide support
- Fixed a bug where certain insertions were read as deletions.
- Small bugfixes
PerfectXL Explore – Version 1.2.4
- The tool can now read Excel files even when in use by OneDrive
- Much more detailed error logging to improve the ability to provide support
- Small bugfixes
February 6th, 2023
PerfectXL Risk Finder – Version 0.8.2
- The tool is now able to analyze .xltx files (Excel Templates)
- Refactored the reference model, formula parts, and formula highlights
- Code formatting for both back-end and front-end code
PerfectXL Compare – Version 1.4.3
The tool is now able to analyze .xltx files (Excel Templates)
PerfectXL Explore – Version 1.2.3
The tool is now able to analyze .xltx files (Excel Templates)
December 19th, 2022
PerfectXL Risk Finder – Version 0.8.1
- Exclude false positives in Numeric Text Calculation
- Small text improvements
- Small bugfixes
December 18th, 2022
PerfectXL Compare – Version 1.4.2
- Preload analysis engine for faster initial analysis
- Update of underlying technology for evaluating cells
PerfectXL Explore – Version 1.2.2
- Small bugfixes
- Preload analysis engine for faster initial analysis
- Links to Excel now work when Excel window is snapped to half the screen
- Update of underlying technology for parsing formulas and evaluating cells
December 14th, 2022
PerfectXL Risk Finder – Version 0.8.0
This release is the the first public beta version of the Risk Finder.
May 24th, 2022
PerfectXL Compare – Version 1.4.1
- Update of underlying technology for evaluating cells
- Increased timeout to 30 minutes.
PerfectXL Explore – Version 1.2.1
- Excel integration. Open Excel from the visualization/tables/popups. Go directly to: charts, conditional formats, data validations, defined names, external links, formulas, pictures, pivot tables, VBA modules and worksheets.
- Update of underlying technology for parsing formulas and evaluating cells
- Increased timeout to 30 minutes
March 4th, 2022
PerfectXL Compare – Version 1.4.0
Big functionality implemented, the tool can now also analyze and display VBA code changes.
January 24th, 2022
PerfectXL Compare – Version 1.3.1
Upgraded underlying Excel libraries and fixed a bug in which an error report stated that the analysis engine was not available.
PerfectXL Explore – Version 1.1.0
- Fixed the incorrect classification of certain simple defined names
- Upgrade of underlying Excel libraries
- Fixed an issue related to a warning about engine not available
- Added the ability to detect external links in pivot tables
October 26th, 2021
PerfectXL Highlighter – Version 1.0.2
- Full support for Internet Explorer 11
- Added correct icons to the package
- Implemented a welcome screen (first run experience)
October 15th, 2021
PerfectXL Highlighter – Version 1.0.0
First public release of the Highlighter 🎉