# Release Notes for Version 8.20.20143.0 and 8.35.20143.0 undefined ## Content This set of release notes includes enhancements and version details. ## Changes from the Previous Release This version of the product has the following changes from Spread for WinForms 7: * The SaveXMLOptions parameter has been added to the Save and SaveXML methods. * The ManualLayout property has been added to the PlotArea class. * The Overlay property has been added to the LabelArea class. * The Overlay, ManualLayout, and LegendPos properties have been added to the LegendArea class. * The TitleManualLayout and TitleOverlay properties have been added to the Axis class. * The FilterBarFilterActive, FilterBarFilterDateTime, and FilterBarFilterInactive fields have been added. * Set the ManualLayout property to false to automatically adjust the plot area if the size or location of the chart title is changed. * Additional fields have been added to the DefaultStyleCollection class. * Additional options have been added to the AggregationType enumeration. ## Enhancements from the Previous Release This version of the product has the following enhancements from Spread for WinForms 7: ## Spread for WinForms 8 * New Control Features * Tables * Office2007 Skin * Office2013 Skin * New Design Features * New Default Skins * More Methods and Properties * RangeGroupSummaryRowBelow * RangeGroupSummaryColumnRight * PictureZoomEffect * New Classes * FlatInterfaceRenderer * FlatScrollBarRenderer * FlatFocusIndicatorRenderer * FlatSelectionRenderer * FlatColumnHeaderRenderer * FlatColumnFooterRenderer * FlatRowHeaderRenderer * FlatCornerHeaderRenderer * FlatCornerFooterRenderer ## Resolved Issues * Text in the text tip is no longer truncated if the text is too long. [51967] * Default sheet names are now exported correctly when saving to an Excel-formatted file. [51968] * Spread now correctly displays calculated values after opening an Excel-formatted file. [51969] * Cell borders now render correctly when the Spread grid lines are hidden. [51971] * The BeginPrinting parameter is now set correctly when the last sheet is empty. [51972] * Custom data models now automatically size columns. [51974] * Items in the filter drop-down list are now sorted based on the string values displayed in the cells. [51991] * The chart area Fill property is now set correctly after importing an Excel-formatted file. [51996] * The custom x-axis location is now correctly exported to an Excel-formatted file. [51997] * The chart SelectData form is no longer lost when the application loses focus. [51998] * Certain 2007 Excel-formatted files now import correctly using the OpenExcel method or the Spread Designer. [52294] * The ShowGrid property now prints the left grid correctly. [52295] * A custom combo box cell no longer causes an exception. [52297] * Certain XML files now load correctly. [52700] * The cell font is now updated correctly when changing the Spread font. [56293] * Conditional format rules now work with custom names. [56307] * The combo box now correctly selects the values. [56910] * Copying formulas when copying the sheet now works correctly. [56926] * The Excel open flag now has an import key map option. [56929] * You can now change the position of the outline range group icon. [56935] * Clicking on a row or column header no longer causes an exception. [56936] * The ClipBoardPasteUndoAction class now works correctly when copying and pasting a cell range. [56937] * A custom data model no longer causes an exception. [56941] * The button image now adjusts the button size when zooming in and out. [56947] * Certain XML files now open correctly. [56962] * Spread now provides support when opening a stream with the OpenExcel() method. [61218] * The sharp zip types are now internal. [63807] * You can now set search strings for the Search dialog manually. [64380] * Long text is no longer truncated in the Preview window. [64979] * Certain formulas now load correctly when importing an Excel-formatted file. [65105] * The page setup now displays correctly when the SmartPrintPagesTall or SmartPrintPagesWide property is greater than 100. [65686] * Certain Excel-formatted files now import correctly. [66231] * Certain XML files now import correctly. [67449] * Certain date formats now appear correctly when the system locale is set to German. [75683] * The ShowPageSetup method no longer causes an exception. [76876] * The OpenExcel method returns the correct value. [77272] * The SuggestAppend option in the AutoCompleteMode property now works correctly in the combo box cell. [82565] * Certain Excel-formatted files now import correctly. [83161] * The Trend formula is now correctly imported from an Excel-formatted file. [83451] * Exponential numbers are now handled correctly when sorting a column in the Spread Designer. [84093] * The SaveHtml method no longer ignores height and borders in the TitleInfo class. [84513] * The ColumnSpan property now works correctly. [84683] * The drop-down list now works correctly when validating. [87053] * Printing a sheet to PDF now works correctly. [87260] * Certain Excel-formatted files now import correctly. [87449] * The column width and shapes are now imported correctly when loading an Excel-formatted file. [88504] * Certain files now load correctly. [89061] * Certain Excel-formatted files now import correctly. [89119] * The drop-down list of a custom combo cell now opens correctly when the cell is clicked. [90414] * Certain Excel-formatted files now import correctly. [91710] ## File Versions Spread for WinForms installs the following file versions on your system. See [Installed Files](/spreadnet/docs/latest/readme/installedfiles/installfilesspwin) for the exact location of these files. | **File** | **Version** | | ---- | ------- | | FarPoint.Win.Spread.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.Spread.Html.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.Design.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.Spread.Design.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.PluginCalendar.WinForms.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.SpreadDesigner.exe | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.CalcEngine.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Excel.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.Ink.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.TextRenderer.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.PDF.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.Chart.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Win.Chart.Design.dll | 8.20.20143.0 and 8.35.20143.0 | | FarPoint.Localization.dll | 8.20.20143.0 | | GrapeCity.Win.PluginInputMan.Design.dll | 8.20.20143.0 and 8.35.20143.0 | | GrapeCity.Win.PluginInputMan.dll | 8.20.20143.0 and 8.35.20143.0 |