Spread 7.0 Fixed Problems


The problem tracking number appears in brackets [ ] after the description of each of the fixed problems. To search for a particular keyword or problem tracking number, select the Edit->Find menu option in the browser.

Where two numbers are given, the new number appears first followed by the original number from the older tracking system.

| Version 7.0.53 |
| Version 7.0.52 | Version 7.0.51 | Version 7.0.49 | Version 7.0.47 |
| Version 7.0.46 | Version 7.0.43 | Version 7.0.41 | Version 7.0.37 |
| Version 7.0.35 | Version 7.0.34 | Version 7.0.33 | Version 7.0.32 |
| Version 7.0.31 | Version 7.0.30 | Version 7.0.25 | Version 7.0.17 |
| Version 7.0.15 | Version 7.0.10 | Version 7.0.07 | Version 7.0.06 |

Technical Issues Addressed—Release Date 01/26/10—
Version 7.0.53

 fpSpread control
  • Certain Spread formatted files load faster. [26981]

Technical Issues Addressed—Release Date 07/09/09—
Version 7.0.52

 fpSpread control
  • Text is now correctly imported from an Excel-formatted file. [25147]
  • Data is copied and pasted correctly to an Excel-formatted file. [25092]
  • The SetTextTip property now works correctly. [22870]
  • Certain formulas now load correctly from Excel-formatted files. [19471]

Technical Issues Addressed—Release Date 12/11/08—
Version 7.0.51

 fpSpread control
  • The TypeHAlign and TypeEditMultiLine properties now work correctly when the control is bound. [23689]
  • The IsVisible function now works correctly. [22891]
  • Certain Excel-formatted files now load correctly. [22882]
  • The Spread Designer now works correctly when setting the text for the column headers. [22852]
  • The RowHeightToLogUnits function is now listed correctly in the ssdllmfc.h file. [16368]

Technical Issues Addressed—Release Date 08/28/08—
Version 7.0.49

 fpSpread control
  • The UserResizeRow property now works correctly. [22579]
  • The SetSelection method now works correctly. [22575]
  • Double values now work correctly in edit cells. [22489]
  • The delete key now works correctly with Microsoft Access. [21962]
  • The combo cell works correctly on a 64-bit machine. [21068]

Technical Issues Addressed—Release Date 04/17/08—
Version 7.0.47

 fpSpread control
  • The Spread control now displays correctly on a secondary monitor to the left of the primary monitor. [22331]
  • The Spread control no longer stops responding when closing the form. [22132]
  • The SearchCol method now finds custom header text. [22101]
  • The vertical scrollbar is now visible when using the fpCombo control in a Spread cell with dual monitors. [22020]
  • Closing the application after sorting now works correctly. [21963]
  • The preview control now displays cell spans correctly. [21902]

Technical Issues Addressed—Release Date 12/12/07—
Version 7.0.46

 fpSpread control
  • Exporting to an Excel-formatted file now works correctly if some columns have a width of zero. [21574]
  • Exporting certain types of data to an Excel-formatted file now works correctly. [21540]

Technical Issues Addressed—Release Date 10/24/07—
Version 7.0.43

 fpSpread control
  • Page breaks are now correctly exported to an Excel-formatted file. [21321]
  • The SetText method now works correctly with the control object. [21204]
  • The SetTypeComboBoxEx function now works correctly with a secondary monitor. [21160]
  • The correct item is now selected when using fpcombo in the Spread control. [21093]
  • The program no longer stops responding when loading Spread files that have many formulas. [21070]
  • The DataSave method and the DAutoSave property now work correctly. [20995]
  • Exporting frozen rows to an Excel-formatted file now works correctly. [20993]
  • The OLE drag and drop now works correctly when switching buttons. [20871]
  • Exporting Hebrew characters to an Excel-formatted file now works correctly. [20862]
  • The preview control now works correctly with the mouse wheel. [20859]
  • Deleting sheets and saving to an Excel-formatted file now works correctly. [20662]
  • Binding to a filtered recordset in virtual mode now works correctly. [11457]

Technical Issues Addressed—Release Date 07/02/07—
Version 7.0.41

 fpSpread control
  • The ExportToHTML method now works correctly when assigning a picture to a column. [20548]
  • Text tips now display correctly with dual monitors. [20536]
  • Grid lines now show up in the header area when printing. [20492]
  • Page breaks are ignored when using the best fit printing option. [20491]
  • Text in header cells is now correctly aligned. [20480]
  • Certain Excel-formatted files now load correctly. [20415]
  • The EditModeReplace property now works correctly with date cells. [20391]
  • The ComboSelChange event now works correctly when using an Fpcombo control in a Spread combo box cell. [20390]
  • The FpImage.DLL now has the correct version number. [20388]
  • The scrollbar now works correctly on a web page. [20369]
  • The ExportToExcel method now works correctly when saving a file to a long folder name. [20364]
  • The Reset method no longer causes the program to stop responding. [20341]
  • Certain numbers are now rounded correctly. [20320]
  • The PrintScalingMethod now works correctly with the best fit option. [20312]
  • The AutoSize property now works correctly when the Spread control is on a web page. [20261]
  • The DeleteSheets method now works correctly. [20174]
  • The SaveTabFileU method now works correctly with long file names. [20152]
  • The focus now works correctly with Spread and Microsoft Visual Studio .Net 2003. [20059]
  • Cells that are right justified in an Excel-formatted file are now imported correctly. [19750]

Technical Issues Addressed—Release Date 03/14/07—
Version 7.0.37

 fpSpread control
  • The print preview control now works correctly if there are many rows. [19951]
  • The backspace key now works correctly with negative numbers. [19939]
  • Saving to an Excel-formatted file now works correctly if using a long file name or path. [19835]
  • The LoadPicture method now works correctly under Windows Vista. [19827]
  • The PrintScalingMethod property now works correctly when using best fit options. [19803]
  • Certain formulas are now exported correctly to an Excel-formatted file. [19748]
  • Saving to a memo field now works correctly. [19696]
  • Printing to legal size paper now works correctly when using smart print. [19624]
  • The SwapRange method now works correctly if the TypeEditMultiLine property is True and the cell is in edit mode. [19609]
  • Certain formulas are now exported correctly to an Excel-formatted file. [19593]
  • Data from Excel-formatted files with special formatting now loads correctly. [19564]
  • Certain Excel-formatted files now import correctly. [19561]
  • Certain formulas are now exported correctly to an Excel-formatted file. [19557]
  • Formulas with sheet references are now exported correctly. [18876]
  • Excel-formatted files with true and false values now import correctly. [18783]
  • The PrintBestFitPagesTall and PrintBestFitPagesWide properties are now exported when saving to an Excel-formatted file. [18756]
  • Making changes in a bound Spread control no longer causes memory leaks. [18029]
  • The TypeTextWordWrap property now works correctly when exporting to html. [15629]

Technical Issues Addressed—Release Date 09/27/06—
Version 7.0.35

 fpSpread control
  • Typing into a combo box cell when the TypeComboBoxEditable property is true now works correctly. [19475]
  • The ScrollBarExtMode property now works correctly when the height is 255. [19431]
  • Certain Excel-formatted files now export correctly. [19275]
  • Certain Excel-formatted files now import correctly. [18495]
  • The Spread Designer now saves changes only applied to the row header label. [18107]

Technical Issues Addressed—Release Date 08/17/06—
Version 7.0.34

 fpSpread control
  • Formulas now work correctly with the regional settings set to French. [19236]
  • The GetText method now works correctly in a Web browser. [19224]
  • The Spread control now displays correctly when setting the TypeHAlign property and the ColWidth property. [19223]
  • The SSM_DATACHANGE message now fires correctly. [19129]
  • The control no longer stops responding when setting the MaxRows property to 0 if no headers are displayed. [19098]
  • The Escape key now closes the combo box cell drop-down list if it is open. [19089]
  • The PrintBestFitPagesTall property now supports a value up to 999. [19014]
  • Owner-drawn cells now work correctly with the Spread print preview control. [18850]
  • The row height now works correctly with multiple sheets. [18838]
  • The scroll bars now work correctly when increasing the total number of rows. [18767]
  • The SSOCX.H file now has the correct information for setting the type of a cell. [18433]

Technical Issues Addressed—Release Date 03/21/06—
Version 7.0.33

 fpSpread control
  • The ExportToTextFile and ExportRangeToTextFile methods have a new flag. [18231]
  • Sorting now works correctly if the AllowColMove property is set to True. [18199]
  • The fpCombo control in the Spread combo box cell now works correctly when the mouse buttons are switched. [18177]
  • The ClearRange method now works correctly with cells that overflow. [18083]
  • The LeaveCell event now is raised if the UserColAction property is set to sort. [12436]

Technical Issues Addressed—Release Date 01/05/06—
Version 7.0.32

 fpSpread control
  • Text now paints faster when scrolling with the unicode OCX. [17903]
  • The alignment in a combo box cell type is now correctly exported to an HTML page. [17888]
  • The ClearRange method now works correctly when the MaxRows property is zero. [17832]
  • Formulas involving custom names are now updated correctly when a row is inserted. [17647]
  • The ClearRange method has been enhanced. [17646]
  • Certain dates now load correctly when importing an Excel-formatted file. [17618]
  • Formula functions with large numbers that check for equality now work correctly. [17569]
  • Certain numbers display correctly when the decimal places property is set. [17533]
  • Certain Excel-formatted files now load correctly. [17523]
  • Loading and exporting certain Excel-formatted files no longer creates excessively large files. [17421]
  • Grid lines do not print when exporting to an Excel-formatted file if vertical and horizontal grid lines are set to false. [17420]
  • Certain Excel-formatted files now load correctly. [17418]
  • Font handles are now managed correctly. [17372]
  • Loading multiple Excel-formatted files many times now works correctly. [17352]
  • The Tab key now tabs out of the Spread control in Microsoft Visual Studio .NET. [17351]
  • Loading a Spread control in a web page with 256 colors now works correctly. [17337]
  • The LeaveCell event is raised correctly now. [17296]
  • Text tips no longer show up in a different application. [17280]
  • The shortcut menu no longer shows up over combo box cells that cannot be edited and check box cells. [17263]
  • Paging to the last row with virtual mode now works correctly. [17155]
  • The Spread Designer now returns the correct cell type after copying a cell. [17126]
  • Spanned check box cells now respond to mouse clicks correctly. [17125]
  • The selected block is now painting correctly if the selection requires scrolling. [17072]
  • The SSSaveBlockToBuffer function now copies the cell tag. [17019]
  • Sorting now works correctly with extended selection operation mode. [16994]
  • The tab key no longer skips the first cell when tabbing from another control to Spread in Microsoft Visual Studio .NET. [16974]
  • The Change event is raised correctly now for formulas on the non-active sheet. [16925]
  • Using the Page Up key no longer makes a hidden row the active row. [16915]

Technical Issues Addressed—Release Date 09/12/05—
Version 7.0.31

 fpSpread control
  • The InsertRows method now works correctly on a web page. [16692]
  • Using LoadTabFile to load a file now works fine with both the non-Unicode OCX and the Unicode OCX. [16649]
  • The program no longer stops responding when using the MaxTextColWidth method with multiple headers when the VirtualMode property is set to true. [16572]
  • With the AllowColMove property set to true, clicking the right mouse button in the middle of dragging the column no longer causes painting issues. [16571]
  • Certain Spread formatted files now paint correctly when editing. [16545]
  • Certain Excel files now load correctly. [16457]
  • Button, check box, and combo box cells now paint correctly if selected in a selected block. [16445]
  • The SS_CalcSetData function now clears the cell in the case of formulas being evaluated that reference cells of different cell types. [16443]
  • The Spread control can now be added to a form in Microsoft Visual Studio 2005 Beta. [16376]
  • The RowHeightToLogUnits function has been updated in ssdllmfc.h. [16368]
  • Creating and deleting the control no longer causes memory leaks. [16366]
  • Certain formulas now calculate correctly when exported to an Excel-formatted file. [16358]
  • Merging now works correctly in the headers. [16346]
  • Exporting many rows of data now works correctly. [16337]
  • The /date and /time options for the PrintHeader and PrintFooter properties now work in the Spread Designer. [16325]
  • The GetBottomRightCell method now returns the correct values in the TopLeftChange event. [16317]
  • The PrintHeader is now previewed correctly when PageView is set to Whole or Normal with Percentage less than 100%. [16316]
  • Changing the number of decimal places of a cell with a formula in the Spread Designer no longer removes the formula. [16311]
  • The PrintSheet method now works correctly when setting the PrintOrientation property. [16309]
  • The LoadTabFile method now works correctly when the file is loaded over existing data. [16302]

Technical Issues Addressed—Release Date 05/20/05—
Version 7.0.30

 fpSpread control
  • The SSM_EDITMODEON message no longer gets called twice when clicking on a combo box or check box cell with SSB_EDITMODEPERMANENT set to true. [16245]
  • The SortKey property can now use other columns in the row header as the sort key. [16218]
  • Setting the TypeComboBoxWidth property to 1 (or -1) now works correctly with the fpCombo control. [16170]
  • Exporting a smaller Excel-formatted file over a larger file now works correctly. [16120]
  • The first two columns are no longer blank when exporting certain Spread controls to an Excel-formatted file. [16089]
  • The SelStart property now goes to the right location in the EditChange event. [16070]
  • Formulas with wildcards now recalculate when the dependency cells change. [16025]
  • The key events now fire for up and down arrow keys if the EditModePermanent and TypeComboBoxEditable properties are set to True. [16021]
  • Text returned from a spanned PIC (mask) cell is now returned correctly. [16009]
  • The arrow keys now select items from an open drop-down list in a combo box cell. [16000]
  • The GetArray method now uses the separator symbol from the regional settings when filling a double array from edit cells. [15975]
  • Time cells in an Excel-formatted file with the format of 37:30:55 are imported now as number cells with the numeric value of the time. [15972]
  • The time cell now works correctly with the EditModePermanent property. [15408]

Technical Issues Addressed—Release Date 03/14/05—
Version 7.0.25

 fpSpread control
  • The SearchCol method no longer causes memory issues. [15859]
  • The ComboSelChange event no longer fires when you first open a List Pro fpCombo control in a combo box cell. [15810]
  • The ArrowsExitEditMode property now works correctly in other programming environments. [15782]
  • Certain cell formats in an xls file now import correctly. [15781]
  • The decimal key on the number key pad now works correctly in a scientific cell. [15571]
  • The thumb bar now works correctly when the ScrollBarShowMax property is set to False. [15763]
  • The ExportToXML method now allows longer tags. [15752]
  • The MaxTextRowHeight property now temporarily takes the cell out of edit mode. [15697).
  • Typing into a float cell with the number pad and using a down arrow key now works correctly. [15673]
  • The standard shortcut menu no longer loads when loading a menu using code with a currency cell. [15670]
  • The nPageNum parameter of the SS_Print function now starts with page 1. [15641]
  • Importing an Excel-formatted file created under Danish that uses the IF formula now loads correctly. [15640]
  • Setting page breaks with certain printing options no longer causes the program to stop responding. [15577]
  • Certain Excel-formatted files are now imported correctly. [15549]
  • Exporting print scaling settings to an Excel-formatted file now works correctly. [15544]
  • Copying cells with formulas that contain relative cell references to cells that do not exist, no longer causes the application to stop responding. [15509]
  • Setting the TypeTimeMin and TypeTimeMax properties now works correctly. [15473]
  • The user is no longer allowed to type 0 if the TypeDateCentury property is set to True. [15462]
  • Loading an SS7 file with an invisible sheet no longer shows the sheet. [15457]
  • The Unicode version of the Spread control now handles certain formulas correctly. [15424]
  • The program no longer stops responding when using Control-C after loading a text file. [15412]
  • The tab strip now updates correctly when deleting sheets. [15405]
  • Searching on a sorted, bound control in virtual mode now works correctly. [15391]
  • Exporting a column with a width greater than 96 to an Excel-formatted file now works correctly. [15365]
  • Painting now works correctly with the OperationMode property set to single select and no grid lines. [15363]
  • Setting the Redraw property to True and hiding rows no longer causes the application to stop responding. [15360]
  • Japanese characters are now saved to XML correctly. [15348]
  • The SSReCalc function now works correctly with custom functions in an ATL based project. [15342]
  • The text now shows up in the combo box cell when typing if the form's KeyPreview property is True and IME mode is used. [15320]
  • Formulas with percent values are now imported correctly. [15302]
  • Certain fonts are now loaded correctly from Excel-formatted files. [15301]
  • Certain Excel-formatted files now load correctly. [15282]
  • Setting text in a combo box cell now works correctly if the cell is editable. [15269]
  • Using the DoEvents method in the BeforeUserSort event no longer causes painting issues. [15215]
  • Setting a cell note to empty string now works correctly. [15180]
  • Setting the AutoSize property at design time now works correctly. [15121]
  • The MoveRowRange method no longer causes the program to stop responding when using certain invalid values. [15117]
  • The TextTipFetch event now fires properly in Visual Studio C++ version 6. [13494]

Technical Issues Addressed—Release Date 08/26/04—
Version 7.0.17

 fpSpread control
  • The QueryData event now fires when using the virtual refresh. [15078]
  • The Windows shortcut menu no longer displays when you right click on a button cell type. [15062]
  • The DataRowCnt property now returns the correct number after sorting. [15058]
  • Exporting to an Excel-formatted file now works correctly with certain color settings. [15056]
  • The Unicode version of the Spread control now shows database values correctly. [15054]
  • Typing into a number cell with the number pad and using a down arrow key now works correctly. [15035]
  • Changing the active cell to a cell with a text tip now works correctly. [15023]
  • The SheetSendingEvent property now works correctly in the custom function event. [15015]
  • The Unicode version of the Spread control now handles data in the OLEDragDrop event correctly. [14996]
  • Sorting now works correctly after loading a Spread formatted file. [14976]
  • The CellTag property now works with the BlockMode property. [14971]
  • Settings for the PrintZoomFactor property are now exported to an Excel-formatted file. [14921]
  • The date and time settings in the PrintHeader property now work on an HTML page. [14443]
  • The history list in the Spread Designer no longer changes the sheet names under certain situations. [14118]

Technical Issues Addressed—Release Date 07/21/04—
Version 7.0.15

 fpSpread control
  • Exporting absolute formula references to an Excel-formatted file now works correctly. [14855]
  • Loading an SS7 file created from an Excel-formatted file no longer causes the program to stop responding. [14850]
  • The correct value is now returned when getting text for a different sheet using the ComboSelChange event. [14831]
  • The PrintHeader and PrintFooter properties are now loaded correctly from an SS7 file. [14800).
  • The /pc option of the PrintFooter property now returns the correct number of pages. [14740]
  • The TypeHAlign property now works correctly. [14702]
  • Certain Excel-formatted files now load correctly. [14500], [14594]
  • The text tip goes away when moving the mouse on another application (after using alt-tab to load it). [14510]
  • Deleting a row that contains a formula reference to a large cell number takes less time. [14466)
  • Dragging data from an Excel-formatted file to Spread now works correctly with the Unicode OCX. [14354]
  • Retrieving the datasource now works correctly. [14046]

Technical Issues Addressed—Release Date 05/26/04—
Version 7.0.10

 fpSpread control
  • Double fields now show up correctly when binding the Unicode version of the Spread control. [14467]
  • The ExportToHTML method now exports pictures correctly. [14384]
  • Custom names are now imported when importing from an Excel-formatted file. [14365]
  • Setting the TypeTextWordWrap property to True no longer causes the MaxTextCellHeight property to return a value 1 pixel larger than if the property was set to False. [14364]
  • Certain formulas are now exported to an Excel-formatted file correctly. [14329]
  • The PrintOrientation property is now exported to an Excel-formatted file. [14303]
  • The printing speed in the Unicode version of the Spread control is now similar to the printing speed in the non-Unicode version. [14167]
  • The ColumnWidthChange event no longer fires before the column width changes, when double clicking the column header to resize the column. [14161]
  • Setting the DataMember property after setting the data source to nothing no longer causes the program to stop. [14148]
  • The ColWidthChange event now returns the correct width when using the automatic size option of the UserColAction property. [14131]
  • The BlockSelected event no longer fires if you are selecting rows with the mouse when the OperationMode property is extended select. [14116]
  • The ImportExcelSheet method no longer imports a blank sheet when loading multiple sheets in a loop. [14110]
  • The ImportExcelSheet method now imports the data into the correct sheet when setting the Sheet property. [14071]
  • Text tips now work under NT4. [14048]
  • The ExportToHTML function now works correctly with spaces. [14022]
  • The DeleteCols method now deletes headers correctly. [14021]

Technical Issues Addressed—Release Date 04/06/04—
Version 7.0.07

 fpSpread control
  • The ImportExcelSheet method now works correctly when the control contains multiple sheets. [13955]

Technical Issues Addressed—Release Date 03/19/04—
Version 7.0.06

 fpSpread control
  • The GDI resources no longer increase when changing tabs. [13930]
  • Sorting by clicking on column headers now works with extended select operation mode. [13903]
  • The ReCalc method now works correctly. [13901]
© 2002-2010, GrapeCity, Inc. All rights reserved.