Farpoint Spread 6.0

Posted on by

Whats New With Spreadsheet. Gear. Jump To Version Choose VersionSpreadsheet. Gear 2. 01. 7Spreadsheet. Gear 2. 01. 2Spreadsheet. Gear 2. 01. 0Spreadsheet. Farpoint Spread 6.0' title='Farpoint Spread 6.0' />Farpoint Spread 6.0Gear 2. Spreadsheet. Gear 2. Spreadsheet. Gear for. NET 2. Spreadsheet. Gear for. NET 2. 00. Farpoint Spread 6.0' title='Farpoint Spread 6.0' />Spreadsheet. Gear for. NET V1 1. Spreadsheet. Gear 2. Farpoint Spread 6.0' title='Farpoint Spread 6.0' />Farpoint Spread 6.0Although Visual Basic 6. UnicodeUTF16 it has several limitations Ships with ANSI only controls Label, Textbox, etc. VB. netSpread spread. Spreadsheet. Gear 2. Spreadsheet. Gear for. NET Standard product, official support for Excel 2. Excel 2. 01. 6, 5. Excel functions, full conditional formatting support, enhanced workbook protection and encryption, cell gradient rendering, and more. Jump directly to the latest New Features and Issues Addressed for the most recent General Availability Release. Latest Hotfix Issues Addressed. Our latest hotfix 8. Nov 3, 2. 01. 7 and is a rollup of issues addressed since the last General Availability Release. Active subscribers of Spreadsheet. Gear can download this hotfix from the Licensed Users Downloads page. Fixed rendering problems with conditional formats when the cell interior uses a fill color and the conditional format color and or pattern color are transparent 8. Implemented calculation performance improvements for certain workbooks which contain a large number of columns 8. Fixed IRangestring reference, IRange. Address and IRange. Get. Address to work with strings 6. K in length and made improvements to IRangestring reference performance in cases where the returned IRange has a high IRange. Area. Count 8. 0. Fixed a problem which sometimes occurred when copying array formulas to other cells in the same column 8. Fixed an issue where scrollbar values were being set incorrectly based on the last sheet tab 8. Added support for copying from a partial array formula 8. Fixed pasting text from Windows clipboard in Silverlight Workbook. View control 8. 0. Fixed clearing of cell contents to no longer throw an exception when clearing a data table without clearing the input rows and or input columns 8. Fixed an issue which caused exceptions to occur in certain cases with the Windows Forms Workbook. View and a combination of UI thread and background thread tasks which use the Workbook. Download Rather Be here. View 8. 0. 6. 6. Fixed Workbook. View. Rewind. Lock to work correctly 8. Fixed issues in Silverlight Workbook. View where text cells are sometimes displayed incorrectly when they are offscreen but overflow into the viewable area 6. Fixed a rendering issue which occurred when resizing rows or columns when using split panes 6. Fixed Calculation. Semi. Automatic mode to calculate data tables when F9 or CTRLALTF9 is pressed and when IWorkbook. Set. Calculate or IWorkbook. Set. Calculate. Full is invoked 6. Fixed problems which sometimes caused shapes to not be properly moved when cells are inserted or deleted 6. Fixed setting the contents of a cell to be more compatible with Excel 2. Fixed rendering issues which caused some merged cells to fail to update when the result of a formula in that cell changes 6. Fixed hiding and showing of rows and columns to update IRange. Show. Details as approprate 8. Fixed problems with the IFERROR and INDEX worksheet functions which occurred with certain very complex workbooks 8. Fixed problems with IRange. Find which occurred when finding on a worksheet with autofilters and hidden rows, when the speciied after argument references a cell in one of these hidden rows 8. Fixed an issue which caused shapes to fail to be moved and or resized as needed when IRange. Show. Levels is used to show or hide rows or columns 8. Fixed an issue which caused the right or bottom cell border to fail to paint when the last column or row in the displayed range is hidden and there is extra display space beyond the last cell 8. Fixed issue where we were losing the tint and shade settings when reading chart and shape font colors from an Open XML workbook 8. Fixed an issue which caused exceptions to be thrown in cases where multiple unreferenced Workbook. View controls are reclaimed by the garbage collector at one time without having had Dispose called on them 8. Fixed a problem in the Formula Bar which caused the name box to fail to update after selecting ranges with the keyboard while hodling down the Shift key 8. Spreadsheet. Gear 2. Spreadsheet. Gear 2. WPF and Silverlight controls, multithreaded recalc, 6. Windows 1. 0 support, Windows Server 2. R2 support, Visual Studio 2. XAML controls, save to XPS and more. Jump directly to the latest New Features and Issues Addressed for the most recent General Availability Release. New Features. WPF and Silverlight Workbook. View and Formula. Bar controls. Support for 6. Excel 2. 01. 0 compatible functions see list below. Support for Windows 8, Windows Server 2. Visual Studio 2. 01. NET 4. 5. Windows 8. Visual Studio 2. 01. Spreadsheet. Gear 2. V7. 1. Windows 1. Visual Studio 2. 01. NET 4. 6 support were added in Spreadsheet. Gear 2. 01. 2 V7. Multithreaded recalc and sorting. Improved memory efficiency and performance for most workbooks particularly in 6. Rich text support in cells with the WPF and Silverlight Workbook. View controls. Custom row and column text as well as custom styling with XAML Control Templates in the WPF and Silverlight Workbook. View controls. Support for saving to Microsoft XML Paper Specification XPS Documents with Spreadsheet. Gear. Windows. Xps. Workbook. Xps. Document. New Spreadsheet. Gear. Core. dll assembly with no references to GDI or Windows Forms. Support for System. Char types in the IRange. Value setter as well as when importing data from a data table. Workbook. Explorer. Allow. Workbook. Designer property to disable the Workbook Designer from the Workbook Explorer. Added bitmap image rendering support to Silverlight with the Spreadsheet. Gear. Windows. Media. Image class 7. 0. Added support for reading and writing Open XML workbooks larger than two gigabytes 7. New Excel 2. 01. 0 compatible functions AVERAGEIFAVERAGEIFSBETA. DISTBETA. INVBINOM. DISTBINOM. INVCEILING. PRECISECELLCHISQ. DISTCHISQ. DIST. RTCHISQ. INVCHISQ. INV. RTCHISQ. TESTCONFIDENCE. NORMCONFIDENCE. TCOUNTIFSCOVARIANCE. PCOVARIANCE. SERF. PRECISEERFC. PRECISEEXPON. DISTF. DISTF. DIST. RTF. INVF. INV. RTF. TESTFLOOR. PRECISEGAMMA. DISTGAMMA. INVGAMMALN. PRECISEHYPGEOM. DISTIFERRORLOGNORM. DISTLOGNORM. INVMODE. MULTMODE. SNGLNEGBINOM. DISTNETWORKDAYS. INTLNORM. DISTNORM. INVNORM. S. DISTNORM. S. INVPERCENTILE. EXCPERCENTILE. INCPERCENTRANK. EXCPERCENTRANK. INCPOISSON. DISTQUARTILE. EXCQUARTILE. Holes By Louis Sachar For. INCRANK. AVGRANK. EQSTDEV. PSTDEV. SSUMIFST. DISTT. DIST. 2. TT. DIST. RTT. INVT. INV. TT. TESTVAR. PVAR. SWEIBULL. DISTWORKDAY. INTLZ. TESTIssues Addressed. Fixed a UI locking issue when auto filling and scrolling by dragging the mouse past the end of the Workbook. View. Fixed OFFSET function to support returning an array of ranges when used in an array formula. Fixed to use the default number format for Open XML number formats which cannot be read. Fixed to clear undo buffer when IWorkbook. Save. To. Memory is called. Fixed IStyle. Equals to no longer cause a stack overflow exception. Fixed saving Open XML workbooks with external workbook references to no longer prepend file to paths which do not start with X where X is a drive letter. Fixed the behavior of adjusting the first displayed sheet tab when a worksheet is selected or deleted. Fixed to support Locale. Argument. Separator when editing formulas in a Workbook. View control. Improved IRR to converge on a result in more cases.