This feature allows the user to change the data in the Browse Data tab on a per-column basis before displaying it. This means even though the data is stored in format X in the database it can be shown in format Y in the browser. This should be useful in cases where the original format X is hard to read or just not useful in a particular case.

For activating the display format, you have to right-click on the header of a column.

Select "Edit display format" to open a dialog which offers a (limited) list of pre-defined formats.

Select the desired display format from the list.

Click OK and the selected format is then applied to the display of the column.

Some considerations have to be taken into account when using display formats:

• Data is not editable (or only via the Edit Dialog) because it isn't transformed back yet.
• Display format customization is supported starting version 3.12.0 (issue #573). You can use any format function you like from the SQLite set of functions or from any loaded extension. The combo-box will change its text to "Custom" in that case.
• There is a different customizable style for columns, for which a format has been set (v3.13.0 and greater). (issue #3404)