Released: Mar 26, 2024

Mises à jour de 17.0.5

Correctifs

• Calculation Fix
  • The ISREF and INDIRECT functions would have different formula results.
  • A specific formula was incorrect.
  • The formula editor would show as undefined for the listSeparator when the culture was changed.
  • A custom function would not show in a sheet.
• Chart Fix
  • The order of charts in a combo chart would not stay the same when using JSON.
  • Restricting the number of series in a chart was not working correctly.
  • Horizontal axis units were inconsistent.
• Microsoft Excel Compatibility
  • Cell spanning after dragging and filling was inconsistent.
  • Hyperlink cells were inconsistent with Excel.
  • The "Ctrl + A" shortcut behaved different than Excel.
• Excel IO Fix
  • Extra rows and columns would incorrectly appear after importing an Excel file.
  • An exported SJS file was prompted to be repaired in Excel.
  • An invalid format error would occur when opening a specific SJS file.
  • Exporting a PDF would remove information from a slicer.
  • An exported Excel file would crash when sorting in MS 2016.
  • A cell position would be incorrect after moving with the keyboard after exporting to Excel.
  • "GetSpans" would return incorrect results.
  • A pivot slicer was lost after exporting to Excel.
  • Conditional formatting would not take effect after exporting to Excel.
  • A slicer's content was incorrectly changed after exporting to Excel.
  • The style of subtotals in a PivotTable would change after exporting to Excel.
  • A slicer's display content was changed after exporting to Excel.
• ReportSheet Fix
  • Support renaming bound columns of a data source.
  • Data entry settings could not filter out columns.
  • The "Show Collapse" button did not work correctly in certain circumstances.
  • An exception was thrown if the DirtyStyle was null.
  • Formula results were incorrect when adding a record in a ReportSheet.
  • The report wizard would throw an error when adding a report.
• Table Fix
  • Deleting a filtered row in a table would cause unexpected behavior.
  • The TableColumnsChanged event was not triggered after adding a column to a data source.
  • Copying and pasting could incorrectly lead to the expansion of columns in a table in certain circumstances.
• TableSheet Fix
  • TableSheet was incorrectly displayed in a panel when inserting a GanttSheet.
  • The data would change when a row was deleted from a sorted column.
  • There was a delay with clicking and cell selection in the Free Header Area.
  • The behavior of TableSheet in Design Mode was not correct.
• Accessibility Fix
  • A VoiceOver screen reader was encountering issues in MacOS 14 and 15.
• Demo Fix
  • The FormatDialog sample displayed an error.
• Designer Resource Fix
  • Some resources were confusing in certain cultures.
• Documentation Fix
  • The openPasteSpecialDialog command API was changed.
• Performance Fix
  • Clearing formula values would cause some performance issues.
• PivotTable Fix
  • Modifying the cells of a PivotTable after setting borders would make the borders disappear.
• Print Fix
  • A sheet was missing in a printing preview.
• Touch Fix
  • Setting the mask on a cell did work with touch devices.
• The EditEnded event would fire when a cross sheet reference was made.
• The culture isn't considered when validating a number.
• The priority was not correct when pasting pictures.
• Data label font options were not available.
• Data was not showing correctly after collapsing and expanding.
• Data validation would not display correctly.
• Inputting "-$100" would have different results in certain circumstances.
• Deleting rows would cause a loss of data validation in some circumstances.
• After closing the Find dialog after using a shortcut, it couldn't be opened with the shortcut again.
• Some borders didn't display correctly in the column header.
• The sorting status was lost after sorting by cell color and opening the sorting dialog.
• The isUndo property output of a custom command in the RowChanged event was incorrect.
• Setting the style of a font would be invalid in some iOS environments.
• A shared formula with a free header area was displaying incorrectly.
• A slicer was not updated properly when the data source of a sheet was changed.
• When dragging and dropping a data source onto a template, the error message was not consistent.
• A custom name would overflow text in an auto complete container element.
• The dataManager would not notify after loading was completed.
• Clicking on a cell would cause the whole sheet to be incorrectly repainted.
• Deleting records would incorrect influence Circle Invalid Data.
• The defaultDatePattern property was not public.
• Selection ranges were incorrect in some circumstances.
• After setting pasteSkipInvisibleRange to true, pasting did not work as expected.
• Data could not be recovered after a slicer filter was cleared.