xuri/excelize
xuri/excelize
1
4
Fork 0
Code Issues Pull Requests Projects Releases 22 Wiki Activity

22 Releases 22 Tags

RSS Feed
  • v2.0.2 a00ba75f0f
    Compare

    v2.0.2 Stable

    xuri released this 2019-10-09 14:11:32 +00:00 | 749 commits to master since this release

    We are pleased to announce the release of version 2.0.2. Featured are a handful of new areas of functionality and numerous bug fixes.

    A summary of changes is available in the Release Notes. A full list of changes is available in the change log.

    Release Notes

    The most notable changes in this release are:

    Breaking Change

    Upgrade requirements Go language version is 1.10 or later.

    Notable Features

    • Create pivot table support. New function AddPivotTable() has been added
    • Create sparkline support. New function AddSparkline() has been added
    • New function GroupSheets() and UngroupSheets() support group and ungroup sheets
    • New function AddVBAProject() to support add vbaProject.bin file which contains functions and/or macros
    • The function SetPageLayout() now support to support to set fit to width and height, relate issue #432
    • The function SetSheetViewOptions() support to set whether to "show a zero in cells that have zero value" now
    • Allow access to more formula attributes in SetCellFormula(), support set the type of the formula and the ref attribute
    • Font strike style support, relate issue #482

    Bug Fixes

    • Fix missing text of comments in some case, resolve issue #434
    • Fix RemoveRow() out of range in some case by recalculate offset for merged cells adjuster, resolve issue #437
    • Fix invalid formula in data validation drop list
    • Fix file corrupted when calling the Save() method in the iteration, resolve issue #443
    • Compatible with different types of relative paths in workbook.xml.rels to fix read file failed in some case, resolve issue #442
    • Fixed file corruption when deleting all merged cells in some case
    • Fix issue where the protection worksheet settings are invalid in some case, resolve issue #454
    • Fix GetSheetName doesn't work in some case by check the sheets list based on index instead, resolve issue #457
    • Add multi-row inline strings support, relate issue #464
    • Fix overflow numeric cell value on the 32-bit operating system, relate issue #386
    • Fix go module dependency errors, relate issue #466 and #480
    • Fix file corrupted when calling SetSheetPrOptions() in some case, resolve issue #483

    Performance

    • Performance optimization, faster for reading the file, relate issue #439

    Miscellaneous

    • Add missing error check in SetSheetRow()
    • Optimize code, combine internal functions:
      workBookRelsWriter, drawingRelsWriter into relsWriter;
      drawingRelsReader, workbookRelsReader, workSheetRelsReader into relsReader
      addDrawingRelationships, addSheetRelationships into addRels
    Downloads