If a workbook contains a worksheet with RowHeight bigger than 600px (SpreadsheetDefaultValues.MaxRowHeight), an exception is thrown while trying to import such a document.
Number formats like "[$-1010409]General" containing locale code and General keyword are not parsed correctly which results in interpreting them as number formats which have to replace the positive numbers with "General". Available in R1 2017 SP
Clicking the Find All button resizes the dialog to a smaller size and the buttons on the bottom are not visible. Closing the dialog and opening it again opens it with very large size. No workaround at the moment.
When using the OpenFile command to open a document, you should be able to obtain the Name of the workbook in the WorkbookChanged event handler.
Currently it's not possible to disable the fill handle feature. Provide API for disabling it.
Workaround: in the attached project.
The sheet selector should hide sheets when their visibility is set to hidden or very hidden. The context menu of the sheet selector should contain Hide and Unhide options that allow to hide a sheet or unhide one of the hidden sheets.
The formula expressions are invalidated by the formula arguments only. Which means that the formula expression will be invalidated only if some of its arguments is invalidated. But formulas like Indirect returns cell reference ranges. If something in the preferred range is changed the result have to update for which invalidation of the formula expression is needed.
The fix will be available in our next LIB release (v. 2015.03.1005).
The feature will be available in our official release Q1 2016.
The fix is available in our latest LIB release (v.2015.3.1026).
The fix will be available in our next LIB release (v. 2015.03.1005).
Using SetValueAsText method to set empty string and the exporting the document generates invalid XLSX, which can not be imported by Excel.
The fix will be available in our latest LIB release (v. 2015.02.0803).
When a cell's format is set to "Percentage" and then a number is entered, the number's format is incorrect. For example, if "10" is entered in such a cell, the value is visualized as "1000.00%", instead of "10.00%".
The fix will be available in our official release 2015 Q2..
When a workbook with a number of worksheets larger than a certain count is saved an out of memory exception is thrown. The necessary number of worksheets depends on the file and the machine, but it ranges between 70-90.
The fix is available in our latest LIB release (v. 2015.1.0323).