SpreadJS 9 SP1 released

SpreadJS is a comprehensive, high-performance HTML5 spreadsheet component which brings data visualization and calculation features to your Web applications, such as calculators, dynamic interactive dashboards and rich colorful reports. SpreadJS provides powerful grid capabilities and spreadsheet functionality that includes cross-sheet referencing and calculations to make use of data and formulas on a variety of sheets. Built on HTML5 and jQuery technology with Canvas as the presenter on the client side, SpreadJS provides a rich, interactive user experience with an Excel-like appearance.

Updates in 9 SP1

The following bugs were fixed:

• The hitTest method now works correctly when filters are applied.
• Certain Excel-formatted files now import correctly.
• Scrolling issues after importing certain Excel files are fixed.
• Margins now import correctly when importing Excel-formatted files.
• Formulas now recalculate correctly when invoking the Sheet.reset method.
• The DragFillBlock event now works correctly with merged cells.
• Pasted values are now recognized correctly.
• Updating CustomFloatingObject content now works correctly.
• Unlocking cells with conditional formatting applied now works correctly.
• TypeScript definitions for Cell properties are now correct.
• Conditional formatting correctly exports to Excel now.
• Deleting data when using the Safari browser on Mac OS now works correctly.
• Header text is now displayed correctly when setting the default row height.
• Hidden row values are no longer displayed in data filters.
• The autoFitRow method now works correctly when hiding columns.
• The filter dialog now works correctly during data input.
• Searching now works correctly with the French locale setting.
• The DATEDIF formula now works correctly.
• Comments are now displayed properly when loading a sheet and re-adding comments.
• The T.INV formula now works correctly.
• The moveToNextCellThenControl method now works correctly when the row count is zero.
• Long dates are now formatted correctly.
• Importing Excel-formatted files with images now works correctly.
• SpreadJS now works correctly within a scrollable container.
• Custom data validation is now saved correctly to an Excel-formatted file.
• The SpreadJS Designer now displays the correct names in the name manager.
• Cells with line breaks are now pasted correctly.
• The cellType.processMouseEnter/processMouseLeave functions now work correctly when scrolling.
• The row filter now works correctly when cells contain line breaks.
• The dirty status is now set correctly when editing a cell with a line break.
• Performance issues with loading certain SSJSON files are now fixed.
• SpreadJS now displays properly on Mac OS.
• The German culture setting now works correctly with certain values.
• Printing to PDF now works correctly.
• Scrolling now works correctly with large column widths.
• Row filters now work correctly when cells contain HTML tags.
• Formulas that reference other sheets now update correctly.
• The recalcAll method now works correctly.
• The Excel import and export DLLs now display the correct version number.
• Merged cells are now pasted correctly.
• Custom culture now works correctly.
• The qualityFactor method has now been added.
• The formula text box now uses the correct culture setting.
• Excel-formatted files are now exported correctly when using the German culture.
• The ACCRINT formula now works correctly.
• The ADDRESS formula now works correctly.
• The spread.fromJSON method now works correctly.
• Certain Excel-formatted files now load correctly.
• The SpreadJS Designer now displays comments correctly.
• The general formatter now works correctly.
• The ExcelIO DLLs now contain the correct information.
• When saving to SSJSON, rowHeaderColWidth and colHeaderRowHeight now return the correct types.
• The addRows method now works correctly with formulas.
• Cell values are now formatted correctly when using German culture settings.

About GrapeCity

GrapeCity has been in the software business for over 25 years. Its corporate headquarters are located in Sendai, Japan, with operations spanning throughout the United States and Asia. Its products benefit corporations, software companies and independent consultants as cost-effective solutions for building distributed Enterprise-wide applications.