Use case 

You need to preserve the initial formatting and apply a new one.

The FORMATWIKI function can be applied in multiple ways:

  1. With commas (,) inside the function body - i.e. FORMATWIKI("{cell:vertical-align=bottom}", T1.'Your Column', "{cell}") - retains the original source data formatting in addition to adding alignment as per its setting
  2. With pluses ( + ) inside the function body - i.e. FORMATWIKI("{cell:vertical-align=bottom}"+ T1.'Your Column',+"{cell}") - clears the original source data formatting and adds alignment as per its setting

Apply the first approach if the original source content contains links, text, cell formatting, etc. that you need to keep further extending the formatting via the function usage.
Apply the second approach if you either do not need to keep the original source content formatting or it initially contains no formatting whatsoever. 

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 'Week', FORMATWIKI("{cell:textColor=green|align=left|width=200px}", 'Plan for Weekly Progress', "{cell}") AS 'Weekly plan' FROM T*

    Keep the following order of attribues: bgColor, textColor, align, width.

  6. Click Next. 

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

  8. Save the macro and the page.

Preserving initial cell formatting doesn't work in case of rows concatenation.