Released: Jan 5, 2024

Updates in 17.0.1

Fehlerkorrekturen

• Calculation
  • A formula was automatically changed incorrectly.
  • A formula was not updated with the RemoveRow RowAction.
  • Certain formulas had incorrect results.
  • Some formulas would not calculate correctly after using resumeCalcService.
  • The lambda formula would not calculate correctly.
  • Deleting a row that contained bound data would prevent a referenced formula from being recalculated.
  • The COUNTIF formula did not calculate correctly.
  • There was a delay in calculating specific formulas.
• Chart
  • A data area would not expand automatically.
  • Series would display incorrectly after a chart is inserted.
  • Switching the data axis would fail if the coordinate axis was not a date type.
  • A chart would not display correctly after importing.
  • The value axis setting of a radar chart was invalid.
• Designer
  • Creating a chart was slow in some circumstances.
  • Data validation was inconsistent.
• Excel IO Fix
  • A file would not import correctly.
  • Cell references were changed incorrectly after importing/exporting a SSJSON file.
  • Some cell values would not display correctly after exporting to Excel.
  • Some Excel files were displayed incorrectly after importing.
  • A #VALUE! error was thrown after loading a SSJSON file in the Designer with the it-IT culture.
  • Gridline colors were not exported properly.
  • Filter options were lost after exporting and then importing.
  • Some chart content was missing after importing an Excel file.
  • An XLSX file could not be loaded.
• Font Enhancement: The Wingdings 2 font was added to fontFamilies.
• Mobile Fix: A sheet would be blank after creating a lot of sheets in iOS.
• PivotTable Fix: Setting a style was slow in some circumstances.
• Printing Fix: The cutting action would incorrectly change the printing area.
• Tables in a Data Source Sheet would not update correctly if added by code.
• Table Column Data Formulas did not work properly.
• TableSheet Fix: A certain format would not apply correctly.
• Filter items would not show in a dialogue.
• Undoing a filter will incorrectly cause content to be hidden.
• AutoFitRow would not work correctly.
• The status bar had some errors with sum.
• Inserting cut cells caused the page to crash with a large number of rows and columns.
• Copying and inserting rows caused some errors.
• Inserting a sparkline was inconsistent with Excel.
• The option button controls were not shown correctly.
• Setting a row height would take different times in the runtime and the Designer.
• Sorting results were inconsistent with Excel.
• The icon set for conditional formatting was displayed incorrectly.
• Opening up a data validation drop-down did not automatically scroll to the selected item.
• Sorting a single cell would show an incorrect error message.
• The state of an Option Button was incorrect.