Spread 6 Fixed Problems - Technical Support

Spread 6.0 Fixed Problems

The problem tracking number appears after the description in square brackets.

Select Edit->Find in the browser menu to search for a particular keyword or tracking number.

| Version 6.0.57 | Version 6.0.56 | Version 6.0.55 | Version 6.0.50 |
| Version 6.0.45 | Version 6.0.40 | Version 6.0.32 | Version 6.0.31 |
| Version 6.0.30 | Version 6.0.27 | Version 6.0.25 | Version 6.0.18 |
| Version 6.0.17 | Version 6.0.16 | Version 6.0.11 | Version 6.0.10 |
| Version 6.0.06 | Version 6.0.05 |

Technical Issues Addressed—Release Date 03/21/06—Version 6.0.57
fpSpread control

The ExportToTextFile and ExportRangeToTextFile methods have a new flag. [18231]

Technical Issues Addressed—Release Date 01/05/06—Version 6.0.56
fpSpread control

The number cell type now rounds correctly when using the SetText method. [12556]

The ProcessTab property now works correctly. [12917]

The GetBottomRightCell method now returns the correct values in the TopLeftChange event. [16317]

There is no longer a delay when using the down arrow key to move over a section of hidden rows. [16323]

The selected item in a combo cell using the fpcombo control now updates faster. [16327]

Exporting certain types of data to an Excel-formatted file now works correctly. [16353]

Certain Excel files now load correctly. [16457]

Certain Spread formatted files export correctly. [17206]

Editing numbers in a float cell now works correctly. [17882]

Technical Issues Addressed—Release Date 05/20/05—Version 6.0.55
fpSpread control

The SelStart property now goes to the right location in the EditChange event. [16070]

The GetTypeComboBoxCurSel property returns the correct value in the ComboSelChange event. [16086]

Certain time cells now import correctly when using the ImportExcelSheet method. [16108]

The Spread control now works correctly with the context menu control. [16154]

The SortKey property can now use other columns in the row header as the sort key. [16218]

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]

Technical Issues Addressed—Release Date 03/14/05—Version 6.0.50
fpSpread control

The Spread designer now picks up supported date formats from control panel. [15200]

Certain fonts are now loaded correctly from Excel files. [15301]

Loading and sorting certain ss6 files no longer causes the program to stop responding. [15321]

The user is no longer allowed to type 0 if the TypeDateCentury property is set to true. [15462]

Copying cells with formulas that contain relative cell references to cells that do not exist, no longer causes the application to stop responding. [15509]

Certain Excel files are now imported correctly. [15549]

The nPageNum parameter of the SS_Print function now starts with page 1. [15641]

Setting text in an editable combo cell now works correctly with the Spread DLL and OCX. [15733], [15269]

The Spread DLL now paints correctly when putting data in a cell with single select operation mode. [15735]

The ExportToXML method now allows longer tags. [15752]

The ComboSelChange event no longer fires when you first open a List Pro fpcombo control in a combo cell. [15810]

Using the fpcombo control in a column of combo cells now shows the correct selected item. [15823]

The SearchCol method no longer causes memory issues. [15859]

Technical Issues Addressed—Release Date 09/01/04—Version 6.0.45
fpSpread control

Loading certain formulas from an SS3 file now works correctly. [14954]

The QueryData event now fires when using the VirtualRefresh method. [15004]

Changing the active cell to a cell with a text tip now works correctly. [15040]

The Windows shortcut menu no longer comes up over a button cell when right clicking on the cell. [15062]

Opening and closing the VB form multiple times no longer causes the incorrect formula value to show up in a cell when control panel is set to German. [15071]

Technical Issues Addressed—Release Date 07/13/04—Version 6.0.40
fpSpread control

The DeleteCols method now deletes headers correctly. [14021]

The TypeMaxEditLen property now works correctly with combo cells. [14047]

Text tips now work under NT4. [14048]

Using the Find method on a recordset bound to a virtual Spread control now works correctly. [14067]

The Spread DLL now returns the correct locale settings. [14090]

Loading specific Excel files no longer causes the control to stop responding. [14179]

Debug issues have been resolved. [14488]

Certain Excel files now load correctly. [14500], [14594]

The ExportToHtml method now exports widths correctly. [14595]

TypeHAlign now works correctly. [14702]

Technical Issues Addressed—Release Date 03/19/04—Version 6.0.32
fpSpread control

Using the SetDataFillData method to write back changes to an SQL table field of type char or varchar now works correctly. [12496]

The SetCustomName method now accepts only valid characters. [13114]

Tool tips now work correctly with dual monitors. [13423]

Clicking on an item in the combo box cell three times no longer halts the program. [13510]

The LoadFromFile method no longer causes the program to stop responding if the file contains certain values. [13519]

The ExportToHtml method no longer fails when exporting large amounts of data. [13611]

The number does not change if you try to type a letter over a selected number in a number cell type. [13619]

The ExportToTextFile method now works correctly with multiple lines of text in a single cell. [13628]

The ExportToExcel method no longer causes the program to stop responding when exporting certain formulas. [13710]

The SaveToFile method no longer returns true if the disk is full or the file has been partially saved. [13728]

The pop-up calendar now uses a Windows system color around the buttons. [13772]

The VirtualRefresh method now updates the bound Spread control correctly. [13799]

The message box now shows up in front of the form after selecting an item in the combo box cell and then showing a message box with Windows 98. [13801]

Technical Issues Addressed—Release Date 01/05/04—Version 6.0.31
fpSpread control

The delete key no longer causes the KeyDown event to fire twice in a Spread cell that is not in edit mode. [13474]

Technical Issues Addressed—Release Date 12/18/03—Version 6.0.30
fpSpread control

Sorted data in a bound control with virtual mode no longer becomes unsorted when viewed with the preview control. [12653]

The TypeComboBoxCurSel property no longer returns an incorrect value when using the arrow key to move down the list. [12868]

The last selected cell no longer becomes unselected when using allowmultiblocks and scrolling to the next page. [13039]

The LoadFromFile method no longer fails when the cell is in editmode. [13078]

The MultiSelCount property returns the correct value when selecting a block of rows followed by a single discontiguous row. [13092]

Using the arrow keys to move the active cell now works correctly. [13041]

All pages are now exported when exporting to Excel with virtual mode. [12586]

Highlighting now works correctly with an ATL based DLL. [12890]

Typing a decimal from the number keypad now works correctly when the language is French. [12890]

There is no longer a resource leak when using a lot of fonts and multiple calls to SSSaveBlockToBuffer and LoadBlockFromBuffer. [13097]

The 3d appearance setting is now similar to the text box appearance. [13266]

Technical Issues Addressed—Release Date 11/12/03—Version 6.0.27
fpSpread control

Exporting files to Excel when the Spread file contains certain border settings no longer causes some data to be lost. [8601, GIC12194]

Copying from an open Spread file and pasting into an Excel file created by exporting from the Spread control no longer causes a memory error in Excel. [11982]

Exporting from the Spread control to an Excel file multiple times no longer causes ongoing decreases in memory. [12297]

Returning formulas with large numbers of operators no longer causes the application to stop unexpectedly. [12424]

Users can now backspace over the characters in an edit cell after typing the maximum number of characters allowed. [12435]

Setting the Value property to True for a check box cell now works correctly. [12441]

Printing a Spread control that has the Enabled property set to False no longer causes it to become enabled. [12450]

Scrolling the active cell with the up and down arrow keys no longer causes painting issues when the EditModePermanent property is set to True. [12451]

Exporting to Excel files in certain situations under Windows 98 no longer creates columns that are too wide in the exported Excel file. [12453]

Text files now load without random exceptions. [12467]

Problems with exporting column information to Excel that caused errors when working in the Excel file in Excel 2000 have been corrected. [12469]

Problems with the font size displaying correctly in text tips have been corrected. [12497]

Exporting to text files using the delimiters Chr(10), Chr(13), or a combination of the two, and then reloading the file now works correctly. [12543]

With the AutoClipboard property set to False and the Ctrl+C and Ctrl+V shortcut keys mapped to menu options, the control now processes the keys correctly for the custom mapping. [12549]

Large double values that have large precision such as 6 decimal places had exhibited the Intel floating point rounding problem when set using the SetText or SetFloat methods. That issue has been corrected. [12556]

Technical Issues Addressed—Release Date 09/17/03—Version 6.0.25
fpSpread control

Setting the NoBeep property to True now correctly turns off the beep for the edit cell type. [1812]

Setting a header cell as an edit cell now correctly lets the application move the focus to the cell, displays the focus rectangle, and lets the user edit the header cell. [10742, 12119]

Transparent bitmaps now display correctly in check box cells regardless of the edit mode setting. [11029, 11798]

Updating a memo field in a database bound to the Spread control no longer causes an error. [11355]

Typing numbers quickly in cells now works correctly. [11402]

Right-clicking on number cells in Visual Interdev now correctly brings up the menu. [11413]

The Ctrl+C shortcut keys now work correctly in Visual Interdev. [11416]

Updating a filtered database that is using virtual mode now correctly displays the number of records in the filtered set, not the entire database. [11457]

Time cells now correctly save the value 00:00 to bound databases. [11503]

Spreadsheets with more than 1025 merges in them now export to Excel correctly. [11611, 12221]

Custom functions now work correctly in date cells. [11615]

The control no longer prints grid lines in spanned cells. [11714]

Typing numbers in scientific notation as formulas in number cells no longer causes projects to cause an exception error. [11727]

The CEILING, FLOOR, INT, MOD, ROUND, ROUNDDOWN, ROUNDUP, TRUNC, EVEN, ODD, ISEVEN, and ISODD functions have been updated to correct for small errors introduced by double-precision floating point arithmetic. [11801]

The GetArray method now correctly returns data when there are multiple header rows. [11813]

In .NET, setting the ShowInTaskBar property to False before setting the value of a check box cell no longer causes an error. [11857]

Relative cell references used in custom names are now updated if colums or rows are added to the spreadsheet. [11870]

Centered text in combo box cells' edit fields now exports to Excel as center aligned. [11903]

Setting the SelectBlockOptions property to only select the entire spreadsheet or rows now works correctly. [11927]

In Visual Interdev projects, selecting rows by clicking the row header, then dragging the selection into the gray area in the control and back up to just the original selected row no longer causes a delay. [11931]

The combo box cell drop-down list now displays correctly over the Windows taskbar, even when the taskbar is set to "Always on top." (11934]

The Spread control is now repainting correctly after the user changes a block selection. [11941]

Spread files that contain unary minus operators in formulas now export to Excel correctly. [11967]

Spreadsheets that use virtual mode now export the first 65536 rows to Excel correctly. [11968]

Adding comments to Visual Basic 6 form files no longer causes error 383. [11975]

The Spread control now exports to Excel such that Excel 97 re-evaluates formulas when the file is opened. [12002]

Fonts no longer change incorrectly when you export to Excel files and then import the files back into the Spread control. [12023]

Performing an OLE drag over the Spread control no longer causes an exception. [12037]

In .NET, print code in the Form Activated event now works correctly. [12046]

The values returned from percent cells in the EditChange and the LeaveCell events are now the same. [12072]

Setting multiple header rows no longer incorrectly changes display when the control is in virtual mode. [12109]

The mouse scroll wheel now works correctly for the Spread control used in Terminal Server 2000. [12169]

The Spread control now correctly exports to Excel cells with large amounts of text data, which previously did not always export correctly. [12182]

Exporting a formula to Excel when the formula contains multiple groupings no longer creates an Excel file that causes file invalid or stack overflow problems in Excel. [12205]

The Ctrl+V and Ctrl+C shortcut keys now work correctly in cells that are in edit mode. [12244]

The hourglass pointer now appears over the entire control when the Spread control is performing time-consuming tasks. [12279]

Copying and then pasting multiple times when the EditModePermanent property is set to True no longer causes the project to stop. [12306]

An ActiveX control that contains the Spread DLL control and is downloaded in a CAB file no longer crashes when entering edit mode in a number cell. [12310]

When rounding a number of display purposes, the number cell type now corrects for small errors introducted by double-precision floating point arthmetic. [12315]

Excel files with cells containing true or false boolean values are now imported as Spread number cells containing the TRUE() and FALSE() functions. Text cells in Excel that contain the text "True" or "False" are imported as Spread text cells containing that text. [12328]

Combo box cells are now correctly updating the list when it is set in the ComboDropDown event. [12335]

Number cells now accept values provided in scientific notation through code. [12359]

Spreadsheets with 10 columns and 6600 rows with each cell set to be a check box cell no longer crash. [12360]

Scroll bars now provide context menus when users right-click them at run time. [12370]

Selecting rows in a spreadsheet with the OperationMode property set to 5 (Extended Select) using the arrow keys now works similarly to extended selection in Microsoft Windows Explorer. [12398]

fpSpreadPreview control

Border lines now display correctly in the fpSpreadPreview control. [11574]

Spread Designer

You can now set the LockBackColor property back to default through the Spread Designer when the Spread Designer is linked to a Spread control in a project. [8699]

Setting the top border for individual cells and setting the left border for cells in a column now works correctly. [10934]

The Retain Selected Block setting in the Spreadsheet Environment dialog is no longer reset when you change column header text. [11576]

Opening Excel files with cell notes and custom borders no longer causes application errors. [11820]

Technical Issues Addressed—Release Date 01/07/03—Version 6.0.18
fpSpread control

Problems loading formulas imported from Excel-formatted files have been corrected. [11405]

Technical Issues Addressed—Release Date 01/03/03—Version 6.0.17
fpSpread control

Problems with files exported to Excel where the files would not load in Excel and generated File Format Not Found errors have been corrected. [11396]

Technical Issues Addressed—Release Date 12/31/02—Version 6.0.16
fpSpread control

Exporting spreadsheets to Excel where the spreadsheets contain cells containing large number of characters no longer causes the export method to fail. [10277]

SQL data type values on systems with the control panel settings set to French (France) previously did not display correctly in Spread. This has been corrected. [10334]

The ClipboardCopy method now works correctly when the control's operation mode is Extended Select. [10740]

Formulas using the greater than or equal operator are now returning the correct value. [10786]

SmartPrint is now printing correctly in portrait orientation from Visual Studio .NET. [10809]

Currency cells exported to Excel when the TypeCurrencyShowSymbol property was set to False caused format errors in the exported Excel spreadsheet. This has been corrected. [10824]

Hiding an MDI form that contains the Spread control in a VB.NET project no longer causes problems with editing the Spread control when you display the form. [10827]

Spread no longer lets users paste to locked cells in column 1 and row 1. [10875]

The LoadTabFile method is now correctly loading data saved from combo box cells. [10890, 10991]

Setting the number of column header rows using the ColHeaderRows property no longer incorrectly changes the number of rows (returned by the Rows property). [10952]

Borders now print correctly to PostScript printers. [10958, 11087]

Sorting now updates the active cell in a set of combo box cells, even when EditModePermanent is set to true. [10981]

Files saved by Spread to Excel format that contain date cells with certain formats now export and load back into Spread correctly. [10983]

Previously, if the user opened a new browser window, creating a copy of a window that contained a Spread control, the new window's Spread control did not display text tips correctly. This has been corrected. [10987]

Loading certain large Excel files no longer causes memory errors in Visual C++. [10988]

The control no longer displays text tips for text cells set up as password cells. [10996]

The control now displays the highlighting correctly for double-clicking and then clicking on another area when the operation mode is set to Row Mode. [10999]

Spread controls now display correctly in maximized main windows. Formerly, the Spread control did not appear in certain projects running under Windows 98 or Windows 95 where the main window was maximized. [11007]

Loading and unloading a form containing a Spread control with check box cells no longer causes a Null reference error. [11026]

Transparent bitmaps now display correctly in check box cells regardless of the edit mode setting. [11029]

The control no longer incorrectly draws the selection rectangle when the user presses the Alt key for a Spread bound using ADO. [11041]

Exporting to Excel-formatted files now correctly exports Cyrillic characters. [11046]

Exporting a spreadsheet to Excel-formatted files where the spreadsheet contains a custom function and a function now works correctly. [11058]

Setting the MaxRows property to zero before calling the LoadTabFile method no longer causes the tab-delimited file to load incorrectly. [11095]

Typing and clicking certain combinations of characters and cells no longer causes the application containing Spread to stop running. [11099]

The EditModeReplace property setting now works correctly for PIC (mask) cells. [11112]

Exporting files to Excel no longer creates files that cause memory problems when they are loaded into Excel. [11174]

Edit cells in Spread that contain numbers are now exporting correctly to Excel. [11276]

Spread no longer causes a memory problem when painting large numbers of cells on a system using 32-bit color. [11303]

The edit overflow feature is no longer causing problems in cells that are also part of a span and where the EditModePermanent property is set to True. [11307]

Pressing the PageDown button on the special scroll bar now correctly loads data. [11325]

Autosizing bound columns (when the DAutoSizeCols property is set to 2 (Best Guess)) now works correctly when loading numeric data. [11339]

Certain files when exported to Excel would save font information incorrectly and cause an error stating there were too many fonts when the file was loaded into Excel. This has been corrected. [11340]

Loading certain Excel files no longer causes out of memory errors. [11345]

The GetText method is now correctly returning values from cells in edit mode. [11358]

Files exported to Excel now lock cells correctly when the lock is applied to all columns and rows in the spreadsheet in Spread. [11363]

Very small negative numbers in cells no longer cause the cell to display "-0.00". Cells now display "0.00" for very small negative numbers. If the TypeNegRed property is set to True, the cell still displays the negative value as red. [11375]

Percent cells with the TypePercentDecPlaces property set to zero now export to Excel correctly. [11386]

Spread Designer

You can now type numbers higher than 999999 in the number cell type's Max Value box. [10965]

Loading certain Spread files (*.ss6) into the Spread Designer and then trying to save them as Excel-formatted files no longer causes the Spread Designer to freeze. [11010]

Technical Issues Addressed—Release Date 08/13/02—Version 6.0.11
fpSpread control

Setting focus to an editable header cell in a header with multiple rows now works correctly. [10742]

Technical Issues Addressed—Release Date 07/31/02—Version 6.0.10
fpSpread control

Cells in spreadsheets exported to Excel now change to Bold correctly when the user presses the Bold button in the Excel worksheet. [8396]

Exporting to Excel no longer incorrectly changes float cells to Excel custom format cells. [8671]

If a combo box cells spans across multiple cells, you only have to click the cell once to display the drop-down list. [9920]

Exporting spreadsheets to Excel and then importing them back no longer results in some formulas being lost. [9922]

The problem with hidden rows and columns being included when a spreadsheet is exported to an HTML file has been fixed. [9925]

Integer cells now correctly replace data in edit mode when the user starts typing new data. [9928]

If you merge columns or rows, cell border settings now display correctly. [9938]

The correct value is now calculated for formulas that use rounding. [9950]

Scrolling horizontally through the control by pressing arrow keys no longer causes the column sort indicator to appear where it should not. [9965]

The correct background color is now displayed in overflow cells that are adjacent to spanned cells. [9979]

You no longer have to call the Reset method before you can load a text file in Spread. [9985]

Printing using the OwnerPrintDraw method now correctly prints to a picture box. [10003]

If you have enable user sorting, clicking the gray area no longer causes a column to sort. [10006]

Latin characters are now exported correctly to XML buffers. [10007]

If you are using Smart Print and the page is landscape, footers are now printed in the correct font size. [10017]

A buffer size has been fixed that caused problems in Visual Basic when exporting a file to XML. [10020]

If you set the ColsFrozen property to 2, the column width of column 1 is no longer reset. [10021], [10268]

The percent cell now displays the correct value when the TypePercentDecPlaces is set to zero and you enter a negative number in the cell. [10081]

The GetFloat method now returns the correct value for a percent cell. [10088]

Cell delimiters are now being placed correctly around cells containing delimiter characters. [10179]

The Value property now works when you use it to check the value of a default button cell in the ButtonClicked event. [10219]

The Spread control now refreshes when you set the MaxCols property in response to a button's Click event. [10234]

Data in spanned cells in a frozen area now print correctly on pages after the first page. [10235]

If you are using Windows 98, the spreadsheet now prints correctly. [10239]

If you are using Windows 98, the cell text now displays in text tips. [10281]

The ExportToXMLBuffer method no longer cause a problem when you call the method in Visual Basic 6. [10316]

Clicking anywhere on a button cell that spans several cells now displays the lowered three-dimensional appearance. [10420]

Using the GetFormula method no longer causes a problem accessing the spreadsheet. [10446]

Calling the SaveTabFile method to save an empty spreadsheet no longer causes the method to fail. [10453]

Combo box cells now work correctly on Windows XP systems. [10665]

The control no longer displays borders for hidden rows. [10703]

Spread Designer

Text orientation settings now work correctly.(9854]

If you set the RetainSelBlock to True, the Spread Designer maintains the property setting for the spreadsheet after you close the Designer. [10060]

For a number cell, the minimum and maximum values now reflect the number of decimal spaces specified for the cell. [10135]

The constants for the TypeComboBoxWidth property have been added to the SSOCX.BAS file. [10323]

If you import Excel spreadsheets that contain charts, sheet data now displays on the correct sheet. [10383]

Technical Issues Addressed—Release Date 04/04/02—Version 6.0.06
fpSpread control

Only the data in the one merged cell now prints. Previously data ini all the merged cells printed. [9901]

When you export a spreadsheet to XML, Spread now checks for invalid XML characters. If an invalid character such as a colon (:) is found, the export will fail. [9912]

The LoadTabFile method now correctly loads the data into the Spread control if your tab-delimited file uses only a carriage return to separate data (versus CR-LF). [9916]

Technical Issues Addressed—Release Date 04/02/02—Version 6.0.05
fpSpread control

If you span cells and set an outline border for a block of spanned cells, the right border is drawn correctly now. [9781]

If you import an Excel worksheet that includes spanned cells, the text is now drawn and aligned correctly. [9783]

If you set the FontBold property to true and then export the spreadsheet to Excel, now only the intended cells display bold text. [9795]

If you set the TypePercentDecPlaces property for percent cells, the Text and Value properties now return the correct number of decimal places. [9799]

If you save the spreadsheet to a text file and then use the LoadTextFile to reload the data, the complete spreadsheet is now loaded. [9817]

If you set the TypeTextOrient property to 1 (Vertical LTR), line breaks in multiline cells now display correctly. [9818]

If you set the TypeTextOrient property to 1 (Vertical LTR), the MaxTextCellHeight and MaxTextRowHeight now return the correct values. [9823]

If you set the ColHeadersAutoText property to 0 (Blank), you can now export the spreadsheet to an XML file. [9850]

If cell strings contain quotation marks and you save the spreadsheet as a tab-delimited file, extra spaces have been eliminated. [9866]

Spreadsheets that contain merged cells no longer cause a problem when they are exported and opened in Excel. [9869]

The memory leak that occurs when you use the SetArray method after resetting the Spread control has been fixed. [9876]

Exporting the spreadsheet to HTML now works correctly when the DisplayColHeaders or DisplayRowHeaders property is set to False. [9886]

If you are using Windows NT 4, projects now run without problems when you perform formula calculations in time cells. [9891]

Spread Designer

If you set the pointer for the Default Spread to the Windows arrow pointer in Spread Designer, the spreadsheet no longer causes a GPF when you run the project. [9810], [9816]