SSGear v3.87 Versions History

The  New indicator shows all properties, methods and events which are new since the previous release!

05jun20

v3.87
Added a ShowChartExplorer method to programmatically display the SpreadsheetGear Chart Explorer New

03jun20

v3.86
Fixed a rounding problem sometimes occurring in the SetRowHeights method when setting the row height for all rows in a worksheet or workbook New

27may20

v3.85
Added a GetShapeNames method to return all shape names in the worksheet New

08jan20

v3.84
Adapted the product to now use the latest version of the SpreadsheetGear DLLs (i.e. v8.3.25.102)

17dec19

v3.83
Added a call to RebuildMaxRowCol in GetTrimmedUsedRange, GetUsedRange, GetUsedRangeCols and GetUsedRangeRows

06dec19

v3.82
Added a SetComboBoxValue method allowing to programmatically set combo box values

v3.81
Added a GetComboBoxValue method allowing to programmatically retrieve the currently selected combo box value

05dec19

v3.80
Added a GetCheck method allowing to programmatically see if CheckBoxes are checked

v3.79
Added a SetCheck method allowing to programmatically check CheckBoxes

15nov19

v3.78
Rewrote the Close> method to now close all opened workbooks

v3.77
Added a CloseWorkbook method

v3.76
Changed the LoadFilePartial method to now open a new workbook in the Workbooks collection instead of replacing all existing workbooks

v3.75
Changed the LoadFile method to now open a new workbook in the Workbooks collection instead of replacing all existing workbooks

v3.74
Made the BookName property basically read-only; just left an empty set to avoid compatibility problems with earlier versions

v3.73
Added a BookFullName property

v3.72
Added a Book property

v3.71
Added an AddBook method

14nov19

v3.70
Added a BookNames property

10jun19

v3.69
Adapted the product to now use the latest version of the SpreadsheetGear DLLs (v8.3.3.102)

15nov18

v3.68
Release where just the version number has changed for test purposes.

02sep18

v3.67
Added a TestEditMode APL function in the SSGear.W3 workspace to demonstrate how to use the EditMode property. Also added an EnumChildWindows and an EnumChildWindows_Hook APL utility.

v3.66
Added an EditMode property allowing to define the behavior of the cursor keys while editing data

27jul18

v3.65
Improved the ShowExplorer method to prevent the APL keyboard from being sometimes locked after the SpreadsheetGear Explorer dialog is closed

v3.64
Improved the ShowDesigner method to prevent the APL keyboard from being sometimes locked after the SpreadsheetGear Designer dialog is closed

03feb18

v3.62
Fixed a problem where the SSGear grid would not enter Edit Mode when pressing F2 or typing in a cell, after the DoubleClickEntersEditMode property was set to 0.

18jan18

v3.61
Added a RemoveControls method to allow removing multiple controls (like CheckBox, Button, etc.) at once from a given WorkSheet

v3.60
Added a RemoveControl method to allow removing one control (like a CheckBox, Button, etc.) from a given WorkSheet

06jan18

v3.59
Added an AddEx method similar to Add but interpreting \n as the \ and n characters rather than as a new line

04jan18

v3.58
Added a Replace method allowing to replace text in all cells of the specified range

25nov17

v3.57
Removed MessageBox.Show and replaced it by throw new Exception in GetSheet

16nov17

v3.56
Added a MergeCells read-only property

v3.55
Added a GetAlignments method

13nov17

v3.54
Fixed a problem in the LoadFilePartial method

v3.53
Fixed the Culture property to now accept either a string or a string[]

v3.52
Updated to now use SpreadsheetGear 2017 v8.0.64.102

26sep17

v3.51
Fixed a little bug in the CopySheet method when the destination worksheet does not exist

v3.50
Improved the DisplayTopRight APL function to support various DPIs

v3.49
Added a demo24_copysheets APL function to the SSGear.w3 workspace

v3.48
Added a CopySheets method

12sep17

v3.47
Added a GetTrimmedUsedRange method

27aug17

v3.46
Added a Hwnd property

v3.45
Added a zHandle property

v3.44
Added a Handle property

17aug17

v3.43
Upgraded the Get method to auto-convert dates when reading cells from a workbook in Date1904 mode

v3.42
Added a GetDateCells method returning a boolean array showing where date cells are located in the workbook

v3.41
Added a Date1904> read-only property telling if dates are represented as number of days since 1/1/1904 instead of 12/31/1899

30may17

v3.40
Added a new RemoveAllCharts method

20feb17

v3.39
Added a Culture property allowing to change the current culture used by the SSGear object

19feb17

v3.38
Changed the Version property to return a version in the X.XX format

18feb17

v3.37
Added a MouseClick event (with more detailed information about the click) and its documentation

v3.36
Hooked up again several events (Click, DoubleClick, ...) that had been lost and were no longer firing

14feb17

v3.35
Integrated the latest version of SpreadsheetGear (v7.4.27.102) published 8feb17

04feb17

v3.34
Fixed a bug in the CopyRange method sometimes happening when the destination range overlapped the source range

02feb17

v3.33
Added an UnMerge method and its documentation

30jan17

v3.32
Extended the ShowSheets method to now also accept a sheet name(s) argument

v3.31
Extended the HideSheets method to now also accept a sheet name(s) argument

v3.30
Added a RebuildMaxRowCol method

v3.29
Added a MaxRows property returning the MaxRow property for all worksheets

v3.28
Added a MaxCols property returning the MaxCol property for all worksheets

v3.27
Improved the GetUsedRange method and the UsedRange property

v3.26
Added a ProtectedBackColor property

v3.25
Rewrote the MaxRow property

v3.24
Rewrote the MaxCol property

29jan17

v3.23
Fixed a problem related to AddSheet and starting typing in the new sheet

28jan17

v3.22
Updated the ShowSheets method to avoid problems when used after setting MaxCol or MaxRow

v3.21
Updated the HideSheets method to avoid problems when used after setting MaxCol or MaxRow

v3.20
Updated the RCtoA1 documentation

v3.19
Updated the RCtoA1 method to accept either 4 arguments (integers) or a 4-element vector single argument

v3.18
Updated the RemoveSheet method to avoid problems when used after setting MaxCol or MaxRow

v3.17
Added a RemoveDisplayReference private method

v3.16
Updated the AddSheet method to avoid problems when used after setting MaxCol or MaxRow

v3.15
Added an InsertDisplayReferenceAfter private method

v3.14
Added an InsertDisplayReferenceBefore private method

v3.13
Updated the SheetName set property to avoid problems when used after setting MaxCol or MaxRow

v3.12
Added an UpdateDisplayReference private method

22jan17

v3.11
Improved the MaxRow property

v3.10
Improved the DisplayReference property to avoid bug using MaxCol when the workbookView DisplayReference property does not include quotes around sheet names

v3.09
Improved the SheetNames property to avoid bug setting SheetNames after setting MaxCol

18jan17

v3.08
Improved the MaxCol property

v3.07
Added an AddTrendLine method

05dec16

v3.06
Removing ALL ssGear1 initialization instructions from Form1.Designer.cs

v3.05
Adding a DisplayDotNetError property

v3.04
Improved the GetSheet method to display an error if the sheet can't be found

v3.03
Improved the GetRangeHelper method to display an error if the range can't be found

20nov16

v3.02
Simplified the SetNumberFormats method

18nov16

v3.01
Upgraded SSGear to now use the latest SpreadsheetGear object (v7.4.16.102)

24jun16

v2.99
Added a ChartSize property

v2.98
Added a ResizeChart method

24jul15

v2.97
Added a SheetChanged event

07apr15

v2.96
Added support for CSV files in SaveAs method

22nov14

v2.95
Added a PasteSpecial method to allow pasting with various options

v2.94
Added a PasteSpecialDialog method which displays the Paste Special dialog to allow pasting with various options

29oct14

v2.93
Added tests for all custom events to check that they are not null

15aug14

v2.92
Added a ShowTooltips method to allow showing tooltips for one or more cells

v2.91
Added a HideTooltips method to allow hiding all cell tooltips

v2.90
Added a GetCellWidths method returning the content width of each cell

v2.89
Added an GetOptimizedColumnWidths method to set tooltips and optimize column widths as well

v2.88
Added an AddNA method similar to the Add method but allowing to specify a text value that should always be right aligned

v2.87
Added an GetColWidthsDouble method similar to the GetColWidths, but returning doubles instead of integers

v2.86
Added a RightJustify method allowing to automatically right justify cells which content contains only a given set of characters

v2.85
Added an AddChartY2 allowing to draw chart having 2 Y-axis

v2.84
Fixed a problem with the GridLines property

v2.83
Added a GridLineColor property

v2.82
Added an ShowBorders property

27jun14

v2.81
Added a test in the PrintFileName property that cannot be set to null

v2.80
Commented the Print(false); instruction in PrintDuplex property

19may14

v2.79
Added a PrintToPdf method allowing to directly print a workbook or part of it to a .PDF file

29apr14

v2.78
Added a SetDevModeEx method allowing to pass the parent window handle as an additional argument

23feb14

v2.77
Added a GetDevMode method to return the printer DEVMODE structure (converted to APL)

v2.76
Added a SetDevMode method to set the printer DEVMODE structure

v2.75
Added a PrintDuplex property to get/set the Printer Duplex setting

v2.74
Added a PrintCanDuplex property to know if the Printer supports Duplex printing

22jan14

v2.73
Added an AddComments method to allow adding comments to cells

v2.72
Added an RemoveComments method to allow removing comments from all cells in a range

v2.71
Added an AddFilter method to allow using AutoFilter

v2.70
Added an RemoveFilters method to remove all existing filters

v2.69
Added an HideFilterButtons method to hide all filter buttons

v2.68
Added an ShowFilterButtons method to show all filter buttons

10jan14

v2.67
Fixed a problem with ChartTypeMarker property

27dec13

v2.66
Fixed a problem with the Enter/Tab key moves when more than one cell is selected

29nov13

v2.65
A MessageBox message was inadvertendly left in the workbookView1_CellBeginEdit event handler

21nov13

v2.64
The Tab[or Enter] key may move beyond the last row or column if the last row or column is hidden

v2.63
The Tab key stops on hidden columns problems in SSGear!

20nov13

v2.62
Pressing Enter when reaching the MaxRow row moves the active cell below the MaxRow row!

02nov13

v2.61
Added a new ReverSeriesOrder property

30oct13

v2.60
Added a TabMovesDown boolean property allowing to tell how the Tab key should move

v2.59
Added a EnterMovesDown boolean property allowing to tell how the Enter key should move

05aug13

v2.58
Added a ChartDataYScale property

v2.57
Removed chart markers if the chart type name contains "NoMarker"

v2.56
Added a PrintFileName property

v2.55
Added a PrintToFile property

v2.54
Added a PrintWithCharts method

12jul13

v2.53
Added a ChartSeriesEx property

28may13

v2.52
DisplayReference changed to return an object[]

v2.51
Added a SpreadsheetGearVersion property to let now which version of SpreadsheetGear is used in the background

20nov12

v2.50
Added a FreezePanes property

v2.49
Added an PaneScrollRow property allowing to get/set the topmost visible row number in each pane

v2.48
Added an PaneScrollCol property allowing to get/set the leftmost visible column number in each pane

v2.47
Added a SendKeys method allow to programmatically send keys to the SSGear active worksheet

v2.46
Added an Indent method allowing to indent the content of a given range

19nov12

v2.45
Added a PreviewKeyDown handler to display MessageBox "Locked cells cannot be modified." when user tried entering data in a locked cell

v2.44
Added a MessageBoxCaption property to allow customizing all the MessageBox captions

18oct12

v2.43
Added a HideFocusRectangle method allowing to hide the focus rectangle around the selected cell

v2.42
Created a ReleaseLock method to release the lock on the WorkbookView object

v2.41
Fixed a bug in SetPrintFitToPages to make the scale and the fittopage specs mutually exclusive

v2.40
Improved documentation for method SetPrintFitToPages

v2.39
Added a ScrollTo method which allows to scroll to a given cell without changing the active cell

v2.38
Added a SetHyperlinks method allowing to add hyperlinks to SSGear sheets

v2.37
Added a CopySheet method allowing to copy a worksheet with all its data, formatting, formulas, charts, .. to another existing workbook

v2.36
Added a ReorderSheets method allowing you to reorder the sheets in a workbook to any order you specify

v2.35
Added a try { } catch { } in method ReleaseLock to prevent error if a matching GetLock has not been issued before

19aug12

v2.34
Made the Get method (and all other methods accepting an address argument) more permissive to accept floats for the address field

v2.33
The XAutoFill method documentation has been extended with more details and more examples

v2.32
Change SSGear so that SSGear enters Edit mode as soon as the user types the first character in a cell

v2.31
Added a SendEscape method

12jul12

v2.30
Added a backend field to ChartGridLinesColor property to retain grid lines color even when no grid lines visible

v2.29
Added a ChartStyleProperties property returning all the chart properties used in Chart Styles

v2.28
Changed Chart Series related properties (ChartLegends, ChartMarkerTypes, etc.) so that one can supply a number of values different than the number of series

v2.27
Removed the error message "Cannot set the Sheet property to a string when DisplayReference has been set!"

v2.26
Added a DoNotDisplayError property preventing SSGear from displaying error MessageBoxes

11jul12

v2.25
Added a ChartPointLabelsVisible property allowing to show or hide all point labels

v2.24
Added a ChartPointLabelsBorderColor property allowing to get/set the point labels border colors

v2.23
Added a ChartPointLabelsFillColor property allowing to get/set the point labels background colors

v2.22
Added a ChartPointLabelsFontSize property allowing to get/set the point labels font sizes

v2.21
Added a ChartPointLabelsPosition property allowing to get/set the point labels position

v2.20
Added support for the ChartPointLabelsVisible, ChartPointLabelsBorderColor, ChartPointLabelsFillColor, ChartPointLabelsFontSize & ChartPointLabelsPosition properties to GetChartStyle

v2.19
Added support for the ChartPointLabelsVisible, ChartPointLabelsBorderColor, ChartPointLabelsFillColor, ChartPointLabelsFontSize & ChartPointLabelsPosition properties to SetChartStyle

v2.18
The ChartMarkerType property now does not longer return a single value if all chart series have the same marker type

v2.17
The ChartMarkerSize property now does not longer return a single value if all chart series have the same marker size

v2.16
Added test for null in ChartGridLinesColor, ChartXAxisRange, ChartYAxisRange, ChartXTitle, ChartYTitle, ... properties

v2.15
Added test for ChartType in SetChartSeriesLabels to avoid warning MessageBox when ChartType incompatible with Labels positioning

v2.14
ChartGridLines now returns true if either ChartHorizontalGridLines or ChartVerticalGridLines is true

27jun12

v2.13
Added an SSGChart APL function showing how to create a form with a chart using the whole form client area

v2.12
Added an AllowSelection property to allow or prevent selecting cells or moving the active cell

v2.11
Fixed a "Object reference not set to an instance of an object" warning happening when defining charts that do not have grid lines

v2.10
Fixed some examples in the properties/methods documentation that were using 'ff'[]wi ... instead of 'ff.ss'[]wi ...

v2.09
Added a SelectChart method to allow working with other charts than the last created one in the worksheet

v2.08
Added a ChartTitleFont property

v2.07
Added a ChartSeriesNames property (same as the ChartLegends property)

v2.06
Added a ChartXAxisLabels property

v2.05
Added a CreateContextMenu method

v2.04
Added a ContexMenuItemClick event

v2.03
Added a GetChartStyle method returning a 2-column nested array of chart property value pairs

v2.02
Added a SetChartStyle method allowing to apply a chart style matrix to an existing chart

v2.01
Added a test in properties ChartXAxisTitleFont and ChartYAxisTitleFont

v2.00
Added a TestChartStyles APL function showing how to retrieve styles from a chart and how to apply them to another chart

v1.99
Added a Zoom property

22may12

v1.98
Using SetColWidths no longer makes hidden columns visible

v1.97
Added a try... catch... to the workbookView1_CellCancelEdit event handler

v1.96
Added a try... catch... to the workbookView1_CellEndEdit event handler

v1.95
Added a call to AV2ANSI in demo20_charts[229] in SSGEAR.W3 workspace to avoid problem when € is sent from APL to C#

v1.94
[DispId(i)] commented in Properties Interface

v1.93
Added a DoubleClickEntersEditMode boolean property (set by default to 1 [or true])

v1.92
Setting DoubleClickEntersEditMode to 0 [or false] now allows the DoubleClick event to fire when double clicking a cell

v1.91
The Click and RightClick events now fire ok in APL when clicking a cell that has already just been clicked

v1.90
The Click event was reporting the previous clicked cell row and column numbers instead of the currently clicked cell row and column number

04apr12

v1.89
Added a ColToPix method converting a fractional column position into pixels

v1.88
Added a RowToPix method converting a fractional row position into pixels

v1.87
Added a RowColToPix method converting both a fractional row and fractional column position into pixels

v1.86
Added a Close method to close the workbook and any associated resources

v1.85
Added support for Int16 integers in the whole DLL so that the DLL fully works with Dyalog APL

v1.84
Removed all new line characters (ŒTCLFs) from properties and methods documentation

v1.83
Added a GetUsedRangeRows method returning list of used range row numbers in the specified sheets

v1.82
Added a GetUsedRangeCols method returning list of used range column numbers in the specified sheets

v1.81
The GetRowHeights method now accept a second argument of -1 to return all used range row heights

v1.80
The GetColWidths method now returns column widths for used range columns instead of for all columns when second argument is -1

v1.79
The selected range was not always correct after the AddAcross method was called

v1.78
Rewrote the CellEndEdit event for better handling of Œwres returned by APL

v1.77
Fixed a bug in method SetAlignments (called by HAlign and/or VAlign)

v1.76
Added a Find method

v1.75
Added a FindOptions property

v1.74
Added a FindNext method

v1.73
Extended property RowCol to accept a cell address argument

v1.72
Added a FindAll method

v1.71
Added a try ... catch ... in internal method ColumnsAutoFit to avoid warnings when column size is larger than 255 pixels

12mar12

v1.70
Fixed a bug in a private method (GetIRangeRows)

v1.69
Improved private method GetIRangeCols

v1.68
Added an IncreaseColWidths method allowing to increase column widths in specified sheets by a given percentage

v1.67
Extended the SetColWidths method documentation

v1.66
Extended the SetRowHeights method documentation

v1.65
Changed AutoFit and SetColWidths to apply a percentage factor on column widths so that they display ok when workbook is opened in Excel

v1.64
Added a ColWidthsFactor property

v1.63
Extended the SetColWidths method so that it accepts a scalar column number for its 2nd argument (in that case it returns a scalar integer column width)

v1.62
Extended the SetRowHeights method so that it accepts a scalar row number for its 2nd argument (in that case it returns a scalar integer row height)

10mar12

v1.61
Added an AddComboBox method allowing to add ComboBox objects to a worksheet

v1.60
Added an AddCheckBox method allowing to add CheckBox objects to a worksheet

v1.59
Aadded an AddSpinner method allowing to add Spinner objects to a worksheet

v1.58
Added an AddListBox method allowing to add ListBox objects to a worksheet

v1.57
Added an argument to the ShapeAction event to allow returning the selected item in a Combo Box

v1.56
Added ShapeAction event for ComboBox item selection

v1.55
Added ShapeAction event for ListBox item selection

v1.54
Added ShapeAction event for Spinner item selection

v1.53
Added ShapeAction event for CheckBox checked event

v1.52
Added documentation for the ShapeAction event

07mar12

v1.51
Added error trapping to the GetNames and A1toRC method so that SSGear sliently accepts named ranges with invalid addresses

v1.50
Added a HideSheets method allowing to hide one or more sheets from the workbook

v1.49
Added a ShowSheets method allowing to show one or more sheets which were previously hidden

v1.48
Added a GetHiddenSheets method which returns the hidden sheet numbers (in origin 1)

v1.47
Added an AddButton method allowing to add buttons to a worksheet

v1.46
Added a ShapeAction event allowing to react to button clicks in a worksheet

05mar12

v1.45
Fixed the LoadFilePartial method which was missing the password argument

v1.44
Added an AddPicture method allowing to add a picture in a range of cells

v1.43
Extended the SortRows method so that you do no longer have to enclose the last argument when there is only one sort key

v1.42
Extended the SortCols method so that you do no longer have to enclose the last argument when there is only one sort key

v1.41
Added a GetHiddenRows method returning the hidden rows numbers

v1.40
Added a GetHiddenCols method returning the hidden columns numbers

29feb12

v1.39
Improved the error message delivered when the .license file is not found

v1.38
Improved the About method by now displaying the folder of the registered SSGear DLL

21feb12

v1.37
The AutoFit method does no longer show rows and/or columns that were hidden

v1.36
The CellEndEdit event now supports you setting Œwres in APL to change the entered value and/or refuse ending Edit mode

v1.35
Added a SortRows method to allow sorting cells in a range according to sort keys

v1.34
Added a SortCols method to allow sorting cells in a range according to sort keys

v1.33
Fixed a problem in the MaxRox, MaxCol and DisplayReference properties that would sometimes change the active sheet why they should not

v1.32
Fixed a bug where the Insert method would change the active range in the active sheet even if applied on another sheet

v1.31
Fixed the SetPrintHeadersFont and SetPrintFootersFont methods which were not always working

v1.30
Fixed the RemoveColPageBreaks, RemovePageBreaks and RemoveRowPageBreaks documentation that was missing an argument

v1.29
Added a MoveChart method to allow moving and resizing the active chart in a worksheet

v1.28
Added a RemoveCharts method to all removeing all charts from a given worksheet

v1.27
Added a ChartLineWeights property

v1.26
Fixed a bug in SaveAs method where saving the workbook with an empty string password would not reset the password to an empty string

v1.25
Fixed a bug in ProtectFormulae method that would protect all cells not just the ones containing formulae

v1.24
Fixed a bug in ProtectFormulae method that would protect charts when it should not

v1.23
Fixed a bug in Protect method which would protect all cells in the sheet instead of just the specified range

v1.22
Renamed the ProtectedCells method to ShowProtectedCells

v1.21
Added a GetProtectedCells method

10feb12

v1.20
Extended the ChartSeries property to allow superposing series having different X values on the same chart

v1.19
Added a ChartLegends property allowing to change the text in the series legends

07feb12

v1.18
Made the Esc key exit Edit mode and restore cell content as it was before entering Edit mode

v1.17
Added a CopyPaste method allowing to copy the current range to any destination range copying forumlae, number formats, ...

v1.16
Added a SetTextOrientation method to allow set the text orientation (between -90 and 90) for all cells in a range

v1.15
Added an UnProtectAll method which unprotects all cells in the specified sheet

v1.14
Added a ProtectAll method which protects all cells in the specified sheet

v1.13
Changed the Protect method so that it no longer removes previous cells protection whne protecting a new range

v1.12
Added an argument to the UnProtect method to allow unprotecting a range in the specified sheet

v1.11
Added a ProtectedCells method which allows to toggle highlighting all the protected cells in a given sheet

v1.10
Added a SetValidation method wlloing to specify validation rules for all cells in a specified sheet/range

26jan12

v1.09
Added a GetRowHeights method

v1.08
Added a ProtectFormulae method allowing to protect formulae in a worksheet/range or in whole workbook

v1.07
Added an EnableProtection property allowing to disable/reenable all cell protections in a workbook

v1.06
Added a ShowExplorer method allowing to display the SpreadsheetGear Workbook Explorer

v1.05
Added a ShowDesigner method allowing to display the SpreadsheetGear Workbook Designer

25jan12

v1.063
Added a Merge method allowing to merge cells

v1.062
Added an password argument to the LoadFile method (pass an empty string if the workbook has no password)

v1.061
Added an password argument to the SaveAs method (passing a non empty string sets a password on the workbook))

v1.060
Added an password argument to the Import method (pass an empty string if the workbook has no password)

v1.059
Added an password argument to the ImportPartial method (pass an empty string if the workbook has no password)

v1.058
Added an password argument to the Export method (passing a non empty string sets a password on the exported workbook))

v1.057
Added a SuppressEvents property allowing to prevent events from being signaled to APL

v1.04
Added a PrintLeftToRight property allowing to print pages from left to right first then top to bottom

v1.03
Enhanced the NumberFormat property so that it be "matrix aware" (i.e. setting a different format for each cell of a range)

v1.02
Enhanced the SetNumberFormats method so that it be "matrix aware" (i.e. setting a different format for each cell of a range)

v1.01
Added a SkipAutoFit property to disable doing an automatic AutoFit when setting some properties (NumberFormat, FontSize, ...) or calling some methods (Add, ...)

20jan12

v1.056
Added a SetPassword method allowing to protect a workbook or worksheet by a password

v1.055
Added an UnsetPassword method allowing to unprotect a workbook or worksheet

v1.054
Added a ScrollRow property to programmatically set the top visible row

v1.053
Added a ScrollCol property to programmatically set the left visible column

v1.052
Added a PrintNoColor property to allow printing in balck and white

v1.051
Added a PrintPaperSize property to allow selecting the paper size for printing

v1.050
Added a PrinterName property allowing to get or set the default Printer

v1.049
Added a PrinterNames property allowing to get the list of all printers installed on your computer

v1.048
Added a StrikeOut property allowing to get/set the active range StrikeOut state

v1.047
Added a RightClick event

v1.046
Added an AutoFill method

v1.045
Added a SetPattern method allowing to use a pattern style for the specified range

v1.044
Added a BeginUpdate method to stop painting changes to the workbook until EndUpdate is called

v1.043
Added a EndUpdate method to restore painting changes to the workbook after BeginUpdate has suspended them

19jan12

v1.042
Added a SetNameValue method allowing to create names associated with a value (not a range)

v1.041
Fixed a typo in AddSheet documentation

v1.040
Added an Evaluate method allowing to evaluate names

17jan12

v1.039
Added an argument to method BlankZeros to let "unblank" zeros

v1.038
Added a MaxCol property to restrict the viewable range to not exceed a given column

v1.037
Added a MaxRow property to restrict the viewable range to not exceed a given row

v1.036
Added a DisplayReference property to restrict the viewable range per worksheet to given ranges

v1.035
Added a SheetNo read-only property returning the active sheet number (in origin 1)

v1.034
Added a BeginEdit method to force active cell to enter Edit mode

v1.033
Added a CancelEdit method to cancel the current cell Edit session

v1.032
Added an EndEdit method to force active cell to end Edit mode

v1.031
Added a CellBeginEdit event

v1.030
Added a CellCancelEdit event

v1.029
Added a CellEndEdit event

v1.028
Added an Insert method to allow inserting rows, columns or ranges

v1.027
Added a Delete method to allow deleting rows, columns or ranges

v1.026
Added a DoubleClick event

v1.025
Rewrote the Click event

v1.024
Added a Palette property allowing to change any or all of the 56 palette colors

v1.023
Added a FontColorIndex property

v1.022
Added a BackColorIndex property

v1.021
Changed the SetBorders method so that a color specified as a scalar is considered a color index in the Palette

v1.020
Changed the SetBottomBorders method so that a color specified as a scalar is considered a color index in the Palette

v1.019
Changed the SetLeftBorders method so that a color specified as a scalar is considered a color index in the Palette

v1.018
Changed the SetRightBorders method so that a color specified as a scalar is considered a color index in the Palette

v1.017
Changed the SetTopBorders method so that a color specified as a scalar is considered a color index in the Palette

14jan12

v1.016
Enhanced the GetNames method so that it could return both named ranges and Excel names

13jan12

v1.015
Added an ImportPartial method allowing to import only part of an Excel workbook

v1.014
Added a LoadFilePartial method allowing to load only part of an Excel workbook

12jan12

v1.013
Added a Col property allowing to get/set the active cell column

v1.012
Added a Row property allowing to get/set the active cell row

v1.011
Added a RowCol property allowing to get/set the active cell row and column

v1.010
Added more arguments to the SetChartSeriesLabels method and documented it

v1.009
Added a GetColWidths method

v1.008
Added a DefaultContextMenu property to allow enabling/disabling the default context menu

v1.007
Added a MouseClick event

11jan12

v1.006
Added a SetName method allowing to create named ranges

v1.005
Added a GetNames method allowing to return named ranges from one sheet or all sheets

v1.004
Added a Names property allowing to retrieve all named ranges from all worksheets

v1.003
Added a SetChartSeriesLabels method to add labels to a chart series

03jan12

v1.002
Added the WrapText property

v1.001
Added the SetWrapText method