Released: Feb 23, 2020

13.0.6 での更新項目

機能

• Improved context menu styles.
• Imported SSJSON formula update.
• Improved Cell Format dialog in online designer.
• Large password-protected Excel export update.
• Improved Data Validator.

Released: Feb 14, 2020

13.0.5 での更新項目

不具合の修正

• Column widths after importing updated.
• Changing protection options and undo stack.
• Tables can be created by selecting range in designer.
• Cross-sheet formulas are now restored when undoing.
• Microsoft Excel export without display inconsistencies.
• Blank page no longer added when printing in landscape.
• Date formatted cells editing updated.
• NumberFormat.percentGroupSeparator in custom cultures enhanced.
• DateTimeFormat.dateSeparator in custom cultures enhanced.
• Shape text FontSize exports to...

Released: Dec 31, 2019

13.0.3 での更新項目

不具合の修正

• Shapes no longer move when zooming in the sheet.
• A recover warning is no longer thrown for a specific exported Excel file.
• Shape position no longer changes when importing an Excel file.
• Changing a table data source now shows correct formula results.
• Pixel scrolling works correctly with the scroll bar.
• Changing the binding source no longer clears cell values adjacent to the table.
• Loading an Excel file no longer causes problems.
• Cutting and pasting does not cause a formula reference area...

Released: Dec 13, 2019

13.0.2 での更新項目

不具合の修正

• Values less than 1 are calculated correctly on logarithmic axes.
• Updating formulas with many dependent formulas no longer freezes tab.
• CalcOnDemand option added to ExcelIO in the tutorial demo.
• Sorting now correctly triggers dirty data.
• Image background color is now correctly exported to PDF.
• HitTest returns correct location when clicking on the bottom-right of a cell.
• SPAN tag no longer breaks form layout.
• IMSUB result is now correct.
• Undo operation is now handled correctly for...

Released: Nov 6, 2019

13 での更新項目

機能

• In-cell images and buttons with a variety of useful drop-down menus.
• Cell state styles for visual feedback based on user activity.
• New cell types:
  • Radio List
  • Checkbox List
  • Button List
  • Range Template
• Microsoft Excel parity features:
  • Chart enhancements
  • Table behavior enhancements
  • Text rotation
  • Pixel scrolling
  • Dynamic arrays and new array functions
• Formula Tracing for enhanced spreadsheet audit and debugging.
• Dynamic column width.
• Split resizing.
• Auto merging.

Released: Sep 12, 2019

12.2.5 での更新項目

不具合の修正

• Chart labels no longer disappear after moving the chart’s data range and then undoing.
• Can now handle undo operation for adding/deleting row/column correctly.
• Formulas now calculated correctly after using the “doNotRecalculateAfterLoad” flag.
• Fonts no longer change abnormally when setting conditional formatting.
• The value of “oldSelections” of the “SelectionChanged” event is now correct after drag-fill operation.
• The value of “rowList” of the “RowHeightChanged” event is now correct when...

Released: Aug 29, 2019

12.2.4 での更新項目

不具合の修正

• goToRange not defined.
• Cell reference with absolute referenced not displayed correctly.
• Formula updates incorrectly when inserting a table row.
• Can’t properly serialize the “conditionRuleBase” type.
• SpreadJS Online Designer unable to set font for a region.
• Loading the same template twice fails to copy.
• SSJSON missing after exporting to Excel.
• ChangeFormulaReference does not work correctly.
• Copying cells causes cell span.
• Error when calculating SUM formula.
• Incorrect range update in...

Released: Jul 22, 2019

12 SP2 での更新項目

機能

Printing Enhancements

• Printing in SpreadJS has been enhanced with a new event, print preview lines, printing info for the page, and background watermark images. With the new BeforePrint event, printing can be cancelled after it is initiated. With print preview lines, dotted lines are drawn in the workbook to show where pages end when printed out.
• The print info now includes API to show the printing range of cells for each page, and the background watermark image can now be added when printing...

Released: Apr 22, 2019

12 SP1 での更新項目

機能

Runtime Features

• Double-Click Auto-Fill - Filling data was already a part of SpreadJS, but now users can double-click on fill indicators in order to auto-fill data.
• Data Validation - Different cell highlighting types have been added to the data validation in SpreadJS. This includes circle, dogear, and icon.
• Number and Date Display Enhancement - The way that numbers and dates are displayed in SpreadJS has been enhanced. When these are too big to fit in a cell, the number will be changed to fit...

Released: Nov 1, 2018

12 での更新項目

機能

• Add Custom and Built-in Shapes to your JavaScript apps - Draw shapes, create interactions, and change them with data. Like Excel, SpreadJS 12 implements dozens of built-in shapes to add more detail and visual appeal to your workbooks, as well as the ability to seamlessly import and export Excel workbooks that contain shapes. These 60+ shapes include basic rectangles, arrows, balloons, and action buttons.
• Include different formatting in a single cell with rich text formatting - With rich text...