Spread 3.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 04/04/02 -- Version 3.5.10

 fpSpread control
  • 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 cell strings contain quotation marks and you save the spreadsheet as a tab-delimited file, extra spaces have been eliminated. (9866)
  • 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)
  • The user sort indicator now displays only in one column as intended. (9910)
  • 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)
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)

Technical Issues Addressed -- Release Date 02/21/02 -- Version 3.5.06

 fpSpread control
  • If you export a spreadsheet to XML, numbers and XML reserved characters and symbols are now exported correctly. (9753)
  • If you export a spreadsheet to Excel and you use the R1C1 reference style, formulas are now exported correctly. (9768)
  • The sort indicator now paints correctly if you minimize and then restore the from in Visual Basic 6. (9769)

Technical Issues Addressed -- Release Date 02/06/02 -- Version 3.5.05

 fpSpread control
  • The SelectionCount property now returns the correct value when the AllowMultiBlocks property is set to True and the OperationMode is set to Normal. (9372)
  • If you sort a group of cells, any empty cells in the group are now located at the bottom of the group after sorting. (9431)
  • When the AllowCellOverflow property is set to True and pressing the End key moves focus to one cell beyond the text that overflows, the text that overflows now paints correctly after focus has changed. (9434)
  • Loading a spreadsheet that contains custom cursors using the LoadFromBuffer function no longer causes a memory leak. (9473)
  • If you use button cells in the header, the active cell is no longer highlighted when you click the header. (9475)
  • If you are using the ListPro fpCombo control in a Spread combo box cell and you set the TypeComboBoxEditable to False, the search capability now works correctly. (9489)
  • ASCII values greater than 127 now work for the TypeTimeSeparator property when you use the SetText method to add data. (9500)
  • Calling the LoadTextFile method no longer causes the RetainSelBlock property to be set to False. (9515)
  • The ScriptKeyUp event now occurs for non-alphanumeric keys when Spread is not is edit mode. (9531)
  • Excel no longer locks up if you click on a cell that contains the If formula function in a spreadsheet that was exported to Excel. (9544)
  • If you use the ExportToTextFile method to export only the column headers, the file length is now correct and the MaxRows property returns a zero when the file is reloaded. (9607)
  • Empty columns that have custom text in the headers are now exported correctly using the ExportToTextFile method. (9612)
  • The SetText method has been optimized to reduce painting problems when used numerous times to add text to the spreadsheet. (9662)
  • Spreadsheets with owner-drawn cells now print correctly. (9684)
  • If you load an Excel file that has numbers with trailing zeros in a text cell, the zeros and the decimal symbol is not shown in Spread. (9694)
  • If you use the List Pro fpCombo control in Spread and you hide items in the list, the drop down list now shows the number of list items specified by the MaxDrop property. (9697)
  • If you set the Row parameter in the DeleteRows method to –1, the header formatting does not change now. (9703)
  • Loading multiple spreadsheets into a Spread control no longer causes painting problems with check box cells. (9730)
  • If the ColPageBreak property is set to False for all columns, opening and closing forms in an MDI child that includes a Spread control no longer causes a problem. (9755)
  • Check box cells now return a value of either 0 or 1 when you use the GetInteger method. (9757)
Spread Designer
  • If you click a column header that is not on the first screen of the spreadsheet and bring up the Column/Row dialog, focus now remains on the column that you click. (9443)
  • Data that is allowed to overflow in cells now persists when you save and apply the changes back to the Spread control. (9583)
  • When you import a spreadsheets from Excel that contain formulas with a large number of elements no longer cause Visual Basic to lock up when the file is loaded.(9727)

Technical Issues Addressed -- Release Date 11/27/01 -- Version 3.5.02

 fpSpread control
  • Columns that are hidden now remain hidden when you export the spreadsheet to an Excel file and open that file in Excel. (9442)
  • If you use the ADO control, the ExportToExcel method no longer causes an error when you save the spreadsheet to an Excel file. (9447)

Technical Issues Addressed -- Release Date 11/15/01 -- Version 3.5.01

 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)
  • If a column is locked, the sort indicator will not display but sorting will still occur. Also if the EditModePermanent property is set to True, data will now sort correctly. (9283)
  • An error in the Shared String Table (SST) that caused problems loading Excel files has been fixed. (9287)
  • If you export a spreadsheet to an XML file, special characters (umlaut, for example) are now preserved. (9293)
  • Several errors in the conversion 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)
  • Combo box cells whose only change from default values was the data are now exported correctly to an Excel file. (9329)
  • Spread files that contain JPEG pictures can now be successfully export to an HTML file. (9337)
  • 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 the AllowCellOverflow property is set to True, cell note indicators now display in the original cell. (9344)
  • The KeyPress event occurs now when you type the first character in a cell. (9368)
  • The keycode parameters in the ScriptKeyPress event have been changed from unsigned short data type to the short data type. (9369)
  • 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)
  • Custom calendar text is now persisted when you save, open, and resave a spreadsheet in the Spread Designer. (9333)
  • Formulas that contain absolute references are now imported and exported correctly from Spread. (9425)