SpreadsheetFormatRow and SpreadsheetFormatColumn interacting strangely| View in Tracker
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.