NanumOS

zOffice Sheet

Status: Ready

A spreadsheet for numbers, text and formulas, worked out as you type.

zOffice Sheet

Double-click an .xlsx or .csv file in Files to open that spreadsheet here.

About this app

A spreadsheet app: write numbers, text and formulas in cells and let it calculate. It is part of the zOffice set and the same app runs on the computer and on the phone screen (Mobile). Double-click a .xlsx or .csv in Files to open it.

Basics

A spreadsheet is like a ruled notebook for your household accounts, with one difference: you do not add the totals yourself. Write a formula such as =SUM(A1:A3) in a cell and the app adds those cells up, and when you change a number the total follows at once. A cell is named by its column letter and row number (A1, B2...).

How to use it

  1. Click a cell, type a value and press Enter to move down (Tab moves right).
  2. Anything starting with = is a formula. =SUM(A1:A3) adds A1 to A3.
  3. The "+" on the sheet tabs at the bottom adds a sheet.
  4. Select number cells and press "Chart" to add a bar, line or pie chart.
  5. Use the Data menu for sort, filter, Remove Duplicates and Trim Whitespace, Ctrl+F to find and Ctrl+H to replace text, and Ctrl+S to save (the default is .xlsx; Settings can change it to .csv).

Try it yourself

Try it: type numbers in A1 to A3, write =SUM(A1:A3) in A4, then change A1 and watch the total follow.

How it works

Technical details

The engine is in user/office/calc.c, so the same code runs in the kernel, in host tests and in wasm32. Numbers are m x 10^e integer decimals (the kernel has no floating point) shown with 15 significant digits. There are 149 functions; the errors are #DIV/0! #VALUE! #REF! #NAME? #NUM! #N/A, and a circular reference is #CIRC!. Reading .xlsx, .ods and .csv is done by oodoc, which writes a flat table model (ZSM); the sheet window builds the table only after checking it. Version 1.7.0.

FAQ

A formula shows #REF!

The cell or sheet the formula pointed to was deleted. Press Ctrl+Z to bring it back.

Can I exchange files with other spreadsheet programs

It opens and saves .xlsx, .ods and .csv. Merged cells, borders, pivot tables and font sizes are not there yet, and charts and conditional formats in ODS are not read.

Does it work on a phone

Yes. It is in the "zOffice" folder on the second home page, and tapping a cell brings up the keyboard.

At a glance

In one line: A spreadsheet app: write numbers, text and formulas in cells and calculate.

The screen

Task 1. Write in a cell

  1. Press a cell
  2. Type a value
  3. Press Enter

Say: "Make a sheet and list fruit prices"

Task 2. Write a formula

  1. Go to a cell
  2. Type a formula like =SUM(A1:A3)
  3. Press Enter

Say: "Make a fruit price sheet with a total row"

Task 3. Save

  1. Press "Save"
  2. Look for the file in the Documents folder

Say: "Open the Sheet app"

Try this

1. Write in a cell

  1. Pick a cell and just type: the text goes into it. Enter moves down.

Write in a cell 1

  1. Type a value and press Enter. 1,234 · 50% · ₩1,000 · 3,500원 · 2026-11-02 · 11월 2일 become numbers and dates shown the way you typed them.

Write in a cell 2

2. Write a formula

  1. Go to a cell and type a formula starting with =. A cell of another sheet is =SheetName!A1.

Write a formula 1

  1. Press Enter to work it out. About 110 functions: SUM, AVERAGE, IF, VLOOKUP, XLOOKUP, SUMIF, TEXT, DATE and more. Copy a formula, or drag the small square at the selection's lower right (the fill handle): names like A1 move along, $A$1 stays.

Write a formula 2

3. Save

  1. Press "Save". A new sheet is saved in Documents as "Untitled 1.xlsx", and saves itself a second after each change. The sheet tabs, formats and charts are saved with it.

Save 1

Shortcuts

KeyWhat it does
Ctrl+NNew
Ctrl+OOpen…
Ctrl+SSave
Shift+Ctrl+SSave As…
Ctrl+WClose
EnterPut in what was typed and go down. With Shift: up.
TabNext cell. Shift with Tab: previous cell.
Backspace or DeleteEmpty the selected cells. With a chart selected: delete the chart.
Ctrl+C / Ctrl+X / Ctrl+VCopy / Cut / Paste (formulas' cell names move along)
Ctrl+DFill Down: the selection's top row into the rows below
Ctrl+RFill Right
Ctrl+ASelect every used cell
Ctrl+F / Ctrl+G / Ctrl+HFind / find next / replace
Ctrl+PgDn / Ctrl+PgUpNext / previous sheet
Shift+F11New sheet
Ctrl+Z / Shift+Ctrl+ZUndo / Redo. While you type in a cell, Ctrl+Z gives the cell back as it was.
Ctrl+B / Ctrl+I / Ctrl+UBold / Italic / Underline
Shift+Ctrl+LFilter on or off

Try it now: pick a cell of a table and choose Data › Filter.

Settings

File › "Settings…" (Ctrl+,) or OS Settings › Apps › zOffice Sheet: Default save format — Excel workbook (.xlsx, the default) or CSV (.csv).

Table Focus Mode

On a phone: the File menu

A phone has no menu bar at the top, so file work goes the way phone apps do it. The file's name sits in the middle of the top bar with its save state under it ("Saved ✓ 3s ago"); tap the name to rename the file. The "⋯" button at the right brings a menu up from the bottom.

What to do now: tap "⋯".

On a phone a row is tall enough to tap with a finger (44 pixels), and columns too narrow to tap are shown wider (the file's column widths stay as they are).

OpenDocument (.ods)

A LibreOffice .ods opens and saves as .ods. Sheets, numbers, text, TRUE / FALSE, dates, times, percentages, currency, formulas (LibreOffice's [.A1] is read as Excel's A1), number formats and column widths are read; saving writes dates as dates and percentages as percentages. Charts, conditional formatting and merged cells in a .ods are not read yet.

The program that reads a file runs on its own

A spreadsheet you received may be damaged, or made to attack. So reading .xlsx, .ods and .csv is done by a small program (oodoc) outside the Sheet window and the system. It is like opening a parcel on a bench outside the front door instead of inside the house. The program has a fixed amount of memory and may write to one temporary folder only. Sheet checks everything it sends back before using it. If a file makes the program stop, Sheet says "The spreadsheet reader stopped on this file (it may be damaged)", and the open table and your other apps stay as they were. What to do now: nothing.

Technical details

u -m N -w /tmp/oodoc oodoc sheet xlsx|ods|csv FILE OUT writes the workbook as a ZSM (a flat table model). Sheet checks every cell position, format number, number, text length, chart and rule before it builds the table (user/office/calc_zsm.inc). Saving (.xlsx, .ods, .csv) writes from the checked table, so it stays in Sheet. Formulas and format codes are read by Sheet when it calculates. docs/APP-ISOLATION.md §8.

What it cannot do

On mobile too

The same Sheet app runs on 「Mobile」 in a phone's browser. It is in the 「zOffice」 folder on the second home page.

Find, replace, remove duplicates, trim spaces

NanumOS 0.1.8349 · 2026-11-16