Tables

A table is a spreadsheet placed on the board:

• The window: its shape is a window over a grid of cells. The grid can be larger than the window, which scrolls over the rest.
• Cells: they hold numbers, dates, formatted text, formulas, or media, including images, videos, documents, sounds, and file cards dragged in from the board.
• Formulas: the usual spreadsheet syntax, with cell references and 84 functions.
• Organizing: columns can be filtered and sorted, and rows and columns can be frozen.
• Files: a spreadsheet file becomes a table, and a table downloads as one.

Creating a table

A table reaches the board in one of four ways: drawn with the Table tool, pasted from tabular content, imported from a spreadsheet file, or converted from a file card that holds one.

Creating the default table

A table of 5 rows by 3 columns, placed with one click.

• Operation:
  1. Pick Table in the board objects multi-button of the Tools panel.
  2. Click where the table should go.
• Result: an empty table of 5 rows by 3 columns, centered on the point, with a white surface and a thin grey grid.

Drawing a custom table

A table sized by hand from the start.

• Operation:
  1. Pick Table in the board objects multi-button of the Tools panel.
  2. Drag to draw the box the table will occupy. A badge in the corner where the drag started shows the count of rows and columns.
• Result: an empty table with as many default-size cells as fit the box, up to 200 rows and 50 columns. The box snaps to whole cells.
• Tip: the box can be changed later with the handles, and the grid with the row and column commands. See Sizing and Cell commands.

Choosing the number of rows and columns

Sets the grid of a table that is still empty, however it was created.

• Operation: type the number of Rows and Columns you want in the Table settings section of the Attributes panel.
• Result: the grid is redistributed evenly inside the shape, which keeps its size. Rows and columns inserted later take the same size.

Pasting tabular content

A table made from cells copied somewhere else.

• Operation: copy cells from a spreadsheet, a table from a web page, or tab-separated text, and paste on the board while nothing is being edited.
• Needs: more than one cell when the block comes from a spreadsheet or a web page, and at least two rows and two columns when it is plain text. Anything smaller is pasted as text.
• Result: a table sized to the block, centered on the view, with the values, styles, merges, and formulas the block had. Formulas copied from another Irakasi table keep calculating.

Importing a spreadsheet

Turns a sheet of a spreadsheet file into a table.

• Operation: drop the file on the board, or choose Import file in the App menu and pick it. Accepted files: .xlsx, .xls, .csv, .tsv, and .ods.
• Needs: a choice in the Import spreadsheet dialog, which lists the sheets of the file with their size, even when there is only one. Pick one and click Import sheet. Under the selected sheet, the dialog says what it will become:
  • All formulas supported: the formulas keep calculating.
  • Some formulas unsupported: every formula in the sheet is replaced by the value the file had saved. A .csv or .tsv file saves no values, so its formula cells come in empty.
  • Too large: the sheet has too many rows, columns, or cells, or too much content, for a live table. It comes in as a scrollable large table with values only. See Large tables.
• Result: one table from the chosen sheet, centered where you dropped the file or in the middle of the view, with the values, number formats, text styles, cell backgrounds, alignment, merges, column widths, row heights, and frozen rows and columns the file had. .xls and .ods files bring values, formulas, number formats, merges, and sizes; .csv and .tsv files bring values, and a field written as =... becomes a formula.
  • Several files dropped together each open their own dialog, and the tables land side by side.
• Tip: to keep the spreadsheet as a file, draw a File card and give it the spreadsheet with Replace file. A sheet whose data would exceed 25 MB is refused: split it and import it in parts.

Converting a file card

A table made from a spreadsheet file that is already on the board as a card.

• Operation: select a file card that holds a spreadsheet file and click Convert to table in the Actions panel.
• Needs: cards with .xlsx, .xls, .csv, .tsv, or .ods files.
• Result: the Import spreadsheet dialog described above opens, and the table takes the card's place, centered on it.

Editing

Opens the table so you can work inside its cells.

• Operation: double-click the table on the cell you want, or select it and click Enter edit mode in the Actions panel. Then:
  • Click a cell to select it. Drag to select a range. Click a row number or a column letter to select the whole band, and drag across headers to extend it. A merged cell is always selected whole.
  • Type to replace the content of the selected cell. Double-click a cell to edit what it holds: the formula, the unformatted number, or the date, not the displayed result. Whatever the cell holds stays when you leave it, with Enter, Tab, Esc, or a click elsewhere.
  • Press Esc with no cell open, or click on empty board, to close the table.
• Result: row numbers and column letters appear around the grid, the Actions panel shows the cell commands, and the Attributes panel shows the cell sections listed under Attributes.
  • The window keeps the scroll position you leave it at. That is what the closed table, the Player, and exports show.

Selecting and editing cells

Keys that work in the open grid, which have no button of their own:

• Tab moves to the next cell and continues on the next row; Enter moves down. With Shift they move back.
• The arrow keys move one cell. With Shift they extend the selection. Home and End jump to the ends of the row.
• F2 edits the selected cell in place. Inside a cell, Shift with Enter starts a new line, or a new item in a list.
• Delete or Backspace clears the selected cells, or removes the selected attachment when one is selected.

Cell commands

The commands the Actions panel shows while a table is open, in the order they appear.

Delete cell content

• Delete cell content: empties the selected cells, attachments included, and keeps their formatting. With an attachment selected it reads Delete selected attachment and removes only that one.

Download attachments

• Download attachments: saves the file of the selected attachment, or of every attachment in the selected cells, one file each. With one attachment selected it reads Download selected attachment.

• PDF choices: when a selected PDF has saved annotations, choose Download originals or Download annotated PDFs. The annotated option saves each attachment's own marks, including separate copies of the same PDF.

• Books: EPUB and CBZ attachments download their stored archive. A successfully converted comic downloads as CBZ.

• Unconverted comics: file cards keep and download the original CBR, CB7 or CBT archive.

Converting a document attachment

A document in a cell can become a picture of the current view or a File Card.

• Operation: select the attachment and choose its conversion in the Actions panel.
• Result:
  • Convert to image keeps the current viewport, annotations, opacity, filter and mask in an image. Confirm the loss of the live document in the dialog.
  • Convert to File Card keeps the document file and drops its reading view and appearance. Saved PDF annotations become part of the card's PDF file.
  • Convert to document opens a File Card holding a recognized PDF or book as a reader, starting at the beginning.

Audio items

• Convert to audio: turns the selected file card into an audio item when its file is an MP3, WAV, or M4A file. The item keeps the card's name and styles.
• Edit audio: opens the selected audio item in the audio editor. Apply writes the edited sound and its markers into the item.

Column filters

• Add/remove filters: gives the selected header cells a filter menu, or takes the menus and their saved criteria away when every selected column already has one. See Filtering and sorting.

Filtered view

• Show filtered view: applies the saved filters, or shows every row again without losing them. See Filtering and sorting.

Freeze rows

• Frozen rows: with whole rows selected, freezes the rows from the top through the selection so they stay in view while scrolling, or unfreezes them from the selection down.

Freeze columns

• Frozen columns: with whole columns selected, freezes the columns from the left through the selection so they stay in view while scrolling, or unfreezes them from the selection on.

Block style

Choose the structure of the selected cells:

• Paragraph
• Heading 1
• Heading 2
• Heading 3

Horizontal alignment

Align the content horizontally:

• Left
• Center
• Right

Vertical alignment

Align the content vertically:

• Top
• Middle
• Bottom

Lists

Choose a list style. Click it again to return to paragraphs.

• Numbered list
• Bullet list

Text styles

Apply these styles to selected cells, or to selected text inside an open cell:

• Bold
• Underline
• Italic
• Strikethrough

Highlighting

• Highlighter: colors the background of the selected text inside a cell.

Inline code

• Inline code: shows the selected text of an open cell in a monospace font on a tinted background.

Superscript and subscript

• Superscript and Subscript: for the text at the caret of an open cell.

New line

• New line: starts a new line in the open cell, or a new item in a list. On a keyboard, Shift with Enter does the same. On a touch screen this button is the way to add lines, since the keyboard's Enter key saves the cell.

Text links

• Cell text link: puts a website or email link on the selected text, or edits the one at the caret. Typing a web address in a cell also makes it a link. Remove cell text link takes it away.

Attach files

• Attach files…: attaches the chosen files to the selected cells. See Media in cells.

Columns

• Column after
• Column before
• Delete columns, as long as one column stays.

Rows

• Row after
• Row before
• Delete rows, as long as one row stays.

Merge cells

• Merge cells: joins the selected range and keeps the top-left content.

Split cells

• Split cells: undoes a merge.

When rows or columns change

• A new row or column takes the Default row height or Default column width of the Table settings section.
• A merged cell grows when a row or column is inserted inside it, and shrinks when part of it is deleted.
• Formula references follow the cells that move. See Formulas.

Numbers and dates

What a cell becomes depends on what you type:

• A plain number such as 1250 or -3.5 is stored as a number and aligns right. Typed with a currency sign, a percent sign, or a thousands separator, it stays text.
• A date typed as 2024-03-15 or 2024/03/15 is stored as a date. 15/3/2024 also works, while 1/2/2024 stays text because it could be read either way.
• Anything else is text, with the formatting the cell commands apply.

How a number is displayed is a setting of its own, Number format in the Cell selection section, and never changes the value:

• Automatic: the number as typed.
• Number: a plain number, with these options:
  • Decimal places, from 0 to 10.
  • Thousands separator, shown or hidden.
  • Negative values, with a minus sign or parentheses.
• Currency: the same options as Number, plus the Currency symbol, any text of up to 12 characters.
• Percent: the value times a hundred with a % sign, with the decimal places and negative values options. A cell holding 0.15 reads 15.00%.
• Date: nine Date format layouts, from 2024-01-31 to Wednesday, 31 January 2024. A typed date takes this format by itself, unless the cell already had another one.
• Custom (imported): a format that came from a file and has no equivalent here, kept as it is.

Editing a formatted cell opens it on the value, so a currency cell opens on 1250, and a date on 2024-03-15.

Formulas

Makes a cell calculate from other cells.

• Operation: type = in a cell, then the expression, such as =SUM(A1:A3), =B2*1.21, or =IF(C1>10,"high","low"). While typing:
  • Click a cell to insert its reference, or drag across cells to insert a range.
  • Click over a reference already in the formula to replace it with the cell you click next.
  • Press F4 on a reference to cycle it through relative, $A$1, A$1, and $A1.
• Result: the cell shows the result and recalculates whenever an input changes. References are colored, and the cells they point to are outlined in the same color. A mistake is underlined in red as you type, with a plain-language explanation in the Cell formula section.
• Tip: start typing a function name and a list of matching functions opens, with the arguments of the one you are in.

Choosing a function

• Click Formula functions while editing a formula to browse the full list and insert a function.

Formula reference

What a formula can hold:

• Numbers, quoted text, TRUE and FALSE, and the arithmetic, comparison, and & operators. ^ raises to a power and % divides by a hundred.
• References to cells and rectangular ranges of the same table. Ranges work only as function arguments.
• These functions:
  • Sums and statistics: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, PRODUCT, SUMIF, SUMIFS, COUNTIF, COUNTIFS, MEDIAN, LARGE, SMALL, STDEV.S, STDEV.P, VAR.S, VAR.P. Given a range, they skip the rows a filter hides.
  • Math: ROUND, ROUNDUP, ROUNDDOWN, ABS, POWER, SQRT, MOD, INT, TRUNC, CEILING, FLOOR, MROUND, SIGN, EXP, LN, LOG, LOG10.
  • Logic: IF, IFS, AND, OR, NOT, XOR, IFERROR, IFNA, ISERROR, ISNA, ISBLANK, ISNUMBER, ISTEXT, ISLOGICAL.
  • Text: CONCAT, CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, LEN, LOWER, UPPER, PROPER, TRIM, SUBSTITUTE, FIND, SEARCH, REPT.
  • Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE.
  • Dates: DATE, YEAR, MONTH, DAY, EOMONTH, EDATE, WEEKDAY, WEEKNUM, DATEDIF, NETWORKDAYS.
  • Finance: PMT, FV, PV, NPV, IRR.
• Not available: other tables, named ranges, whole rows or columns, and array formulas. TODAY, NOW, RAND, and RANDBETWEEN are left out because results are saved with the board and would go stale. SUMPRODUCT, AVERAGEIF, VALUE, TEXT, and DATEVALUE are not supported either.

The syntax, the references, and the functions follow Excel's definitions, so Microsoft's Excel functions reference explains each function listed here, with its arguments and examples. Google's Sheets function list covers the same functions, if you know Sheets better.

References follow the cells:

• Inserting or deleting rows and columns rewrites every formula that points past them. A cell reference to a deleted row or column becomes #REF!. A range shrinks to what is left, and becomes #REF! only when all of it is deleted.
• Pasting formulas moves their references by the same distance, except the parts marked with $.
• Sorting and filtering never change a formula; they only change which rows show.

Errors a cell can show:

• #DIV/0!: a division by zero.
• #REF!: a reference outside the table, or to a deleted row or column.
• #NAME?: an unknown function, or a formula that could not be read.
• #VALUE!: a value that does not fit the operation, such as text where a number is needed.
• #CYCLE!: the formula depends on itself, directly or through other cells.
• #NUM!: a result that is not a finite number, or a recalculation that touches more than 100,000 range cells.
• #N/A: a lookup that found nothing.

Media in cells

Puts pictures, documents, sounds and other files inside a cell.

• Operation: one of:
  • Drag an image, video, document (PDF, EPUB or CBZ), audio shape, or file card from the board onto a cell. An open table takes it at once; a closed table takes it after you hold it over the cell for half a second. Hold Alt to leave a copy on the board.
  • Drop a file from your device on a cell.
  • Paste an image or a file while the table is open. Pasted e-book and comic files become file cards.
  • Click Attach files… and choose the files.
• Needs: an empty cell, or one that holds only media. A cell with a value refuses media until the value is cleared, and a cell with media refuses typing until the media is removed.
• Result: the cell shows the media instead of text, fitted inside the cell, and shapes dragged in leave the board. Several files land one per cell, in reading order from the target cell or the selection, and continue through the rest of the table; files left over after the table's last cell stack up in it. If any of those cells holds a value, the whole drop is refused. What each kind does in its cell:
  • Image: shows the picture. Double-click it while the table is open to crop it in place: drag the window or its handles, then press Enter or click elsewhere. Double-click a handle to go back to the full picture.
  • Video: shows its poster, and plays after a click with its controls. A click elsewhere ends the interaction with it, and it keeps playing. Double-click it while the table is open to crop it, as with an image.
  • PDF: shows its saved view. Double-click it to read it inside the cell, with page controls over the document and in the Document controls section. Ink and text annotations made on the PDF shape stay with it.
  • E-book or comic: drop an EPUB or CBZ file, or choose it with Attach files…, to read its pages in the cell. CBR, CB7 and CBT comics are converted to CBZ. Double-click the document to read it with its page controls.
  • File card: shows the card with its Open and Download buttons. While the table is open, double-click the card to edit its title; the original filename stays unchanged.
  • Audio: an MP3, WAV, or M4A file, or an audio shape, shows as an audio card with its play button, title, time, waveform, and markers, and plays in place. Select the card, then click or drag on its waveform to move the playhead. While the table is open, drag the handles at the ends of the selected card's waveform to trim the clip, and double-click the card to edit its title; an empty title shows the file name. Audio the board can't play stays a file card, and a notice says why.
• Tip: click an attachment to select it, and click the cell background to select the cell again.

Books must be 50 MB or smaller, including the converted CBZ. A copy-protected e-book or a comic that cannot be converted stays as an attachment of the original file, with a notice explaining why. Invalid books and files over the limit are refused.

Reading a document

To read a PDF, EPUB or CBZ in its cell, double-click it with a selection tool. In the Player and with the Explore canvas tool, one tap opens it.

• Continuous view scrolls through the pages; Single page view turns one page at a time.
• Links open their destination, and an EPUB's Contents takes you to a chapter.
• A click elsewhere ends the interaction, and the document stays open on the page you reached.

To add or edit PDF annotations, extract pages, or delete a page, drag the document out onto the board and use its PDF tools. Drag it back into the cell when you finish.

Moving attachments

While the table is open, an attachment moves by dragging it:

• Over another attachment in the same cell, to change their order.
• Into another cell, to move it there. The cell must be empty or hold only media.
• Beyond the table, to put it back on the board as its own image, video, document, audio shape, or file card, centered where you drop it and selected. It keeps its crop, playback settings, reading position, clip, volume, markers, and styling.

Documents moved into a cell and back keep their view mode, size and appearance, including EPUB page color and text style. PDF ink and text annotations stay with the document.

How the attachments sit in the cell, from the Cell selection section:

• Media layout: with several attachments, Horizontal puts them side by side and Vertical stacks them.
• Media fit, for every attachment in the cell:
  • Cover crops each one to fill its share of the cell, so several attachments become equal tiles. New attachments start this way.
  • Contain shows each one whole, at its own proportions, side by side.
  • File cards and audio cards keep their card size either way.
• A cell with media has no value: formulas and spreadsheet files treat it as empty.

Attachment attributes

With an attachment selected, the Attributes panel shows the sections of its shape type instead of the cell sections, applied to that attachment alone. Drag the handles around it to resize it inside its cell; the cell still decides where it sits.

• Image: the Image, Stroke, and Fill sections of an image, with Cropping Info while it is cropped.
• Video: the Video, Controls, Stroke, and Fill sections of a video, with Cropping Info while it is cropped.
• Document (PDF, EPUB or CBZ): Document sets its size and opacity. Document controls choose the view and page, keeping your place when you switch views.
• Document Fill: replaces the file with another PDF, e-book or comic, retaining its size, opacity and view. Info shows the filename, size and type, plus pages for PDFs and comics or chapters and title for e-books.
• EPUB appearance: Page color colors the paper and its file preview. Text Style and Text Fill set the book’s typography and text color.
• Document Mask: uses masks to hide part of the document, including its annotations and filter effects. Moving the document or its mask changes the visible area.
• Document Filter: adds filter effects to the selected document, including its annotations and page color. Copies of the same file can have different filters.
• File card: the File card, File, Text Style, Text Fill, Text Outline, Stroke, and Fill sections of a file card.
• Audio: the Audio, Audio Settings, Text Style, Text Fill, Text Outline, Stroke, and Fill sections of an audio shape.

Filtering and sorting

Shows only some rows, or reorders them, without touching the data.

• Operation: select cells in the header row, then click Add/remove filters to give those columns a menu button, and open a column's menu. From top to bottom it offers:
  • Sort A→Z and Sort Z→A, and Clear sort on the sorted column.
  • Filter by condition, with the conditions that suit the column: text conditions such as Contains or Begins with, number conditions such as Greater than or Between, or date conditions Before, After, and Between. Between includes both ends.
  • A list of the column's values with a search box, Select all, and (Blanks) at the end. Untick a value to hide its rows.
  • Clear filter, OK, and Cancel.
• Needs: the header is the first row, or every frozen row when rows are frozen. It always stays in view and is never filtered or sorted.
• Result: the rows that fail a filter are hidden and the rest keep their order, or follow the sort. The row numbers keep their stored values, so they can read out of order. The stored table never changes: sort is single-column and stable, blanks sort last, and rows joined by a vertical merge move as one block.
  • Filters and sorts are saved with the board and can be undone. Show filtered view pauses the filters to show every row and applies them again, without losing the criteria or the sort. It works on the closed table too, below Enter edit mode.
  • Removing a column's filter with Add/remove filters also drops its saved criteria; the sort stays.
  • Merging, splitting, and freezing rows need the selected rows in the table's own order, and freezing also needs the view to start with the table's first rows. Clear the filter or sort when they aren't. A paste stops at the last visible row and tells you when rows were left out.
• Tip: when a column has more than 10,000 distinct values, the list is cut and a note says so. Use a condition instead. The same goes for a values filter that would untick too many values to save.

Copying and pasting cells

Cells move between tables, and to and from other spreadsheets, through the clipboard.

• Copy or cut a range inside an open table. Cut empties the cells and keeps their formatting.
• A range that touches a merged cell takes the whole merge.
• Paste lands at the top-left of the selection and grows the table if the block needs more rows or columns.
• One copied cell fills the whole selected range.
• A blank cell in the block empties its target without touching the target's formatting.
• Copied cells paste into Excel or Sheets as styled, merged cells holding their displayed values, and into other apps as tab-separated text. Pasted back into an Irakasi table, they bring their formulas, formats, styles, merges, and media.
• Pasted text is read like typed text, so =SUM(A1:A3) becomes a formula and 2024-05-01 a date.
• A paste that would take the table past its limits is refused whole, with a notice.

Large tables

A live table holds up to 200 rows, 50 columns, 10,000 cells, and about 900 KB of content. A sheet beyond any of those comes in as a large table, which trades editing power for size.

• Kept:
  • The values and their number formats.
  • The column widths, and the sheet's frozen rows and columns, or the first row frozen when it has none.
  • Scrolling in every mode, and the content scale.
  • Editing any cell's value.
  • Filtering and sorting from the column menus, and Download table.
• Replaced: formulas become the values the file had saved. A = typed in a cell stays text.
• Off:
  • Text styles, merges, and media.
  • Row and column edits, and per-row heights.
  • The cell commands keep only Add/remove filters and Show filtered view, and Table settings keeps only its layout fields.
  • The window cannot grow past the sheet.
• A large table cannot become a live table again. To edit freely, download it and import a smaller sheet.

Sizing

• The shape is a window over the grid. Smaller than the content, it scrolls in both directions once the table is open. Larger, the last row and column stretch to fill it.
• Drag any row or column boundary, on the headers or inside the grid, to resize that row or column. Rows and columns go down to 2 pixels and have no upper limit.
• Double-click a boundary to reset that row or column to the Default row height or Default column width of the Table settings section.
• Row height and Column width, in the Cell selection section, give one size to every row or column the selection touches.
• Content scale, from 0.1 to 4, enlarges or shrinks everything inside the window without changing the window. Text that would paint smaller than 6 pixels on screen is not drawn; zoom in to read it.
• Locked Ratio keeps the window's proportions. With it on, Proportional makes a resize scale the window and its content together.
• The window cannot shrink below 16 by 16 pixels.
• Frozen rows and columns need room to scroll beside them. When they would fill the window, they scroll along with the rest until the table is made larger, and a notice says so.

Attributes

A selected table shows these sections of the Attributes panel.

Selection info

The attributes that affect the shape as a whole.

• X: the horizontal position of the shape's pivot. Inside a frame, it's measured from the frame.
• Y: the vertical position of the pivot, also measured from the frame inside one. Which way it grows depends on the Y axis direction in the UI settings.
• W: the width of the shape.
• H: the height of the shape.
• Rotation: the angle around the pivot.
• Opacity: the transparency of the whole shape, stroke and fill included.
• Corners radius: rounds the corners of the shape.
• Locked Ratio: keeps the proportion between width and height while resizing.
• Proportional: scales the stroke width, dashes, hatching, and tiles along with the shape, so a resized shape keeps its look.

Stroke

The lines of the grid and the frame. Content scale enlarges the grid lines with the cells, while the frame keeps its width.

• Stroke style: the kind of line. The style decides which of the controls below appear.
  • No stroke: no line at all. Arrows don't offer it.
  • Solid stroke: a continuous line.
  • Dashed stroke: a line made of dashes.
• Stroke color: the color of the line.
• Stroke opacity: the transparency of the line alone.
• Stroke width: the thickness of the line.

Dashed strokes and roughness

Freehand strokes

Fill

The surface under the cells. Cell backgrounds paint on top of it, and a downloaded spreadsheet leaves it out.

• Fill style: the kind of fill. The style decides which of the controls below appear.
  • No fill: the inside stays empty.
  • Solid fill: one flat color.

Fill color

• Fill color: the color of the fill.

Fill opacity

• Fill opacity: the transparency of the fill alone.

Table settings

The grid defaults, the content scale, and the typography of the cells.

• For empty tables only:
  • Rows: how many equal rows fill the box.
  • Columns: how many equal columns fill the box.
• Default row height: the height new rows get.
• Default column width: the width new columns get.
• Content scale: zooms rows, columns, and text inside the window together, without changing their sizes.
• Typography, a group with the default text settings of every cell. A cell can override them from its own section.
  • Table font category: the family of typefaces.
    • Sans Serif
    • Serif
    • Handwriting
    • Mono
    • Display
  • Table font family: the typeface, within the chosen category.
  • Table font variant: the weight or slant of that typeface.
  • Table line height: the space between lines.
  • Table text color: the color of body text.
  • Table font size: the size of body text.
  • Heading 1 color: the color of level 1 headings.
  • Heading 1 size: their size relative to body text.
  • Heading 2 color: the color of level 2 headings.
  • Heading 2 size: their size relative to body text.
  • Heading 3 color: the color of level 3 headings.
  • Heading 3 size: their size relative to body text.
  • Table highlight: the background color of highlighted text.

Filter

The visual filter of the whole shape, unrelated to the column filters. See Filters.

Mask

A table can be masked. See Masks.

Cell sections

With cells selected inside an open table, the panel shows these sections instead. With an attachment selected, it shows the sections of that attachment. See Media in cells.

Cell formula

Cell selection

Text selection

Actions

Besides the actions every shape has, covered in What every shape shares, a table offers these in the Actions panel.

Show filtered view

Switches between the filtered rows and all of them.

• Operation: select the table and click Show filtered view.
• Needs: a table with a saved filter.
• Result: the rows a filter hides come back, or go away again. The criteria and the sort are kept either way. See Filtering and sorting.

Clear contents

Empties every cell but keeps the grid and its styles.

• Operation: select one or more tables and click Clear contents.
• Result: every value is emptied. Rows, columns, sizes, cell formatting, and media stay. Large tables are left alone.

Download table

Saves the table as a spreadsheet file on your device.

• Operation: select the table, without opening it, and click Download table…. Choose a format and click Download.
• Result: a file named Table.
  • Excel workbook (.xlsx), the default:
    • Keeps values, formulas with their results, number formats, cell styles, merges, column widths, row heights, and frozen rows and columns.
    • Rows hidden by a filter are in the file, marked hidden, with a filter set on the sheet. Sums, averages, counts, minimums, maximums, products, standard deviations, and variances over ranges become SUBTOTAL calls, so Excel skips those rows too.
    • Headings become plain text, list items become lines, and media cells are empty.
  • CSV (.csv): the visible rows only, as plain text of the values as displayed.

Convert to Image

Replaces the table with a picture of it, which draws faster but can no longer be edited.

• Operation: click Convert to Image. When the conversion would lose something, a dialog lists what, and you confirm with Convert.

• Result: one image of the table as it shows on the board: the scrolled window, with the filters and sort applied, as a JPEG when opaque or a PNG when it needs transparency. The corners, filter, mask, and a plain outer stroke stay editable; a rough or freehand stroke is drawn into the picture. Move, rotate, scale, resize, and opacity animations move to the image.

• Tip: while the image renders, an empty image marks its place and the original stays untouched, so you can keep working.

• Exported documents: table images and SVG exports capture the current document view, including the page you have just requested. Turning another page while the export runs leaves that capture unchanged.

Player interaction

A table works like the other interactive shapes:

• Scrolling: tap the table anywhere outside its videos and documents, and the wheel scrolls it from where it was left in the editor, up to its edge. Until then, a wheel over the table moves the board.
• Reading: its content can be read but not selected or edited.
• Links: links in cells open in a new tab.
• Videos and documents in cells: they work like video and document shapes, apart from the table.
  • Videos: one tap plays a video. While you interact with the video, the wheel over it moves the board, because a video has nothing to scroll. A tap elsewhere ends the interaction, and the video keeps playing.
  • Documents: one tap opens a PDF, EPUB or CBZ inside its cell, with scrolling, page controls and links. While you interact with the document, the wheel over it acts on the document only. A tap elsewhere ends the interaction, and the document stays open on its page.
• Sounds and files: a click plays a sound, and a file offers its download.
• Filters: a filtered or sorted column shows a small badge in its header. The view cannot be changed.

Animating tables

A table takes the position, rotation, scale, resize, and opacity animations. See Transforming shapes and Revealing and hiding shapes.

Limits

• A live table holds up to 200 rows, 50 columns, 10,000 cells, and about 900 KB of content. Beyond that it is a large table, which holds up to 250,000 rows, 1,024 columns, and a 25 MB file.
• Any edit that would take a live table past those limits, such as an insert, a paste, or a big cell, is refused with a notice.
• Formulas reference the same table only, and a recalculation that touches more than 100,000 range cells returns #NUM!.
• One sort column at a time. A filter list shows the first 10,000 values, and a filter that hides too many distinct values is refused; use a condition instead.
• Media goes in live tables only.