FarPoint Technologies Spread 3 Fixed Bugs

Spread 3 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 11/27/01 -- Version 3.0.41
fpSpread control

If you use the ADO control, the ExportToExcel method no longer causes an error when you save the spreadsheet to an Excel file . (9447)

Spread Designer

If you use the DLL control and your spreadsheet contains date cells, saving the spreadsheet to an Excel file no longer causes a GPF . (9452)

Technical Issues Addressed -- Release Date 11/08/01 -- Version 3.0.40
fpSpread control

The corner pixels of the button now display the correct color when you sent the TypeButtonColor property. (4832/GRB7125)

If you use the Spread control on a web page, the scroll bars now print in Internet Explorer 5.5. (5415/GIC10742)

You can now load non-32x32 icons in the Spread control. (8092)

If the Windows regional settings are Arabic, right-aligned text now displays all characters. (8600)

If you use the List Pro fpCombo control in a Spread combo box cell and the TypeComboBoxEditable property is set to True, the ComboSelChange event now occurs when you use the arrow keys to scroll through the list items. (8652/GIC12446)

If the Windows regional settings are Norwegian (Bokmal), the correct default decimal character is now displayed in float cells. (8928)

You can now use long printer names when printing a Spread control. (8989)

If you use the List Pro fpCombo control in a Spread combo box cell, list items now display correctly in the cell. (9075)

If you use the List Pro fpCombo control in a Spread combo box cell, you do not have to set the TypeComboBoxEditable property to True to add a list item using the Text property. (9168)

The GetMultiSelItem function now returns hidden rows. (9210)

An error in the Shared String Table (SST) that caused problems loading Excel files has been fixed. (9287)

Several errors in the coversion of the Spread IF cases to an Excel IF stream have been fixed and no longer cause files exported to Excel to have problems in Excel. (9310)

If you use Windows ME and your regional settings are Dutch and Belgium, all data exported to an Excel file displays when you open the file in Excel. (9338)

If your regional settings are Spanish, the GetFloat method now returns the correct decimal character. (9401)

fpSpreadPreview control

The PrintPreview control now displays and scrolls the correct range of pages. (9173)

Spread Designer

Formulas are now saved when you choose Exit from the File menu and choose Okay on the Save File dialog. (9317)

Technical Issues Addressed -- Release Date 09/10/01 -- Version 3.0.39
fpSpread control

If you hide the grid lines and create a cell border, the complete cell border now shows when you print the spreadsheet. (9154)

If the first column is frozen and the operation mode is set to row mode, data typed in the first column now displays in the first column. (9197)

If you use the fpCombo control in a Spread combo box cell and the TypeComboBoxEditable property is set to False, the ComboSelChange event now occurs when you type a letter in the combo box edit field to select a list item. (9238)

An error in the Shared String Table (SST) that caused problems loading Excel files has been fixed. (9242)

If you use Simplified Chinese Windows regional settings and default character set, all characters display now when you type in a cell that is not in edit mode. (9265)

fpSpreadPreview control

The Print Preview control now shows the correct range of pages after scrolling. (9173)

Spread Designer

The text color no longer changes when you turn cell mode on and off. (9090)

Technical Issues Addressed -- Release Date 07/10/01 -- Version 3.0.37
fpSpread control

If you use the List Pro fpCombo control in a Spread combo box cell, the list text now displays in the cell. (9075)

If you import an Excel file and then use the ColWidth property to change the column width, the spreadsheet now displays the correct column width. (9063)

Technical Issues Addressed -- Release Date 06/22/01 -- Version 3.0.35
fpSpread control

If you use the Spread control in an HTML page, the control now displays correctly when you scroll down in Internet Explorer 5.5 or later. (8282)

Excel files that have a space in the filename now load without causing an access error. (8653)

If you set the EditModePermanent property to False and the form is an MDI child, the Spread control now displays the focus rectange when you run the project. (8654)

Spread now saves data in a block of cells that is dragged from the first page of the spreadsheet and dropped on another page. (8657)

The IsExcelFile method now returns a 2 (File is locked) if you try to use an Excel file in Spread that is currently open in Excel. (8659)

An error in the Shared String Table (SST) that caused problems loading Excel files has been fixed. (8662) (8683) (8927) (9038)

The default value of 1 now displays in the "Fit to" text box in the print preview dialog in Excel for a spreadsheet that is exported as an Excel file from Spread. (8670)

You must set both the PrintColHeaders and PrintRowHeaders to False if you do not want to print headers in Excel. (8675)

If you use the Spread 32-bit DLL control in Visual C++, the Len parameter of the SSSetTypeEdit function now correctly limits the number of characters that can be typed in the cell. (8691)

The setting of the AutoCalc property is now persisted when you save and reload a spreadsheet file. (8700)

The Spread control now responds to the OLEDBSimpleProvider setVariant function. (8708)

Properties set in the ComboSelChange event are now processed correctly. (8712)

If you add a record to a bound Spread control and press the Down Arrow key, the spreadsheet will now move the active cell to the next row. (8720)

If you set the AllowCellOverflow property to true for header cells, resizing the right-most column of the spreasheet no longer cause a problem with the text display. (8725)

If you use the 32-bit Spread DLL control in Windows 95 or 98, the constant SPREAD_COLOR_NONE now works correctly. (8726)

The Spread control now prints correctly if you set large page margins. (8727)

Spreadsheet files that contain a large number of pictures can now be loaded, saved, and reloaded without error. (8732)

If your computer uses a custom font setting, the GetCellPos method now returns the correct cell coordinates and cell height and width. (8758)

If you sort a check box cell and there is no text in the cell, the cell is sorted by check box state. (8787)

When you export a spreadsheet to Excel and use either a carriage return (0xd) or a linefeed (0xa), the Spread control will add either missing function. The Windows edit control requires both a carriage return AND a linefeed to create a "hard return". (8832)

If you set the TypeEditMultiLine property to True, the TypeVAlign property now works correctly. (8922)

If you right-align text in a file exported to HTML, the data now displays as right aligned in IE5 SP1. (8950)

Spread no longer causes a memory error if you set the Action property to 19 (Copy Range) and the amount of data is greater than 32K. (9006)

fpSpreadPreview control

If you use the fpSpreadPreview ActiveX control in Visual C++, the PageChange and Zoom events now occur when you click the preview control to zoom and then switch pages. (8725)

Spread Designer

When you use Learn Mode to generate code to outline a block of cells, the correct code is now generated. (5786)

When a column or row is selected, the settings for the column or row are now returned (previously returned the settings for the first cell in the column or row). (6129)

When you change the forecolor of a cell, enter data, and turn Cell Mode on and off, the forecolor no longer changes back to the default color. (8459)

If you select a block of cells and create a solid border for the right side, only the right border is created. Note that you cannot select a block of cells when a column is selected. (8478)

The online help has been corrected to reflect that you can create a custom name but you cannot create a custom function in the Spread Designer. (8556)

If you create a multiline cell, use Alt-Enter to force a line break, save the file, and reload it in Spread Designer, the last letter in the word at the line break now displays. (8760)

Technical Issues Addressed -- Release Date 11/15/00 -- Version 3.0.32
fpSpread control

When you import an Excel spreadsheet into Spread, you can now select blocks by using code at run time. (CHB7093)

When you import an Excel spreadsheet into Spread, the default money character now displays correctly in a float cell.(CHB7398)

The WEBADO30 example now displays the data correctly in IE5 when you change web sites. (GIC11800)

If you use Windows 95 or Windows 98, highlighted areas now paint correctly when scrolled into view. (GIC12139)

When a cell is not in edit mode, the KeyPress event now fires when you press Ctrl+C. (GIC12142) (SCS9734)

If you use an alphabetical character for the wKey parameter of the SetActionKey function, you must use uppercase letters. (GIC12161)

If you set the Windows Regional Settings to German (Standard), decimal values now display correctly. (GIC12166)

If you the EditModePermanent property to True and focus is on a combo box cell, you now only have to click a Command button once to get a response. (GIC12170)

If you use alphabetical characters for the SetActionKey function or method, you must use uppercase characters. (GIC12286)

The GetArray and SetArray methods no longer cause a memory leak. (SCS9714)

The Form KeyDown and KeyUp events now occur when you press the Delete key and the Spread control has the focus. (SCS9771)

If you set the CellBorderStyle property to any of the Fine settings (11-15), the spreadsheet print file is now normal in size. (SCS9822)

Copying and pasting a column from an exported Excel spreadsheet to another worksheet no longer causes a problem in Excel. (SCS9866)(SEL5033)

If you scroll the spreadsheet by clicking the scroll bar (not the scroll arrow or box), the cell background colors now paint correctly. (SCS9922)

Text in integer and float cells that is aligned to the right or center of the cell is now aligned correctly after the spreadsheet is exported and opened in Excel. (SCS9954)

Spread Designer

If you create a float cell, select the Money check box, type a number in the cell, save the file as an Excel file, and reopen the file in Spread Designer, the money symbol now displays in the cell and the check box is still selected. (GIC11985)

You can now set the TypeMaxEditLen property to a value greater than 999. (GIC12063)

Spread will now accept the "at" (@) sign in cells when you import an Excel spreadhsheet. (GIC12259)

Spread will now accept the greater than/less than symbol ("<>") when you import an Excel spreadsheet. (GIC12327)
Excel files that are marked read only can now be loaded in Spread using the GetExcelSheetList method. (GIC12387)

Technical Issues Addressed -- Release Date 5/17/00 -- Version 3.0.26
fpSpread control

When you export a spreadsheet with locked cells to an HTML file, the background and text color of locked cells now exports correctly. (GIC12052)

If you have a float cell with a with a comma as the decimal separator character, Spread no longer adds to zeros to the number when you type a number in the cell and then leave that cell. (GIC12062)

Technical Issues Addressed -- Release Date 5/12/00 -- Version 3.0.25
fpSpread control

Making changes to database record programmatically (SetCellDirtyFlag method, Action property 15 (Data Save), DAutoSave False) no longer cause edit error 104 (An error occurred during an Update function call to the Data Access Object). (CHB5338)

The ComboSelChange event now occurs when the user scrolls through a combo box cell list using the arrow keys. (CHB6061)

Spreadsheets now print correctly using an HP 4000 printer with the PCL 6 driver. (GIC8336)

The ExportToHTML function now returns a FALSE and a file is not written when and you try use the function when Spread is embedded in a web page. (GIC10752)

If you use the ActiveX control in Visual InterDev, the page up and page down keys now work. (GIC10882)

Spread now prints the header using the correct size font on pages after the first page. (GIC10886)

If you set your Windows Regional Settings to German (standard) and use either the ImportFromExcel function or the Spread Designer to import an Excel file, date and time values now appear correctly in the Spread control. (GIC10940)

When you set the DataFillEvent property to False, the DataFill event no longer fires. (GIC11069)

Setting the TypeIntegerMin property to 1 no longer causes an “Invalid property value” error. (GIC11153)

If list items in a combo box cell have the same value, the TypeComboBoxCurSel property now returns the correct selected list item number when used inside the ComboSelChange event. (GIC11160)

The LockBackColor property now works correctly with check box cells. (GIC11209)

If you set the active cell in the ComboCloseUp event for a combo box cell, the Change event returns the correct (changed) cell. (GIC11361)

The SaveToFile method now returns a True value when the file is saved. (GIC11550)

When you print the current spreadsheet page, the print preview control displays the page and Spread prints the page. (GIC11571)

The copy and paste functions on the edit popup menu now work correctly when you set the AutoClipboard property to False. (GIC11594)

After you load a binary file, the spreadsheet no longer causes a GPF when you scroll to the right edge of the spreadsheet and then scroll back to the left. (GIC11727)

If you set the wAction parameter of the SetActionKey function to 0 (Clear) for the Delete key no longer causes a navigation problem when typing numbers with a decimal symbol. (GIC11823)

If you set the RowHeight property in the ComboSelChange event code, the selected item now appears correctly in the edit field of the combo box. (GIC11950)

If use the fpCombo control in Spread and you set the TypeComboBoxEditable property to True, automatic searching now works correctly. (GIC11973)

If you use a message box in the ComboSelChange event, the correct index of the selected item now displays. (GIC11987)

Spread now displays type 139 (NUMBER) Oracle fields when the precision and scale are zero. (GRB7505)

Spread now displays the correct cursor after you resize a column or row. (GRB7510)

You can now set the WS_VSCROLL style bit on a edit cell. Note that no other WS stylebits are allowed in Spread. (SCS8934)

If you load a spreadsheet exported to an HTML file in IE5, the correct data is displayed when you use Ctrl-C/Ctrl-V to copy and paste from one cell to another. (SCS9037)

Edit mode now toggles correctly when you move off the spreadsheet to another form, close that form, and then go back to edit a cell in the spreadsheet. (GRB9157)

The tool tip now displays in the correct place when the cell for which the tool tip displays is on the right edge of the screen. (SCS9319)

When the TypeHAlign property is set to 1 (Right) and the AllowCellOverflow property is set to True, scrolling overflow data off and on screen no longer causes a problem. (SCS9486)

The Delete key now works correctly when you open the spreadsheet in Microsoft Access and try to delete data. (SCS9529)

When you set the ColsFrozen property to a value other than 0 and the AllowCellOverflow property to True, and the overflow text displays in cells with a non-white background color, moving another window over the spreadsheet where the overflow text is no longer causes a painting problem. (SCS9638)

If you have a number with a comma in an edit cell and you change the cell type to a float cell, the number now displays correctly. (SCS9645)

The SetArray function now works with HTML in scripting. (SCS9700)

The LockBackColor property now works with check box cells. (SEL5052)

Spread Designer

A spreadsheet that is exported to an Excel file now displays the font name in the formatting toolbar when you open the file in Excel. (CHB5950)

If you set your Windows Regional Settings to Norwegian (BokMal), you can now use the decimal point key on the number keypad. (GIC10710)

If you use the MOD function in a formula and the dividend is a negative number, the formula now displays the same result as Excel when you export the spreadsheet to an Excel file. (GIC10711)

A spreadsheet that contain cells with a large amount of data can now be exported to an HTML file without error. (GIC10754) (GIC10897)

A large spreadsheet that is exported to an Excel file no longer causes a memory error when you open the file in Excel. (GIC10912) (GIC10955) (GIC11352)

A spreadsheet that is exported to an Excel file now displays all the data in cells referenced by formulas. (GIC10982)

A spreadsheet that is exported to an Excel file no longer causes Excel to lock up when you click on a cell. (GIC11276)

Excel files that are marked read only can now be loaded in Spread using the GetExcelSheetList method. (GIC11343)

If you use MS San Serif font in a spreadsheet that is exported to an Excel file, the font no longer changes to Arial when you open the file in Excel. (GIC11667)

Cells in a non-password protected Excel file are now locked when you open and save the file in Spread and then reopen the file in Excel. (GIC11677)

A spreadsheet that is exported to an Excel file no longer causes a file format error when you open the file in Excel. (GIC11708)

If you set the TypeHAlign property to 0 (Left) and export the spreadsheet to Excel, text is now left-aligned in the cells. (GIC11733)

Column widths and row heights are now retained when you export the spreadsheet to an Excel file. (SCS8978)

Fonts no longer change when you import and export an Excel file. (SCS9062)

Spread no longer truncates cell text at 256 characters when loading an Excel file into the spreadsheet. (SCS9105)

A spreadsheet that is exported to an Excel file no longer causes a problem in Excel if you choose Style from the Format menu. (SCS9135)

Spreadsheets exported to an Excel file can now be opened in Excel without an error. (SCS9510)

fpSpreadPreview control

When you set the PageViewType property to 5 (Multiple Pages) and zoom in and out, the print preview control now displays correctly. (GIC11140) (TIB5988)

Technical Issues Addressed -- Release Date 9/21/99 -- Version 3.0.16
fpSpread control

If you use the ActiveX control, Spread no longer truncates numbers when you use the SetText method and load data from a variant array. (GIC10547)

If you use the ADO control and add new records to the recordset, Spread now displays the new data rows when the control is refreshed. (SCS8904)

If you set the EditModeReplace property to True and you highlight the default value in a float cell, values that you enter that are larger than 9 are now correctly displayed in the cell. (TIB5870)

Spread Designer

If you export a large spreadsheet (5000+ rows, 50+ columns) to an Excel file, you can now load that .XLS file in Spread Designer or Excel without problems. (GIC9513) (GIC10305)

A spreadsheet that is exported to an Excel file from Spread Designer or in code at run time no longer causes a memory reference error when you open the file in Excel and formulas are now exported correctly. (GIC10463)

Cell borders now display correctly in Excel when you export an spreadsheet file to an Excel file. (GIC10561)

Combo boxes and text boxes now display correctly in Spread Designer dialog boxes. (TIB5728)

Technical Issues Addressed -- Release Date 8/27/99 -- Version 3.0.15
fpSpread control

The fpSpread control now reads the numeric fields from an Oracle database using the Microsoft ODBC driver for Oracle. (CHB1417)

If you use the VBX control in VC++ 1.5x, the spreadsheet does not lock up when you try to edit cells at run time. (CHB5129)

If you use the ADO ActiveX control, updating the database after inserting a record no longer causes Edit error 104. (CHB5338)

If you use the ActiveX control, the Row property can now return a value greater than the MaxRows property. (GIC8667)

If you use the ActiveX ADO control and the CursorLocation property is set to adUseServer, the spreadsheet now reflects any changes made to a field in the database. (GIC8682)

The PrintFooter and PrintHeader properties have a new option, /pc, that calculates and inserts the page count in the footer or header. (GIC8974)

You can now set the TypeComboBoxCurSel property by typing an exact match in the combo box edit field. (GIC8997)

If you export a spreadsheet as an Excel file, you can now use the Format Cells option when you open the exported .XLS file in Excel. (GIC9006) (GIC9586) (GIC9637) (SCS8464)

When saving a spreadsheet with formulas to an .XLS file, the correct number of formula tokens are now added to the .XLS file during conversion. (GIC9089) (GIC9114) (GIC9468) (KEM24)

If you use the ActiveX ADO control, the fpSpread control now highlights the correct row when the recordset's current record is not the first one. (GIC9093)

If you use the ActiveX control, loading Excel spreadsheets that contain large text strings no longer causes an error. (GIC9132) (SCS8694)

The GetActionKey function works correctly if you set the fShift and fCtrl parameters to variables to be returned by the function. (GIC9141)

The SelBackColor property now displays the correct background color for check box cells. (GIC9183)

If you use the ActiveX control, loading large Excel spreadsheets no longer causes Visual Basic to lock up. You can also load these spreadsheets into FarPoint's Ex-con sample. (GIC9212) (GIC9494) (KEM23)

Excel no longer locks up when you use Ctrl+C and Ctrl+V to copy and paste data from a Spread-generated .XLS file to an Excel-generated .XLS file. (GIC9230)

If you use the ActiveX control, data is no longer truncated in spreadsheets with a large number of rows that were created in Spread, exported as an .XLS file, opened and changed in Excel, and then imported and reopened in Spread. (GIC9502)

If you use the ActiveX control, loading a password-protected Excel file into Spread no longer causes a GPF. Spread cannot load a password-protected Excel file. (GIC9678)

The GetExcelSheetList method now returns the correct number of sheets in a bound spreadsheet. Note that the GetExcelSheetList method now returns an integer value instead of a boolean value. If the return value is 0, the file is not an Excel file in BIFF 8 format. If the return value is 1, the file is an Excel file in BIFF 8 format. If the return value is 2, the file is locked or protected. (GIC9702)

The edit cursor displays in the correct position when you tab from cell to cell. (GIC9756)

Large float values that display separator characters and display with an exponential value no longer cause a GPF in Visual Basic. (GIC9830)

Button cells now display their cell borders correctly when you click cells and move around the spreadsheet. (GIC9831)

If you use the List Pro fpCombo control to enhance the Spread combo box cell, the combo box now displays data when you bind the combo box to a database and set the VirtualMode property (for the fpCombo control) to True. (GIC9839)

When you hide the last column in the spreadsheet, the border on the last column now displays correctly. (GIC9901)

Loading a large number of pictures in the spreadsheet no longer causes a memory leak. (GIC9926)

The page footer now prints correctly, if the spreadsheet has a single cell with more than one page of text. (GIC10017)

If you export a spreadsheet to an HTML file, most system colors are now converted correctly to web-safe colors. (GIC10056)

Conversion of the default cell background color has been optimized when you import a spreadsheet from Excel. (GIC10087)

If you set the Appearance property to 1 (3-D), the AutoSize and ScrollBarExtMode properties to True, and the MaxCols and MaxRow properties, the scroll bars do not display. (GIC10208)

If you set the TypeCheckCenter property to True for a combo box cell, the check box now displays in the center of the cell when the application runs in Windows 2000. (GIC10313)

If you set the background color of a check box cell to a dithered color, the background color now prints as white. (GIC10328)

If you use the List Pro fpCombo control in the Spread control and you set the TypeComboMaxDrop property to some value, the correct number of rows now display when the user presses the drop-down arrow. (GIC10394)

If you set the MaxRows property to 0 and click where row 1 would be, the row parameter of the Click event now returns the correct value. (GRB7392)

If you set the MaxRows property to 0, the ActiveRow property now returns the correct value. (GRB7427)

If you use the fpCombo control in the spreadsheet, the list with a large number of records (>98K) in a combo box cell now drops down. (JUW150)

If you set the TypeComboBoxEditable to True, the DataRowCnt property now returns the correct value when you enter and delete combo box list items. (JUW427)

If you set both the GridShowHoriz property and the GridShowVert property to False and the SelBackColor to a value other than the default value, the grid lines stay hidden. If either the GridShowHoriz property or the GridShowVert property is set to False, the grid lines will display. (JUW460)

If you populate the combo box cell using code in the ComboDropDown event, the combo box list drops down when the user clicks the drop-down arrow and closes when the user selects an item. (JUW497)

If you use the ActiveX ADO control in VC++ 6.0 and bind the fpSpread control to a database with date fields, the date data now displays in the spreadsheet. (KEM2)

If you use the ActiveX ADO control and MSDAC version 2.1 and the fpSpread control is bound to a database with memo fields, records are now updated when a memo field is modified in the spreadsheet. (KEM6)

For a combo box cell, text tips now display when part of the text in the edit field is obscured by the drop-down arrow. (KEM11)

If you use the ActiveX ADO control and bind the fpSpread control to a VB DataEnvironment control, you can now modify data in the first row of the spreadsheet. (KEM15)

Assigning a formula in the CustomFunction event no longer causes a MEM_BAD_HANDLE error. As a rule, you should not change a formula in the CustomFunction event as this could lead to unexpected results. (KEM18)

If you use the ActiveX ADO control, variant fields in dynamically created recordsets now work correctly in the spreadsheet. (KEM27)

If you use the ActiveX control in VC++ 6.0 and you create a custom cursor, you can now print in virtual mode. (KEM28)

If the cell border style is the same for all four sides of a cell, the CellBorderStyle property now returns the outline border style when the CellBorderType property is set to 16 (Outline). (KEM29)

In a combo box cell, the TypeComboBoxCurSel property now returns the selected item number when the list is dropped and the item is selected using keystrokes instead of the mouse. (KEM124)

If you use the ActiveX ADO control in VC++ 6.0 and you bind the fpSpread control to the MS ADO control, opening a dialog that contains an fpSpread control no longer causes an exception error. (KEM172)

Fonts are now resized correctly when the spreadsheet is printed in landscape mode using SmartPrint. (SCS7354)

If you use the ActiveX ADO control and you bind the fpSpread control to a client-side ADO recordset and a server-side recordset, spreadsheet changes are now made to both the client side and the server side recordset. (SCS8079)

If you use the ActiveX ADO control and change data in the recordset, the spreadsheet now updates to reflect the change. (SCS8095)

If you are using Visual Basic, the text tip now displays on multiple lines when the TextTipFetch event's MultiLine parameter is set to automatic and there is a vbCr (carriage return) in the text string. (SCS8202)

The GetCellFromScreenCoordinate function's Row parameter now returns a -1 when you set the row height, click on a row, and drag it off the grid area to scroll down the spreadsheet. (SCS8218)

The Edit menu displays now when a cell is in edit mode and you right click in the cell. (SCS8261)

If you export a spreadsheet with data in a single cell to an HTML file, the background color of the cell with data is no longer displayed in adjacent empty columns. (SCS8516)

You can now select any item in the list if you set the CellType property to 8 (Combo Box) for a cell that already contains data.(SCS8643)

When you load a spreadsheet from an Excel file, cells that were locked in the Excel file are now locked in the fpSpread control. (SCS8650)

If you want to return the border style or border color for a cell, you must first specify the side for which you want to return the style or color by setting the CellBorderType property. Then use the CellBorderStyle or CellBorderColor property to return the style or color. You must set the CellBorderType property each time you want to return the border style or color for a side of the cell. (SCS8723)

When bound to a database, the fpSpread control now disconnects from the database when the dialog containing the control is closed. (SCS8735)

If you set the VirtualMode property to True and export the spreadsheet to an Excel file, the entire spreadsheet is exported. (SCS8850)

If you use the ActiveX ADO control, you can now make an ADO connection through the ADO Data control to an Object Store database. (SCS8874)

If you use the ActiveX ADO control and bind the spreadsheet to a DataAdapter, the data now loads correctly. (SEL5011)

If you use the ActiveX ADO control in Visual C++ 6.0, you can now bind the fpSpread control to an ADO data source. (SEL5016)

The GetText function now returns an empty string when you set the Text property to " " for an integer or float cell. (TIB123)

When you export a spreadsheet as an HTML file, the effect of the RowHeight property setting displays correctly now in both IE 4 and IE 5. (TIB5503)

If you export a spreadsheet to an Excel file and open the file in Excel, clicking on the "$" or "%" key no longer causes an Excel error. (TIB5644)

The minimum date for the TypeDateMin property is 01011000 not 01010001 as previously documented. (TIB5702)

When you increase the row height of an integer cell, the cell text and spin button now display correctly. (TIB5703)

If you use the Clip property to set float cell values, the same decimal separator is now displayed for both the Danish and Swedish Windows regional settings. (WEB920621597671)

In a date cell with the format yyyy/mm/dd, the spin button now works properly for the month field based on the TypeDateMax and TypeDateMin property settings. (WEB923473323125)

fpSpreadPreview control

When you export a spreadsheet to an Excel file, load the file in Excel, and display gridlines, the gridlines display when you use Excel's print preview feature. (GIC10019)

The fpSpreadPreview control now scrolls through the pages when you use the SetPageCurrent functions and multiple pages are displayed. (ROP2)

System colors now display properly when you set any fpSpreadPreview control color property. (TIB5280)

Spread Designer

The Min Value and Max Value text boxes in the Cell Type dialog box for Integer cells are now wide enough to accept a 10-digit value. (GIC8693)

If you use the ActiveX DAO control in Windows 98, files opened in Spread Designer are now saved correctly as an .SS3 file. (GIC8975)

If you create a custom name, it does not cause the CustomFunction event to fire. The documentation has been corrected. (GIC9001)

Code generated in Learn Mode now contains the correct constant values for text tips. (KEM8)

If you define a combo box, check box, or picture cell type, set a user-defined picture, and then set another cell property, the user-defined picture is no longer reset to the default picture for that cell type. (KEM31)

If you lock a cell or change a font characteristic, you are now prompted to save changes if you close the designer window. (TIB145)

If you set decimal characters, separator characters, or currency characters in Spread Designer, these characters now display the correct character when you change the Windows regional settings. (TIB5287)

Technical Issues Addressed -- Release Date 3/30/99 -- Version 3.0.07
fpSpread control

If you use the ActiveX ADO control in Visual C++, an access violation no longer occurs when you open a workspace with the fpSpread control bound to an ADO control on a CFormView. (CHB110)

If you use the ActiveX control, setting the BorderStyle property to 0 (None) now works correctly. (CHB2098)

Relative cell references in formulas now work correctly when you import spreadsheets from and export spreadsheets to Excel. (GIC8585)

Because the Excel color palette contains only 40 colors, Spread uses a color approximation scheme to convert spreadsheet colors to Excel colors when you export spreadsheet files to Excel files. (GIC8586)

If you use the ActiveX control, set the Print Orientation property to 2 (Landscape) and the PrintSmart-Print property to True, the spreadsheet now prints in landscape mode. (GIC8656)

If you use the ActiveX control, the Row property no longer returns a value greater than the value of the MaxRows property. (GIC8667)

The amount of time it takes to unload a spreadsheet that contains a large number of rows is signifi-cantly improved. (GIC8729)

The CellBorderType property is now returning the correct value for a cell. (GIC8824)

Header and footers print correctly now. (GRB7364)

In Windows NT, printing spreadsheets using Smart Print and an Epson Stylus 600 Color printer no loonger causes NT to crash. (GRB7372)

If you use the fpSpread ActiveX ADO control in virtual mode, the scrollbars now work correctly . (KEM4)

Large files (>32K) that are created in Spread Designer and then exported as .XLS files no longer lock up Excel when loaded. (KEM173)

For Excel conversions, a log message has been added for exporting static text cells. Excel does not support the Spread static text cell type. The value of the Spread cell is been placed in the correspond-ing Excel cell, but the cell formatting is discarded. (KEM176)

When a float cell is in edit mode and you use Ctrl-V to paste in a number with two decimal places, the cell now displays the correct value. (TIB35)

Opening more than one project in Visual Basic 3 or 4 (16-bit) that contains the fpSpread VBX control no longer causes an error. (TIB172)

If you click on a check box cell to move the focus to another cell, put the move focus code in the But-tonClicked event (versus the Click event) to avoid focus rectangle painting problems. (TIB679)

If you use the fpSpread and RDO controls, when the recordset has 2 records and you click the arrows in the data control, focus now moves from one record to the other. (TIB768)

fpSpreadPreview control

If you use Windows 98, the scroll bars display and scroll correctly when the page size is greater than 60%. (TIB533)

Spread Designer

When you change the unit of measurement to twips, the row height and column width values are now converted correctly. (CHB124)

You can now enter 10-digit numbers for integer cells. (GIC8693)

If you select all the cells in the spreadsheet except the headers, switching between the Column and Row tabs in the Headers dialog box no longer causes Spread Designer to lock up. (GIC8940)

Reopening the check box Cell Type dialog box after creating a check box cell and applying the settings back to the fpSpread control no longer causes a Smart Heap error. (SCS8055)

Technical Issues Addressed -- Release Date 2/18/99 -- Version 3.0.06
fpSpread control

The fpSpread ADO control now reflects the correct number of rows when adding or deleting records in the database. (CHB1837)

If the focus is on a combo box cell, the Click event fires when you click a command button once. (CHB1949) (SCS7872)

Moving the scroll box or scroll arrows now work consistently when you have hidden columns or rows. (GIC2866)

For a combo box cell, the TypeComboBoxCurSel now returns a value of -1 when you clear the value of a selection or change the value of a selection using the Text property. (GIC7770)

All rows or columns of data are shown now when you set the MaxCols or MaxRows property and export the spreadsheet to an Excel file. (GIC8041)

Large files (>32K) that are created in Spread Designer and then exported as .XLS files no longer lock up Excel when loaded. (GIC8065) (GIC8223) (GRB7246) (KEM160)

When a float cell is in edit mode and you use Ctrl-V to paste in a number with one decimal place, the cell now displays the correct value. (GIC8083)

If you use the fpSpread ADO control, you can now edit bound cells after sorting. (GIC8207)

If you use the fpSpread ADO control, the correct data displays when the DataSource is reset. (GIC8435)

The correct value displays now in a float cell when you enter a negative number with more than two decimal places and the TypeFloatMoney property is set to True. (GIC8519)

If you use the fpSpread ADO control, data is not cleared if you call the Requery method on a control that has 9 or fewer records. (GRB7201)

If you use the fpSpread ADO control and the first time you call the Query method, it returns zero records, the second query now returns the correct number of records. (GRB7212)

The scroll box no longer changes size when you hide rows and scroll the spreadsheet past the hidden rows. (KEM139)

You can now invoke F1 help while in edit mode. (KEM 153)

If you have over 64K of data, Spread now performs a sort correctly. (KEM156)

The spreadsheet no longer flickers when the fpSpread control is on an MDI child, the MDI is loaded and minimized from the MDI DblClick message, and the form is maximized. (SCS7356)

The right side of the fpSpread control now paints correctly if the width of the control is wider than the desktop. (SCS7717)

In Windows 95 or Windows 98, very large Spread Designer files with check box cells that are loaded into the fpSpread control now paint correctly. (SCS7731)

Refreshing a spreadsheet with a large number of 256-color pictures no longer causes painting problems in the cells. (SCS7758)

If you use Windows NT, you can now print a spreadsheet with a landscape orientation. (SCS7796)

The fpSpread ADO control now updates itself when you set a new connection string to an ADODC. (SCS7909)

If you use the 32-bit DLL and you use a UserControl on a dialog with the class name of Spread to draw an fpSpread control on the dialog, the border now displays around the control. (SCS7931)

The print header now prints correctly within the specified print margins. (SCS7964)

When you bind Spread to the RemoteData control and move from record to record in the data control, focus moves to the correct row in the fpSpread control. (TIB768)

If you use the fpSpread ADO control, the fpSpread control now performs a query when an item is selected in any control bound to the same data source. (TIB805)

fpSpreadPreview control

If you use the 32-bit fpSpread control and you set the PrintSmartPrint property before the hWndSpread property, the headers and footers now display the correct font size. (SCS7826)

If you use Windows98 and the page percentage is set to a value greater than 60%, the print preview control now displays the horizontal scroll bar and the pages scroll correctly. (TIB533)

Spread Designer

You can now delete text and change text alignment in a check box cell. (GIC8024)

When you hide rows or columns, they display only if run-time mode is on. (GIC8364)

Active cell or block selections are now maintained when you switch between design mode and run-time mode. (SCS7619)