Formula not getting applied in xlsb file after 256 columns


#1

Hi All,

I am using excel.save(outstream,fileFormat) method of com.aspose.cells.Workbook but after 256 columns formula is not getting applied.
I have attached sample code for that. Please check the same

String headerKey = “Content-Disposition”;
String headerValue = String.format(“attachement; filename=”%s"", fileName);
response.setHeader(headerKey, headerValue);
OutputStream outStream=response.getOutputStream();
// SaveOptions saveoptions=new Saveo

        excel.save(outStream, SaveFormat.XLSB);

// excel.save(fileName,SaveFormat.XLSX);
outStream.flush();
outStream.close();


#2

@ankushbh,

Thanks for the sample code segment.

I think the issue might be in your code, so could you create a simple sample project (runnable), zip it and post us here to reproduce the issue, we will check your issue and try to figure it out soon. Also attach your template files (input file(if any) and output file, etc.).