Released: Jun 5, 2025

18.1.2 버젼 업데이트

수정사항

• Data Binding:
  • The SpreadJS custom asynchronous function was triggered to execute twice after the setDataSource method is called.
  • The formula calculation in the first sheet affected the table binding speed of the second sheet.
• Filter: The tree node structure in the row filter was incorrect.
• Calculation Engine:
  • Result of COUNTIF and SUMIF was different from Excel comparing '-', '-'.
  • After exporting to Excel, the arc @ symbol in the formula caused calculation errors.
  • If you export ssjson, then...

Released: May 22, 2025

18.1.1 버젼 업데이트

수정사항

• Calculation Engine:
  • Fixed a calculation engine bug where configuring PrintArea caused the AsyncFunction to trigger four recalculations.
  • Non-volatile Async Custom Function calculated the second time Print tiles were set.
  • Fixed an incorrect Formula Evaluation After Excel Import – SUMIF with Entire Column Reference and Use of addRows.
  • Fixed issue where import of sjs file failed.
• DataChart:
  • Changing chart type removed the existing bindings.
• Data Validation:
  • DataValidator reference did not...

Released: May 8, 2025

18.1.0 버젼 업데이트

기능

• ​Performance & Optimization​​
  • Reduced the size of the SpreadJS Designer component JS and CSS for faster loading.
  • Improved PivotTable performance for smoother data operations.
• ​​Designer Enhancements​​
  • SidePanel Flexibility​​: The Designer SidePanel now supports docking and floating.​​
  • Command Palette​​: Added Command Palette support for streamlined workflows.
  • Ribbon Checkbox Styling​​: Updated the appearance of ribbon checkboxes for better visual consistency.​​
  • Scrollbar Control​​: Added...

Released: Apr 10, 2025

18.0.7 버젼 업데이트

수정사항

• Calculation Engine fix:
  • Cell reference is not updating.
  • Conditional formatting does not display consistently with Excel.
  • Formula String Lost After Import Xlsx To SpreadJS.
  • Inconsistency with Excel's calculation.
  • String In Date Format Will Regard As Date Value In SumIf Function.
  • The calculation results of the calculation worksheet and calculation are different.
• Comments fix:
  • Import file annotations cannot be viewed.
• ConditionalFormatting fix:
  • Conditional formatting not being displayed...

Released: Mar 26, 2025

18.0.6 버젼 업데이트

기능

• Added support for Windows Server 2025.

수정사항

• Calculation Fix:
  • Unexpected Behavior of totalCellCount in the calculationProgress Event.
  • The calculation result of the WORKDAY function is inconsistent with Microsoft Excel.
  • SLN formula problem.
  • Result of formula is inconsistent with Excel.
  • Set formula and Undo does not return.
• Charts Fix:
  • Removed Legend is still displayed on spreadsheet when importing from Excel.
• Designer Fix:
  • The page margin data on designerUI is wrong.
  • After setting a custom...

Released: Mar 13, 2025

18.0.5 버젼 업데이트

수정사항

• Fix:
  • The SpreadJS would display as blank in some circumstances.
  • A formula in the Name Manager incorrectly changes the list separator in a different culture.
  • Shortcut keys could still be used when a cell was locked.
  • Dialog and text tip position were incorrect in the Wujie framework.
  • Entering a full-width number in a cell with percentage formatting would result in an incorrect value.
  • Hierarchy icons would disappear after refreshing a table.
  • Setting as #¥* the format string in a cell will...

Released: Feb 27, 2025

18.0.4 버젼 업데이트

수정사항

• Fix:
  • A character displayed in vertical mode was inconsistent.
  • There was a discrepancy between versions for table.getDirtyRows().
  • Hidden filter buttons would incorrectly appear after cutting and inserting certain columns and cells.
  • Scrollbar size would not reset after deleting a row and undoing the deletion.
  • Table columns could not be deleted if a table only contained a header.
  • Tables would not display filter buttons in certain circumstances.
  • There were some issues with drag filling.
  • Some...

Released: Feb 13, 2025

18.0.3 버젼 업데이트

수정사항

• Miscellaneous:
  • A template preview effect was not consistent.
  • Arrow key navigation was slow.
  • The transpose pasting effect was inconsistent with Excel.
  • The padding text for a cell resulted in an incorrect font style.
  • Conditional formatting formula incorrectly applied a prefix.
  • Color is lost after using auto wrap in Rich Text.
  • A red mark would appear in the corner of a cell when modifying the value in preview mode.
  • Different values of a bound column could not be edited.
  • Vertical mode character...

Released: Jan 16, 2025

18.0.2 버젼 업데이트

수정사항

• Fix:
  • Tooltips were not displayed when hovering over a merged cell in a row header.
  • Moving a parent hierarchy up and down caused issues.
  • There was an issue with percentage data.
  • Content copied from WPS and pasted into SpreadJS was not correct.
  • Drag filling a block did not trigger the print line change.
  • The copy and cut methods of the TouchToolStrip can now be overridden via commands.
  • Copying content from DingTalk documents to SpreadJS causes a table area to turn white.
  • In preview mode...

Released: Jan 2, 2025

18.0.1 버젼 업데이트

수정사항

• Fix:
  • A header image was not correctly displaying in WPS.
  • Scaling the worksheet size incorrectly altered the text layout in an area camera shape.
  • Formulas could not be copied using the copyTo method.
  • An issue was happening with the DataSource table column visible property.
  • ReportSheet image formats were not working correctly.
  • After filtering, data that was pasted into other sheets was incorrectly changed.
  • Pixel based scrolling would cause display issues.
  • The CalcArray.toArray result was not...