Indicate

Version: 2.2.0

How to create, save and open files

Click on a calculation in the *start screen* to create a new calculation file
Click on a calculation in the *start screen* to create a new calculation file

Click on a calculation in the start screen to create a new calculation file. The start screen is shown when you launch Indicate or when you select New from the File Menu or when you click the Plus Icon in the upper right corner. Use the file menu to save and open previously created files. You can access the file menu by clicking on the menu-symbol (☰) in the upper left corner of the application window. It is also possible top open files via drag&drop.
Note: Right now, it is not possible top open files from within your file manager or desktop!

How to view files

A group of collapsed items
A group of collapsed items
An expanded item
An expanded item

Each file consists of several items such as tables, plots and forms. When you open a file these items are represented by headers. Click on a header to expand and view the item, click again to hide the item. Right click on an item to open its context menu.

Use the context menu to sort and filter tabular data
Use the context menu to sort and filter tabular data
Use the context menu to adjust a plot's visual appearance
Use the context menu to adjust a plot's visual appearance
Use the scrollbar on the right to scroll to a specific item
Use the scrollbar on the right to scroll to a specific item

The context menu lets sort and filter table data and resize the width of bars in a barchart (zoom). To scroll to a specific item, use the rightmost scrollbar. To scroll within a specific item, use the item’s scrollbar. To resize an item drag its bottom edge. Click the i-Icon in the upper right corner of the calculation sheet or a specific item to get further help.

Resize the visible area of a plot or table by dragging its bottom edge
Resize the visible area of a plot or table by dragging its bottom edge
Click the i-Icon in the header bar to open the help document of a calculation file
Click the i-Icon in the header bar to open the help document of a calculation file
Click the i-Icon on a specific item to access the corresponding section within the help file
Click the i-Icon on a specific item to access the corresponding section within the help file

How to select data

Click on the upper left corner of a table to select all data of a table
Click on the upper left corner of a table to select all data of a table
Click on a row number or column header to select an entire row or column respectivly
Click on a row number or column header to select an entire row or column respectivly
Click on a row number or column header to select an entire row or column respectivly
Click on a row number or column header to select an entire row or column respectivly
Hold the left mouse button and move the mouse to select an area of tabular data
Hold the left mouse button and move the mouse to select an area of tabular data

Table data can be selected in multiple ways. To select all data, click on the upper left corner of a table. To select a specific row or column, click on the respective row number or column header. To select a range of cells, click the first cell in the range and then drag to the last cell. Remove and add cells to an existing selection by using [SHIFT] and [⌘]/[Ctrl] while performing the aforementioned operations.
Note: Tweaking a selection in this way is constrained so that the overall selection always contains the same number of cells per row.

How to copy data

To copy data including column headers right click and choose 'Copy with headers' from the context menu
To copy data including column headers right click and choose 'Copy with headers' from the context menu
Paste copied data with headers into your spreadsheet software (i.e. Excel, Numbers, OO Calc – Einfügen is german for paste)
Paste copied data with headers into your spreadsheet software (i.e. Excel, Numbers, OO Calc – Einfügen is german for paste)
Pasted data with headers in your spreadsheet software
Pasted data with headers in your spreadsheet software

To copy a selection, right click and choose Copy from the context menu. Alternativly, use the keyboard shortcut [⌘]/[Ctrl] + [c].
To copy data including column headers right click and choose Copy with headers from the context menu. This method is convenient if you want to paste copied data into your spreadsheet software (i.e. Excel, Numbers, ...)

How to paste data

Use the context menu and choose 'paste'
Use the context menu and choose 'paste'
A completed paste operation
A completed paste operation

To paste data, right click and choose Paste from the context menu. Alternativly, use the keyboard shortcut [⌘]/[Ctrl] + [v].
Data is pasted at the current cursor position. Cells below and to the right of the cursor position might get overwritten depending on the size of the copied data. If the number of copied cells is smaller than a selected area for pasting, the copied cells are repeatedly pasted to fill that area.

How to edit and delete data

Position the cursor on a cell and start typing to edit values
Position the cursor on a cell and start typing to edit values
Delete entire rows
Delete entire rows
Undo changes
Undo changes

Use the arrow keys or mouse to set the cursor on a cell. Start typing to edit values. To delete entire rows choose Delete rows from the context menu. Alternatively, select an entire row and then press [Delete] on your keyboard. Choose Undo or Redo from the Edit menu to undo or redo your changes respectively (Shortcuts: [⌘]/[Ctrl] + [z] / [⌘]/[Ctrl] + [Shift] + [z]).

How to export data as csv

To export a dataset as CSV file, choose 'Export CSV' from the context menu
To export a dataset as CSV file, choose 'Export CSV' from the context menu

To export a data set as CSV file, right click on a table and choose Export CSV from the context menu.
Note: Values in exported files are delimited by a , (comma) for each row and decimal fractions are separated by a . (point).