In SQL Navigator, after setting the Formatter options to a custom configuration, the settings have no effect on the code that's being formatted.
Close and reopen session after making changes in Format Options to enable new options, by the following steps:
1. Open Format Options, select required options and save them.
2. Close the database session and reopen it (or open another session to the same database).
3. Apply Format Text (Ctrl +R) to the sql in Editor.
The database session needs to be closed and reopened in order to accept formatting changes. Also, changes made in Formatting Options are permanent until new changes are applied - by following the above steps.