Theme:
v
LC.Objects.SSGear DLL Update History

For APL+Win:

30-day Trial Version:

Download SSGear (v1.0.27.0) 30-Day Trial Version for APL+Win

Updates:

Download LC.Objects.SSGear.dll (v1.0.27.0)
Download SSGear.w3 (v1.27)
Download SSGear.zip (unzip it to SSGear.sf) (v1.27)
Download SSGear.chm (the SSGear Help File)

For Dyalog APL:

30-day Trial Version:

Download SSGear (v1.0.20.0) 30-Day Trial Version for Dyalog APL

Updates:

Download LC.Objects.SSGear.dll (v1.0.20.0)
Download SSGearDyalog.Zip (unzip it to SSGear.dws and SSGear.dcf) (v1.20)
Download SSGear.chm (the SSGear Help File)

Other pages of interest:

Version 1.37.0.0 (19dec13)

Version 1.37.0.0 includes the following enhancements:

  1. added a TabMovesDown boolean property allowing to tell how the Tab key should move the active cell
  2. added an a EnterMovesDown boolean property allowing to tell how the Enter key should move the active cell
  3. removed chart markers if the chart type name contains "NoMarker"
  4. added a PrintFileName property
  5. added a PrintToFile property
  6. added a PrintWithCharts method
  7. added a new ChartSeriesEx property
  8. DisplayReference changed to return an object[]
  9. added a SpreadsheetGearVersion property to let know which version of SpreadsheetGear is used in the background
  10. added a FreezePanes property
  11. added an PaneScrollRow property allowing to get/set the topmost visible row number in each pane
  12. added an PaneScrollCol property allowing to get/set the leftmost visible column number in each pane
  13. added a SendKeys method allow to programmatically send keys to the SSGear active worksheet
  14. added an Indent method allowing to indent the content of a given range

Version 1.27.0.0 (19nov12)

Version 1.27.0.0 includes the following enhancements:

  1. added a PreviewKeyDown event handler to display MessageBox Locked cells cannot be modified. when user tries entering data in a locked cell
  2. added a MessageBoxCaption property to allow customizing the MessageBox captions of all MessageBoxes dispayed by SSGear

Version 1.26.0.0 (25oct12)

Version 1.26.0.0 includes the following enhancements:

  1. added a HideFocusRectangle method allowing to hide the focus rectangle around the selected cell
  2. created a ReleaseLock method to release the lock on the WorkbookView object
  3. fixed a bug in SetPrintFitToPages to make the scale and the fittopage specs mutually exclusive
  4. improved documentation for method SetPrintFitToPages
  5. added a ScrollTo method which allows to scroll to a given cell without changing the active cell
  6. added a SetHyperlinks method allowing to add hyperlinks to SSGear sheets
  7. added a CopySheet method allowing to copy a worksheet with all its data, formatting, formulas, charts, .. to another existing workbook
  8. added a ReorderSheets method allowing you to reorder the sheets in a workbook to any order you specify
  9. added a try { } catch { } in method ReleaseLock to prevent error if a matching GetLock has not been issued before

Version 1.25.0.0 (25aug12)

Version 1.25.0.0 includes the following enhancements:

  1. make the Get method (and all other methods accepting a numerical address argument) more permissive to accept floats for the address field
  2. the XAutoFill method documentation has been extended with more details and more examples
  3. change SSGear so that SSGear enters Edit mode as soon as the user types the first character in a cell
  4. added a SendEscape method

Note: up to now, you had to click in a cell after the SSGear object got displayed, before you could start typing to edit the cell. SSGear has been enhanced in version 1.0.25.0 so that you can type right away after the SSGear object is displayed to start editing the currently active cell (usually A1).

In order for this to work, you must handle the onFocus event on the parent APL form and call the new SendEscape method on the SSGear object (see how it's done in functions SSG and SSGear in the new 1.25 version of the SSGear.w3 workspace).

Version 1.0.24.0 (24jul12)

Version 1.0.24 includes the following enhancements:

  1. added a backend field to ChartGridLinesColor property to retain grid lines color even when no grid lines visible
  2. added a ChartStyleProperties property returning all the chart properties used in Chart Styles
  3. changed Chart Series related properties (ChartLegends, ChartMarkerTypes, etc.) so that one can supply a number of values different than the number of series
  4. removed the error message "Cannot set the Sheet property to a string when DisplayReference has been set!"
  5. added a DoNotDisplayError property preventing SSGear from displaying error and warning MessageBoxes

Note: SSGear is by default displaying Warning or Error messages when you use a property or method which is not valid for the current type of chart: this is sometimes too intrusive for the user. You can now set the DoNotDisplayError to false to avoid displaying those MessageBoxes

Version 1.0.23.0 (11jul12)

Version 1.0.23 includes the following enhancements:

  1. added a ChartPointLabelsVisible property allowing to show or hide all point labels
  2. added a ChartPointLabelsBorderColor property allowing to get/set the point labels border colors
  3. added a ChartPointLabelsFillColor property allowing to get/set the point labels background colors
  4. added a ChartPointLabelsFontSize property allowing to get/set the point labels font sizes
  5. added a ChartPointLabelsPosition property allowing to get/set the point labels position
  6. added support for the ChartPointLabelsVisible, ChartPointLabelsBorderColor, ChartPointLabelsFillColor, ChartPointLabelsFontSize & ChartPointLabelsPosition properties to GetChartStyle
  7. added support for the ChartPointLabelsVisible, ChartPointLabelsBorderColor, ChartPointLabelsFillColor, ChartPointLabelsFontSize & ChartPointLabelsPosition properties to SetChartStyle
  8. the ChartMarkerType property now does not longer return a single value if all chart series have the same marker type
  9. the ChartMarkerSize property now does not longer return a single value if all chart series have the same marker size
  10. added test for null in ChartGridLinesColor, ChartXAxisRange, ChartYAxisRange, ChartXTitle, ChartYTitle, ... properties
  11. added test for ChartType in SetChartSeriesLabels to avoid warning MessageBox when ChartType incompatible with Labels positioning
  12. ChartGridLines now returns true if either ChartHorizontalGridLines or ChartVerticalGridLines is true

Version 1.0.22.0 (25jun12)

Version 1.0.22 includes the following enhancements:

  1. added an SSGChart APL function showing how to create a form with a chart using the whole form client area
  2. added an AllowSelection property to allow or prevent selecting cells or moving the active cell
  3. added a SelectChart method to allow working with other charts than the last created one in the worksheet
  4. added a ChartTitleFont property
  5. added a ChartSeriesNames property (same as the ChartLegends property)
  6. added a ChartXAxisLabels property
  7. added a CreateContextMenu method
  8. added a ContexMenuItemClick event
  9. added a GetChartStyle method returning a 2-column nested array of chart property value pairs
  10. added a SetChartStyle method allowing to apply a chart style matrix to an existing chart
  11. added a TestChartStyles APL function showing how to retrieve styles from a chart and how to apply them to another chart
  12. added a Zoom property
  13. added a test in properties ChartXAxisTitleFont and ChartYAxisTitleFont
  14. fixed a "Object reference not set to an instance of an object" warning happening when defining charts that do not have grid lines
  15. fixed some examples in the properties/methods documentation that were using 'ff'[]wi ... instead of 'ff.ss'[]wi ...

Version 1.0.21.0 (22may12)

Version 1.0.21 contains mainly some small improvements and bug fixes:

  1. added a DoubleClickEntersEditMode boolean property (set by default to 1 [or true])
  2. setting DoubleClickEntersEditMode to 0 [or false] now allows the DoubleClick event to fire when double clicking a cell
  3. using SetColWidths no longer makes hidden columns visible
  4. added a try... catch... to secure the workbookView1_CellCancelEdit event handler
  5. added a try... catch... to secure the workbookView1_CellEndEdit event handler
  6. added a call to AV2ANSI in demo20_charts[229] in SSGEAR.W3 workspace to avoid problem when is sent from APL to C#
  7. [DispId(i)] commented in Properties Interface
  8. the Click and RightClick events now fire ok in APL when clicking a cell that has already just been clicked
  9. the Click event was reporting the previous clicked cell row and column numbers instead of the currently clicked cell row and column number

Version 1.0.20.0 (10apr12)

To install SSGear v1.0.20.0, you must reinstall the complete 30-Day Trial version. To do so:

  1. backup your LC.Objects.SSGear.license file (if you purchased SSGear)
  2. download the complete SSGear Trial version (1st link at the top of this page) and reinstall it
  3. then, reinstall your own backed up LC.Objects.SSGear.license file in the SSGear folder (if you purchased SSGear)

Starting with v1.0.20.0, you must use 2 instructions to create an SSGear instance:

      'ff'⎕wi'*.ss.Create' 'LC.Objects.SSGear.LoaderHookerAttribute'
      'ff'⎕wi'*.ss.Create' 'LC.Objects.SSGear.SSGear'

Therefore, if you have already written APL code using SSGear, you must add the above first APL instruction before the instruction that instantiates SSGear in your code.

To properly close the SSGear object and free all resources it may be using, you should do the following the parent form onClose event handler:

      'ff'⎕wi'*.ss.XClose'
      'ff'⎕wi'*.ss.Close'

Here are the enhancements in this version:

  1. added a Close method (use: XClose to call it) to close the workbook and any associated resources
  2. added a Find method to search a given sheet and range for a string
  3. added a FindAll method to find all cells in a given sheet and range containing a given string
  4. added a FindNext method to find the next hit
  5. added a FindOptions property to allow setting several search options
  6. extended the RowCol property to accept an A1 address
  7. the GetRowHeights method now accept a second argument of -1 to return all used range row heights
  8. the GetColWidths method now returns column widths for used range columns instead of for all columns when second argument is -1
  9. added a ColToPix method converting a fractional column position into pixels
  10. added a RowToPix method converting a fractional row position into pixels
  11. added a RowColToPix method converting both a fractional row and fractional column position into pixels
  12. added support for Int16 integers in the whole DLL so that the DLL fully works with Dyalog APL
  13. removed all new line characters (⎕TCLFs) from properties and methods documentation
  14. added a GetUsedRangeRows method returning list of used range row numbers in the specified sheets
  15. added a GetUsedRangeCols method returning list of used range column numbers in the specified sheets
  16. the selected range was not always correct after the AddAcross method was called
  17. rewrote the CellEndEdit event for better handling of ⎕wres returned by APL
  18. fixed a bug in method SetAlignments (called by HAlign and/or VAlign)

The SSGear workspace v1.0.20.0 contains a new demo (called: demo23_findreplace) showing how to use the new Find, FindOptions, FindNext and FindAll properties and methods

Version 1.0.19.0 (13mar12)

Here are the enhancements in this version:

  1. added a ColWidthsFactor property allowing to apply a factor when setting column widths
  2. added an IncreaseColWidths method allowing to increase column widths in specified sheets by a given percentage
  3. changed AutoFit and SetColWidths to apply the ColWidthsFactor factor on column widths so that they display ok when workbook is opened in Excel
  4. 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)
  5. 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)
  6. extended the SetColWidths method documentation
  7. extended the SetRowHeights method documentation
  8. fixed a bug in private GetIRangeRows method
  9. improved private GetIRangeCols method

For reasons internal to the way SpreadsheetGear has been developed, column widths set in an SSGear workbook display about 8% to 9% narrower in Excel. For this reason a ColWidthsFactor property with default value of 1 has been added to SSGear: if you plan to open workbooks created with SSGear in Excel, you should set the ColWidthsFactor property to 1.08 or 1.09 just after instantiating the SSGear object.

Version 1.0.18.0 (11mar12)

Here are the enhancements in this version:

  1. added an AddComboBox method allowing to add ComboBox objects to a worksheet
  2. added an AddCheckBox method allowing to add CheckBox objects to a worksheet
  3. added an AddSpinner method allowing to add Spinner objects to a worksheet
  4. added an AddListBox method allowing to add ListBox objects to a worksheet
  5. added an argument to the ShapeAction event to allow returning the selected control item or new control value
  6. added support for ComboBox item selection in the ShapeAction event
  7. added support for ListBox item selection in the ShapeAction event
  8. added support for Spinner item selection in the ShapeAction event
  9. added support for CheckBox checking in the ShapeAction event
  10. added documentation for the ShapeAction event

The new SSGear.w3 workspace contains a new version of the SSGear function demonstrating use of the new Controls.
The SSGear.w3 workspace also contains a new Tutorial entitled: demo22_controls

Version 1.0.17.0 (7mar12)

Here are the enhancements in this version:

  1. added more error trapping to the GetNames and A1toRC methods so that SSGear silently accepts named ranges with invalid addresses
  2. added a HideSheets method allowing to hide one or more sheets from the workbook
  3. added a ShowSheets method allowing to show one or more sheets which were previously hidden
  4. added a GetHiddenSheets method which returns the hidden sheet numbers (in origin 1)
  5. added an AddButton method allowing to add buttons to a worksheet
  6. added a ShapeAction event allowing to react to button clicks in a worksheet

The new SSGear.w3 workspace contains a new TestButtons function showing how to create buttons in a worksheet

Version 1.0.16.0 (5mar12)

Here are the enhancements in this version:

  1. added an AddPicture method allowing to add a picture to a cell or range of cells
  2. added a GetHiddenRows method returning the hidden rows numbers in a given sheet
  3. added a GetHiddenCols method returning the hidden columns numbers in a given sheet
  4. extended the SortRows method so that you do no longer have to enclose the sort keys argument when there is only one sort key
  5. extended the SortCols method so that you do no longer have to enclose the sort keys argument when there is only one sort key
  6. fixed the LoadFilePartial method which was missing the password argument

Version 1.0.15.0 (1mar12)

Here are the enhancements in this version:

  1. improved the error message delivered when the .license file is not found
  2. improved the About method by now displaying the folder of the registered SSGear DLL
  3. ensured that a RightClick event fires in addition to the Click event

Notes:

Please be sure to not only download the SSGear DLL but also SSGear.w3 (and SSGear.zip) as the SSGear Tutorial has been improved in this version. It is also now available in the form of 21 smaller Tutorials which makes it easy to run only part of the large tutorial!

Version 1.0.14.0 (23feb12)

Here are the enhancements in this version:

  1. the AutoFit method does no longer show rows and/or columns that were hidden
  2. the CellEndEdit event now supports you setting []wres in APL to change the entered value and/or refuse ending Edit mode
  3. added a SortRows method to allow sorting cells in a range according to sort keys
  4. added a SortCols method to allow sorting cells in a range according to sort keys
  5. fixed a problem in the MaxRow, MaxCol and DisplayReference properties that would sometimes change the active sheet why they should not
  6. fixed a bug where the Insert method would change the active range in the active sheet even if applied on another sheet
  7. fixed the SetPrintHeadersFont and SetPrintFootersFont methods which were not always working
  8. fixed the RemoveColPageBreaks, RemovePageBreaks and RemoveRowPageBreaks documentation that was missing an argument
  9. added a MoveChart method to allow moving and resizing the active chart in a worksheet
  10. added a RemoveCharts method to removing all charts from a given worksheet
  11. added a ChartLineWeights property allowing to change the line weights for all chart series
  12. fixed a bug in SaveAs method where saving the workbook with an empty string password would not reset the password to an empty string
  13. fixed a bug in ProtectFormulae method that would protect all cells not just the ones containing formulae
  14. fixed a bug in ProtectFormulae method that would protect charts when it should not
  15. fixed a bug in Protect method which would protect all cells in the sheet instead of just the specified range
  16. renamed the ProtectedCells method to ShowProtectedCells(please adapt your code if you have been using the ProtectedCells method)
  17. added a GetProtectedCells method returning the protected cells from a given worksheet
  18. added a try ... catch ... in internal method ColumnsAutoFit to avoid warnings when column size is larger than 255 pixels

Notes:

The most important enhancement in this Release is the new interactive exhaustive demo in the SSGear.w3 workspace
So please be sure to download and install the latest SSGear.w3 workspace, load it and run the demo.

Version 1.0.13.0 (12feb12)

Here are the enhancements in this version:

  1. extended the ChartSeries property to allow superposing series having different X values on the same chart
  2. added a ChartLegends property allowing to change the text in the series legends

Version 1.0.12.0 (10feb12)

Here are the enhancements in this version:

  1. made the Esc key exit Edit mode and restore cell content as it was before entering Edit mode
  2. added a CopyPaste method allowing to copy the current range to any destination range copying forumlae, number formats, ...
  3. added a SetTextOrientation method to allow set the text orientation (between -90 and 90) for all cells in a range
  4. added an UnProtectAll method which unprotects all cells in the specified sheet
  5. added a ProtectAll method which protects all cells in the specified sheet
  6. changed the Protect method so that it no longer removes previous cells protection whne protecting a new range
  7. added an argument to the UnProtect method to allow unprotecting a range in the specified sheet
  8. added a ProtectedCells method which allows to toggle highlighting all the protected cells in a given sheet
  9. added a SetValidation method wlloing to specify validation rules for all cells in a specified sheet/range

Note: since the UnProtect method has an additional argument, you may have to update your code if you have used UnProtect.

Version 1.0.11.0 (26jan12)

Here are the enhancements in this version:

  1. added a GetRowHeights method
  2. added a ProtectFormulae method allowing to protect formulae in a worksheet/range or in whole workbook
  3. added an EnableProtection property allowing to disable/reenable all cell protections in a workbook
  4. added a ShowExplorer method allowing to display the SpreadsheetGear Workbook Explorer
  5. added a ShowDesigner method allowing to display the SpreadsheetGear Workbook Designer

Also, download the new version of SSGear and look at the new SSProtectFormulae function in this workspace.

Version 1.0.10.0 (25jan12)

Here are the enhancements in this version:

  1. added a PrintLeftToRight property allowing to print pages from left to right first then top to bottom
  2. enhanced the NumberFormat property so that it be "matrix aware" (i.e. setting a different format for each cell of a range)
  3. enhanced the SetNumberFormats method so that it be "matrix aware" (i.e. setting a different format for each cell of a range)
  4. added a SkipAutoFit property to disable doing an automatic AutoFit when setting some properties (NumberFormat, FontSize, ...) or calling some methods (Add, ...)
  5. added a Merge method allowing to merge cells
  6. added an password argument to the LoadFile method (pass an empty string if the workbook has no password)
  7. added an password argument to the SaveAs method (passing a non empty string sets a password on the workbook))
  8. added an password argument to the Import method (pass an empty string if the workbook has no password)
  9. added an password argument to the ImportPartial method (pass an empty string if the workbook has no password)
  10. added an password argument to the Export method (passing a non empty string sets a password on the exported workbook))
  11. added a SuppressEvents property allowing to prevent events from being signaled to APL

Notes:

WARNING: There has been a design change in this version.

The Export, Import, ImportPartial, LoadFile and SaveAs method now accept an addtional argument which is the password associated with the workbook. So you will have to add this argument in existing code you may have already written which use any of these methods. The change will be easy though: just pass an additional argument of "" (i.e. an empty character vector) as the password.

Version 1.0.9.0 (22jan12)

Here are the enhancements in this version:

  1. added a SetPassword method allowing to protect a worksheet by a password
  2. added an UnsetPassword method allowing to unprotect a workbook or worksheet
  3. added a ScrollRow property to programmatically set the top visible row
  4. added a ScrollCol property to programmatically set the left visible column
  5. added a PrintNoColor property to allow printing in balck and white
  6. added a PrintPaperSize property to allow selecting the paper size for printing
  7. added a PrinterName property allowing to get or set the default Printer
  8. added a PrinterNames property allowing to get the list of all printers installed on your computer
  9. added a StrikeOut property allowing to get/set the active range StrikeOut state
  10. added a RightClick event
  11. added an AutoFill method
  12. added a SetPattern method allowing to use a pattern style for the specified range
  13. added a BeginUpdate method to stop painting changes to the workbook until EndUpdate is called
  14. added a EndUpdate method to restore painting changes to the workbook after BeginUpdate has suspended them

Version 1.0.8.0 (19jan12)

Here are the enhancements in this version:

  1. added a SetNameValue method allowing to create names associated with a value (not a range)
  2. added an Evaluate method allowing to evaluate names
  3. fixed a typo in AddSheet documentation

Version 1.0.7.0 (17jan12)

Here are the enhancements in this version:

  1. added an argument to method BlankZeros to let "unblank" zeros
  2. added a MaxCol property to restrict the viewable range to not exceed a given column
  3. added a MaxRow property to restrict the viewable range to not exceed a given row
  4. added a DisplayReference property to restrict the viewable range per worksheet to given ranges
  5. added a SheetNo read-only property returning the active sheet number (in origin 1)
  6. added a BeginEdit method to force active cell to enter Edit mode
  7. added a CancelEdit method to cancel the current cell Edit session
  8. added an EndEdit method to force active cell to end Edit mode
  9. added a CellBeginEdit event
  10. added a CellCancelEdit event
  11. added a CellEndEdit event
  12. added an Insert method to allow inserting rows, columns or ranges
  13. added a Delete method to allow deleting rows, columns or ranges
  14. added a DoubleClick event
  15. rewrote the Click event
  16. added a Palette property allowing to change any or all of the 56 palette colors
  17. added a FontColorIndex property
  18. added a BackColorIndex property
  19. changed the SetBorders method so that a color specified as a scalar is considered a color index in the Palette
  20. changed the SetBottomBorders method so that a color specified as a scalar is considered a color index in the Palette
  21. changed the SetLeftBorders method so that a color specified as a scalar is considered a color index in the Palette
  22. changed the SetRightBorders method so that a color specified as a scalar is considered a color index in the Palette
  23. changed the SetTopBorders method so that a color specified as a scalar is considered a color index in the Palette

Notes:

Colors

Up to this version you could specify colors as 3-element integer RGB values (as in APL) or as a scalar integer (for example: 255 to mean: red). Starting with this version, colors must be specified:

  • either as a 3-element integer RGB vector
  • or as a color index (integer scalar between 1 and 56) into the SSGear colors Palette

So if you specify a color as an integer it will be understood as a color index into the Palette.

Properties like BackColor and FontColor do no longer accept scalar colors: you must use BackColorIndex and FontColorIndex instead if you want to use Palette colors.

The SetBorders series of methods accept either a 3-element color RBG vector or a color index (between 1 and 56).

Finally, if you want to use Palette colors in your application and if you want that changes in the Palette affects the workbook colors, you must use color indices everywhere in your code. All colors specified as 3-element RGB values will NOT be affected by changes in the Palette colors.

DisplayReference

The DisplayReference property allows you to limit rows and columns that can ve viewed, in all sheets of the current workbook. The MaxRow and MaxCol properties which apply to the current sheet only are implemented by internally using DisplayReference

Click Events

Support for Click events is somewhat limited in this version. Some click or double click events do not fire in APL yet, but most do fire.

Palette

There is a new Palette property which returns the 56 colors contained in the SpreadsheetGear Palette. You can easily change Palette colors as follows:

      'ff.ss'⎕wi'*xPalette'
0 0 0  255 255 255  255 0 0  0 255 0  0 0 255  255 255 0  255 0 255  0 255 255
128 0 0  0 128 0  0 0 128  128 128 0  128 0 128  0 128 128  192 192 192
128 128 128  153 153 255  153 51 102  255 255 204  204 255 255  102 0 102
...

      ⍝ Change a palette color
      colors←'ff.ss'⎕wi'palette'
      (3⊃colors)←128 0 0
      'ff.ss'⎕wi'palette'colors

However, be warned that this will NOT affect colors that you have set with such properties as BackColor, FontColor or by setting colors as a 3-element RGB color anywhere in the DLL.

If you want to use Palette colors, you MUST use such properties as BackColorIndex, FontColorIndex and specify colors everywhere as color indices (1 to 56 inclusive) into the Palette.

Version 1.0.6.0 (14jan12)

Here are the enhancements in this version:

  1. extended the GetNames method so that it could return both named ranges and Excel names

Version 1.0.5.0 (13jan12)

Here are the enhancements in this version:

  1. added an ImportPartial method allowing to import only part of an Excel workbook
  2. added a LoadFilePartial method allowing to load only part of an Excel workbook

Version 1.0.4.0 (12jan12)

Here are the enhancements in this version:

  1. added a Col property allowing to get/set the active cell column
  2. added a Row property allowing to get/set the active cell row
  3. added a RowCol property allowing to get/set the active cell row and column
  4. added more arguments to the SetChartSeriesLabels method and documented it
  5. added a GetColWidths method
  6. added a DefaultContextMenu property to allow enabling/disabling the default context menu
  7. added a MouseClick event

Version 1.0.3.0 (17jan12)

Here are the enhancements in this version:

  1. added a SetName method allowing to create named ranges
  2. added a GetNames method allowing to return named ranges from one sheet or all sheets
  3. added a Names property allowing to retrieve all named ranges from all worksheets
  4. added a SetChartSeriesLabels method to add labels to a chart series

Version 1.0.2.0 (12jan12)

Here are the enhancements in this version:

  1. added the WrapText property
  2. added the SetWrapText method

Version 1.0.1.0 (3jan12)

Version 1.0.1.0 is made of the following properties and methods:

Properties

  1. xAllowSelection
  2. xBackColor
  3. xBackColorIndex
  4. xBold
  5. xBookName
  6. xCalledFromAPL
  7. xChartDataYScale
  8. xChartGridLines
  9. xChartGridLinesColor
  10. xChartHorizontalGridLines
  11. xChartLegendVisible
  12. xChartLegends
  13. xChartLineWeights
  14. xChartMarkerSize
  15. xChartMarkerType
  16. xChartMarkerTypes
  17. xChartPointLabelsBorderColor
  18. xChartPointLabelsFillColor
  19. xChartPointLabelsFontSize
  20. xChartPointLabelsPosition
  21. xChartPointLabelsVisible
  22. xChartSeries
  23. xChartSeriesEx
  24. xChartSeriesNames
  25. xChartStyleProperties
  26. xChartTitle
  27. xChartTitleFont
  28. xChartType
  29. xChartTypes
  30. xChartVerticalGridLines
  31. xChartXAxisLabels
  32. xChartXAxisLabelsFont
  33. xChartXAxisRange
  34. xChartXAxisTitleFont
  35. xChartXTitle
  36. xChartYAxisLabelsFont
  37. xChartYAxisRange
  38. xChartYAxisTitleFont
  39. xChartYTitle
  40. xColWidthsFactor
  41. xDecimalSeparator
  42. xDefaultContextMenu
  43. xDefaultFont
  44. xDisplayReference
  45. xDisplayReferenceString
  46. xDoNotDisplayError
  47. xDoubleClickEntersEditMode
  48. xEnableProtection
  49. xEnabled
  50. xEnterMovesDown
  51. xErrorTrapping
  52. xFindOptions
  53. xFixedCols
  54. xFixedRows
  55. xFont
  56. xFontColor
  57. xFontColorIndex
  58. xFontName
  59. xFontSize
  60. xFormula
  61. xFormulaBarVisible
  62. xFreezePanes
  63. xGridHeadings
  64. xGridLines
  65. xHAlign
  66. xHScrollBarVisible
  67. xIsDirty
  68. xItalic
  69. xListSeparator
  70. xMaxCol
  71. xMaxRow
  72. xMessageBoxCaption
  73. xNames
  74. xNbCols
  75. xNbRows
  76. xNbSheets
  77. xNumberFormat
  78. xOrientation
  79. xPalette
  80. xPaneScrollCol
  81. xPaneScrollRow
  82. xPrintArea
  83. xPrintBottomMargin
  84. xPrintFileName
  85. xPrintFitToPagesTall
  86. xPrintFitToPagesWide
  87. xPrintFooters
  88. xPrintFootersMargin
  89. xPrintGridLines
  90. xPrintHCenter
  91. xPrintHeaders
  92. xPrintHeadersMargin
  93. xPrintLeftMargin
  94. xPrintLeftToRight
  95. xPrintMargins
  96. xPrintNoColor
  97. xPrintPaperSize
  98. xPrintRightMargin
  99. xPrintScale
  100. xPrintTitleCols
  101. xPrintTitleRows
  102. xPrintToFile
  103. xPrintTopMargin
  104. xPrintVCenter
  105. xPrinterName
  106. xPrinterNames
  107. xRangeSize
  108. xReverseSeriesOrder
  109. xRowCol
  110. xScrollCol
  111. xScrollRow
  112. xSheet
  113. xSheetName
  114. xSheetNames
  115. xSheetNo
  116. xSkipAutoFit
  117. xSpreadsheetGearVersion
  118. xStrikeOut
  119. xSuppressEvents
  120. xTabMovesDown
  121. xTabsVisible
  122. xUnderline
  123. xUsedRange
  124. xVAlign
  125. xVScrollBarVisible
  126. xVersion
  127. xVisible
  128. xWrapText
  129. xZoom
  130. xcol
  131. xrange
  132. xrow

Methods

  1. A1toRC
  2. A1toRCDoc
  3. About
  4. AboutDoc
  5. Add
  6. AddAcross
  7. AddAcrossDoc
  8. AddButton
  9. AddButtonDoc
  10. AddChart
  11. AddChartDoc
  12. AddCheckBox
  13. AddCheckBoxDoc
  14. AddColPageBreaks
  15. AddColPageBreaksDoc
  16. AddComboBox
  17. AddComboBoxDoc
  18. AddDoc
  19. AddListBox
  20. AddListBoxDoc
  21. AddPageBreaks
  22. AddPageBreaksDoc
  23. AddPicture
  24. AddPictureDoc
  25. AddRowPageBreaks
  26. AddRowPageBreaksDoc
  27. AddSheet
  28. AddSheetDoc
  29. AddSpinner
  30. AddSpinnerDoc
  31. AllowSelectionDoc
  32. AutoFill
  33. AutoFillDoc
  34. AutoFit
  35. AutoFitDoc
  36. BackColorDoc
  37. BackColorIndexDoc
  38. BeginEdit
  39. BeginEditDoc
  40. BeginUpdate
  41. BeginUpdateDoc
  42. BlankZeros
  43. BlankZerosDoc
  44. BoldDoc
  45. BookNameDoc
  46. CalledFromAPLDoc
  47. CancelEdit
  48. CancelEditDoc
  49. CellBeginEditDoc
  50. CellCancelEditDoc
  51. CellEndEditDoc
  52. ChartDataYScaleDoc
  53. ChartGridLinesColorDoc
  54. ChartGridLinesDoc
  55. ChartHorizontalGridLinesDoc
  56. ChartLegendVisibleDoc
  57. ChartLegendsDoc
  58. ChartLineWeightsDoc
  59. ChartMarkerSizeDoc
  60. ChartMarkerTypeDoc
  61. ChartMarkerTypesDoc
  62. ChartPointLabelsBorderColorDoc
  63. ChartPointLabelsFillColorDoc
  64. ChartPointLabelsFontSizeDoc
  65. ChartPointLabelsPositionDoc
  66. ChartPointLabelsVisibleDoc
  67. ChartSeriesDoc
  68. ChartSeriesExDoc
  69. ChartSeriesNamesDoc
  70. ChartStylePropertiesDoc
  71. ChartTitleDoc
  72. ChartTitleFontDoc
  73. ChartTypeDoc
  74. ChartTypesDoc
  75. ChartVerticalGridLinesDoc
  76. ChartXAxisLabelsDoc
  77. ChartXAxisLabelsFontDoc
  78. ChartXAxisRangeDoc
  79. ChartXAxisTitleFontDoc
  80. ChartXTitleDoc
  81. ChartYAxisLabelsFontDoc
  82. ChartYAxisRangeDoc
  83. ChartYAxisTitleFontDoc
  84. ChartYTitleDoc
  85. ClearRange
  86. ClearRangeDoc
  87. ClearSheet
  88. ClearSheetDoc
  89. ClearSheets
  90. ClearSheetsDoc
  91. Close
  92. CloseBook
  93. CloseBookDoc
  94. CloseDoc
  95. ColDoc
  96. ColToPix
  97. ColToPixDoc
  98. ColWidthsFactorDoc
  99. Copy
  100. CopyDoc
  101. CopyPaste
  102. CopyPasteDoc
  103. CopySheet
  104. CopySheetDoc
  105. CreateContextMenu
  106. CreateContextMenuDoc
  107. Cut
  108. CutDoc
  109. DecimalSeparatorDoc
  110. DefaultContextMenuDoc
  111. DefaultFontDoc
  112. Delete
  113. DeleteDoc
  114. DisplayReferenceDoc
  115. DoNotDisplayErrorDoc
  116. DoubleClickEntersEditModeDoc
  117. EnableProtectionDoc
  118. EndEdit
  119. EndEditDoc
  120. EndUpdate
  121. EndUpdateDoc
  122. EnterMovesDownDoc
  123. ErrorTrappingDoc
  124. Evaluate
  125. EvaluateDoc
  126. Export
  127. ExportDoc
  128. Find
  129. FindAll
  130. FindAllDoc
  131. FindDoc
  132. FindNext
  133. FindNextDoc
  134. FindOptionsDoc
  135. FixedColsDoc
  136. FixedRowsDoc
  137. FontColorDoc
  138. FontColorIndexDoc
  139. FontDoc
  140. FontNameDoc
  141. FontSizeDoc
  142. FormulaBarVisibleDoc
  143. FormulaDoc
  144. GeneralDocDoc
  145. Get
  146. GetChartStyle
  147. GetChartStyleDoc
  148. GetColName
  149. GetColNameDoc
  150. GetColNum
  151. GetColNumDoc
  152. GetColPageBreaks
  153. GetColPageBreaksDoc
  154. GetColWidths
  155. GetColWidthsDoc
  156. GetDoc
  157. GetFormula
  158. GetFormulaDoc
  159. GetHiddenCols
  160. GetHiddenColsDoc
  161. GetHiddenRows
  162. GetHiddenRowsDoc
  163. GetHiddenSheets
  164. GetHiddenSheetsDoc
  165. GetNames
  166. GetNamesDoc
  167. GetNextRowPageBreak
  168. GetNextRowPageBreakDoc
  169. GetNumberFormats
  170. GetNumberFormatsDoc
  171. GetPageBreaks
  172. GetPageBreaksDoc
  173. GetProtectedCells
  174. GetProtectedCellsDoc
  175. GetRange
  176. GetRangeDoc
  177. GetRowHeights
  178. GetRowHeightsDoc
  179. GetRowPageBreaks
  180. GetRowPageBreaksDoc
  181. GetSheetNum
  182. GetSheetNumDoc
  183. GetUsedRange
  184. GetUsedRangeCols
  185. GetUsedRangeColsDoc
  186. GetUsedRangeDoc
  187. GetUsedRangeRows
  188. GetUsedRangeRowsDoc
  189. GridHeadingsDoc
  190. GridLinesDoc
  191. HAlignDoc
  192. HScrollBarVisibleDoc
  193. HideCols
  194. HideColsDoc
  195. HideFocusRectangle
  196. HideFocusRectangleDoc
  197. HideRows
  198. HideRowsDoc
  199. HideSheets
  200. HideSheetsDoc
  201. Import
  202. ImportDoc
  203. ImportPartial
  204. ImportPartialDoc
  205. IncreaseColWidths
  206. IncreaseColWidthsDoc
  207. Indent
  208. Insert
  209. InsertDoc
  210. IsDirtyDoc
  211. ItalicDoc
  212. ListSeparatorDoc
  213. LoadFile
  214. LoadFileDoc
  215. LoadFilePartial
  216. LoadFilePartialDoc
  217. MaxColDoc
  218. MaxRowDoc
  219. Merge
  220. MergeDoc
  221. MessageBoxCaptionDoc
  222. Move
  223. MoveChart
  224. MoveChartDoc
  225. MoveDoc
  226. NamesDoc
  227. NbColsDoc
  228. NbRowsDoc
  229. NbSheetsDoc
  230. NumberFormatDoc
  231. OrientationDoc
  232. PaletteDoc
  233. PaneScrollColDoc
  234. PaneScrollRowDoc
  235. Paste
  236. PasteDoc
  237. Print
  238. PrintAreaDoc
  239. PrintBottomMarginDoc
  240. PrintDoc
  241. PrintFileNameDoc
  242. PrintFitToPagesTallDoc
  243. PrintFitToPagesWideDoc
  244. PrintFootersDoc
  245. PrintFootersMarginDoc
  246. PrintGridLinesDoc
  247. PrintHCenterDoc
  248. PrintHeadersDoc
  249. PrintHeadersMarginDoc
  250. PrintLeftMarginDoc
  251. PrintLeftToRightDoc
  252. PrintMarginsDoc
  253. PrintNoColorDoc
  254. PrintPaperSizeDoc
  255. PrintPreview
  256. PrintPreviewDoc
  257. PrintRightMarginDoc
  258. PrintScaleDoc
  259. PrintTitleColsDoc
  260. PrintTitleRowsDoc
  261. PrintToFileDoc
  262. PrintTopMarginDoc
  263. PrintVCenterDoc
  264. PrintWithCharts
  265. PrintWithChartsDoc
  266. PrinterNameDoc
  267. PrinterNamesDoc
  268. Protect
  269. ProtectAll
  270. ProtectAllDoc
  271. ProtectDoc
  272. ProtectFormulae
  273. ProtectFormulaeDoc
  274. QuickChart
  275. QuickChartDoc
  276. RCtoA1
  277. RCtoA1Doc
  278. RangeDoc
  279. RangeExpand
  280. RangeExpandDoc
  281. RangeOffset
  282. RangeOffsetDoc
  283. RangeSizeDoc
  284. Redo
  285. RedoDoc
  286. Refresh
  287. ReleaseLock
  288. ReleaseLockDoc
  289. RemoveCharts
  290. RemoveChartsDoc
  291. RemoveColPageBreaks
  292. RemoveColPageBreaksDoc
  293. RemovePageBreaks
  294. RemovePageBreaksDoc
  295. RemoveRowPageBreaks
  296. RemoveRowPageBreaksDoc
  297. RemoveSheet
  298. RemoveSheetDoc
  299. ReorderSheets
  300. ReorderSheetsDoc
  301. ResumeLayoutGrid
  302. ResumeLayoutGridDoc
  303. ReverseSeriesOrderDoc
  304. RightClickDoc
  305. RowColDoc
  306. RowColToPix
  307. RowColToPixDoc
  308. RowDoc
  309. RowToPix
  310. RowToPixDoc
  311. Save
  312. SaveAs
  313. SaveAsDoc
  314. SaveDoc
  315. ScrollColDoc
  316. ScrollRowDoc
  317. ScrollTo
  318. ScrollToDoc
  319. SelectAll
  320. SelectAllDoc
  321. SelectChart
  322. SelectChartDoc
  323. SendEscape
  324. SendKeys
  325. SendKeysDoc
  326. SetAlignments
  327. SetAlignmentsDoc
  328. SetBorders
  329. SetBordersDoc
  330. SetBottomBorders
  331. SetBottomBordersDoc
  332. SetChartSeriesLabels
  333. SetChartSeriesLabelsDoc
  334. SetChartStyle
  335. SetChartStyleDoc
  336. SetColWidths
  337. SetColWidthsDoc
  338. SetDefaultFont
  339. SetDefaultFontDoc
  340. SetFixedCols
  341. SetFixedColsDoc
  342. SetFixedRows
  343. SetFixedRowsDoc
  344. SetFormula
  345. SetFormulaDoc
  346. SetHyperlinks
  347. SetHyperlinksDoc
  348. SetLeftBorders
  349. SetLeftBordersDoc
  350. SetName
  351. SetNameDoc
  352. SetNameValue
  353. SetNameValueDoc
  354. SetNumberFormats
  355. SetNumberFormatsDoc
  356. SetPassword
  357. SetPasswordDoc
  358. SetPattern
  359. SetPatternDoc
  360. SetPrintFitToPages
  361. SetPrintFitToPagesDoc
  362. SetPrintFootersFont
  363. SetPrintFootersFontDoc
  364. SetPrintHeadersFont
  365. SetPrintHeadersFontDoc
  366. SetPrintTitles
  367. SetPrintTitlesDoc
  368. SetRange
  369. SetRangeDoc
  370. SetRightBorders
  371. SetRightBordersDoc
  372. SetRowHeights
  373. SetRowHeightsDoc
  374. SetTextOrientation
  375. SetTextOrientationDoc
  376. SetTopBorders
  377. SetTopBordersDoc
  378. SetValidation
  379. SetValidationDoc
  380. SetWrapText
  381. SetWrapTextDoc
  382. ShapeActionDoc
  383. SheetDoc
  384. SheetNameDoc
  385. SheetNamesDoc
  386. SheetNoDoc
  387. ShowCols
  388. ShowColsDoc
  389. ShowDesigner
  390. ShowDesignerDoc
  391. ShowExplorer
  392. ShowExplorerDoc
  393. ShowProtectedCells
  394. ShowProtectedCellsDoc
  395. ShowRows
  396. ShowRowsDoc
  397. ShowSheets
  398. ShowSheetsDoc
  399. SkipAutoFitDoc
  400. SortCols
  401. SortColsDoc
  402. SortRows
  403. SortRowsDoc
  404. SpreadsheetGearVersionDoc
  405. StrikeOutDoc
  406. SuspendLayoutGrid
  407. SuspendLayoutGridDoc
  408. TabMovesDownDoc
  409. TabsVisibleDoc
  410. UnProtect
  411. UnProtectAll
  412. UnProtectAllDoc
  413. UnProtectDoc
  414. UnderlineDoc
  415. Undo
  416. UndoDoc
  417. UnsetPassword
  418. UnsetPasswordDoc
  419. UsedRangeDoc
  420. VAlignDoc
  421. VScrollBarVisibleDoc
  422. VersionDoc
  423. WrapTextDoc
  424. ZoomDoc