Only encrypt with password starts to support in Spire.XLS 7.6.33

A new release version of Spire.XLS 7.6.33 is available today. In this new version, we add new features to protect the file with password and set the offset of image. With the effort of our develop team, we also fix bugs in this version. View the details as below:

New Features:

  • Add new feature to only encrypt with password.
  • workbook.Protect("111",false,false);
    
  • Add new feature to set the offset of image when the fill way of chart is picture fill.
  • Workbook book = new Workbook();
    Worksheet sheet = book.Worksheets[0];
    Chart chart = sheet.Charts.Add();
    chart.ChartArea.Fill.CustomPicture(Image.FromFile("01.png"), "None");
    IChart ichart = book.Worksheets[0].Charts[0];
    (ichart.ChartArea.Fill as XlsShapeFill).Tile = false;
    (ichart.ChartArea.Fill as XlsShapeFill).PicStretch.Left = 10;
    (ichart.ChartArea.Fill as XlsShapeFill).PicStretch.Top = 20;
    (ichart.ChartArea.Fill as XlsShapeFill).PicStretch.Right = 10;
    (ichart.ChartArea.Fill as XlsShapeFill).PicStretch.Bottom = 5;
    

Bug solutions:

  • Fix the issue that "Zip exception" when loading the CSV file using LoadFromStream method.
  • Fix the issue that the feature to lock/unlock cell doesn't work.
  • Fix the issue that the content of chart is incorrect when .xls to .xlsx conversion.
  • Fix the issue that all datalable fonts will change when setting individual datalable's font.
  • Fix the issue that the format of the cell will change when merging multiple files.

Welcome to experience Spire.XLS 7.6.33 with downloading here:

http://www.e-iceblue.com/Download/download-excel-for-net-now.html