| Version | Date | Remark |
| 1.0.1 | Apr 5 2009 | Initial Release |
| 1.0.2 |
Apr 7 2009 |
Added Workbook Import & Export to XML Added substitution variable support in downloaded filename |
| 1.0.3 | Apr 7 2009 | Bug fix: Downloads from Module not working when using SEF. (router.php) Security fix in download code. category access not checked properly |
| 1.0.4 | Apr 7 2009 | Bug fix: "Error: unterminated string literal" error when previewing some reports (depends on raw data ) Ref: http://support.joomla-r-us.com/forum?func=view&catid=5&id=3 |
| 1.0.5 | Apr 8 2009 | Bug fix : "Operation aborted" error when Previewing (with Template) using IE7 Ref: http://support.joomla-r-us.com/forum?func=view&catid=5&id=21#42 |
| 1.0.6 | Apr 8 2009 | Bug fix : "Operation aborted" error when Previewing (with Template) using IE7 still showing up on some servers. |
| 1.0.7 | Apr 10 2009 | Added new parameter, "Live Syntax Check". Bug fix: Syntax check not working on some servers Bug fix: Characterset problem when previewing with no template Improved stylesheet when previewing without template |
| 1.1.0 | Apr 14 2009 | Section / Category View added for the frontend Bug fix: Preview with template - incorrect HTML |
| 1.1.1 | Apr 14 2009 | Bug fix: "Show number of reports / categories" component parameter listed twice |
| 1.1.2 | Apr 15 2009 | Added filter parameters to the Section List View. Added several new styles and buttons for the Section List Added support for the cPanel module |
| 1.1.3 | Apr 17 2009 | Added support for adding arbitrary cells with text and formulas in Worksheets Added support for many more colors Bug fix in upgrade code |
| 1.1.4 | Apr 21 2009 | Bug fix: Saving Worksheets didn't work on all servers Bug fix: "Live Syntax Check" parameter added back |
| 1.1.5 | Apr 22 2009 | Bug fix: Export / Import not preserving new lines when moving between DOS / Linux Bug fix: Extra Cells broken in 1.1.4 Limiting Sheetname to 30 characters |
| 1.1.6 | Apr 22 2009 | Bug fix: Commas and Quotes in extra cells did not work Bug fix: #VALUE error in some formulas. MS Excel only - worked in OpenOffice Calc. Ref: http://support.joomla-r-us.com/forum?func=view&catid=5&id=85 |
| 1.1.7 | Apr 23 2009 | Bug fix: Formulas in extra cells caused preview problems |
| 1.1.8 | Apr 23 2009 | Bug fix: Import / Export - handling of empty cells |
| 1.1.9 | Apr 26 2009 | Added limited support for substitution variables in Syntax Checker Added List of Values for Workbook Parameters Ref: http://joomla-r-us.com/faq/31-general/76-sql-2-excel-pro-workbook-parameters |
| 1.2.0 | Apr 28 2009 | Added Description and Keywords for Workbooks. Description can be shown in the Section/List view. keywords included in the page Meta parameters for search engines. Workbook Parameter bug fix |
| 1.2.1 | Apr 30 2009 | Bug fix for Internet Explorer - Database Form |
| 1.2.2 | May 8 2008 | Added Workbook Caching Finer control of Preview added. Each Workbook can now control Preview settings Preview bug fixes |
| 1.2.3 | May 9 2009 | Added MAXROWID and MINROWID substitution variables for Formulas |
| 1.2.4 | May 11 2009 | Added support for Joom!Fish. Download Joom!Fish Content Element for SQL 2 Excel Pro here. |
| 1.2.5 | May 12 2009 | Bug fix: Cannot access empty property error message when Download or Preview |
| 1.2.6 | May 12 2009 | Bug fix: Wildcard field selection did not work after Joom!Fish support was added |
| 1.2.7 | May 16 2009 | Bug fix: Worksheet form did not work well with Internet Explorer |
| 1.2.8 | May 19 2009 | Bug fix: Extra new line added to SQL queries in Internet Explorer |
| 1.3.0 | May 23 2009 | Upgraded Excel Writer class. Now with full UTF-8 support! |
| 1.3.1 | May 26 2009 | Added System Information on the SQl 2 Excel > About page to help debugging |
| 1.3.2 | May 27 2009 | Added fallback methods when iconv and mbstring are not installed. More graceful degradation of functionality when not all functions exist on the server. |
| 1.3.3 | May 29 2009 | Bug fix: Excel Writer failed when running PHP Safe mode on some servers |
| 1.4.0 | Jun 7 2009 | Scheduler added. You can now define schedules to automatically send emails, updating your cache, run SQL queries etc. |
| 1.5.0 | Jun 13 2009 | All configurations, previously under "Parameters", moved to Settings. Stored in a database table for convenience. Future upgrades will be much easier since there is no need to redo your configurations. Added Export/Import of Settings. Allows you to move configurations from one server to another easily. A few minor bug fixes |
| 1.5.1 | Jun 16 2009 | Bug fix to avoid conflict with existing PEAR library/classes that are installed on some servers. Eliminates blank Worksheets and errors when downloading spreadsheets. Bug fix: Excel Writer version Setting not used when downloading in backend. Bug fix: Freeze Panes not working when using "Excel 2000 / Limited Characterset Support" Excel Writer |
| 1.5.2 | Jun 17 2009 | Added support for postgreSQL databases |
| 1.5.3 | Jun 18 2009 | Bug fix: SQL based Workbook parameters not working |
| 1.5.4 | Jun 19 2009 | Bug fix: #Value problem for some formulas |
| 1.5.5 | Jun 20 2009 | Bug fix: SQL based Workbook parameters and List of Values Bug fix: External MySQL database connection problem |
| 1.5.6 | Jun 22 2009 | Bug fix: Preview with SQL based Workbook Parameters Bug fix: Long formulas in Extra Cells Bug fix: leading zeros trimmed off in zip code strings |
| 1.6.0 | Jul 2 2009 | Added font formatting for Header & Footer Added font formatting for data rows Added background color settings for datarows Added support for bitmap images Added support for Compression of Downloaded Workbooks Added support for Compression of Workbooks attached to scheduled emails Added required field indicators for most input forms |
| 1.6.1 | Jul 8 2009 | Added 6 more fonts for Worksheets Code cleanup Minor bug fixes |
| 1.6.2 | Jul 14 2009 | Bug fix: Scheduled email with attachments did not work when using Cache Bug fix: Minor installation bug fixed Improved Schedule Tester |
| 1.7.0 | Jul 26 2009 | Improved user interface interface (tabs) Added Print Settings Added Grid Line on/off setting Added setting for default SQL Query Help tab Bug fix: Excel Writer with limited UTF-8 support - bug fixes |
| 1.7.1 | Jul 30 2009 | Added setting for Date/Time mode setting. You can now choose to use the Joomla time (inclsive timezone) or to use the Server's time/date for date/time substitution variables. More info |
| 1.7.2 | Jul 31 2009 | Bug fix: Preview and Workbook parameters didn't work after Date Mode was added |
| 1.7.3 | Aug 2 2009 | Bug fix: {H} and {h} not substituted. Fatal crash on some servers |
| 1.8.0 |
Aug 10 2009 | Added Rule Based Schedule execution (Run-If) Added On Success/Failure handlers for Schedules Improved Schedule test Added support for different databases on Workbook Parameters Workbook Parameters cleaned up and support for sequential substitution added Bug fix: WB parameter popup in backend not working Bug fix: Internet Explorer layout issue with tabs Bug fix: $_['SERVER ADDR'] not set on all servers causing corrupt Excel files |
| 1.8.1 | Aug 12 2009 | Added setting for Title/Link in Section List Bug fix: Sort order for Workbooks not working Bug fix: router.php error when id not set Bug fix: Workbook parameter error messages |
| 1.8.2 |
Aug 15 2009 | Added Visibility flag for each Workbook parameter. Allows you to hide some of your parameters and show others Added Twitter Feed to the control panel Bug fix: Minor workbook parameter issue |
| 1.8.3 | Aug 18 2009 | Bug fix: Internal Server Error when downloading on some servers |
| 1.9.0 |
Aug 24 2009 | Added CSV and HTML download formats Added: Support for overriding download format in URL Added: Custom Database Driver support Added: Workbook column in the Worksheets list Added: Worksheet- and Workbook title to the edit screens Added: Setting for Marging scaling Added: Sort capability on ID's on admin screens Added: Check for duplicate Sheet Names in Workbook - Worksshets screen and in Excel Writer Bug fix: Removed 255 char limit for Email To/CC/BSS fields in Schedule |
| 1.9.1 | Aug 25 2009 | Bug fix: mysql_num_rows(): supplied argument is not a valid MySQL result on Worksheets page Bug fix: Preview not worsking ( Undefined index: REQUEST_URI) Bug fix: {SQL2EXCEL_WS_ROWS} returned one row too much |
| 1.9.2 | Aug 28 2009 | Added: Settings for how to handle CRLF ( required for CSV, but also useful for other formats. More info ) Improved look for Database Test Page Bug fix: Custom database driver issue Bug fix: Scheduler - Email with Attachment was sent even though attachment failed (caused by non-existing cache directory) Ref Bug fix: Scheduler - Failure email to Admin now sent even if onFailure email not specified Bug fix: Minor layout issue on Worksheets page |
| 1.9.3 | Sep 1 2009 | Bug fix: Preview problem when using custom database driver |
| 1.9.4 | Sep 2 2009 | Bug fix: Hide/Show Sections and categories did not work in frontend |
| 2.0.0 |
Sep 7 2009 | Added: Ability to build your worksheets from any number of SQL queries - from different databases ( More Info ) Added: More formatting possibilites for extra cells Changed: If no header is specified then the column headings starts at row 1 Bug fix: Database test page when not using custom driver |
| 2.0.1 | Sep 9 2009 | Bug fix: Constant PEAR_ERROR_RETURN already defined error on some servers |
| 2.0.2 | Sep 10 2009 |
Added support for substitution variables in Extra Cells |
| 2.1.0 |
Sep 18 2009 | Added new Formatting Feature for Worksheets Removed requirement to have a main SQL query defined on a sheet |
| 2.1.1 | Sep 25 2009 | Added conditional formatting |
| 2.2.0 | Oct 24 2009 | Added Worksheet Zoom Level setting Added Vertical Alignment Formatting Added Word Wrap Setting Added Total Number of Records note on Preview |
| 2.2.1 | Nov 3 2009 | Added support for SQL 2 Excel Pro Data Grid Plugin |
| 2.2.2 |
Nov 8 2009 | Bug fix: Substitution variables in Worksheet Names Bug fix : MSSQL database connection fix. More info |
| 2.2.3 | Nov 9 2009 | Bug fix: Data Grid Plugin not working with SQL based WB parameters |
| 2.3.0 | Nov 27 2009 | Added Multi-Select List of Values Workbook Parameters Bug fix: Trigger schedule handler from template not working well. |
| 2.3.1. | Nov 28 2009 | Bug fix: Preview with Multi-Select Workbook Parameters not working correctly |
| 2.3.2 | Dec 3 2009 | Bug fix: Copy Workbooks with Multi-Select Workbook Parameters |
| 2.4.0 | Jan 9 2010 | Added setting for Show/Hide column headers Added setting for size of parameter pop-up dialog (lightbox) Added setting for escaping special HTML characters in HTML mode Added support for formulas in column headers Added more font size choices Bug fix: _pear_call_destructors() crash on some systems. More info Bug fix: Extra line breaks added in Multi Select Workbook Parameters when using Interner Explorer. More info |
| 2.4.1 | Jan 12 2010 | Bug fix: Problem adding multiple Workbooks to a Schedule More info |
| 2.5.0 | Feb 2 2010 | Added Section and Category views for menu assigment Added setting for Download Button (Show/Hide) in Preview in each Workbook Bug fix: SMTP email not working with Scheduler on some servers Bug fix: HTML problem in Preview Bug fix: Download Message for Preview
Bug fix: CSS issues fixed |
| 2.5.1 | Feb 15 2010 | Bug fix: Refresh button not visible when using Preview / No Template Bug fix: Data Grid plugin not working when using Multi-Select Workbook Parameters |
| 2.5.2 |
Mar 5 2010 |
Improved: Workbook parameter handling rewritten in order to handle unlimited number of parameters and selections Added support for SET statements before the main SQL query |
| 2.5.3 |
Mar 8 2010 | Improved formatting code to reduce file- and memory requirement when using lots of formats. This change also helps avoiding the 4000 formats limit per spreadsheet in Excel. |
| 2.5.4 | Mar 9 2010 | Bug fix: Javascript error on (Admin) Worksheet page affecting some servers |
| 2.5.5 | Mar 10 2010 | Bug fix: Warning messages when no records returned by the query on some servers |
| 2.6.0 |
Mar 30 2010 | Added support for dynamic (SQL) email addresses in the Schedules. More info Added color settings for Workbook Parameter popup dialog (Lightbox) ( SQL 2 Excel Pro > Settings > Workbook ) Bug fix: Email body not saved/updated properly when selecting "Send Email" action in schedules Bug fix: Character-set not set for Workbook Parameter popup |
| 2.7.0 |
Apr 17 2010 | Added repeatable Print Headers and Footers to Worksheets |
| 2.7.1 | Apr 25 2010 | Added test for Published Workbook in Schedule Test Added support passing default values through URL for Workbook Parameters in Preview Mode More info |
| 2.7.2 |
Jun 8 2010 | Added support for substitution variables in Schedule email address SQL queries Added setting for sending Schedule emails to multiple recipients as separate emails Bug fix: Setting default value for Workbook parameters through URL did not work for list parameters in Preview. Bug fix: Triggering schedule_cron.php on a Windows based webserver Bug fix: Invisible Workbook parameters added empty table row in Preview Bug fix: Using SQL based Workbook parameters from remote databases caused problems in Preview |
| 2.7.3 | Jun 9 2010 | Bug fix: Setting default value for Workbook parameters through URL did not work for Single Select List in Preview |
