In base, in the table, make default number alignment "Right" not left?

[Original_Memory6188]

That’s my question.

The Spreadsheet has 49 “columns”, two are text, the rest various numbers: Indices (integer), Indices(decimal), counts, percentage, currency. All nicely, integers are centered, decimals to the right.

Import to BASe. all columns are default formatted to the left. When values range from 0 to 9,999.99, or 0 to .0123, this is unpleasant to look at. And individually changing 48 columns (for this table, which is only 1 of 5) is sub-optimal.

A) is there a way to select all the columns in a table and say “change alignment”?
B) is there a way to have BASe just default numbic data to right alignment?

[mariosv]

Please attach a sample file to copy from.

[Wanderer]

@Original_Memory6188

Import to BASe.

Copied to Base, or Spreadssheet as datasource linked? But Ii guess in both versions only data is available, not formatting.

@Original_Memory6188

all columns are default formatted

In a form (grid control) or table view in Base ?

[UnklDonald]

In the Table Data View left alignment is default and I’m not aware of any way to change that but
Right click on a column heading and select Column Format
to open the Field Format dialog. The Alignment tab shows several options, but each column must be changed individually.

When viewing data in Base, a Form is a much better option. Properties dialogs have options like Alignment and numerous Font options including style, size and color.
Plus Table Controls created using the Form Design Wizard by default right justify Numeric fields.