Hi,
I have a spreadsheet (attached) that can not be opened when it is saved in SpreadsheetML.
Here’s my code:
public void AsposeTest()
{
var workbook = new Workbook();
workbook.Open(“C:\block_formatting.xls”, FileFormatType.Default);
workbook.Save(“C:\block_formatting.xml”, FileFormatType.SpreadsheetML);
}
And when I open the SpreadsheetML, here’s the error I got:
XML ERROR in Worksheet Setting
REASON: Bad Value
FILE: C:\block_formatting.xml
GROUP: Worksheet
TAG: Table
ATTRIB: ExpandedColumnCount
VALUE: 255
Some tips:
When we manually set the ExpandedColumnCount in the SpreadsheetML to 256, it will work.
btw, I’m using the Aspose.Cells in .NET.
-Steve
Hi,
Thanks for providing us the template file.
We found the issue after an initial test, we will figure it out soon.
Thank you.
Hi,
Please try the attached version.
Thank you.