3 Replies Latest reply on Aug 30, 2016 11:35 PM by haxtbh

    Not all cell formatting appearing in excel 2013


      I am using Coldfusion to generate a large spreadsheet (18 tabs) with a lot of formatting and it works perfectly when I view the resulting file in Excel 2010 but a bunch of the formatting is missing in Excel 2013.


      If I generate each tab in a separate Workbook then the spreadsheets work great but when combined into a single Workbook, problems appear.


      Tab 1 - 3 columns x 19 rows  Formatted 42 cells.  formatting is correct on all cells

      Tab 2 - 6 columns x 21 rows. Formatted 92 Cells.  formatting only 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 was thinking there might be a limit on the number of formats that can be applied to a workbook, but then why would it work in Excel 2010 and not Excel 2013.

      I am only using 10 different styles but I am applying them on a cell by cell basis.


      Has anyone else run into this problem before?