Ga naar hoofdinhoud

Custom Format Cell dialog

This dialog lets you apply custom formats to one or more groups of table cells. It can be invoked from the object menus of a table box, a straight table or a pivot table, provided that the Design Grid command of the View menu is activated or when the Always Show Design Menu Items under User Preferences: Design is checked.

The group of cells to be affected by the formatting is determined by where you right-click in the table to invoke the command. The smallest group of cells to be formatted as a unit is one field (normally column) in a table box or one expression/dimension in a table chart. If striping is used, each stripe is formatted separately.

Whenever this dialog is used to custom format any part of a table, the Style as set in the Style page of the table's Properties dialog will be set to [Custom]. If you change the Style setting back to one of the pre-defined styles, the custom formatting will be lost.

InformatieTable styles in general will be superseded by any formatting resulting from attribute expressions.
  • Table Preview Pane: The preview pane shows format changes made to the group/groups of table cells. Unlike the smaller preview to the right, Sample Text, it shows the changes in context and after the application of visual cues and/or attribute expression formatting.
    Within this pane it is possible to freely move about the table and apply formats to the different groups of cells. Just click in a cell to move formatting focus.
  • Undo: The Undo button can be used for undoing the changes made within the Custom Format Cell dialog step by step.
    After leaving the Custom Format Cell dialog all changes made in the dialog may be undone with just one click on the Undo button in the main toolbar.
  • Redo: The Redo button can be used for reapplying changes previously undone with the Undo button within the Custom Format Cell dialog step by step.
  • Sample Text: This is the preview cell which shows the settings made.
  • Background Color: Defines the cell background color.
  • Text Color: Defines the cell text color.
  • Border before cell: Here you define the border to precede the cell. There is a drop-down for setting border style and a button to set border color. Note that cell borders will be merged between cells, which may cause the actual border in the table to look differently from the preview.
  • Border after cell: Here you define the border to succeed the cell. There is a drop-down for setting border style and a button to set border color. Note that cell borders will be merged between cells, which may cause the actual border in the table to look differently from the preview.
  • Text settings: In this group you fins a number of text modifiers applicable to the cell:
    • Text Size: Use the drop-down to apply a size modification to the general font used in the table.
    • Bold: Mark this check box for bold text.
    • Italic: Mark this check box for italic text.
    • Underlined: Mark this check box for underlined text.
    • Drop Shadow: Mark this check box for text with drop shadow.
  • Border after cell: Changes are normally applied only to the expression, dimension or field (table boxes) in which you right-clicked to access the dialog. With the help of this drop-down you may choose to apply the same formatting to other expressions, dimensions or fields.

Was deze pagina nuttig?

Als u problemen ervaart op deze pagina of de inhoud onjuist is – een typfout, een ontbrekende stap of een technische fout – laat het ons weten zodat we dit kunnen verbeteren!

Neem deel aan het Analytics Modernization Program

Remove banner from view

Moderniseer zonder uw waardevolle QlikView-apps op het spel te zetten met het Analytics Modernization Program. Klik hier voor meer informatie of om contact op te nemen: ampquestions@qlik.com