This article details workarounds related to Merged Cells and Merge & Center.
Support & Consulting has composed a few workarounds to merge cells ad Merge & Center not working within the Cloud web portal.
- Insert a small column in the center of the report and just use center on that one cell - this works when it’s a fixed set of columns; however, this will not work when expanding.
For expanding, you can put a counter (1,2,3…) in a hidden row above the expanding column and then use an if statement to only show the center text string if it is the middle column based on the counter above. You can view the attachment (Forecast Column Headers w Centered Text.xlsx) example for a forecast situation - the centered text is intended to go in period 6 whether that falls in the actual or forecast section. One downside is that the column has to be wide enough to contain the text (unless someone else knows a way around that…)
For Merge & Center, you can put the OSR code in another cell and reference that non-merged cell in the merged and centered cell. Otherwise, the other workarounds mentioned should work just as fine. Please note, in some cases, on expanding nested groupings, the text-only centers on the first column/row and the ones that follow all left align so you are limited on how to solve those.
- Note, that this only works on the first column/row of a nested grouping. Basically, it works in headers or non-repeating columns/rows.
If you just expand the formatting one column beyond the expansion and then hide it then it works:
The above will work when you are not using OSRGet formulas in those cells. The attached ('Test [...]' Templates) broken one errs out in Portal because the merged and centered cell for Entity description in cell F3 has OSRGet code and even though F3 isn’t in an expanding column and only overlaps expanding columns, it still errors out in the portal. The non-broken one works because it is referencing OSRGet code from a non-merged cell in F3.
- Private Host