-
UPPERCASE text on entire sheet without formulas
Having to have helper columns for every column in a sheet with formulas to change all text to UPPERCASE that is input through a form from other people makes my very large sheet ridiculously and needlessly larger - and then there is the problem of data shuttle which does not shuttle columns that contain formulas, so you…
-
Run Config Window for Data Shuttle
When you run a DataMesh, a window Run Config window appears that shows the number of rows that will be impacted for different types of things (i.e., New Rows). It would be helpful to have this for Data Shuttle as well. On more than one occasion the unique identifier mapping unexpectedly un-maps, and all the rows are…
-
Sheet Properties / Metadata - Column Count
Rows are numbered but columns are not. There should be sheet metadata available thru File / Properties that tells the user how many columns are in the sheet. This would be helpful for solution developers to know if they're approaching the 400-column limit without the tedious and error-prone task of counting them manually.…