afs1jes / Clarins-CA-IR-Migration

0 stars 0 forks source link

Monthly financial statement detail Ecommerce #17

Open afs1jes opened 1 year ago

afs1jes commented 1 year ago

-- experimenting with selectable inside a @ member cell

afs1jes commented 1 year ago

corrected display column headers for lag formulas. Removed zoom Control (improved builds from 30 seconds to 10 seconds). added Do Not Read/Write markers to spacer columns.

FrederickGiroux commented 1 year ago

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

afs1jes commented 1 year ago

edited grid properties to allow outlining. Revoked subtotal formulas for all columns. Locked all cells in grid (grid is not write-enabled).

Returning for retest.

FrederickGiroux commented 1 year ago

Column spacing too wide

AVHuntley commented 1 year ago

Migrated formatting again to correct small discrepancies.

FrederickGiroux commented 1 year ago

Workbook name is different. Otherwise its ok

FrederickGiroux commented 1 year ago

Image

AVHuntley commented 1 year ago

Yeah, how strange. Seems like maybe the CONCAT formula I'd used for the WorkbookName name was messing with that. I changed the formula to use ampersands instead (like most other templates), and that seems to do the trick.

Image