Working with tables
Almost every window in "Рахівниця" (Kasa, Sklad, Barcom, Service) shows lists — products, documents, business partners — as a table. All these tables work the same way and share one set of abilities, described below.
A menu with part of these commands opens from the arrow in the table's top-left corner, above the row numbers.
Sorting
Click a column header — the table sorts by it, and an arrow appears in the header. Click again to switch direction (ascending/descending). Hold Shift and click one or more other headers — the table sorts by several columns at once, in click order; the order is shown by the numbers next to the arrows.
Column order and width
Drag a column header left or right with the mouse — columns swap places. Drag the border between headers — the column changes width. Double-click that border — the column resizes itself to fit its longest content.
Show or hide a column: open the menu from the arrow and pick "Редагувати видимість стовпчиків" ("Edit column visibility"), or press Ctrl+D while in the table. A list of all columns opens with checkboxes — check or uncheck the ones you want and confirm.
Search
Click a cell and start typing — a search box appears above the table, and the cursor jumps straight to the first row where the selected column starts with what you typed. Ctrl+F does the same thing. To keep that box on screen all the time instead of only while typing, turn on "Показати рядок пошуку" ("Show search row") in the menu from the arrow.
Where this is set up, pressing Ctrl+F again (while the search box is still open) opens a "Пошук" ("Find") dialog with wider options: search in a specific column, choose the search direction, match case or value format. Click "Знайти далі" ("Find next") to move from match to match.
Filter
Ctrl+T, while standing on the column you need, asks for a value and leaves only the matching rows in the table (for text, part of the word is enough). The filtered column is highlighted in the header. Ctrl+R clears this filter.
To filter by several columns at once, turn on "Показати розширений фільтр" ("Show advanced filter") in the menu from the arrow — a row appears under the headers where you can type a condition into each column separately; the table filters immediately, with no confirmation needed.
Row numbers, alternating-row shading, totals
The same menu has three switches: "Показати номери рядків" ("Show row numbers") numbers the rows on the left; "Виділяти парні рядки" ("Highlight even rows") shades every other row so the eye doesn't lose its place in a wide table; "Показати рядок підсумків" ("Show totals row") adds a row at the bottom with the sum of the money and quantity columns.
Exporting to a file
The same menu — "Експортувати вміст у форматі .csv" and "...у форматі .htm" — saves the table's current view (filter, sorting and visible columns included) to a file.
Selecting several rows at once
In tables where this is set up (for example, picking products for a document, the bulk repricing queue, the online orders cockpit), you can select several rows at once with Ctrl+click or Shift+click, the same way as in Windows Explorer — then act on all of them at once.
Entering data in document tables
In a document's line rows (invoice or receipt positions, etc.), Enter moves the cursor to the next cell in the same row instead of the row below — handy for typing quantity and price one after another without reaching for the mouse. Delete removes the selected row(s), with a confirmation prompt.
Settings remember themselves
Column order, width and visibility, along with every switch from the menu (filter, search row, row numbers, alternating rows, totals), are saved separately for each window and restored the next time it opens — there is no need to set the table up again from scratch.