This demo emulates an Excel-style spreadsheet. It supports a subset of spreadsheet functionality and is intended to demonstrate formulae integration with table.

These are the supported functions.

• ABS
• MULTIPLY
• ADD
• AVERAGE
• CEILING
• POWER
• COUNT
• PRODUCT
• DIVIDE
• REMAINDER
• ROOT
• FLOOR
• ROUND
• GEOMETRICMEAN
• SORT
• STDDEVIATION
• SUBTRACT
• SUM
• MAX
• MEDIAN
• TRUNC
• MIN

These are examples formulae.

• =sum(a1:a5)
• =sum(a1,a5)
• =product(a1, a5)
• =product(sum(a1:a5),5)
• =product(abs(a1), 2)