Not all cell formatting appearing in excel 2013
i using coldfusion generate large spreadsheet (18 tabs) lot of formatting , works when view resulting file in excel 2010 bunch of formatting missing in excel 2013.
if generate each tab in separate workbook spreadsheets work great when combined single workbook, problems appear.
tab 1 - 3 columns x 19 rows formatted 42 cells. formatting correct on cells
tab 2 - 6 columns x 21 rows. formatted 92 cells. formatting appears on 42 cells
tab 3 - 4 columns x 10 rows .formatted 31 cells. no formatting appears
tab 4 through 15. no formatting appears
tab 16 - 8 columns x 306 rows. formatting on 37 of 2412 cells
tab 17 . no formatting appears
tab 18 4 of 28 cells has formatting.
i thinking there might limit on number of formats can applied workbook, why work in excel 2010 , not excel 2013.
i using 10 different styles applying them on cell cell basis.
has else run problem before?
what file name saving ? xls or xlsx?
which cf version using? think cf11 using apache poi 3.9 dated before excel 2013 well. means may not support lot of 2013
More discussions in ColdFusion
adobe
Comments
Post a Comment