Docs · Research
Sheets: workbooks in the project
Spreadsheets with Hikma's own engine: 230 functions that recalculate as you type, number and date formats, conditional formatting, data validation, charts, pivot tables and named ranges — saved as ordinary .xlsx files in the project that Excel and LibreOffice open unchanged. The same Sheets runs in the desktop app on files on your computer.
The workbook at a glance
Project → Sheets lists the project's workbooks; New workbook creates an .xlsx in the project's files, and an .xlsx uploaded under Files appears here too. A workbook opens with a toolbar (undo, font, bold/italic/underline, colours, alignment, wrap, merge, number format, decimals, sort, filter, freeze, find, Rows, Columns, Insert, Format, Data), a name box and formula bar, the grid, and sheet tabs with Add sheet and a Sheet menu (rename, move, colour, delete). Save writes the file back to the project; 20 seconds after your last change it saves on its own.
| Keys | What they do |
|---|---|
| Enter · Tab · Shift+Enter · Shift+Tab | Commit and move down, right, up, left |
| F2 · Esc · Delete | Edit in place · cancel · clear |
| Ctrl+arrows · Ctrl+Home/End · Shift+click | Jump across data · corners · extend the selection |
| Ctrl+C / X / V | Copy, cut, paste — as cells inside Sheets, as tab-separated text with Excel, Word and LibreOffice; pasted text that starts with = becomes a formula |
| Ctrl+Z / Y · Ctrl+B / I / U | Undo, redo · bold, italic, underline |
| Fill handle | Drag the small square at the selection's corner to continue a series or copy formulas with relative references |
Formulas and functions
A cell that starts with = is a formula: cell and range references (A1, B2:D9, A:A, 3:3), other sheets (Sheet2!A1, 'Site data'!B2:B9), absolute references ($A$1), names (=AVERAGE(Ages)) and 230 functions — maths, statistics (STDEV.S, T.TEST, NORM.DIST, CORREL, SLOPE…), text, dates (DATEDIF, NETWORKDAYS, EOMONTH…), lookups (VLOOKUP, XLOOKUP, INDEX/MATCH, FILTER, UNIQUE, SORT), logic (IF, IFS, SWITCH, IFERROR) and information. The formula bar completes function names (Tab accepts) and shows the signature while you type. Recalculation is incremental and immediate; a circular reference shows #CYCLE! in the cells involved.
Results agree with Excel: 195 functions were written by Sheets and recalculated by LibreOffice in the compatibility audit with the same answers; the statistical functions are computed to machine precision.
Formats, conditional formatting and data validation
The number format list has General, numbers, thousands, percent, scientific, currency, dates, times, text and Custom (any Excel format code). Typed input implies a format once: 12.5% becomes 0.125 shown as 12.5%, 2026-03-15 a date.
- Format → Conditional formatting… adds rules to the selection: cell value is (eight operators), text contains, top/bottom N, duplicate values, a formula that is TRUE, two- or three-colour scales; fill, text colour and bold. Rules are listed per selection and removable; Excel keeps them.
- Data → Data validation… restricts a range: a list of options (typed, or a range) with a dropdown arrow on the cell, whole or decimal numbers, dates, text length with operators, a custom formula, blank allowed or not, and your own message. A refused value stays in the editor with the message.
- Data → Sort… (by a column, header row kept, formulas follow their row) and Filter… (tick the values to show) work on the current block; Freeze panes… keeps rows and columns in view.
Charts, pivot tables and named ranges
- Insert → Chart…: bar, line, pie, scatter, histogram, box plot from a range (first row as series names, series in columns or rows). The chart sits on the sheet, follows the cells, moves by its title bar, resizes at its corner, saves as a PNG, and goes into the .xlsx as a picture at its place — the definition travels in the file so it stays live here.
- Insert → Pivot table…: row field, optional column field, value field and count/sum/mean/median/min/max/SD with totals; the summary becomes a new sheet (re-run for a fresh one).
- Insert → Named range…: names for ranges, usable in formulas and saved as Excel names.
Files: .xlsx, CSV, print
Workbooks are ordinary .xlsx files: values, formulas with their results, formats, fonts, fills, alignment, borders, widths, merges, frozen panes, validation and conditional formats as Excel stores them; Sheets' charts also as pictures. CSV exports the sheet or the selection with your separator and decimal mark (semicolon and comma for European Excel); Print puts the used range or the selection on paper or in a PDF through the browser's print dialog.
The desktop app runs the same Sheets on files on your computer (Sheets in the sidebar, or double-click an .xlsx) and adds two hand-offs: Analyse in Data opens the block as a dataset in Data, Insert in Writer places it as a table in the open document. Signed in, the desktop app shows the project's workbooks under Projects → Sheets as well.
Related
Something missing or wrong? Tell us.