FarPoint Technologies Spread 2.5 Fixed Bugs

Spread 2.5 Fixed Bugs

Select the Edit->Find menu option at the top of this page to search for a particular keyword or update number.

Technical Issues Addressed -- Release Date 10/28/98 -- Version 2.5.55

The Advance event no longer fires when you set the RowHidden property in code. (CHB1177)

When the EditModePermanent property is set to True, the AllowCellOverflow property is set to False, some columns are locked, and you resize one of the locked column using the pointer, the other locked columns are now painted correctly. (GIC5398)

You can now set the TypeComboCurSel property while the Visible property is set to False.(GIC6574)

The maximum value allowed for the TypeDateMax property is now 12/31/3000. (GIC6790)

Hidden columns no longer display when you save and reload the spreadsheet. (GIC6803)

If you are using the 32-bit ActiveX control, you can now sort on a column header. (GIC6809)

If you are using the 32-bit ActiveX control in Visual Basic 4.0, Visual Basic no longer locks up when you set the Visible property to False in the properties window at design time. (GIC7004)

Setting the BlockMode to -1 no longer causes a run-time error method. (GIC7363)

The correct number of rows are now copied and pasted when using the Clipboard keys to copy (Ctrl+C) and paste (Ctrl+V) data in the spreadsheet. (GIC7394)

The scroll bar now works correctly when used to scroll up and down when the spreadsheet is bound to large databases. (GRB6082)

The Text property now works with combo box cells. (GRB6106)

In Spread Designer, header changes are now applied to the Spread control when you choose Apply - All from the File menu. (GRB7010)

If you have multiple combo box cells and you select an item from one combo box cell, making a second selection from a different combo box cell no longer causes Visual Basic to lock up. (GRB7027)

Visual Basic no longer locks up when you set the VirtualMode property to True and start the Spread Designer. (GRB7032)

If you are using Visual Basic 3.0, the correct value for the ColHidden property is now returned for visible columns. (GRB7069)

If you are using the ActiveX control, the DisplayRowHeaders property now works correctly when you set it in the properties window. (GRB7074)

If you are using the 32-bit DLL, you can now load a picture at run time using the path and filename. (SCS7288)

If you have a Tab Pro and Spread control on a form, pressing the Backspace key once no longer deletes all text in a PIC cell in the spreadsheet. (SCS7308)

You can now access columns or rows in the range 262048 to 262079. (SCS7424)

All rows that are added to a bound spreadsheet after you delete all the original rows are now saved. (SCS7522)

Hidden columns stay hidden when you set the ColHidden property to True and either save as a .SS2 file in Spread Designer or use the SaveToFile function. (TEL153)

Technical Issues Addressed -- Release Date 8/11/98 -- Version 2.5.45

The correct data now displays in a float cell with an ANSI currency character greater than 128. (GIC6309)

The BackColor, CellBorderColor, ForeColor, LockBackColor, LockForeColor, ShadowColor, ShadowDark, TypeButtonBorderColor, TypeButtonDarkColor, and TypeButtonLightColor properties now accept and return Windows system colors. (GIC6391) (GIC6413) (SCS7253)

The Col and Row parameters of the GetCellFromScreenCoord function now return a -1 when the pointer is over the gray area. (SCS6871)

The Spread control nows binds correctly to an integer field through the Remote Data Control. (SCS7259)

Technical Issues Addressed -- Release Date 7/7/98 -- Version 2.5.40

This release updates the control to allow users to type year values starting with the number 2 into date cells. Previous releases allowed users to type in years starting with the number 2, but as the user typed the year value, after the number 2 was typed as the first digit of the year, the control would automatically change the date to the value specified by the TypeDateMax property (the default for which is 12/31/2100). The user could then backspace over the date and correct the entire date value. If the user did not correct the value, when the cell left edit mode, the EditError event occurred. You might have added code to the EditError event as a workaround.
Now, the control lets users type in years starting with the number 2 without automatically advancing to the maximum date value. As soon as the user types in the number 2 for the first digit of the year value, the year value changes to the maximum year value specified by the TypeDateMax property, but the month and day values no longer change. The user can continue to type and simply type over the changed year value. The EditError event no longer occurs when the cell leaves edit mode.

Sorting date cells is significantly faster in Spread version 2.5.40.

You now get a error message when you try to bind the spreadsheet to the Remote Data control using Spread Designer in Visual Basic 5.0 without setting the SQL property of the Remote Data control. (CHB139)

When the AutoClipboard property is set to False and you are in edit mode, the KeyDown event now fires when you use keyboard shortcuts (Ctrl-X, Ctrl-C, Ctrl-V, Shift-Insert)to cut, copy, paste, or insert data. (CHB192)

The Change event no longer fires twice when leaving edit mode in a combo box cell. (GIC2547)

Text in an edit cell whose length is determined by the TypeEditLen property is no longer truncated when the spreadsheet is reloaded. (GIC2802)

The spreadsheet now displays and prints dotted and dashed borders around cells correctly when the CellBorderType property is set to 16 (Outline). (GIC2803)

Selections are now highlighted correctly when the OperationMode property is set to 4 (Multi Select) or 5 (Extended Select) and you scroll horizontally or vertically off the screen. (GIC2924)

When printing a bound spreadsheet that is in virtual mode, the spreadsheet no longer continues to spool data after you cancel the print job. (GIC3183)

When the OperationMode property is set to 5 (Extended Select), you can now click on the row headers and drag the mouse pointer down the row headers to select multiple rows. (GIC3207)

When the OperationMode property is set to 4 (Multi Select) or 5 (Extended Select), cutting or copying an entire row now cuts or copies all cells in that row. (GIC3265)

Painting problems no long occur when the Operation Mode property is set to 4 (Multi Select) and you bring up and move another form on top of the form with the spreadsheet. (GIC4278)

Formulas are now cleared when you change the cell type or the cell type formatting in any part of the spreadsheet. (GIC4291)

You can now link the spreadsheet currency field to the remote data control. (GIC4433)

When virtual mode is on and you click and drag a row, the OldTop parameter of the TopLeftChange event now returns the correct row number. (GIC4554)

The edit cursor no longer appears in bold face when you click on the menu option. (GIC4720)

A Property is Write-only message is no longer generated when you have a form with (1) a user control with an fpDateTime control and (2) a vaSpread control and you have code in the Write event of the user control. (GIC4950)

An error no longer occurs when changing fonts in Spread Designer using the Spread ActiveX control in Windows NT 4.0. (GIC5232)

Learn Mode in the Spread Designer now generates the correct code for cell ranges. (GIC5301)

Two rows are no longer highlighted when you set the TopRow property and the active cell. (GRB363)

Using the Text property to enter data in a noneditable combo box cell no longer causes an error. (GRB5865)

When you sort a bound spreadsheet, the spreadsheet and data control are now in sync and the cells display the correct data. (GRB5872)

If you use the 32-bit ActiveX control, the BackColor property now returns the correct color value. (GRB5981)

The TypeButtonBorderColor property has an effect only in Windows 3.1 or Windows NT 3.5 (pre-Windows 95 operating systems. The button border appearance varies according to your operating system. In a pre-Windows 95 operating system, the button has a simple three-dimensional shading and a border. In Windows 95 or Windows NT 4.0 or later, the button has a complex three-dimensional shading and no border. Hence the TypeButtonBorderColor property has no effect. (JIS3727)

Rows now load properly in Virtual Mode when the spreadsheet is bound to a data control and you page up. (JOK4574)

If the Visible Property is set to false at design time, the border now paints around the spreadsheet when you set the Visible Property to true at run time. (JOK4673)

The Click event now fires when the OperationMode and AllowMultiBlocks properties are set to True and you select a row header using the mouse and the Shift key. (JOK4954)

The vertical scrollbar and scrollbar area are now hidden when the AutoSize and the ScrollBarExtMode properties are set to True and rows are hidden in the spreadsheet. (JOK4981)

You can now set the TypeFloatCurrencyChar property to ASCII values greater than 128. (KEM56)

When you print the spreadsheet in landscape mode, headers are now printed correctly and printing no longer causes an Out of Memory problem. (SCS6157)

When the TypeEditMultiLine property is set to True, cell data is no longer printed on multiple lines if the cell is not large enough to accommodate the data. (SCS6220)

Rows in the spreadsheet now display correctly when you have frozen rows, the top frozen row is hidden, and you scroll up from the first visible row. (SCS6298)

The headers and footers now print the correct font when the font is not an ANSI font. (SCS6439)

The GetCellFromScreenCoordinate function now returns a -1 when the mouse pointer is over the gray area. (SCS6871)

When the spreadsheet is in Virtual Mode and populated, the correct first record displays on the first virtual page. (SCS6922)

If you use the 32-bit ActiveX control in Visual Basic 4.0 (32-bit) and the spreadsheet is invisible, the CustomFunction event no longer causes Visual Basic to GPF. (SCS6967)

In the 32-bit DLL control, you can now copy text entered in an edit cell that allows horizontal scrolling. (SCS7006)

The EditError event now fires when you put a duplicate ID in a unique ID field. This event will fire only on controls that are cursor bound and not on controls that are simple bound. (SCS7062)

When you drag the mouse off the spreadsheet to the left to resize the first column, the column width is now set to zero. (SCS7126)

The correct cell now receives focus when you reload a tab file after deleting all spreadsheet rows in the file. (TEL1607)

The EditError event now fires when an editing error has occurred and you leave an Integer cell. (TEL2024)

Technical Issues Addressed -- Release Date 11/07/97 -- Version 2.5.25/35

If you are using Spread to display data from replicated tables, you can no longer create field names of s-Generation, s-GUID, or s-Lineage. We had to key from these names to identify that the spreadsheet is bound to a replicated table.

Pressing the Enter key to choose a button cell in the spreadsheet that unloads the spreadsheet no longer causes a GPF.

When the EditModePermanent property is set True, the KeyDown event now fires only once when you press the up arrow key. (CHB1226)

In Spread Designer, after you delete the Max Date value, you can now change the year in the Max Date year field to 2100. (CHB1284)

When you have the same item listed more than once in succession in a combo box cell and you select any of the same items other than the first item, the TypeComboCurSel property now returns the currently selected item. (CHB1339)

When RowsFrozen (ColsFrozen) is greater than or equal to 1 and only part of the first scrollable row (column) is visible, the TopLeftChange event no longer fires when you edit a cell in a frozen row (column). (CHB1371)

If you use the 32-bit ActiveX control in Visual Basic 5.0, pasting text characters in a float cell type no longer causes a GPF. (GIC2388)

Toggling the EditModePermanent property from False to True in the Click event no longer causes paint problems. However, you still cannot select columns while the EditModePermanent property is set to True. (GIC2443)

The cell contents no longer touch the grid line when you print a small spreadsheet on a 600dpi printer using the Action property setting 32 (Print). (GIL237)

In the Spread Designer, when you turn virtual mode on, by default, the VirtualMaxRows and MaxRows properties are set to 1 million rows. If you do not specify a value for the VirtualMaxRows property and you turn off virtual mode, the value of the MaxRows property is still set to 1 million rows. When you exit the Spread Designer, the control verifies row by row if any cell changed. If you exit the Spread Designer without changing the VirtualMaxRows or MaxRows property, the control will verify 1 million rows. The control appears to be hung when in reality it is checking the 1 million rows. Now, if you turn off virtual mode and exit Spread Designer, a message box appears asking whether of not you would like to reset the MaxRows property to its default value of 500 rows. (GIL346)

Selecting a check box in the first row before working in any other cell no longer causes an error. (GIL392)

If you choose the Esc button after selecting the check box in a check box cell, the correct state of the check box is shown (that is, the check mark is not displayed). (GIL395)

If you use the 16- or 32-bit ActiveX control ,an out of memory error no longer occurs when using the Clip or ClipValue property multiple times in succession. (GIL509)

When the spreadsheet has the focus, the EditModePermanent property is set to True, and the active cell is visible after scrolling, the TopLeftChange event now returns the correct oldtop and newtop values. (GIL684)

In float cells, the cursor is now positioned properly when you either use the arrow key to move from left to right in a cell or you highlight text from right to left and then press the Delete or Backspace key to delete a character. (GIL708)

When you have two buttons on a form (Button 1 loads a modeless form with a spreadsheet. Button 2 performs any action.) and you go into edit mode in the spreadsheet and then choose the Button 2, focus is now given to the correct button. (GIL742)

For the DLL and ActiveX controls, when you scroll horizontally or vertically, the TopLeftChange event now passes the correct value for the old top left cell. (GIL909)

When EditModePermanent is set to True, the spreadsheet now receives event notifications for the correct cell. (GIL1129)

For the VBX control, the spreadsheet now displays the correct number of columns and rows when you use the LoadFromFile and LoadFromTabFile functions after changing the maximum number of rows or columns. (GIL1132)

In virtual mode, when you scroll up to a new location outside the current virtual buffer, the spreadsheet now loads the data in the correct rows. (GIL1218)

If you use the ActiveX control in Visual Basic 5.0, you can now choose and set any color property available on the Color property page. (GIL1291)

If you are in the Spread Designer learn mode, select a date cell, and paste the code, the Date Min and Date Max settings now display the date in the correct format (mm/dd/yyy). (GIL1608)

Formulas that use an OR operator and have one empty parameter now return the correct result. (GIL2021)

You can now display a different mouse pointer when the pointer is over a button or check box cell. (GRB5514)

When using virtual mode and a partial row is displayed, the RowsNeeded parameter is now returning the correct data for the QueryData event. (GRB5519)

In Visual Basic 5.0, a user-created OCX containing a Spread 32-bit ActiveX control no longer GPFs when exiting the application. (GRB5678)

In parse routines, you can now use custom functions and custom names that begin with an underscore character. (GRB5705)

Invalid function and custom names are now being rejected by the spreadsheet. (GRB5706)

In Visual Basic 5.0, the spreadsheet now displays the first record in the database when the spreadsheet is bound to the Remote Data Control (version 2.0). (GRB5723)

When the ScrollBarExtMode and AutoSize properties are both set to True, the vertical and horizontal scroll bars no longer overlap. (GRB5773)

You can now set the LeftCol property in the LeaveCell event. (GRB5782)

When you have a large number of columns, the PrintAbort event now fires when using SmartPrint. (GRB5794)

If you are using the DLL control in Visual C++ 1.5x in Windows for Workgroups, painting the spreadsheet in landscape mode no longer causes a GDI leak. (GRB5803)

A memory leak no longer occurs when you repeatedly refresh the spreadsheet. (JAP4262)

If you use the VBX control in Visual Basic 3.0 or 16-bit 4.0, you can now change the MS SanSerif font size. Note: This problem will not be fixed in versions prior to Spread 2.5. (JAP4627)

Setting the TypeComboBoxCurSel property to a list item that is greater than 500 characters no longer causes a GPF. (JAP6269)

When virtual mode is on and the last row of the spreadsheet is empty, the last row of the spreadsheet no longer flickers when it is displayed. (JAP6276)

When the AllowMultiBlocks property is set to True, clicking in a cell to deselect a block of rows no longer causes a paint problem. (JAP6666)

Installation tools (such as InstallShield Express) will no longer attempt to register the SS32D25.DLL file. (JAP7304)

The SetCellDirtyFlag function is now included in the SSVBXMFC.CPP file. This function is included only for backward compatibility for VBX users of QE. (JAP7348)

In Visual Basic 4.0, when the ProcessTab property is set to True, Ctrl-Tab now moves the focus through child forms. However, in Visual Basic 5.0, the Ctrl-Tab combination does not work when any ActiveX control has the focus. (JAP7485)

The PrintAbort event fires only when the PrintAbortMsg is defined (that is, non-blank). (JAP7507) (SEL8115)

If you using German (Standard) settings, you can now type numbers in the decimal places. (JAP7567)

If you use the 32-bit ActiveX control in Visual Basic 5.0, setting the AutoSize property to True for a control with a small number of visible columns and rows no longer causes a GPF. (JAP7579)

The lpBufferLen parameter of the SSSaveToBuffer DLL function is now defined as LPLONG in the header files and documentation. (JAP7601)

In virtual mode, if you select the entire spreadsheet and copy it, the column header is now included. (JAP7654)

Float default characters are now only saved when they are specifically set. (JAP7688)

If you use the 32-bit ActiveX control, using the GetText method to retrieve data no longer causes memory leaks. (JAP7761)

When you load a .SS file, button cell types are now correctly displayed. (JAP7909)

The ButtonClicked event no longer fires when you use the LoadFromFile function or method to load a button cell type. (JAP7937)

When the AllowCellOverflow property is set to True, all data in all cells overflow into the next cell regardless of when data is entered in the cell. (JAP7942)

If you use the 32-bit ActiveX control in Visual Basic 4.0 or 5.0, the Spread control is no longer displayed in front of other controls. (JAP7989)

If you use the 32-bit DLL control in Borland C++ 5.0 under Windows NT, passing the HDC to the Spread control no longer causes a crash. (JAP8000)

The GetDataFillData function no longer gives an exception error if it reads a blank record. If this function reads a blank record it returns a True value and a return variant of VT_EMPTY. (JAP8051)

The drop-down arrow for a combo box now displays correctly after selecting a dialog box from the combo box drop-down list and then closing the dialog box.(JAP8080)

When printing the spreadsheet headers, they no longer overflow into the cells below them. (JAP8081)

Loading cell types multiple times into a large spreadsheet no longer causes a Smart Heap error. (JAP8094)

The resource leak that occurs every time the control selects a font into the hDC cannot be fixed without a change in Visual Basic 4.0/Windows. You can work around the problem by creating a control array of spreadsheets and loading and unloading them. For more information, contact the FarPoint technical support department. (JIS3410)

If you use the VBX in Visual Basic 3.0 and the AllowCellOverflow property is set to True, painting problems no longer occur in cells with overflow text. (SCS4154)

A program error no longer occurs when you change the Small Fonts font size in Spread Designer using the 32-bit ActiveX control in Visual C++ 5.0. (SCS6690)

In the Spread Designer, you can now highlight just part of the cell text, copy it to the clipboard, and paste it into another cell. (SEL13)

When the OperationMode property is set to 2 (Row Mode) or 3 (Single Select), the spreadsheet no longer receives the focus when you click on the scroll bar and the KeyPress, KeyDown, and KeyUp events now fire. (SEL23)

When virtual mode is on and the active row is the last row of the spreadsheet, the control now correctly resets the Direction parameter of the QueryData event. (SEL1207)

If you set the reference style to R1C1, applying a formula that contains both an absolute and relative row or column reference no longer causes Visual Basic to crash. However, the formula will be rejected because formulas cannot contain both an absolute and a relative reference. (SEL4003)

When you load or save a spreadsheet file under either of the following circumstances Windows no longer crashes: (1) If the spreadsheet file contains picture cells that have a NULL bitmap and include the VPS_HANDLE style or (2) If the spreadsheet file contains picture cells that have a non-NULL bitmap but do not include the VPS_BMP or VPS_ICON style. (SEL5626) (SEL8251)

When the MoveActiveOnFocus property is set to False and you move focus back to the spreadsheet by clicking the left mouse button, the Click event does not fire and the active cell does not move. This is the intended behavior of the MoveActiveOnFocus property. (SEL5775)

When the CellType property is set to Time and you assign a record set to the data control, the bound Spread control now displays the data without having to refresh the data control. (SEL6510)

When the EditModePermanent property is set to True for a combo box cell, the 5 (Next) setting of the EditEnterAction property now works correctly. (SEL6777)

When the OperationMode property is set to 2 (Row Mode), the ButtonDrawMode property is ignored. While the highlight bar is visible, no buttons are drawn. While the row is being edited, all the buttons in the current row are drawn. (SEL6810)

When the OperationMode property is set to Row Mode, if you set the AllowDragDrop property to True and you drag and drop a cell or block of cells, the entire row or rows containing the selected cell or cells are dragged and dropped. (SEL6836)

When edit mode is on, the Visual Basic KeyPreview property now receives the keystrokes sent to the Spread control. (SEL6851)

Typing non-ASCII (for example, ANSI) alphabetic characters in a PIC cell with the mask "9999" no longer causes a GPF. (SEL8047)

If you use the 16-bit ActiveX control, loading files in a loop no longer causes a GPF. (SEL8106)

If you use a bound Spread VBX control in Visual Basic 4.0, deleting a record with the Action property setting 5 (Delete Row) and then trying to delete the next record without moving the record pointer no longer causes a "No current record" error. (SEL8176)

When using Action property setting 15 (Data Save) after data in a static text cell is programatically changed, the Spread control can update more that 500 characters to a memo field. (SEL8312)

If a spreadsheet is very large and your system has limited free memory, the SSSaveToFile function now returns False instead of corrupting the spreadsheet. (SEL8390)

When virtual mode is on in a bound Spread control and you do a find first on the record set in the data control, the control now scrolls to the correct row. (SEL8410)

If you are using the 32-bit ActiveX control, you can now update a blank value from a time cell in a bound Spread control. (SEL95051)

If you use the VBX control in Visual Basic 3.0 and set the TypeTextPrefix property to False, the character succeeding an ampersand character (&) is no longer underlined. (SEL95056)

If you use the 16- or 32-bit ActiveX control and set the TypeTextPrefix property to True, the character succeeding the ampersand (&) is now underlined. (SEL95057)

Formulas that involve values larger than long integers are now calculated correctly. (SEL95109)

If a check box and button cell are in the same column or row, the MaxTextColWidth and MaxTextRowHeight properties now return the correct value. (TEL27)

If the TypeEditCharSet property is set to Alphanumeric or Numeric, the minus sign (-) is an acceptable character. (TEL172)

If you set the column or row to -1 when you write data to a block of cells, you cannot use the 19 (Copy Range), 20 (Move Range), 21 (Swap Range), 22 (Clipboard Copy), 23 (Clipboard Cut), or 24 (Clipboard Paste) settings of the Action property. DLL users cannot use the SSCopyRange, SSMoveRange, or SSSwapRange functions. (TEL367)

If you use the VBX control in Visual Basic 3.0, the row height is now displayed correctly when the row height is changed multiple times. (TEL2970)

In the Windows operating system, the non-client area is painted by the operating system. The client area is painted by the application or the control. If you do not display grid lines, borders, and headers, the top border (and adjacent grid line) of the top row and the left border (and adjacent grid line) of the left column are outside of the client area, and the CellBorderStyle property will not display border lines on the top or left side of the control. (TEL3595)

When the AutoClipboard property is set to False, Ctrl-X no longer cuts text from the spreadsheet. (TEL5701)

Technical Issues Addressed -- Release Date 12/06/96 -- Version 2.5.20

The check box cell now has three-state capability. For the DLL control, use the SSSetTypeCheckBox function. For the OCX/VBX control, use the new TypeCheckType property. For more information, refer to the function or property information in the Reference Guide section of the online help.

In the OCX control, you can now select a block of cells after setting the Action property to SS_ACTION_RESET. (GRB5135)

When using the VBX control in Visual Basic 3.0, moving off a new record no longer causes a GPF. (GRB5136)

The Spread Designer now writes the correct value for the SS_SELBLOCKOPT_BLOCKS setting for the SelectBlockOptions property during Learn Mode. (JAP4708)

In the Spread Designer, items added to a combo box cell in the Cell Type dialog box are now displayed after pressing the Apply button. (JAP5820)

In Windows 95, you can now start the 16-bit Spread Designer if the date in the Control Panel setting is set to a data greater than January 1, 1997. (JIS3503)

When the AllowDragDrop property is set to True and the SelectBlockOptions property is set to 0, you can now drag and drop the first cell in the last row or column. (JOK781)

In the Spread Designer, selecting a block of cells and setting the cell type to combo box no longer causes a GPF. (JOK835)

In the Spread Designer, duplicate mnemonics have been in all dialog boxes except the Print dialog box. (RIP6)

If you turn edit mode on, add items to an empty combo box cell, and turn edit mode off, items are now retained. (SCS4155)

Using the SSClip function in Visual C++ 1.5x no longer causes a GPF when building your application. (SCS4240)

In a 32-bit environment, loading more than 32K of data in a combo box cell using the TypeComboBox String property no longer causes a GPF. In a 16-bit environment, loading more than 64K of data in a combo box cell using the TypeComboBoxString property no longer .causes a GPF. (SCS4252)

The Spread control column widths now display correctly when bound to a remote data control whose ResultSet property is set to Nothing. (SEL6753)

A bound spreadsheet is now updated when a Seek action is performed on the Data control using code. (SEL6807)

The version information in the OCX control is now correct. (SEL6822)

Technical Issues Addressed -- Release Date 11/08/96 -- Version 2.5.15

When you move from a changed row to a new row in a bound spreadsheet, the new data from the changed row is now added to the database. (ARR94)

Loading data into the spreadsheet no longer causes a GPF. (ARR157)

The spreadsheet now displays the correct value for a float cell when you set the number of decimal places to zero. (ARR243)

Cells now resize properly using the drag-drop method. (ARR400)

When you delete rows, the DataRowCnt property now returns the correct value. (ARR748)

Cells are now highlighted correctly when edit mode is on. (ARR770)

Setting the active cell inside the Click event no longer causes the entire spreadsheet to be selected. (GRB1763)

Right-justified cells now paint correctly when you resize the cell. (GRB2118)

The spreadsheet now correctly validates the minimum and maximum values in an integer cell. (GRB2234)

The MouseUp event now occurs in the correct order when used with custom events associated with the button release. (GRB2438)

When using Windows NT 4.0 and the TypeTextPrefix property is set to True, text in a static text cell now prints correctly. (GRB2535)

When you set the Action property to SS_ACTION_RESET, the VScrollSpecial property is now reset to the default setting. (GRB2536)

The AllowCellOverflow property now works correctly with hidden rows. (GRB5117)

Setting the Action property to SS_ACTION_VMODE_REFRESH no longer causes a GPF. (JAP4025)

Performing a sort on a large number of rows no longer generates a Smart Heap error. (JAP4054)

If you load a Spread 2.1 spreadsheet before a Spread 2.5 spreadsheet, combo box cells in the Spread 2.5 spreadsheet now perform correctly. (JAP4176)

When using 16-bit, Visual Basic 4.0, font settings that are made using the Spread Designer are retained correctly when the project is run. (JAP4539)

Clicking on the same row header more than once to either select or deselect a row no longer causes two Click events to occur. (JAP4584)

The GetCellFromScreenCoord function now returns the correct coordinates when you click in cell (0, 0). (JAP4677)

When edit mode is on, the GetText function now returns the text instead of the value of the active cell. (JAP5039)

The CursorIcon property and the SS_CURSOR_STYLE_USER_DEFINED setting for the Cursor Style property are valid only for OCX controls. (JAP5133)

When you set the ScrollBarExtMode and AutoSize properties to True, the scroll bar area now paints correctly. (JAP5266)

When using the 16-bit OCX control, passing an uninitialized NULL variable into a cell no longer causes a GPF. (JAP5376)

When using the 32-bit DLL control, loading bitmaps and text no longer causes a resource leak. (JAP5457)

The NoBeep property now works properly for all invalid Ctrl-< > keystrokes. (JAP5662)

Spreadsheet files that have a large number of rows and virtual mode on now load in Spread Designer. (JAP5697)

Ctrl-double clicking a cell no longer causes a black border to be painted around the cell. (JIS3304)

Setting the NoBeep property to False now works correctly in all situations. (JIS3305)

When using the Unicode version of Spread, column widths are now correctly calculated and displayed for bound spreadsheets. (JIS3390)

When using the Spread Designer, different Fixedsys, Small Fonts, and Terminal font sizes are now supported. (JIS3394)

When using the Unicode version of Spread and you set the AutoSize property to True, the spreadsheet now resizes correctly. (JIS3395)

When using the 32-bit DLL control, changing the date in the Windows Control Panel to a date past January 19, 1996 no longer causes a GPF. (JIS3425)

When using the Spread Designer, if you leave the Min Date or Max Date box blank for a date cell, the box is reset to display the default values (1/1/1990 for Min Date, 12/31/2100 for Max Date). (JIS3429)

When using the Spread Designer, tabbed dialogs now display correctly. (JIS3483)

The Spread Designer title bars now display the correct Spread version number. (JIS3484)

Highlighted cells now paint correctly when you scroll through the spreadsheet. (JOK683)

The Spread Designer no longer locks up if you invoke the data binding option without setting the RecordSource property for the data control. (KEM3462)

When using the Spread Designer, you can now change the property settings for a picture cell after the picture is loaded. (RIP5)

When using the Spread Designer, Three State is no longer an option for the check box cell type. The check box does not have three state capability.(SCS2447)

When binding the Spread control to an integer field in an Access database, signed integers are now correctly displayed. (SCS2818)

When printing a spreadsheet in color, the background color now prints over the grid lines. (SCS3315)

The scroll bar now updates correctly when you set the Action property to SS_ACTION_ACTIVE_CELL inside the LeaveCell event. (SCS3482)

When the Action property is set to SS_ACTION_RESET, the spreadsheet now clears and resets property values much faster. (SCS3699)

When the AutoSize property is set to True and rows or columns are deleted, the correct number of visible rows and columns is now displayed. (SCS3711)

When using the 16-bit OCX control, owner drawn cells with screen coordinates greater than 32767 now print correctly. (SCS3719)

Time cells with a 24-hour format and a spin button no longer allow hour values greater than 24. (SCS3769)

When you load an empty tab-delimited file, you can now write back to the same file. (SCS3780)

When using the 32-bit OCX control, you can now select text in code within the KeyDown event for combo box cells. (SCS3994)

When you use Row = -1 to add a string to the lists of an entire column of combo box cells and the first combo box has an existing list, the first combo box now displays the new string. (SCS4002)

User-entered formulas in Spread 2.1 spreadsheet files are now correctly loaded in Spread 2.5. (SCS4003)

When you delete a Spread control, all font resources associated with the Spread control are now released. (SEL3431/SEL6622)

The mouse no longer freezes up when a breakpoint is reached in code in the MouseDown event. (SEL5155)

Setting the TypeEditLen to a value greater than 32767 no longer causes a Smart Heap error. (SEL5184)

When the OperationMode property is set to SS_OP_MODE_ROWMODE, the DInformActiveRowChange property is set to True, and the user clicks on a new row, the data control and other bound controls are now updated with data from the active row in the Spread control. (SEL5203)

When the BorderStyle property is set to NONE, the three-dimensional appearance of scroll bars is correctly displayed. (SEL5292)

Changing the font for a cell no longer causes the current row and all rows below it to be repainted. (SEL5312/SEL6059)

When the 32-bit OCX control is bound to a table and the AddNew, Update, MoveFirst, Edit, and Update (again) methods are used, the AbsolutePosition property now returns the first record. (SEL5433)

When using the 32-bit OCX control, the GetCellFromScreenCoord function now returns the correct coordinates only if the x and y parameters are in twips regardless of your development environment. (SEL5536)

Loading a spreadsheet file that contains picture cells with pictures no longer causes a GPF. (SEL5626)

The active cell border is now displayed correctly when the ProcessTab property is True and you tab from a cell in a frozen column across hidden columns into a column which is not entirely displayed. (SEL5658)

Pressing Esc to unload a modal form before moving the active cell to an editable cell no longer causes a GPF. (SEL5718)

The PrintAbort event now occurs and printing is canceled when the user clicks the Cancel button in a print in-progress dialog box. (SEL6032)

The Round, Roundup, and Truncate functions of the Formula property no longer cause a GPF when you enter a value in a cell whose address is one of the formula's variables. (SEL6074)

The BackColorStyle property now works correctly for static text cells. (SEL6127)

The Spread control no longer causes a GPF when Windows reuses the window handle of a destroyed spreadsheet for a new window. (SEL6314)

The 16-bit Spread Designer now runs if ctl3d.dll is not on the system (ctl3dv2.dll is loaded instead). (SEL6348)

When using the Spread Designer, the default Min Date value for a date cell now reflects the correct setting of 01011990. (SEL6471)

When using the Spread Designer, if you create a combo box cell and do not add any list items, the combo box no longer displays one blank item. (SEL6537)

When a column is bound to an integer field, the Spread control now returns the correct value without explicitly setting the cell type to integer. (SEL6541)

The cursor now moves correctly when the user types a special character (with an ASCII value >128) in a PIC cell using the Alt-xxx keyboard shortcut. (SEL6631)

When the EditModePermanent property is set to True, the EditEnterAction property is set to SS_CELL_EDITMODE_EXIT_NEXT, and you are currently in a combo box cell, pressing Enter now moves the focus and the cursor to the next cell. (TEL3550)

Technical Issues Addressed -- Release Date 8/19/96 -- Version 2.5.10

In Spread Designer, you can now display previously hidden columns or rows by setting the column or row width to -1. (JAP5179)

When the ScrollBarMax property is set to False, the vertical scroll bar range is 1 to either 20 or the DataRowCnt property value, whichever is greater. The horizontal scroll bar range is 1 to either 8 or the DataColCnt property value, whichever is greater. (JIS338)

The Spread control no longer GPFs when you populate a combo box cell with a string larger than 32767 characters. (KEM47)

The BackColorStyle property now works properly for static or owner drawn cell types. (SCS3511)

Values entered in a float cell with the TypeFloatDecimalPlaces property set to 2 and the TypeFloatSeparator property set to True no longer display a 0. (SCS3591)

Technical Issues Addressed -- Release Date 8/13/96 -- Version 2.5.05

The Spread control DLL now shows in Borland's Resource Workshop. (GRB1618)

Customizing header text using the Spread Designer is now easier to accomplish. (KEM3522)

The ColHidden check box in the Spread Designer now works correctly. (KEM3749)

The DataAddNew event now fires correctly when updating an empty database table. (KEM3762)

When the Spread control has the focus, closing an application by clicking on the icon in the upper left corner no longer causes a GPF. (JAP4544)

The GetCellFromScreenCoordinates now returns the correct coordinates for a cell in column header row or the row header column. (JAP4677)

Float cells with zero decimal places no longer truncate the decimal value. (KEM3755)

Choosing any option from the Unit Type dialog box in Spread Designer now works correctly.(SCS3144)

When the EditModePermanent property is set to True and the last column is locked, you can now scroll to the end of the spreadsheet. (SCS3218)

The 16-bit OCX Spread control now correctly writes data back to a database. (SCS3319)

The memory leak problem is now fixed. (SCS3383)

Binding a column of numeric data to a column of static text cells no longer causes a GPF when the form is loaded. (SEL5286)

In Windows 3.x, unloading a Spread VBX control on an MDI child form using a button in a Visual Basic picture box, a Visual Basic frame, or MicroHelp frame control no longer causes a GPF. (SEL5553)

If you are using Visual C++ 4.x and you have a frame window around the form view, buttons no longer require two key presses to be activated. (SEL5713)

When using a custom function inside the parameter list of another custom function, characters are no longer lost from the formula string. (SEL5720)

The truncate function of the Formula property now calculates floating point numbers with better precision. (SEL5799)

Long (multiple line) formulas are no longer truncated. (TEL2937)

Technical Issues Addressed -- Release Date 7/10/96 -- Version 2.5c

The online help now correctly documents the ButtonDown parameter for the ButtonClicked event as an integer value. (GRB1793)

Cells that overflow now print correctly. (GRB1964/1965)

Float cells now round correctly to the specified number of decimal places. (KEM3709)

When the Spread control is bound to a Microsoft Access 7.0 database, the database is now updated when data is written to it. (KEM3715)

You can now set the font to Wingdings. (SCS2929)

Changing the background or text color of cells in frozen rows or columns no longer causes a painting problem. (SEL2)

In Windows NT 3.5, the Spread control no longer causes a GPF when you set the row height equal to the value of the MaxTextRowHeight property while looping through more than nine rows.(SEL5105)

Picture cells now paint properly. (SEL5397)

The Spread control no longer GPFs when loading a spreadsheet that contains custom functions in the Form_Load event. (SEL5403)

Technical Issues Addressed -- Release Date 6/10/96 -- Version 2.5b2

When using the 32-bit OCX control in Visual C++ 4.0, all changes made by the Spread Designer are now updated in the Resource Compiler.

You can now use the Visual Basic 4.0 Setup Wizard to register the Spread control.

When a cell is in edit mode and a message box is displayed by clicking the right mouse button, the Spread control now receives the focus after the message box is closed. (GRB1617)

The Action property setting 8 (Load) now works correctly in Visual Basic 4.0. (GRB1834)

Rows and columns that frozen are no longer duplicated. (GBR1847)

The horizontal and vertical scroll bars now work properly when the ScrollBarMaxAlign property is set to True and columns are hidden. (GRB1861)

Data is now displayed in integer fields of bound spreadsheet controls. (JAP3696)

The GetClientArea and GetCellPos functions now return the height and width values in twips. (JAP4045)

When you display an icon in a picture cell whose background color is set to vbWindowBackground, the background no longer turns black. (JAP4167)

In Visual Basic 3.0, the combo box cell now works correctly when Spread version 2.1 is loaded before Spread version 2.5. (JAP4176)

Picture cells no longer cause memory leaks in Visual Basic 3.0. (JAP4201)

For the Spread OCX control, the Back Color Displays drop-down list box on the Display property page now includes the Over Horz Grid Only and Over Vert Grid Only list items. (JIS3266)

In a single select spreadsheet, invoking a drag method no longer causes the spreadsheet to scroll with mouse movement. (KEM3548)

When the Drag Mode property is set to 1 (Automatic), the scroll bars are now correctly displayed. (KEM3548)

When working with the Spread VBX control in Visual C++, using the SetText function to set the header text no longer causes a SmartHeap memory error. (KEM3636)

Setting the Action property 0 (Activate Cell) now updates the record pointer. (SCS2739)

The Text property now works properly when used within the KeyDown event. (SCS2798)

Spreadsheets saved using the old Interface Designer (.SS files) are now loaded correctly in the new Spread Designer. (SEL3850)

When the DAutoSave property is set to False, the Action (15Data Save) property now correctly saves inserted and modified rows in a bound spreadsheet. (SEL3984)

The MS Sans Serif 9.75 point font is now displayed correctly. (SEL5080)

When using Windows NT, the TypeIntegerMax and TypeIntegerMin properties are now processed much faster. (SEL5100)

Formulas are now updated correctly after sorting rows. (TEL1994)

Technical Issues Addressed -- Release Date 5/10/96 -- Version 2.5a

Within the MouseDown event, the GetCellFromScreenCoord function now returns the correct values for the Col and Rowparameters. (BOJ3070)

The Spread VBX control no longer GPFs when you set the DataField property for the row header column (column 0). (BOJ3703)

The KeyPress event will now process the pressing of the Enter key. (GRB814)

Formulas that involve columns are now updated correctly when the value of a cell is changed in code.(GRB1623)

You can now assign the value of the Picture property for another control (Image, for example) to the TypePictPicture, TypeButtonPicture, TypeButtonPictureDown, or TypeCheckPicture properties. (GRB1683)

When you set the background or foreground color of a block of cells, the color for that block now stays set when you change the background or foreground color of the spreadsheet. (JAP3695)

When you set the background color of a spreadsheet and you display only the horizontal (vertical) lines, you can now set the back color style to avoid spaces where the vertical (horizontal) lines cross the horizontal (vertical) lines. This can be set through the Spread Designer, the properties window, or in code. (JAP3757)

The row height value no longer decreases every time you reset it. (JAP3819)

When you have a command button (Default property = True) and a spreadsheet on a form, pressing the Enter key now fires the command button's Click event. (JAP3853)

Check box cells now display the correct data and picture when the Spread control is bound to a Microsoft Access database table. (JAP3883)

The Button parameter in the MouseMove event no longer returns a 1 when the mouse buttons are up. (JAP3957)

The Spread Designer now unlocks locked cells correctly. (JIS3201)

The Spread Designer no longer GPFs intermittently when you apply or exit the Spread Designer.(JIS3226)

The ProcessTab property now works correctly when the EditModePermanent property is True. (KEM3491)

The PrintType property, Cell Range setting now works correctly. (KEM3508)

The scroll box now resizes correctly based on the maximum number of rows in the spreadsheet. (KEM3520)

In the Spread Designer, the User Defined Text portion of the Headers dialog box has been redesigned and now works correctly. (KEM3522)

Invoking a Drag method for a Spread control in single select operation mode no longer causes the spreadsheet to scroll with mouse movement. (KEM3548)

The NoBeep property now works correctly. (KEM3618)

The SSSetFont and SSSetFontRange functions now work correctly when the column number is greater than 32767. (SCS2506)

When you set a color property to a system default color at design time, the system default color is no longer converted to a hex constant. (SCS2509)

The TypeCheckCenter property now works correctly when set for a range of cells. (SEL3466)

When the Spread control is in row mode or single select mode, the RetainSelBlock property is False, and you change the active cell, the new row is now highlighted.(SEL3553)

The drop-down list portion of multiple combobox cells on a spreadsheet now displays correctly. (SEL3639)

The SelBlockCol, SelBlockCol2, SelBlockRow, and SelBlockRow2, and the SSGetSelectBlock and SSGetMultiSelBlock functions now return a value of -1 when an entire row or an entire column is

selected. (SEL 3651).

The popup calendar in a date cell is now modal when the Spread control is in a modal dialog. (SEL3754)

The ButtonClicked event now fires for a button cell and correctly reflects the ButtonDown parameter as an integer type. (TEL1809)

The correct number of Change, EditMode, and LeaveCell events are fired now when EditModePermanent is set to True. (TEL1844)

Integer fields in a spreadsheet bound to a Microsoft Access database table now display correct data. (TEL1962)

In the Spread Designer, the Multiline check box on the Edit Cell Type dialog box now works correctly. (TEL1963)

The MaxTextRowHeight property now returns the correct row height for cells with short text lines and for static text cells. (TEL1977)

The Lock property is now working properly for the VBX control. (TEL2107)