Excel GBS Version History
|
Date
|
Version
|
Change Details
|
15-Jun-08
|
5.3.1
|
Major Update: This release contains a number of new functions as well as some bug fixes;
1) NEW FEATURE - Added menu routines to show/hide completed tasks. Also, added configuration item to automatically hide completed tasks when printing.
2) NEW FEATURE - Added another daily date band that is 12 hourly with 2 bands per 12 hour block.
3) NEW FEATURE - Added a weekly date band that shows the actual day number instead of the day of the week. That is shows 5, 6, 7 etc instead of M, T, W etc.
6) NEW FEATURE - Added hot keys to the Insert/Delete Gantt Tasks and also the Gantt Task Wizard menu items.
5) BUG FIX - Fixed a bug with Auto Build Gantt bars running when the chart was built with Absolute headers such as M1, M2, etc. This is now not permitted.
6) BUG FIX - Improved, slightly the performance of the help function. Also, the system will only search once per Gantt file now instead of once per excel session.
|
31-May-08
|
5.2.2
|
Minor Update: This release contains a fixed to an issue with the "Outlook task export" function when the Gantt column headings contained non-printable characters, this would cause the export to fail.
|
26-Apr-08
|
5.2.1
|
Major Update: This release contains a number of new functions as well as some bug fixes;
1) BUG FIX - Performance improvement on some workbooks with very large column counts. Improved how hidden rows are processed so we now only process the actual hidden rows instead of all of them.
2) BUG FIX - Fixed an issue with building Gantt charts not working correctly, if the user has turned off automatic calculations.
3) NEW FEATURE - During the build process, sometimes a date band will not be available because the date range is too large. This enhancement adds a button on these messages to show how many columns are required to assist in modifying your date ranges.
|
14-Apr-08
|
5.1.2
|
Minor Update: This release contains a fixed to an issue with the main Gantt worksheet being locked for editing when the resource costings was used.
|
08-Mar-08
|
5.1.1
|
Minor Update: This release contains a fixed to an issue with the default settings for page sizes on Letter and Legal paper sizes. Also, added the function 'Save Gantt Sheet to a new workbook". This will allow the user to save the current selected Gantt sheet into a new workbook that is fully functional Gantt builder file.
|
29-Feb-08
|
5.0.5
|
Minor Update: This release contains a number of bug fixes; namely fixed an issue with the right-mouse click routines in non-english versions of the Gantt program. Improved error reporting on workbooks that have been damaged by the user, such as removing the inbuilt code routines etc.
|
10-Feb-08
|
5.0.4
|
Major Release: This release contains a number of new functions as well as some bug fixes.
1) NEW FEATURE - Added resource costs and project cost profiling.
2) NEW FEATURE - Added feature of a new task wizard that steps through the process of creating a task. This interactive step-by-step planning aid will help you quickly master the project management process and terminology used.
3) NEW FEATURE - Added the ability, via the configuration dialog on the Task Labels Tab, to define task labels without the need to place text in the righthand most column. The configuration dialog allows you to override this and force labels to be placed based on a specific columns values. Note, if this forced option is selected, then it will override the text in the righthand most column.
4) Improved error handling for the outline function.
5) Fixed an display issue with calendar control within the Configure dialog.
6) Fixed an issue with "GBS Insert Row" and "GBS Delete Row" when the auto build feature was turned on.
7) Improved resource profiles to take into account recurring task information.
8) Fixed an issue with the Gantt right-mouse-click menu still appearing in other workbooks.
9) Fixed an issue with milestones on Mondays being removed if hide weekends was enabled.
10) Fixed an issue with 'auto-build' enabled, tasks with labels would leave the old label behind until a full rebuild of the chart is performed.
|
1-Jun-07
|
4.2.0
|
Minor Update: This release contains a number of new functions as well as some bug fixes, specifically for Excel 2007.
1) Fixed an issue with Excel 2007 not being able to print Gantt charts.
2) Improved error handling on Print and Print Preview functions
3) Fixed an issue with the Roll-up auto population Toolbox not working is 'S' tasks where present either just before or just after the 'R' marked task.
4) Added Excel 2007 Ribbon bar to Excel 2007 version (.xlsm) of Gantt file.
5) Fixed an issue where the gantt columns would not be the correct size if the user saved the gantt workbook in a .xlsm format.
6) Fixed an issue where dependencies would not build correctly under Excel 2007. The issue here was Microsoft had changed the implementation of some of the shape operators.
7) New feature - added 3D Gantt bars for Excel 2007 version.
|
18-Apr-07
|
4.1.3
|
Fixed an issue introduced in version 4.1.1 where an 'error 13' would be produced during the gantt build process for non-english versions of Excel.
|
13-Apr-07
|
4.1.2
|
Fixed an issue where gantt bars would fail to build if they were recurring tasks and the Auto-Build feature was enabled.
|
10-Feb-07
|
4.1.1
|
Fixed an issue (workaround for Microsoft Excel 2007 bug) where gantt bars would not align correctly the further down the chart you went.
|
03-Feb-07
|
4.1.0
|
Minor Update: Fixed a number of issues to make this version compatible with Excel 2007. Also, keeps backward compatibility with Excel 97, 2000, XP, and 2003.
|
01-Sep-06
|
4.0.1
|
Fixed an issue where the chart would error during build if AutoFilters were present with criteria. These are now saved and restored after the build is complete.
|
13-Jun-06
|
4.0.0
|
Major Release: This release contains a number of new functions as well as some bug fixes.
1) Added fiscal based chart types. This allow charts to be build based on fiscal years instead of the normal calendar years. These are setup via the 'Configuration' dialog, and go to the 'Date Settings' tab.
2) Enhanced the recurring tasks functions to allow users to specify either hourly, daily, weekly, monthly, or yearly intervals.
3) Added ability to export Gantt tasks to Outlook tasks (this is a Plus Pak function).
|
19-Feb-06
|
3.3.0
|
Minor Update: Added two new menu entries to allow users to create a new Gantt sheet within their workbook, or clone the currently active Gantt sheet.
|
28-Jan-06
|
3.2.3
|
Fixed an issue where by an error would be raised when running the Dependency toolbox if the sheet within the workbook had been renamed.
|
15-Dec-05
|
3.2.2
|
Fixed an issue where the Export function would generate an error.
|
20-Oct-05
|
3.2.1
|
Fixed an issue with digital signature damage with Excel 2002/XP SP3.
|
10-Sep-05
|
3.2.0
|
Minor Update: Fixed an issue with multiple sheets of Gantts within the one workbook. The builder would always build the first sheet not the current selected one. Added the ability to enable/disable the border around the Gantt chart and can also control it's colour.
|
31-Jul-05
|
3.1.4
|
Fixed a minor issue with the check for additional data not working under some cases. Also, fixed an issue with export failing due to code within the Gantt worksheet.
|
3-Jun-05
|
3.1.3
|
Fixed a build issue with status lines when the chart also had manually entered chart date ranges. This would cause the status line input dialog to keep reappearing until the system crashed Excel.
|
19-May-05
|
3.1.2
|
Fixed an issue introduced with 3.1.0 where recurring tasks would error during the build. Also, added the ability to remember manually set dates for chart building.
|
18-May-05
|
3.1.1
|
Fixed an issue introduced with version 3.1.0 where under certain cases a compile error would result.
|
13-May-05
|
3.1.0
|
Major Update: Added controls to display the PERT and Resource charts after building has completed. Added some performance improvements to PERT chart building. Added Auto-build feature to allow the Gantt tasks to automatically update the bar and dependencies when data is changed on a row-by-row basis.
|
9-Apr-05
|
3.0.3
|
This update contains a number of fixes and minor enhancements, namely:
 Fixed a minor problem with "Print Preview" where the header rows did not continue on the second and subsequent pages.Fixed an issue with PERT charts not building if absolute (M1, M2 ...) date type was specified.Fixed an issue with time phased pert chars without dependencies were not positioned correctly. Added the ability for the user to control the centering of dependencies in PERT charts this is a cosmetic issue to allow users the move lines incase of overlap for PERT clarify. |
30-Mar-05
|
3.0.1
|
Major Release: This release contains a number of new functions as well as the introduction of a 'Plus Pak' extension for users that require the additional functions. New in this release is:
the ability to build PERT charts (Plus Pak only),the ability use specify resources for each task and build resource profile graphs (Plus Pak only),added the ability to collapse/hide Gantt chart detail via Excels outline features.fixed a number of minor issues/bugs and enhancements. |
13-Feb-05
|
2.9.0
|
Major Update: Added additional 4 hourly date band to extend total duration of chart to approx 16 days. Added the ability to store the last used status line date for reuse when the chart is rebuilt. Added Print Preview menu that allows the user to select a specific printer. Added another dependency connection style that is user selectable. The style can be set via the configuration dialog.
|
30-Oct-04
|
2.8.3
|
Fixed an issue with the auto rollup function not working if blank/skip rows are present before the rollup row. Fixed an issue with the auto milestone function not working if blank/skip rows are present.
|
14-Oct-04
|
2.8.2
|
Fixed an issue where the calendar popup would produce an error when used to set the entire chart's date range during building.
|
8-Oct-04
|
2.8.1
|
Fixed a minor bug related to the positioning of the calendar popup. Sometimes it would not appear at all.
|
19-Sep-04
|
2.8.0
|
Major Update: Added more functions to the calendar popup and improved some position related issues. Fixed a minor bug when canceling a chart build for the very first time. Fixed an issue with licence scanner in Excel 97.
|
21-Jul-04
|
2.7.2
|
Added an OLE interface to the GBS program. This will allow building of Gantt charts from external programs such as VB. Also, fixed some chart building and export issues if the user has added one or more columns before the default "A" column.
|
16-Jun-04
|
2.7.1
|
Fixed a problem with 2.7.0 not working with non-english versions of Excel. Also, added the ability to scan for licence files if a licence error is detected.
|
5-Jun-04
|
2.7.0
|
Major Update: Added absolute labeling in the chart header (ie W1, W2, ... Wx), added the ability to allow >100% complete tasks, and added the filtering function to zoom in/out of the chart. Also, fixed an issue where conditional fill colour on Column A were not being applied for Milestone and Rollup tasks colour's. Changed Qtr based charts to be sub-divided into 3 (more intuitive) instead on 4 sub-divisions.
|
3-Apr-04
|
2.6.1
|
Corrected a problem with the 'Help' menu entry not working with 'File not found' error.
|
13-Mar-04
|
2.6.0
|
Major Update: Added new features to the Rollup Task utility toolbox, such as can an now rebuild existing rollup dates and autocalculate dates based on 'R' tasks.
|
29-Jan-04
|
2.5.2
|
Corrected an issue where GBS failed to correctly construct bars for rows that have been hidden by the application of a filter. Corrected an issue with the recurring tasks dialog not allowing values greater than 50.
|
21-Jan-04
|
2.5.1
|
Corrected an issue where GBS failed to correctly construct bars for rows that have been hidden by the application of a Filter or by using the Outline/Group feature.
|
7-Jan-04
|
2.5.0
|
Major Update: Added the capability to have recurring tasks defined and draw multiple Gantt bars on a single row. Also added a right-mouse-click popup for the Task Type column to make setting this field easier.
|
3-Dec-03
|
2.4.0
|
Major Update: Added the ability to re-calculate task dates based on their dependencies. This is used to automatically move tasks based on their dependencies. Added ability to control the calendar popup default date.
Also, fixed an issue with some non-english language versions of Excel.
|
21-Nov-03
|
2.3.3
|
Fixed an issue introduced into weekly charts with the last update.
|
20-Nov-03
|
2.3.2
|
Fixed issue with auto update failing on pre 2.x versions.
Fixed an issue with charts failing sometimes under some unusual date circumstances.
|
10-Nov-03
|
2.3.1
|
Fixed an issue with the separator line not displaying when both shade & hide weekends are turned on. Fixed an issue with print preview destroying some user set column settings. Fixed a problem with public holiday shading being incorrect sometimes.
|
17-Sep-03
|
2.3.0
|
Major Update: Added the ability to shade and alert on public holidays. Public holidays can now be entered by the 'Configure' option on the menu. Also, added a new demo data to illustrate the use of task durations.
|
11-Sep-03
|
2.2.1
|
Correct a problem introduced by the latest update to most antivirus scanners. No functional changes present.
|
5-Sep-03
|
2.2.0
|
Major Update: Fixed an issue with task bars being shadowed if the default setting was shadow on. Fixed an issue if trying to build a chart with 'object selector' enabled. Also, fixed the export function not working with dependencies.
Added new function where tasks can now have labels defined for them.
|
12-Aug-03
|
2.1.3
|
Fixed an issue with GBS not working correctly under Office . Also, fixed the set date format not working correctly when "Other" format selected.
|
22-Jul-03
|
2.1.2
|
Fixed an issue with the export function not correctly processing comments. Also, fixed an issue with comments being left behind after the build, if they are to the right of the chart.
|
14-Jul-03
|
2.1.1
|
Corrected an issue with the special row insert and delete function not recalculating the dependencies correctly.
|
3-Jul-03
|
2.1.0
|
Major Update: Added the new function to display a Status date line on the chart. Also added a warning message if the chart looks like it may have more data.
|
14-Jun-03
|
2.0.9
|
Added ability to determine, via web, if a newer version is available. Also, added option to submit enhancement requests via the program.
|
1-May-03
|
2.0.8
|
Fixed an issue with hourly date bands failing if the duration of the entire Gantt chart was only single day.
|
20-Apr-03
|
2.0.7
|
Corrects a problem with hourly date bands not constructing.
|
18-Apr-03
|
2.0.6
|
Added the capability to colour the Gantt bars based on Excel's Conditional Formatting properties. Also, added demonstration data that uses conditional formatting as an example of its use.
|
18-Mar-03
|
2.0.4
|
Corrected an issue introduced with 2.0.2 with the end of tasks not being calculated correctly. Corrected an issue with the date popup when the current value was blank or a non date value for start and finish dates.
|
07-Mar-03
|
2.0.2
|
Major Release: This release contains a fully reworked user interface to remove the toolbars and reduce clutter. Also, major functional changes include:
the introduction of task dependencies,greater control over task sizes and positions with each row including constant task heights,introduction of a chart update wizard to simplify future upgrades, andaccess to the user documentation from within the GBS application. |
15-Feb-03
|
1.9.2
|
Corrected an issue with Daily by 12 hours charts not calculating correctly. Plus added refinements to all Daily chart types.
|
30-Jan-03
|
1.9.0
|
Major Update: Added the capability to configure the way hours are rounded with Weekly based charts. Also, removed the ability for a user to explicitly release their licence before the 7 days auto expiry period due to abuse.
|
14-Jan-03
|
1.8.3
|
Added further enhancements of the accuracy of Gantt bars when ending very near the end of the date band. Also, added the ability for a user to explicitly release their licence before the 7 days auto expiry period.
|
08-Jan-03
|
1.8.2
|
Fixed and error when the task date ends exactly on the chart end date causes an error under some circumstances and the chart not to build correctly. Corrected an issue with folder names for MAC version. Also corrected an issue in the evaluation version only with the selection of the 5 year band.
|
23-Dec-02
|
1.8.0
|
Major Update: Added 5 year and 10 year date bands. Also improved the resolution and positioning of Gantt bars.
|
16-Dec-02
|
1.7.7
|
Corrected an issue with manual date range setting when the chart is weekly and the last date is exactly on the last day. Issue only present in manual date setting. Expanded the available date ranges for the evaluation version. Corrected an issue with weekly and bi-weekly charts when dates transition over a year boundary. Enhanced the debug analysis reporting wizard.
|
7-Dec-02
|
1.7.5
|
Added capability to allow users to define borders, background fill colours and text colours for the part of the Gantt to the left of the chart. Prior to this version, these properties were cleared. Now, via the configuration dialog, you can set to preserve these properties.
|
21-Nov-02
|
1.7.2
|
Fixed a minor issue with backward compatibility with earlier versions of the user's base builder file. Fixed a rounding issue with weekly based charts where the hours were being truncated from the date so 2-May-02 8:00am to 3-May-02 6:00pm would only show one day not two.
|
2-Nov-02
|
1.7.0
|
Major Update: Added capability to scale/zoom the Gantt chart during the build process. The zoom factor is controlled via the configuration dialog. Also, made significant refinements to the resolution of the Gantt bars, resulting in more accurate bars.
|
7-Oct-02
|
1.6.3
|
Added debug reporting wizard to facilitate our support staff's analysis of your problems - this update is a support feature only.
|
7-Sep-02
|
1.6.0
|
Major Update: Added the ability to use fill patterns for Gantt bars as well as colour. This feature is fully configurable via the configuration dialog.
|
6-Aug-02
|
1.5.1
|
Major Update: Added additional "Week By 2 Week" date band and toolbar to control date/time formatting. Added better error handling on non-upgraded versions of .xls file and fixed a modality error with manually setting date ranges. Also, updated the Converter.xls workbook to not be dependent on Microsoft's MDAC software.
|
18-Jul-02
|
1.4.2
|
Fixed compile issue with Office 97 and improved weekend shading. Performance improvements with some non-english language versions of Excel. Also corrected some right-click erroneous activations on the Gantt sheet.
|
29-Jun-02
|
1.4.0
|
Major Update: Added weekend shade/hide function. Also, added calendar popup on start and finish times.
|
23-Jun-02
|
1.3.6
|
Fixed problem with US date formats.
|
03-Apr-02
|
1.3.3
|
Major Update: Added hourly date bands. Also, fixed a bar layout issue with hourly bands in US date format.
|
28-Mar-02
|
1.2.2
|
Fixed a compatibility problem between Office 97 and XP.
|
05-Mar-02
|
1.2.0
|
Major Update: Corrected a issue with non-english versions of Excel and the use of particular add-ins. Add-ins removed.
|
01-Mar-01
|
1.1.5
|
Fixed a number of minor bugs.
|
17-Jan-01
|
1.0.0
|
Initial version.
|