Skip to main content

Set formatting per data row/column using a formula in the ausgabe list.

  1. Go to the ausgabe General tab in the list.
  2. Click on neu Add > bookmark Bookmark in text processing to insert a new formula.
  3. Double-click to open the formula and select, for example, the function "Text > Enumerate conditions (text)".
  4. Enter the name of the default bookmark as the "Else value". If one bookmark is set in a list, all text must be formatted using bookmarks. Items for which no bookmark is defined are automatically assigned the "Other value".
    Example: "Standard"
  5. Enter one or more conditions and the name of the bookmark you want as value.
    Example: All items in the item group sharing the External 2 name "Foods (External 2 is usually used for top groups)" should be formatted according to the settings for the "Foods" bookmark. The "Foods" bookmark is formatted as right-aligned, font Arial, font size 11pt.
    [Group External 2 (character string (31))]="Foods"; "Foods";
    Result: All items in the groups that have the name External 2 "Foods" (main dishes, side dishes, soups etc.) are formatted right-aligned and in Arial font, size 11pt.
  6. Add further bookmarks, check and confirm the formula by clicking OK.