tracker issue : CF-4204537

select a category, or use search below
(searches all categories and all time range)
Title:

SpreadsheetFormatRow and SpreadsheetFormatColumn interacting strangely

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Michael S. / ()

Created: 06/18/2019

Components: Functions

Versions: 2018

Failure Type:

Found In Build/Fixed In Build: Update 3/4 /

Priority/Frequency: Normal /

Locale/System: / Win All

Vote Count: 0

Problem Description:
Using SpreadsheetFormatColumn to apply a format (i.e. number formatting) to a column causes that column to inherit other formatting (i.e. bold) from a previously used SpreadsheetFormatRow.  The actual formatting in each spot doesn't seem to matter - whatever is applied to the row is inherited to the column (in addition to the column's formatting).

Steps to Reproduce:
This fiddle demonstrates how setting bold on the top row and number formatting on columns 3 and 4 causes those columns to inherit the bold formatting:
https://cffiddle.org/app/file?filepath=aada5d04-08a0-4e14-8157-a4b1467a1a2b/ac2bc145-597e-446b-ad53-f657aa31e0b5/47e2678c-244a-4242-80d5-7b1b05eae95c.cfm

Actual Result:
Top row is bold (correct), columns 3 and 4 are number formatted (correct), columns 3 and 4 are bold all the way down (INCORRECT).

Expected Result:
Top row is bold (correct), columns 3 and 4 are number formatted (correct), columns 3 and 4 are only bold on top row.

Any Workarounds:
This worked correctly in CF10.  The problem is reproducible in CF11, 2016 and 2018.

It seems like there are other combinations you can do to produce other formatting inheritance issues (not necessarily SpreadsheetFormatRow first, etc), but I'm leaving this bug focused on this root issue.

Attachments:

Comments:

Michael, You can avoid the the formatting issue by passing the attribute "styleCellwise" set to true in the formatting struct passed to format the spreadsheet object. For example: {fontsize=10, styleCellwise=cellWiseBool} Alternatively. you may set it at the server level by using the following jvm argument in the jvm.config file: -Dcoldfusion.format.cellwise=true
Comment by Piyush K.
30978 | July 01, 2019 09:49:42 AM GMT