What's New With Spreadsheet. Gear. Jump To Version: [Choose Version]Spreadsheet. 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. 00. 6 - 2. Spreadsheet. Gear for . The official website of the City of New York. Find information about important alerts, 311 services, news, programs, events, government employment, the office of the. NET V1 - 1. 2 - 1. Spreadsheet. Gear 2. Spreadsheet. Gear 2. Spreadsheet. Gear for . NET Standard product, official support for Excel 2. Excel 2. 01. 6, 5. New Features. WPF and Silverlight WorkbookView and FormulaBar controls. Support for 64 new Excel 2010 compatible functions (see list below). Support for Windows 8. Download Windows Media Player 11 for Windows 7 (Replace WMP 12). Here way to downgrade windows media player 12 to WMP 11 on Windows 7. UpdateStar is compatible with Windows platforms. UpdateStar has been tested to meet all of the technical requirements to be compatible with Windows 10, 8.1, Windows 8. 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. more. Latest Hotfix Issues Addressed.Our latest hotfix (8.Sep 2. 6, 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 IRange[string reference], IRange. Address and IRange. Get. Address to work with strings > = 6. K in length and made improvements to IRange[string 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. 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. 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. Fixed Workbook Designer freeze panes menu command to not freeze columns when entire row is selected and not freeze rows when entire column is selected. Fixed scrollbar thumb and value positions to account for hidden (non- viewable) rows/cols at beginning and end of worksheet. Fixed issues with Range. Explorer clearing cell formatting when formatting hyperlinks. Changed Workbook. View. On. Mouse. Move to display a Get. Lock / Release. Lock warning only when a debugger is attached. Fixed mouse wheel scrolling issue which occurred when using a high- resolution mouse. Fixed IRange. Merge to throw an exception if an attempt is made to merge a single cell. Fixed chart line markers to no longer render outside of plot area. Fixed autofill & data- series APIs to sometimes copy cell formatting (font, interior, etc..) as Excel does. Fixed some issues with plotting error and empty type values on area charts that use a date axis. Fixed refresh issues with the Workbook. View control when using the Dock / Undock smart tag item in Visual Studio. Fixed default Text. Box horizontal alignment when reading Open XML document. Fixed cell merging to fix up cell borders and formats. Fixed reading of Open XML external references such as "/Dir/Book. C: \Dir\Book. 1. xlsx" as Excel does, and fixed writing external references such as "C: \Dir\Book. Dir/Book. xlsx". Fixed printing routine to only print visible sheets when printing entire workbook. Fixed to no longer include the active cell when using CTRL or SHIFT with Mouse. Down to point at a range when editing a formula. Fixed reading Open XML files to handle xmlns in cases where an exception was being thrown. Fixed copying and pasting of an entire row to be smarter about not creating a large number of blank formatted cells. Fixed HLOOKUP, VLOOKUP and MATCH to compare numbers as Excel does, no longer considering two numbers equal if they are very close as the "=" operator does. Fixed autofilter and data validation drop down controls to choose a more appropriate height to fix the problem where they are not displayed when the default row height is zero. Fixed to read and display shapes which hang past the edge of a worksheet. Fixed to remove incomplete conditional formats before writing workbooks to avoid writing workbooks which Excel will not read. Improved performance when reading Open XML workbooks with a large number of external targets (such as hyperlinks). Fixed Auto. Fill mouse handler to execute Fill. Down / Fill. Right when worksheet has autofilters on as Excel does. Fixed default print range to work more like Excel regarding blank formatted cells. Added Outlines option to Location. To. Range / Range. To. Location APIs. Fixed theme color picker to not select Transparent color tooltip label for white. Fixed undo and redo to handle frozen or split panes correctly. Fixed to no longer display two error message boxes when beginning a cell edit on a protected worksheet with the Backspace key. Fixed to no longer convert references such as $A5: $A$1. REF! when inserting rows above the cell containing the reference.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2017
Categories |