Released: Sep 27, 2018

11.2.6 での更新項目

不具合の修正

• Fixed an issue where drag-swapping columns in a page causes a loss of data binding.
• Fxed a problem with the LOOKUP formula calculation.
• Fixed an issue with exported Excel files not following the Open XML specification.
• Fixed performance degradation issues with applying styles on cells from V 11.0.6 to V 11.2.4.
• Fixed a problem where backColor is null after importing.
• Fixed an issue where adding a chart crashes when selecting a column.
• Fixed a problem where the full DataRange area is not...

Released: Sep 13, 2018

11.2.5 での更新項目

不具合の修正

• Fixed a bug with the “COUNTBLANK” formula.
• Fixed performance issues with the “SUMIFS” formula.
• Fixed performance of worksheet operations.
• Fixed an issue with importing a combination chart from Excel.
• Fixed a zooming issue.
• Fixed a problem with the “RANK” formula.
• Fixed an issue with the “COUNTIF” formula.
• Fixed a problem with Excel values changing when importing.
• Fixed Excel importing issues.
• Fixed issues preventing the sheet object initializing in the workbookInitialized event.

Released: Jul 25, 2018

11.2.1 での更新項目

機能

• React and Vue.js Support - SpreadJS can now be used in the React and Vue.js frameworks. This includes specific tags as well as elements and events that make using the two together easy. With SpreadJS being released on NPM, you can use it with the frameworks by either using traditional HTML or the NPM package.
• SpreadJS NPM Package - SpreadJS has now been publicly released as an NPM package. The package can be downloaded and used in your applications, which makes it easy to keep it updated...

Released: Jun 28, 2018

11.1.4 での更新項目

不具合の修正

• Fixed an issue where the result of the “h:mm:ss” format is incorrect after a Chrome update.
• Fixed a problem where a cell can’t be selected when editing a cross-sheet formula when allowDragMerge is true.
• Fixed an issue where certain Excel files are exported without formulas and the date is not displayed correctly.
• Fixed a problem where the IRR function does not calculate correctly.
• Fixed an issue where the XIRR function results in #NUM!

Released: Jun 19, 2018

11.1.3 での更新項目

不具合の修正

• Fixed a problem with table binding not working when the sheet is not active.
• Fixed an issue where word wrap does not work correctly after the cell padding is set.
• Fixed a problem where shared formulas don’t import correctly.
• Fixed an issue where cell spans have errors after inserting rows.
• Fixed a problem where the browser crashes when importing Excel files that contain the CDATA formula.

Released: Jun 5, 2018

11.1.2 での更新項目

不具合の修正

• Fixed an issue with exporting to PDF resulting in incorrect code on macOS in some cases.
• Fixed a problem with zooming.
• Fixed an issue with some spread options not working when initializing.
• Fixed a problem with the qualityFactor causing print layout to be incorrect.
• Fixed an issue where copying numbers does not work correctly for some imported Excel files.
• Fixed some problem with calculating formulas.
• Fixed an issue with the AVERAGEIF function when the sum range includes a blank cell.

Released: May 17, 2018

11.1.1 での更新項目

不具合の修正

• Fixed calculation precision issues.
• Fixed a problem with the SUM function calculation.
• Fixed an issue with ranges not open format cells dialog in the designer when clicked.
• Fixed a problem with the formula bar not working correctly when focused using tab.
• Fixed an issue with exporting to PDF.
• Fixed a formula calculation problem.
• Fixed an issue where certain calculation engine results were not consistent with Excel.
• Fixed a problem with the canvas.arc position being incorrect when exported...

Released: Apr 25, 2018

11 Service Pack 1 での更新項目

機能

• Undo/Redo enhancement - In previous versions, undo and redo for custom commands had to be handled with multiple functions. Now the user only needs to define the "execute" function, making it much simpler.
• FilterDialog UI enhancement - SpreadJS now supports tree hierarchies in the filter dialog, useful for dates and outlines. The hierarchies support conditional filters like text, number, and date, as well as color.
• Protection Options enhancement - More protection options have been added to the...

Released: Dec 6, 2017

11 での更新項目

機能

• Chart Support - Successfully import and export Excel files with charts. Charts include column, bar, line, pie, doughnut, area, scatter, bubble, stock, and combination.
• New Function Support - SpreadJS now features a more extensive function library with 462 functions. The functions are for use in scientific, statistical, engineering and business formulas.
• HitTest functionality is now supported at workbook level.
• Columns can now be easily indented for tree structures.
• Events have been added for...

Released: Aug 29, 2017

10 SP2 での更新項目

機能

• Added support for Angular.
• Added new features to the Spread Designer:
  • Cell padding and labels.
  • Tag setting.
  • Clipboard options.
  • Range select.
  • Calendar sparkline.
• Added a Korean culture option.

不具合の修正

• You can now remove the border format of cells in the Designer.
• You can now display the formula by using formulaTextBox.
• The PrintInfo firstPageNumber is now correct and in sync with Excel.
• Excel no longer opens with an error when there is no selection.
• Opening an Excel file that has formulas with...