Released: Jan 7, 2021

4.0.2 中的更新

修补程序

• Image position is wrong after importing ssjson then export to PDF.
• Pivot Table's border is lost in the exported PDF when there are banded rows/columns.
• Exception occurs when opening certain Excel file.
• Freezing range changed after saving existing excel via GcExcel API.
• The image can not display when opening GcExcel exported HTML in QQ and outlook mailbox.
• The image border is wrong in the exported HTML.
• Null exception is thrown after calling calculate method.
• It becomes slow if you update cell tag in custom function.
• Rows can not be deleted after calling IRange.delete method.
• Open and then save an Excel with auto filter, an error occurs.
• IRR formula calculation result is different with Excel.
• Cell B2's value is different with Excel.
• Gradient and pattern fill are lost after GcExcel load ssjson.
• Copy pasting with intersecting merged cells throws exception.
• When GcExcel copys whole rows/columns to other one with merged area, an invalid operation exception will occur.
• The line disappears in exported image.
• Sheet background image can not be exported to HTML.
• When the cell adjacent to the cell set the C template property is entered value or formatted, generated data is incorrect.
• It takes a long time to load a ssjson.
• Cell value is wrong when opening Excel with DoNotCalculateAfterOpened is true.
• Exception is thrown after opening and saving Excel file.
• When TemplateOptions.KeepLineSize is set true, row heights in generated xlsx file are not the same as the original template file.
• ArgumentOutOfRangeException occurs when GcExcel get the cell value which can't be converted to DateTime.
• ArgumentOutOfRangeException occurs when the max value of DateTime is set in a cell.
• Hyperlink is not generated in exported HTML when the cell is set a Hyperlink function.
• Broken file created when copying sheet (related to Comments).
• Cell formats are lost after SpreadJS load the ssjson generated by GcExcel.
• Webdings font does not take effect in the exported PDF.