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,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Please try the attached version.
Thank you.