Whats New With Spreadsheet. Gear. Jump To Version Choose VersionSpreadsheet. Gear 2. 01. 7Spreadsheet. Gear 2. 01. 2Spreadsheet. Gear 2. 01. 0Spreadsheet. Gear 2. 00. 9Spreadsheet. Gear 2. 00. 8Spreadsheet. Gear for. NET 2. Spreadsheet. Gear for. NET 2. Spreadsheet. Gear for., ,. Serial Para Reason Care Security. SpreadsheetGear for. NET is a royalty free Microsoft Excel compatible spreadsheet component for the Microsoft. NET Framework featuring the fastest and most complete. Search the worlds information, including webpages, images, videos and more. Google has many special features to help you find exactly what youre looking for. CT000000 null 5. 00 CT000002 SET 1. CT000004. NET V1 1. Spreadsheet. Gear 2. Spreadsheet. Gear 2. Spreadsheet. Gear for. NET Standard product, official support for Excel 2. Excel 2. 01. 6, 5. No more missed important software updates UpdateStar 11 lets you stay up to date and secure with the software on your computer. 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. Dec 5, 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. 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. Fixed an issue which caused shapes to fail to render in certain cases 8. Updated default font in a new workbook used with Japanese Culture. Info to be consistent with Excel 2. MS PGothic to Yu Gothic 8. Fixed a rendering issue which caused text to be painted over itself multiple times causing the text to get darker each time in certain complex rendering cases  8. Fixed conditional formats to ignore interior pattern styles of None as Excel does 8. Fixed border rendering to take into account the luminosity of red, green and blue when choosing darker borders over lighter borders as Excel does 8. Fixed an issue which caused conditional formats to fail to render correctly in certain cases when cells are scrolled into view 8. Fixed an issue which caused an exception to be thrown in certain cases when pasting cell formulas which reference worksheet scoped defined names on a worksheet in another workbook 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. Manual De Instalacion Pc 1550 here. Workbook. Xps. Document. Best Cad Design Software Mac. 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. INCRANK. AVGRANK. EQSTDEV. PSTDEV. SSUMIFST. DISTT. DIST. 2. TT. DIST. RTT. INVT. INV. TT. TESTVAR. PVAR. SWEIBULL. DISTWORKDAY. INTLZ. TESTIssues Addressed.