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 |