This project is read-only.

Copy a style from the template and use in new cells

Feb 21, 2013 at 3:46 AM
I've created template xlsx file and now I'm trying to copy the cell style from one cell to a new one on a newly created row. But the cell style format doesn't seem to be holding. I'm wondering if I've missed something.


SpreadsheetStyle MonthStyle = WorksheetReader.GetStyle(Document, wsPart, "A", 19);

. . . (a bunch of code)

ws.SetStyle(MonthStyle, "A19");

The original cell appears as "January 1980" and the format is "mmmm yyyy"

When the code is finished cell appears as "38,231" and the format is "#,###"

If I change the format to "mmmm yyyy" it correctly shows "September 2004"
Feb 13, 2015 at 2:29 PM
I'm trying to do exactly the same thing....

Did you manage to find a solution?