TABLE TRANSFORMER - Using class stylesheet with FORMATWIKI {cell}

[Roberta Bortolotti]

Hi,

I wonder if there is a way to use the class attribute name in the FORMATWIKI with {cell}. For example, I tried the following but it did not work.

SELECT * 

FORMATWIKI({cell: class='cw-state__icon'}" + 'Priority' + "{cell}")

from T*

Thank you

[Tomislav Tobijas _Koios_ · Accepted solution]

Hi @Roberta Bortolotti ,

I didn't use Table Filter app that much so I can't be much of a help here, but I would just like to point out to the official vendor support portal in case you don't get any answer here.

Vendors usually reply fast and can help with almost all troubleshooting questions.

Cheers,
Tobi

[Roberta Bortolotti]

Thank you, @Stiltsoft support and @Tomislav Tobijas _Koios_ , I will send my question via support portal and post the answer here so others can get it as well.

I went through the documentation and there is no mention of using CSS class.

Thank you,

Roberta

[Stiltsoft support]

Seems that we've answered this question here and there is no any need to refer to the portal unless you have other troubles:

And answering your initial question: no, the class attribute is not supported. We support only style attributes.

[Roberta Bortolotti]

Thank you, @Stiltsoft support 

Where can I find the CSS file for the attributes used by Stilsoft macro?

Roberta

[Stiltsoft support]

The ones you see in the documentation are supported: bgColor, textColor, align, vertical-align, width, height, border-color, font-size, font-weight. That is regarding the FORMATWIKI function.

If you are talking about the CSS formatting, then you may use the Stylesheet tab of the Table Transformer macro where you can apply regular CSS code. Here we have only basic examples but you may write your own code.

[Roberta Bortolotti]

Thank you so much, @Stiltsoft support 

Before I close this question, one last one: Is there any plan to for Table Transformer to support CSS class in the future?

[Stiltsoft support]

The Table Transformer macro was initially designed to work with tables as mini-databases using the AlaSQL library and tiny bits of JavaScript.

The FORMATWIKI function and CSS Stylesheet tab were designed for standard content formatting (and conditional formatting as a big separate case).

If we got you correct, you want smth that allows you to create your own HTML classes, set them somewhere in the macro (in a special CSS file, somewhere in a new UI tab, and so on) and then use these classes in the queries for custom formatting.

If this is the case, we don't have any similar requests (yours is the first one). From our experience, it is rather hard for our users to use even the FORMATWIKI function. There are a lot of cases when they switch to the Table Spreadsheet macro to work with conditional formatting in a familiar Excel style.

So, as for now we don't have any plans to extend the macro capabilities in the advanced formatting area. We've registered your feature request but unfortunately it needs way more user votes to be implemented.

[Roberta Bortolotti]

Thank you, @Stiltsoft support

I was thinking of the user would specify an AUI Class. https://aui.atlassian.com/

An example is this macro from ScriptRunner https://docs.adaptavist.com/sr4c/7.3.0/features/macros/built-in-macros/create-page

I will keep my eyes open in case this is implemented in the future.

Best,

Roberta

[Stiltsoft support]

Thanks for the clarification!

Anyway, this thread is linked to the ticket from our backlog, so if the feature is implemented, we'll come back here to notify you.

[Stiltsoft support]

Hi @Roberta Bortolotti ,

If you have any questions regarding the Table Filter, Charts & Spreadsheets for Confluence app and its macros, you may refer to our support portal for further assistance (just as @Tomislav Tobijas _Koios_ has kindly mentioned).

And you may also browse our documentation regarding the question: here is a part related to the FORMATWIKI function.

And answering your initial question: no, the class attribute is not supported. We support only style attributes.