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. 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
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.
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.
How to select 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 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
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
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 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).