Changing alignment

Use case 

You need to align text in some columns of the table.

Solution

1. Switch the page to the edit mode.

2. Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.

3. Select the macro and click Edit.

4. In the Presets  tab select Custom transformation  and click Next.

5. Enter the following SQL query:

   SELECT  FORMATWIKI("{cell:vertical-align=bottom}", T1.'Bill to', "{cell}") AS 'Bill to', FORMATWIKI("{cell:align=right}", T1.'Invoice', "{cell}") AS 'Invoices', T1.'Date', T1.'Product', T1.'Price' FROM T1

   SQL

6. Click   Next . 

7. Define the table settings and view options if needed. 

8. Save   the macro and the page.