We have problem with cell formatting in generated XLSX file in 184.108.40.206 version (same problem actually exists in 220.127.116.11 version).
If you open attached file "test.xlsx", you'll see a number "152" in formatted cell C5 (Sheet1). Formatting applied is...
- Font size set to Calibri 8pt
- Background color set to "White Background 5% darker"
Now, if you change formatting of that cell to currency using "$" button in number options, it works OK.
So, "test.xlsx" is the template we use when opening new workbook instance through Aspose.Cells.
We do not manipulate any cell, sheet or any workbook option and just save it through Aspose.Cells as "DATA2011-06-02-18-41-01.xlsx" to harddrive (SaveFormat.Xlsx).
If you change formatting of that same cell to currency using "$" button in number options, it loses all formatting (both font size and background color).
So, it's something in Aspose.Cells causing this as file created/saved directly through Excel works OK.
We validated this behavior in both Excel 2007 and Excel 2010.
Any ideas on solving this? Is there any property to set?