We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Error Check options not working with .xlsm files

Hi,

I have the following code run with 2 sample files c.xlsm and d.xls the two files are the same just saved in different format.

Before runnning the code below please open both files separatly and note that both have a green triangle on the top right corner of each cell. After running the code below the triangle is gone only for d.xls.

The code below works with d.xls but not with c.xlsm

Workbook wb1 = new Workbook("d.xls");

Worksheet ws = wb1.Worksheets[0];

format(ref ws, 0, 0, 10, 10); //user sub defined

wb1.Save("d.xls");

-------------------

public static void format(ref Worksheet s, int startrow, int startcol, int endrow, int endcolumn)

{

Aspose.Cells.ErrorCheckOptionCollection opts = s.ErrorCheckOptions;

int i = opts.Add();

Aspose.Cells.ErrorCheckOption opt = opts[i];

opt.SetErrorCheck(Aspose.Cells.ErrorCheckType.TextNumber, false);

CellArea ca = new CellArea();

ca.StartRow = startrow;

ca.StartColumn = startcol;

ca.EndRow = endrow;

ca.EndColumn = endcolumn;

opt.AddRange(ca);

}

I will appreciate if you can solve the issue with XLSM files

Thanks

Hi,

We will support it within 1-2 days.

Hi,


Please try the attached version v7.0.2.6, we have supported it for XLSM file format.

Thank you.

I tested and it works great

Thank You

The issues you have found earlier (filed as CELLSNET-40081) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.