| Version |
Date |
Remark |
| 0.30 |
Feb 9 2009 |
Initial Beta Release |
| 0.31 |
Feb 12 2009 |
Bug fix, SQL queries not retrieved properly in all cases |
| 0.4 |
Feb 12 2009 |
Header & Footer Added
Added support for Date/Time codes |
| 0.41 |
Feb 20 2009 |
Bug fix, UTF8 character handling
|
| 0.5 |
Feb 22 2009 |
Added support for 5 reports in the same module
Sheet Name can be set
Minor bug fixes |
| 0.8.0 |
Mar 3 2009
|
New component based backend.
New features:
* All queries stored in database tables. You will not have to redo any queries
after future upgrades.
* Sections and Categories
* Worksheets and Workbooks. Multiple Worksheets can be assembled into
one workbook.
* Standard Joomla access control on Sections, Categories, Worksheets and
Workbooks
|
| 0.8.1 |
Mar 4 2009 |
Bug fix : Worksheet Header & Footer did not preserve new lines properly |
| 0.8.2 |
Mar 4 2009 |
Bug fix : Worksheet and Workbook download counter |
| 0.9.0 |
Mar 6 2009 |
Variable Substitution Added! Create dynamic reports depending on which user is downloading it, which day it is etc etc
Improved documentation
Language file added (english only)
Minor bug fixes and code cleanup |
| 0.9.1 |
Mar 8 2009 |
Bug Fix: Filename of workbook settable again
Changed default Published = Yes
Added Help Tabs for SQL Query in the Worksheet
|
| 0.9.2 |
Mar 9 2009 |
Formula support added. |
| 0.9.3 |
Mar 12 2009 |
Preview before download added |
| 0.9.4 |
Mar 19 2009 |
Security Enhancements. Bad Words list added.
Several bug fixes involving substitution variables |
| 0.9.5 |
Mar 24 2009 |
Bug fix: Unpublished Workbooks shown in Module.
Code cleanup |
| 0.9.6 |
Mar 30 2009 |
Added Workbook Download link in the backend. Added router for SEF. |
| 1.0.0 |
Apr 7 2009 |
Added Workbook Import & Export to XML
Added variable substitution in filename |
| 1.0.1 |
Apr 7 2009 |
Bug fix: "Error: unterminated string literal" error when previewing some reports (depending on raw data ) |
| 1.0.2 |
Apr 8 2009 |
Bug fix: "Operation aborted" error when previewing report with IE7
Bug fix: SEF problem |
| 1.0.3 |
Apr 8 2009 |
Bug fix: "Operation aborted" error when previewing report with IE7 still showed up on some servers.
|
| 1.0.4 |
Apr 10 2009 |
Improved styling when previewing with no template
Bug fix: Characterset problem in preview with no template |
| 1.1.0 |
Apr 14 2009 |
Added Section / Category list view in the frontend. Publish it to a menu and let users browse sections and categories to locate the reports that you publish. |
| 1.1.1 |
Apr 21 2009 |
Added filter for Sections and Categories in the Section List View
Bug fix: Saving Worksheets didn't work on some servers |
| 1.1.2 |
Apr 23 2009 |
Bug fix: Import / Export not preserving line breaks when moving reports between Windows and Linux
Bug fix: Some formulas not evaluating properly
Sheetname limited to 30 characters
Filname check for .xls extension |
| 1.1.3 |
Apr 23 2009 |
Bug fix: Import/Export handling of empty cells |
| 1.1.4 |
Apr 29 2009 |
Added Description and Keywords for Workbooks for improved navigation and SEO |
| 1.1.5 |
May 9 2009 |
Added Preview Settings to each individual Workbook.
Preview code enhancements and bugfixes
Added possibility to hide columns in Preview
Added {MAXROWID} and {MINROWID} substitution variables for Formulas |
| 1.1.6 |
May 9 2009 |
Preview bug fix |
| 1.1.7 |
May 11 2009 |
Added support for Joom!Fish. Download Joom!Fish Content Element for SQL 2 Excel here.
Fixed Download Button in Preview Hide/Show issue |
| 1.1.8 |
May 12 2009 |
Bug fix: Cannot access empty property error when Downloading or Preview |
| 1.1.9 |
May 12 2009 |
Bug fix: Wild card field selection broken after Joom!Fish support was added |
| 1.2.0 |
May 19 2009 |
Bug fix: Extra line break added to SQL query when using 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 character set support when not all required 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.3.4 |
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. |
| 1.3.5 |
Jun 19 2009 |
Bug fix: Value# problem for some formulas |
| 1.4.0 |
Jun 24 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 possibility to edit number of downloads/hits on Worksheets and Workbooks
Bug fix: Leading zeros in zip code strings was removed
Bug fix: Number of Workbooks in category always shown
|
| 1.5.0 |
Jul 8 2009 |
Added font formatting for Header / Footer and data rows
Added required field markers |
| 1.6.0 |
Jul 26 2009 |
Tabbed user interface introduced
Print settings added
Bug fix in Limited UTF8 Excel Writer |
| 1.6.1 |
Jul 30 2009 |
Added setting for Date Mode. You can now choose to use Server time or Joomla time for date/time substitution variables.
Bug fix: Excel Writer - Limited UTF8-support - fatal error when using formats |
| 1.6.2 |
Jul 31 2009 |
Bug fix: Preview not working |
| 1.6.3 |
Aug 2 2009 |
Bug fix: {H} and {h} codes not working plus fatal crash on some servers |
| 1.6.4 |
Aug 6 2009 |
Bug fix: Internet Explorer layout issue with tabs |
| 1.6.5 |
Aug 9 2009 |
Bug fix: $_['SERVER ADDR'] not set on all servers causing corrupt Excel file |
| 1.6.6 |
Aug 12 2009 |
Added setting for Link / Title in Section List
Bug fix: Workbook ordering not working
Bug fix: router.php error when id not set |
| 1.6.7 |
Aug 15 2009 |
Added Twitter feed to Control Panel
Bug fix: Minor installation problem fixed |
| 1.7.0 |
Aug 24 2009 |
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
|
| 1.7.1 |
Aug 25 2009 |
Bug fix: Worksheet page |
| 1.7.2 |
Aug 29 2009 |
Added: Setting for how to handle linebreaks
Bug fixes |
| 1.7.3 |
Sep 2 2009 |
Bug fixes |
| 1.7.4 |
Sep 7 2009 |
Bug fix: Worksheets not shown in backend on some servers
Changed: When no header specified the column headings starts at first row |
| 1.7.5 |
Sep 9 2009 |
Bug fix: Constant PEAR_ERROR_RETURN already defined error on some servers |
| 1.7.6 |
Sep 18 2009 |
Removed the requirement of a SQL query in a Worksheet |
| 1.8.0 |
Oct 24 2009 |
Added Zoom Level Setting
Added Total Number of Records note on Preview |
| 1.8.1 |
Nov 9 2009 |
Bug fix: Substitution variables not working in Worksheet Name |
| 1.9.0 |
Jan 20 2010 |
Added setting for showing/hiding column header
Added support for formulas in column header
Bug fix: _pear_call_destructors() crash on some systems. |
| 2.0.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: HTML problem in Preview
Bug fix: Download Message for Preview
Bug fix: CSS issues fixed
|
| 2.0.1 |
Mar 5 2010 |
Added support for SET statements before the main SQL query |
| 2.0.2 |
Mar 9 2010 |
Bug fix: Javascript error on (Admin) Worksheet page affecting some servers |
| 2.0.3 |
Mar 20 2010 |
Bug fix: Warning messages when no records returned from query on some servers
Improved: No records message written after header |
| 2.1.0 |
Apr 17 2010 |
Added repeatable print header and footers to teh Worksheets |
Subscribe to this comment's feed