search

afs1jes / Clarins-CA-IR-Migration

0 stars 0 forks source link

Monthly financial statement detail - Cascaded #4

Open AVHuntley opened 1 year ago

AVHuntley commented 1 year ago

In the title section, there's a reference to =@SelectCompany which resolves to #NAME. Company isn't a selectable, as far as I can tell, so I'm not sure what this should be.

rlautt commented 1 year ago

55 sec

FrederickGiroux commented 1 year ago

Formating not the same, missing the grouping for the ''+'' or ''-'' to collapse and expand

afs1jes commented 1 year ago

Adjusted grid properties to allow application of formatType to rollups. Also enabled Subtotal property to create row groupings.

Returning for retest.

FrederickGiroux commented 1 year ago

Column spacing is different. Also we should not see the gridlines. The variance column V, AD, AH should not be red once i press ''+''

AVHuntley commented 1 year ago

Okay I took another stab at copying the formatting from the prod version. Then I also locked formulas so they don't show up in red font.

FrederickGiroux commented 1 year ago

grouping seems fine. We shouldnt see the gridlines, the sheet tab color is different, spacing is too wide.

AVHuntley commented 1 year ago

-Copied and pasted the formatting from the prod template into the dev template. This adjusted the column width. -Unselected template property 'Show gridlines'

As for the tab colors, this might just be a feature of the new version of A3. In cascaded models, tabs for rollups and leaves are colored differently. Here's a comparison: Prod (old/original): Image

Dev (new/migrated): Image

Is this going to be okay?

FrederickGiroux commented 1 year ago

Hey Alec, this reports is sometimes consolidated in a group report and the tab colors are there to match the look and feel of the rest of the report. So yes please, i'd like the tab to be the same color as before.

afs1jes commented 1 year ago

Hi Fred,

This is the result of a new product feature. A3 Cascade now colors tabs based on whether the sheet member has children in the online or not. Previously, all cascaded sheets inherited the tab color of the source sheet. We've forwarded your request to the A3 Product team for consideration. In the mean-time, there are a couple options you can consider. If it's a one-off situation when you prefer to control the tab colors, you could record a macro (and even drop that on your Excel Quick Access toolbar) that you can use to change the sheet colors after a cascade. If the sheet tab colors issue more broadly applies across your user community, you could enable a little post-build VBA to make the change.