Released: Jul 29, 2021

14.1.4 中的更新

修補程式

• Inserting formulas was enabled even though the sheet was protected.
• Quotes were not automatically added when adding text to a formula.
• Clicking a check box would take time to update the rest of the sheet.
• The result of a formula was different from Excel.
• PivotTable would update the data source incorrectly when incremental loading is enabled.
• The GETPIVOTDATA formula would not return the correct value.
• Cell formats would change after importing an Excel file.
• An exported Excel file could not be opened.
• Some gridlines would disappear.
• Number validation behavior is inconsistent with Excel.
• Excel IO would throw an error in the Angular framework after v14.1.0.
• A dialogue would not show if a user tried to drag/drop a cell into a merged range.
• Designer: The formula bar would not work in the Safari browser.
• Opening one file after another would result in incorrect cell background colors.
• Using “clear all” would not work after selecting all cells and setting the cell background color.
• The result of the XIRR formula was inconsistent with Excel.