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

Popular posts from this blog

Illustrator CS6 Ocurrío un error E/S en el archivo.

Why is os_ViewContainer running?

Animate - problem with duplicating scripts after loop