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

| Versions 4.0.2026.2005 and 4.0.3526.2008 |
| Versions 4.0.2024.2005 and 4.0.3524.2008 |
| Versions 4.0.2022.2005 and 4.0.3522.2008 |
| Versions 4.0.2015.2005 and 4.0.3515.2008 |
| Versions 4.0.2012.2005 and 4.0.3512.2008 |
| Versions 4.0.2011.2005 and 4.0.3511.2008 |
| Versions 4.0.2010.2005 and 4.0.3510.2008 |
| Versions 4.0.2009.2005 and 4.0.3509.2008 |
| Versions 4.0.2008.2005 and 4.0.3508.2008 |
| Versions 4.0.2005.2005 and 4.0.3505.2008 |
| Versions 4.0.2003.2005 and 4.0.3503.2008 |
| Versions 4.0.2001.2005 and 4.0.3501.2008 |

Versions 4.0.2026.2005 and 4.0.3526.2008
Release Date 11/11/2010
Technical Problems Fixed

 fpSpread component
  • Searching now works correctly with wildcard characters. [99918482]
  • Selecting items with multiple combo cells now works correctly. [99918365]
  • Formulas are now imported correctly from Excel-formatted files. [99918319]
  • Certain XML files are now loaded correctly. [99918287]
  • Typing in sheets with many formulas now works correctly. [99917823]
  • The SelectionChanged event now works correctly. [99917796]
  • A single character search now works correctly in a combo cell. [99917738]
  • The SetClipValue method now works correctly with a check box cell. [99917274]
  • Certain formulas now work correctly after importing an Excel-formatted file. [99917268]
  • Updating data in a hierarchical control with hidden columns now works correctly. [99917254]
  • Cell notes are now correctly exported to Excel-formatted files. [99917241]
  • The print header now prints correctly with certain font types. [99916848]

Versions 4.0.2024.2005 and 4.0.3524.2008
Release Date 07/29/2010
Technical Problems Fixed

 fpSpread component
  • Print headers now work correctly with images. [99916728]
  • Frozen rows now work correctly when filtering. [99916707]
  • The cell editor dialog now works correctly. [99916663]
  • The Spread Designer now works correctly on an inherited control. [99915061]
  • AllowUserFormulas now works correctly with the formula text box. [99914825]

Versions 4.0.2022.2005 and 4.0.3522.2008
Release Date 06/07/2010
Technical Problems Fixed

 fpSpread component
  • The SetViewportTopRow method now works correctly with multiple sheets. [99916161]
  • Custom drop-down cells now work correctly. [99915993]
  • Spanned cells can now be edited if one of the cells is invisible. [99915992]
  • The Spread Designer now works correctly with formulas that reference other sheets. [99915984]
  • The SelectionChanged event now works correctly. [99915505]
  • The rich text cell now prints correctly. [99915275]
  • Drop-down lists that reference other sheets are now imported correctly from an Excel-formatted file. [99915256]
  • Certain currency symbols are now imported correctly from an Excel-formatted file. [99915167]
  • Custom names are now imported correctly. [99915161]
  • The FormatString property now exports correctly. [99915116]
  • The ResetWidth and GetPreferredWidth methods now work correctly. [99914955]
  • The SaveHTML method now works correctly. [99914903]
  • Scrolling now works correctly with multiple panels. [99914862]
  • Cross sheet formulas now work correctly when using the mouse. [99914774]
  • Custom combo cells now work correctly. [99914534]
  • The border editor now works correctly when selecting multiple rows. [99914392]
  • The ShowGrid property now works correctly with grid lines. [99914344]
  • Headers and footers now work correctly. [99914292]

Versions 4.0.2015.2005 and 4.0.3515.2008
Release Date 02/15/2010
Technical Problems Fixed

 fpSpread component
  • The scroll bars now work correctly when the row count is set to a small or large value. [27227]
  • The GetIntersectedFilteredInRows method now works correctly. [27128]
  • Selecting cells now works correctly with the formula text box. [27123]
  • The mouse wheel now works correctly with the formula text box. [27122]
  • Certain Excel-formatted files now load faster. [27089]
  • Certain Excel-formatted files now load correctly. [27047]
  • The SetInsideBorder method now works correctly. [26998]
  • The ScrollBarShowMax property now works correctly. [26960]
  • The ScrollBarShowMax property now works correctly. [26959]
  • The Cando property now works correctly. [26958]
  • Certain Excel-formatted files now import and export correctly. [26953]
  • Using unicode characters for the currency symbol now works correctly. [26932]
  • The VerticalScrollBarPolicy property now works correctly. [26444]
  • Setting a cell value for an invisible row now works correctly. [26349]
  • Pasting now works correctly with number cell types. [26209]
  • The scroll bar now works correctly with large column widths. [26029]
  • Certain formulas now load correctly from an Excel-formatted file. [25804]
  • The control no longer stops responding when setting a list control property to a listbox with a combo cell. [25676]
  • Unlocking a column when there are frozen columns now works correctly. [25312]

Versions 4.0.2012.2005 and 4.0.3512.2008
Release Date 08/13/2009
Technical Problems Fixed

 fpSpread component
  • Copying and pasting blocks of data greater than the column or row count now works correctly. [26916]
  • Setting the column or row count between the SuspendLayout and ResumeLayout methods now works correctly. [26899]
  • Cross-sheet references now load correctly. [26867]
  • Certain Excel-formatted files now load correctly. [26857]
  • The FormatString property of the general cell type now works correctly. [26856]

Versions 4.0.2011.2005 and 4.0.3511.2008
Release Date 08/03/2009
Technical Problems Fixed

 fpSpread component
  • Copying and pasting now works correctly. [26511]
  • The multi-column combo cell now works correctly in a user control. [26279]
  • Setting a skin now works correctly under certain appearance settings. [26102]
  • The SaveExcel method no longer requires a reference to the FarPoint.PluginCalendar assembly. [26094]
  • The SaveXML method now works correctly if the sheet does not have a name. [26056]
  • The GetPreferredColumnWidth method now works correctly with header cells. [26028]
  • The formula text box now works correctly when scrolling. [26026]
  • Certain characters are now handled correctly when exporting to PDF. [25977]
  • Spread shows the correct number of rows when bound to a related table. [25954]
  • The print header is now centered correctly. [25872]
  • The Rate formula function now works correctly. [25857]
  • Certain xlsx files now load correctly. [25840]
  • The border editor dialog now works correctly. [25743]
  • The number cell type now works correctly when deleting. [25729]
  • Setting the Visible property for a large number of rows now works correctly. [25649]
  • The program no longer stops responding when binding to a data view that is not part of a dataset. [25497]
  • The filter is now reset correctly. [25474]
  • Scrolling now works correctly. [25445]
  • Right clicking on a dropped down combo cell no longer causes the cell to go out of edit mode. [25431]
  • Setting the row count to zero when there are spanned cells now works correctly. [25383]
  • The ShowPageSetup method now works correctly. [22436]

Versions 4.0.2010.2005 and 4.0.3510.2008
Release Date 04/08/2009
Technical Problems Fixed

 fpSpread component
  • The GetPreferredHeight method now works correctly. [25215]
  • The focus rectangle is no longer displayed around the header cell text when the VisualStyles property is set to off. [25135]
  • The program no longer stops responding when closing the print preview dialog (after canceling the printer selection). [25060]
  • The scrollbars now work correctly when filtering a row. [25009]
  • Exporting custom column headers with wrapped text to an Excel-formatted file now works correctly. [24972]
  • The DisplayAtTopOfList property now works correctly. [24970]
  • Scrolling now works correctly with hidden rows. [24884]
  • Binding to an empty class at design time now works correctly. [24839]
  • Clicking off of a combobox cell in a bound row of a DataSet now works correctly. [24775]
  • The BorderEditor border images now display correctly. [24749]
  • Putting a null value in a cell bound to an ArrayList now works correctly. [24672]
  • Footers now print correctly to certain printers. [24670]
  • Binding the Spread control to a collection that implements the IBindingList interface now works correctly. [24658]
  • The GetPreferredColumnWidth method now works correctly. [24629]
  • The button cell now works correctly when there are many hidden rows in the Spread control. [24622]
  • The IRR formula function now works correctly. [24575]
  • The ActionComplete event now works correctly with the tab key. [24562]
  • Pasting an invalid value into a number cell now fires an error event. [24525]
  • The ScrollBarShowMax property now works correctly. [24508]
  • The control now works correctly with an hid compliant mouse. [24507]
  • Custom formula descriptions now work correctly with the formula text box. [24478]
  • The LeaveCell event now works correctly with the SelectionBlockOptions property. [24258]
  • The SerializeModels property now works correctly when the Localizable property is set to True. [23948]
  • The default font is now correctly exported to an Excel-formatted file. [23363]
  • Filtering now displays correctly with dual monitors. [22885]

Versions 4.0.2009.2005 and 4.0.3509.2008
Release Date 12/22/2008
Technical Problems Fixed

 fpSpread component
  • Scrolling has been enhanced. [23975]
  • The formula editor now works correctly in a user control. [23923]
  • The NoteIndicatorSize property is now serialized correctly. [23845]
  • Setting a decimal separator for the currency cell now works correctly. [23661]
  • Editable combo cells are now correctly imported from an Excel-formatted file. [23660]
  • The height of the multi-column combo cell is now set correctly. [23621]
  • Certain Excel-formatted files now import correctly. [23555]
  • Binding to a binding source with many levels now works correctly.[23539]
  • The formula text box now works correctly when clicking on a cell. [23538]
  • Certain Excel-formatted files now load correctly. [23511]
  • The back color of the tab strip is now correctly exported to an Excel-formatted file. [23510]
  • The Product formula function now works correctly. [23501]
  • Printing one page with the print dialog now works correctly. [23483]
  • The default font now correctly exports to an Excel-formatted file. [23363]
  • The Spread control now works correctly in a user control with formulas. [23327]
  • The Spread control now works correctly in a user control. [23326]
  • The NewRow parameter of the LeaveCell event now works correctly with single select mode. [23269]
  • An interface type object is now saved correctly in a bound control. [23236]
  • A read only data column now works correctly with the Spread control. [23145]
  • Data in a combo cell now exports correctly to an Excel-formatted file. [23140]
  • The Spread control now works correctly with a table layout panel with a user control. [23053]
  • Reloading a hierarchical dataset now works correctly. [23041]
  • The hyperlink cell has a new event. [22984]
  • Loading an image now works correctly. [22895]
  • Serialization has been updated. [22893]
  • Scrolling and setting the row count to zero no longer causes the program to stop responding. [22890]
  • The footer now prints correctly. [22886]
  • Filtering now works correctly when using dual monitors. [22885]
  • Spanned data now exports correctly. [22874]
  • The NonEmptyRowCount and NonEmptyColumnCount properties now work correctly. [22871]
  • The clipboard cut action now works correctly with the undo action. [22868]
  • Setting the row count to zero no longer causes the program to stop responding. [22867]
  • Certain characters now correctly export to an xml file. [22866]
  • Certain data now correctly exports to an Excel-formatted file. [22857]
  • Selecting items with the combo cell type now works correctly. [22849]
  • Selecting rows now works correctly with frozen columns in the sub editor. [22844]
  • The ScrollBarShowMax property now works correctly. [22843]
  • The ShowPrintDialog property now works correctly when printing multiple sheets. [22828]
  • The EditingControl property in the ComboSelChange event now reflects the correct editor. [22827]
  • The GetChildView method now works correctly. [22822]
  • The AllowDragFill property now works correctly with a custom data model. [22818]
  • The TextTipFetch and CellClick events now work correctly with the sheet corner. [22810]
  • The ExcelSaveFlags enumeration has a new option. [22458]

Versions 4.0.2008.2005 and 4.0.3508.2008
Release Date 10/29/2008
Technical Problems Fixed

 fpSpread component
  • Certain strings are now formatted correctly when loading Excel-formatted files. [23268]
  • Certain Excel-formatted files now load correctly when control panel is set to Spanish. [22889]
  • Creating a custom skin in the Spread Designer now works correctly. [22577]
  • Certain data now exports correctly to PDF. [22055]

Versions 4.0.2005.2005 and 4.0.3505.2008
Release Date 08/07/2008
Technical Problems Fixed

 fpSpread component
  • Printing to PDF now works correctly when the print spooler service is not running. [22806]
  • Copying a value from a combo cell now works correctly. [22785]
  • The CanFocus property now works with conditional formatting. [22774]
  • Exporting to PDF now works correctly with certain print settings. [22773]
  • The EditModeReplace property now works correctly with the AllowUserFormulas property and edit mode. [22762]
  • A multi-column combo box now displays correctly if the form is maximized. [22760]
  • Certain Excel-formatted files now load correctly. [22747]
  • The right margin now works correctly with the scale rule. [22742]
  • The DataField property now works correctly in the Spread designer. [22741]
  • Pasting data into the Spread control from an Excel-formatted file now works correctly. [22646]
  • Loading an Excel-formatted file into a sheet now works correctly. [22626]
  • The GetPreferredHeight method now works correctly with a text cell. [22624]
  • Anti-Aliasing fonts now work correctly with a hyper link cell. [22599]
  • The undo now works correctly with the ClipboardPasteToFill property. [22596]
  • The undo now works correctly with multiple sheets. [22595]
  • The VLOOKUP function now works correctly with date values. [22574]
  • The SaveAsFiltered flag now works correctly. [22563]
  • Printing now works correctly with certain settings. [22562]
  • Certain Excel-formatted files now load correctly. [22557]
  • Exporting custom headers to an Excel-formatted file now works correctly. [22551]
  • The undo action now works correctly with child sheets. [22523]
  • Certain cell types now import correctly from an Excel-formatted file. [22518]
  • Certain Excel-formatted files now load correctly. [22514]
  • The print preview now displays correctly. [22513]
  • Sorting and then exporting to an Excel-formatted file now works correctly. [22499]
  • Certain formulas now load correctly when loading an Excel-formatted file. [22496]
  • The ScrollTipPolicy property now works correctly. [22491]
  • Transparent colors are now handled correctly when exporting to an Excel-formatted file. [22488]
  • Spread now works correctly on an inherited form. [22443]
  • Smart print now centers the data correctly in the print preview control. [22439]
  • The Spread Designer now correctly saves the AutoCalculation property setting. [22365]
  • Filtering now works correctly. [22303]
  • Using multiple save flag settings no longer causes the program to stop responding. [22156]

Versions 4.0.2003.2005 and 4.0.3503.2008
Release Date 05/14/2008
Technical Problems Fixed

 fpSpread component
  • Child controls now paint correctly when scrolling. [22478]
  • The designer now works correctly with sheet skins. [22465]
  • The GetColumnFromTag method now works correctly. [22459]
  • The ShowPageSetup method no longer causes the program to stop responding. [22436]
  • The HitTest method now works correctly when sorting. [22406]
  • The Spread control now works correctly on a maximized mdi form. [22349]
  • Formulas now work correctly when recalculating after grouping. [22314]
  • The row filter icon now displays correctly when grouping and moving columns. [22312]
  • Setting the FractionDenominatorPrecision property to custom now works correctly. [22272]
  • New character lines are now correctly exported with the SaveHtml method. [22265]
  • Skins are now correctly exported to PDF. [22223]
  • Exporting to PDF now works correctly with wrapped column header text. [22197]
  • Setting the selection to cells now works correctly when sorting. [22175]
  • Resizing the column by double-clicking now works correctly. [22174]
  • Exporting to an Excel-formatted file now works correctly with custom data models. [22172]
  • The program no longer stops responding when using filters and code in the mouse move event. [22170]
  • Setting the height of a column header row to 0 when grouping now works correctly. [22166]
  • Typing 0 in a number cell that has the LeadingZero property set to no, now works correcty. [22163]
  • Enhancements have been made when adding cell spans. [22140]
  • The control no longer stops responding when using notes in colum headers while the number of rows is zero. [22139]
  • The button cell now displays the correct color when locked. [22138]
  • Text tips now work correctly with spanned cells. [22137]
  • The combo cell now works correctly with a null item. [22131]
  • Certain Excel-formatted files now load correctly. [22130]
  • The GetPreferredWidth method now returns a smaller width if there is extra space in the column. [22119]
  • The AutoCompleteSource property now works correctly. [22103]
  • Exporting to PDF now works correctly when the display uses large fonts. [22098]
  • Printing specific pages with notes now works correctly. [22094]
  • The ScrollBarShowMax property now works correctly. [22086]
  • The LoadTextFile method now works correctly with certain files. [22085]
  • Centering an image now works correctly in a cell span. [22074]
  • Cell and text objects are now handled correctly with garbage collection. [22073]
  • Exporting to PDF now works correctly when control panel is set to Finnish. [22071]
  • The classic skin now works correctly. [22059]
  • The FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat flag now works correctly. [22058]
  • Certain formulas now load correctly from an Excel-formatted file. [22043]
  • Scrolling now works correctly. [22040]
  • The general cell now displays a large value correctly.[22038]
  • Certain Excel-formatted files are now correctly imported. [22034]
  • Notes and custom headers are now correctly exported to an Excel-formatted file. [22033]
  • Sorting now works correctly if the EditModePermanent property is true. [22030]
  • Exporting to PDF now works correctly with certain non-ASCII characters. [22026]
  • The GetColumnFromTag method now works correctly [22025]
  • Bold fonts now export correctly to PDF. [22015]

Versions 4.0.2001.2005 and 4.0.3501.2008
Release Date 02/12/2008
Technical Problems Fixed

 fpSpread component
  • Saving to an Excel-formatted file no longer causes the program to stop responding. [22028]
  • The Spread Designer now works correctly when setting the row count to zero. [22019]
  • Printing to a PDF file now works correctly with Microsoft Windows 2000. [22014]
  • The SetRowHeight method no longer causes the program to stop responding in the edit change event. [22012]
  • Changing the column width now works correctly. [22008]
  • Smart Print no longer causes the program to stop responding. [22004]
  • Scrolling and filtering no longer causes the program to stop responding. [22003]
  • Print Preview now displays borders correctly. [21990]
  • Certain Spread Designer settings now work correctly. [21984]
  • The program no longer stops responding after setting the SerializeModels property at design time. [21912]
© 2002-2010, GrapeCity, Inc. All rights reserved.