Spread for Windows Forms 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.

| Version 1.1.0.0 | Version 1.0.9.0 | Version 1.0.8.0 | Version 1.0.7.0 |
| Version 1.0.6.0 | Version 1.0.5.0 | Version 1.0.4.0 | Version 1.0.3.0 |
| Version 1.0.2.0 | Version 1.0.1.0 |

Version 1.1.0.0 (Release Date 10/10/2005)
Technical Problems Fixed

 fpSpread component
  • Clicking on bound check box cells now works correctly. [16792]
  • Date-time cells now work correctly with regional settings set to Portuguese (Brazil). [16728]
  • Saving certain types of data to an Excel-formatted file now works correctly. [16536]
  • Values now stay within the minimum and maximum settings with certain formats in the date-time cell. [16518]
  • The correct sheet name is now returned when resetting the Spread component. [16369]
  • Speed enhancements have been made to the Spread component. [16306]
  • Setting the CellType property for a header in the designer now works correctly. [16303]
  • Text tips now show when the Spread component is in a user control that is used on a web page. [16300]
  • Pasting columns with empty cells from Excel to Spread now works correctly. [16295]
  • Adding a row to the currency manager with the Spread component bound to a sorted view now adds the row in the correct location. [16276]
  • Adding and sorting rows in the Spread component no longer causes mapping issues when calling the RemoveRows method. [16275]
  • Certain Excel-formatted files now load correctly. [16269]

Version 1.0.9.0 (Release Date 05/09/2005)
Technical Problems Fixed

 fpSpread component
  • Setting the FormatString property to "N" now works correctly in a general cell. [16216]
  • The EnterCell event now fires when clicking on a column header or a row header. [16194]
  • Adding an unbound row to a Spread component bound to a collection and then adding that row to the data source now adds the correct number of rows. [16193]
  • The GetPreferredHeight method now works on rows in the column header. [16169]
  • The GetValue method now returns the correct value when used in the LeaveCell event. [16165]
  • The program no longer stops responding when updating the bound control from the EditChange event. [16158]
  • The copy and paste now works with the CharacterSet property of the text cell. [16142]
  • The spin button and what the user is allowed to type are now the same when setting the MaximumValue property for a percent cell. [16138]
  • The copy and paste now pastes the formatting and then the value when ClipboardPasteOptions is set to All. [16125]
  • An empty array is now returned if no rows are selected when using the GetSelections method with the OperationMode property set to ExtendedSelect. [16078]
  • Cell notes now display in button, check box, and combo box cells. [16057]
  • Vertical borders now print correctly. [16055]
  • The Spread component now handles GDI resources properly. [16020]
  • The text property can now be accessed from a check box on a different sheet. [16010]
  • The program no longer stops responding with an index out of range error when filtering a value. [15974]
  • The program no longer stops responding when using the LeftChange event to programatically scroll a parent SpreadView when the child SpreadView is scrolled. [15958]
  • The vertical alignment for a cell now paints correctly with a named style. [15909]
  • The currency cell now shows the correct symbol if the NegativeFormat property is set to show parentheses and the ShowCurrencySymbol property is false. [15816]
  • The alternating row color now shows through a button when the ButtonColor property is set to transparent. [15727]
  • The form KeyDown event now fires when pressing the F12 key in a general cell. [15656]
  • The GetPreferredHeight method now works correctly when the font is changed. [15633]
  • The BackColor now paints correctly when using a skin in a hierarchical Spread component. [15582]

Version 1.0.8.0 (Release Date 04/07/2005)
Technical Problems Fixed

 fpSpread component
  • The program no longer stops responding when deleting a row after sorting. [15908]

Version 1.0.7.0 (Release Date 02/23/2005)
Technical Problems Fixed

 fpSpread component
  • Changing a value in a child sheet now works correctly. [15743]
  • Cell borders now print correctly to a JPEG (.JPG) file. [15654]
  • The Enter event now is raised before the EnterCell event if the EditModePermanent property for the control is true. [15598]
  • Double-line borders now export to an Excel-formatted file correctly. [15578]
  • Setting a row filter that causes fewer rows to be displayed no longer causes the program to stop responding. [15558]
  • Removing all columns after sorting data no longer causes the program to stop responding. [15556]
  • Numbers greater than ten can now be typed in a number cell with certain number format settings. [15450]
  • Data is no longer duplicated when adding a sheet with frozen rows to the sheet collection. [15448]
  • The OwnerPrintDraw method now prints frozen rows and columns correctly. [15437]
  • The column headers now print correctly. [15426]
  • The AllowUserZoom property now works correctly when overriding the PaintCell method. [15420]
  • Sorting by clicking on a column header now works correctly after adding a row to a bound Spread component. [15418]
  • The SetValue method of the sheet view now works correctly. [15413]
  • Scrolling with the wheel mouse now appears smoother with invisible rows. [15401]
  • Merged cells are now imported correctly when opening an Excel file at the sheet level. [15400]
  • The right arrow key no longer causes the Spread Designer to close. [15394]
  • Setting the DecimalSeparator property and the Separator property for the number cell now works correctly when using the Value property for the cell. [15393]
  • Setting a value of Super.Nan in a number cell now works correctly. [15390]
  • Setting a value of Single.Nan in a general cell now works correctly. [15389]
  • Removing the last row that contains the active cell from a bound Spread component now works correctly. [15388]
  • Opening an Excel file in the Spread component now loads the borders correctly. [15367]
  • The edit cursor now shows up in the cell if the Spread component is on an MDI form. [15364]

Version 1.0.6.0 (Release Date 11/09/2004)
Technical Problems Fixed

 fpSpread component
  • The NonEmptyRowCount property now returns the correct value when the data set has zero records. [15351]
  • The number cell type now uses plain rounding. [15346]
  • Setting the BackColor property for the cell while the cell is in edit mode no longer causes the cell to go out of edit mode. [15336]
  • Input maps now work correctly with hidden columns. [15328]
  • Printing now works correctly when the ShowGrid property is true and the cells have borders. [15324]
  • Page breaks are now exported correctly when exporting to an Excel-formatted file. [15323]
  • The GetPreferredSize method now works correctly with a text cell type when the MultiLine property is true and the WordWrap property is false. [15310]
  • Custom names are now loaded correctly from an Excel-formatted file. [15294]
  • Resetting the DataSource property no longer causes scroll bar painting issues with child sheets. [15292]
  • The combo box cell now closes correctly when on a tab control on an MDI child window. [15286]
  • Hidden rows are now handled correctly when sorting. [15281]
  • The navigation keys now work correctly when the OperationMode property is set to extended select. [15261]
  • The Search method now works correctly with a range of cells when the AlternateSearch property is false. [15252]
  • Setting the visible option for the row header now works correctly in the Spread Designer. [15243]
  • The SerializeModels property is now persisted to the Spread Designer. [14878]
  • Using the Spread component in a user control on a Web page no longer causes the program to stop responding when exiting edit mode. [14159]

Version 1.0.5.0 (Release Date 09/27/2004)
Technical Problems Fixed

 fpSpread component
  • Custom names are now loaded correctly when importing from an Excel-formatted file. [15239]
  • The general cell now formats correctly when setting a new value to the Text property. [15201]
  • The print header is now imported correctly from an Excel-formatted file. [15185]
  • The Property list is no longer disabled when assigning a cell type object to the SelectedObject property. [15184]
  • The TabStripRatio property is now saved to XML correctly when the control panel is German. [15133]
  • The form KeyDown event is raised only once now when typing in a cell and the KeyPreview property is true. [15048]
  • Updating small changes to a bound control requires less painting. [15042]
  • Binding a percent cell to a single data type now shows the correct values. [15041]
  • Various printing issues now work correctly. [15034]
  • Using an up arrow key with an empty combo box cell now works correctly. [15030]
  • Removing a column that has been automatically sorted then clicking on a new column to sort no longer causes an exception. [15021]
  • The MoveToNextColumnWrap action now works correctly with the EditModePermanent property. [15005]
  • The general cell now formats values in C# code correctly. [14980]
  • Copying a negative number from Excel to a cell with the same format now works correctly. [14975]
  • Using the arrow keys to change the active cell when the SelectionUnit property is set to row now works correctly. [14969]
  • Typing the letter "E" in a combo box cell no longer causes a command button click event to occur. [14953]
  • Removing a row when searching no longer causes the program to stop responding. [14934]
  • Typing 100% in a general cell now works correctly. [14920]
  • Column widths are now imported correctly when loading an Excel-formatted file. [14860]
  • Setting the AcceptsArrowKeys property for the combo box cell is now working for up and down arrow keys. [14856]
  • The LeaveCell and EnterCell events now occur once when the EditModePermanent property is true. [14854]
  • Formulas with custom names are now loaded correctly with the OpenExcel method. [14841]
  • Highlighting and replacing a number in a currency cell with the decimal places now works correctly. [14808]
  • Copying from cells with percent and currency formats in Excel and pasting them to percent and currency cells into the Spread component now works correctly. [14802]
  • Printing a new, non-active sheet no longer causes the program to stop responding. [14777]
  • Sorting a bound control with unbound rows now works correctly. [14756]
  • The OpenExcel method no longer stops responding when loading a file with external links. [14726]
  • Cell borders created with named styles are now exported to an Excel-formatted file correctly. [14723]
  • The OperationMode property now works correctly with a bound control. [14704]
  • Closing an mdi parent now works correctly. [14653]
  • Deleting a sheet from a Spread component with text tips and then moving the mouse pointer over the control now works correctly. [14608]
  • Changing the column header font now works correctly in the Spread Designer. [14588]
  • The DragDropBlock event now occurs once when you display a message box. [14573]
  • Setting the FrozenColumnCount property at design time now works correctly. [14555]
  • The GetPreferredHeight and GetPreferredWidth methods now work correctly when typing in a multiline cell. [14540]
  • The abort dialog now closes properly when printing. [14517]
  • The control no longer stops responding when clicking from an open combo box cell to another combo box cell in a user control on a Web page. [14511]
  • Text tips are now displayed correctly on a child form. [14509]
  • Copying and pasting two double quotes from Excel to the Spread component now works correctly. [14431]
  • Certain SS6 files now load correctly. [14404]
  • The note indicator now moves with the sorted cell. [14389]
  • Exporting overlapping color properties to an Excel-formatted file now works correctly. [14386]
  • Clicking on a row in a bound, sorted Spread component after using the Remove method for the data set now works correctly. [14367]
  • The Spread component on a modal form now displays correctly. [14330]
  • Background colors that resolve to white are now exported correctly. [14184]
  • The check box cells now show design time settings. [14177]
  • Combo cells now work correctly with the TopMost property of the form. [14169]
  • Multiple operations in the Spread Designer, such as hiding more than 30,000 rows, no longer cause the program to stop responding. [14168]
  • The program no longer stops responding when setting the DataSource property after a search. [14166]
  • Copy and paste now work correctly when the SelectionUnit property is set to row. [14165]
  • Text tips now work correctly when the Spread component is in a user control on a Web page. [14164]
  • The designer now correctly loads an SS6 file. [14163]
  • Exiting edit mode in a Spread component in a user control now works correctly. [14159]
  • The Spread component now goes out of edit mode when the InputMap is set to MoveToNextRowWrap or MoveToNextColMap and the appropriate key is pressed. [14153]
  • The SortRange method now works correctly on formula cell references. [14152]
  • Setting the DataField property for a column at design time now lets the Spread component fill, when the AutoGenerateColumns property is set to False. [14145]
  • The text cell type no longer shows multiple lines of text when the Multiline property is false. [14126]
  • The MoveRange method no longer causes the program to stop responding. [14117]
  • The SetActiveCell method now works correctly. [14075]
  • The general cell type now works correctly with the FormatString property. [14068]
  • Decimal places are now displayed correctly with a percent cell type. [14066]
  • Pressing the tab key when the sheet count is zero no longer causes the program to stop responding. [14065]
  • Using the AddRowToDataSource method no longer adds a row to the data model when bound to a data view with a row filter and the column criteria is not met. [14060]
  • The NonEmptyRowCount property of the default sheet data model now returns the correct value. [14059]
  • The OpenExcel method now works correctly when there is a double-byte character in a formula string. [14033]
  • The SaveExcel method now works correctly with duplicate custom names. [13973]
  • Setting the background color with the BackColor property for a column now exports to an Excel-formatted file correctly. [13491]

Version 1.0.4.0 (Release Date 03/19/2004)
Technical Problems Fixed

 fpSpread component
  • Copying and pasting the Spread component no longer causes the program to stop responding. [13905]
  • Deleting characters in a date-time cell that has the date-time format set to user-defined now works correctly. [13900]
  • The reference in the documentation to an EnteModePermanent property is corrected to be EditModePermanent. [13889]
  • The program no longer stops responding when importing large .XLS files and using the RemoveRows method. [13888]
  • The program no longer stops responding when the format string is set to X or D with a general cell type. [13885]
  • The horizontal alignment of text in a cell now works correctly. [11911]

Version 1.0.3.0 (Release Date 03/09/2004)
Technical Problems Fixed

 fpSpread component
  • Sorting the Spread component using the SortColumns method and then accessing a cell no longer causes the program to stop responding. [13797]
  • Exporting to an Excel-formatted file now works correctly with a column of number cells. [13777]
  • Copying the entire spreadsheet by clicking on the upper left cell and pressing the Cntrl C keyboard shortcut now copies to the Clipboard correctly. [13734]
  • Unsupported Excel formulas can now be retrieved using the Formula property after loading an Excel-formatted file. [13727]
  • The Backspace key or Delete key can now be used to remove the highlighted minus sign in a number cell. [13640]
  • Scrolling a child sheet with a mouse wheel now scrolls correctly. [13625]
  • In the Spread Designer, you can resize any row of column headers and any column of row headers, not just the first. [13597]
  • The Alt-down arrow key combination works on a combo box cell when the cell type is set for the entire column of cells. [13590]
  • Formulas are now recalculated when they reference a bound cell and that cell is updated from the data source. [13589]
  • Copying from an edit type cell and pasting to a combo cell with the EditorValue property set to index for the combo cell no longer causes the program to stop responding. [13550]
  • Opening an Excel-formatted file with over 4000 formats no longer causes the program to stop responding. [13548]
  • The project no longer stops when the mouse is over a row that goes away before the tool tip is shown when the TextTipPolicy property is set. [13502]
  • Typing characters with the Graphical Alt key is now working. [13410]
  • The control now rounds correctly when using the SetValue and decimal places are zero. [13315]
  • Cell notes now show correctly on a control that is on a form with the TopMost property set to True. [13096]
  • Importing an Excel-formatted file with custom cells with custom number formats now works correctly. [13059]
  • Using the Cntrl X keyboard shortcut no longer removes the formula from a locked cell. [12943]
  • The Spread Designer can now be used to add blank items to a combo cell. [12935]
  • The text that the user types in a combo box cell is not removed after pressing Enter even when the text is not one of the choices in the list. [12867]
  • Using the Clipboard operations, such as copying a value in a GeneralCellType cell, no longer looses the separator and other FormatString and FormatInfo object information. [12608]
  • The format string setting of $#,###.00 now works correctly. [12590]
  • The GetPreferredHeight method now works on rows in the column header. [12584]
  • The use of the DefaultSheetDataModel involving retrieving data from a list-based datasource no longer causes a system exception when exporting a sheet to an Excel-formatted file. [12575]
  • When the AddRowToDataSource method is called, the adding of the row to a child sheet in the ChildViewCreated event no longer raises an exception. [12574]
  • The SelectionChanged event does not occur when the user clicks on the same cell multiple times since the selection does not change. [12570]
  • The program no longer stops responding when loading an Excel-formatted file and then binding to a database and locking a row. [12569]
  • Right alignment now works correctly when there are spaces in the string of text. [12555]
  • The percent cell type now rounds numbers instead of truncating. [12544]
  • Binding the Spread to a collection base that has a structure as its Item now works properly. [12522]
  • When the RowCount is set to zero, the ActiveRow and ActiveCell properties are now null and do not raise an exception. [12517]
  • Right clicking on the tab strip area to the right of the sheet names when running the project no longer causes an exception. [12509]
  • When exporting to an Excel-formatted file, the scroll bar is now the larger button and does not change based on the total number of columns. [12500]
  • Typing Chinese characters now works correctly when the cell is not in edit mode when you start typing. [12488]
  • The TextTipFetch event now returns the correct cell location for a combo box cell. [12477]
  • With the correct Control Panel settings, the check box cell and Chinese double-byte characters now load correctly from a Spread SS6 file. [12476]
  • Headers can now be copied to the Clipboard with the Cntrl C keyboard shortcut when using the all-headers option. [12474]
  • Right-clicking on a resize area of the Spread no longer causes the resize to work; only left-clicking works. [12473]
  • The Shift-arrow key combination no longer overrides the restrictions placed by the SelectionBlockOptions property setting. [12472]
  • Copying and pasting data from a text cell to a date cell no longer causes the project to stop with an invalid data error. [12471]
  • Passing 0.2 (a double) to a percent cell now gives the same results as passing 0.2D (a decimal) to the cell. [12468]
  • Using the arrow keys to move through rows is now working when you have the SelectionBlockOptions property set to Rows. [12466]
  • Using an empty string in a formula now works with percent cells as it does for number cells. [12457]
  • With EditModePermanent property set to true, pressing the Esc key no longer results in being unable to close the form. [12456]
  • Clicking on the header of a column that has AllowAutoSort turned on no longer throws an exception when the RowCount property of the sheet is zero. [12449]
  • Printing while a cell is in edit mode no longer causes the program to stop responding. [12444]
  • The cell set as ButtonCellType now correctly raises the ButtonClicked event when the user presses the spacebar or presses the Enter key with focus on a button cell. [12420]
  • Mousing over a frozen column no longer causes a system index-out-of-range exception and the program to stop; it now handles the text tip properly. [12404]
  • Typing 1t or 1T in a general cell no longer causes a system index-out-of-range exception and the program to stop. [12389]
  • Spread now handles the focus correctly when it is in edit mode and you click on a button. [12386]
  • The GetChanges method now works correctly when you edit a cell and then click on another cell in the same row. [12381]
  • Spread no longer stops when you click on a combo box cell. [12380]
  • Printing now works with frozen columns and frozen rows. [12368]
  • Column spans now print and preview properly even when you remove the row headers. [12347]
  • To handle the importing and exporting of borders properly from an Excel-formatted file, Spread displays a grid line with Color.Empty when there are no grid lines so that borders do not appear doubled when loaded from an Excel-formatted file. [12257]

Version 1.0.2.0 (Release Date 08/25/2003)
Technical Problems Fixed

 fpSpread component
  • The value in a combo box cell (ComboBoxCellType) is now correctly retained after using a list control and entering Edit mode in the cell. [12371]
  • The sheet, when it has been sorted or filtered, is now correctly getting the updated data from a bound DataViewManager. [12346]
  • For bound data, using the AutoGenerateColumns method now reinitializes both the data model and the cell types in the style model. [12334]
  • Exporting an Excel-formatted file with spanned column headers now works correctly. [12330]
  • Clicking on a combo box cell (ComboBoxCellType) in a control that is on a Web page does not cause an exception. [12323]
  • Setting the RowHeaderColumnCount property to 0 in the Spread Designer no longer causes an index-out-of-range exception. [12321]
  • Displaying the calendar in DateTimeCellType cells no longer causes an exception. [12317]
  • Setting the BackColor property for a MultiOptionCellType cell to transparent no longer causes the cell to go black when entering Edit mode. [12303]
  • Changing the style property for a combo box cell in the EditChange event does not cause the program to terminate. [12300]
  • The EditChange event now occurs when the cell type (for example, ComboBoxCellType) is not EditBaseCellType. [12299]
  • Exporting an Excel-formatted file with the SaveExcel method does not cause a null-reference exception. [12296]
  • Users that have both Spread for Windows Forms and Input Pro for Windows Forms products no longer have a problem with a module shared by both products. [12292]
  • Setting the RowCount or ColumnCount property, or calling AddRows, AddColumns, RemoveRows, or RemoveColumns methods on a sheet that has been sorted with the SortRange method, no longer causes an exception. [12288]
  • Setting the RowCount property in a bound spreadsheet to a value less than the number of rows in the data source and adding rows with the AddRows method no longer causes an index-out-of-range exception. [12287]
  • The CalcErrors now are being serialized in the models correctly between RC3 and 1.0.1.0. [12286]
  • The formulas (functions and operators) now support long, ulong, sbyte, and byte data types. [12285]
  • The SheetView.Tag property now is being serialized correctly. [12268]
  • The SheetView.AddUnboundRows method inserts new unbound rows at the correct index in a sorted sheet. [12267]
  • The FpSpread.Change event provides the correct row and column indexes when the sheet is sorted with SortRows or SortColumns methods. [12266]
  • Frozen rows and columns now work correctly in child sheets, even though the properties could be set previously. [12265]
  • Printing to a non-default paper size now works correctly. [12259]
  • The Spread Designer and XML serialization now work with Regional Settings specifying a character other than a period for the decimal point. [12256]
  • A formula assigned to an entire column that references an entire column now updates correctly. [12251]
  • The DragFill and DragDropArea cursors are now changed. [12248]
  • The TRUNC and ROUNDDOWN functions are now returning the correct values. [12241]
  • The KeyDown event now occurs correctly for each keystroke. The KeyUp event occurs only once per keystroke.

Version 1.0.1.0 and earlier releases

  • Internal issues resolved.
© 2002-2006, FarPoint Technologies, Inc. All rights reserved.