- 2 new columns: N O - 2 new iCloud Save slots (8 and 9) - iPadOS windowed mode interface optimization

- 3 additional K L M columns - 2 additional iCloud Save slots (6 and 7) - New =sav(name) function replacing the Save slot name - New font colors: red for =sav(), orange for =lin() and bar() - Formulas with =lin() =bar() =sav() are invisible to charts and widgets but visible to formulas - Smoother horizontal scrolling (iOS) - Cosmetic widget color changes

- New function: counts symbols in a given range: sy...(a0:j99) where ... is any string of characters, examples: =syOK(a0:a99) counts the number of OK in column A =sy:(b0:b99)+sy;(b0:b99)+sy,(b0:b99)+sy!(b0:b99) counts the total number of : ; , ! in column B - Changed the display of long text in cells: if the text doesn't fit on two lines, it displays the beginning and ... - Returning to the furthest saved cell in a column after leaving the chart (watchOS) ignores the =off() function - Brighter charts in widgets

- New toolbar button for changing cell colors or resetting them to default, it replaced the removed color formulas =si() =re() =bl() =gr() =vi() =or() - New "invisible" functions for charts and other cells, activated by entering in any cell: =lin(x) provides a full-screen line chart =bar(x) provides a full-screen bar chart for non-negative values - What the lin and bar functions return (number, text, formula result) becomes the title of the full-screen chart - Multi-color line charts (each line is the same color as the cell) - Charts adapt to the full screen - Selecting an entire column with the button below the column no longer resets the previous selection - "Cut”, "Copy”, "Paste”, „Undo” now apply to cell colors - Improved performance: =off() =cou() =pi =eu =row - Improved horizontal scrolling on macOS

- Removed the limit of 500 cells restored with the "Undo" button after cutting

- The app now works on iOS and iPadOS, as well as macOS and visionOS (Designed for iPad), sharing data with watchOS via iCloud Save - Chart thumbnails are always visible on iOS - In iOS, the button bar also includes "Copy Numbers" and "Select All"

What's new: - 10 columns (A-J) instead of 7 - Column names are permanently visible (watchOS 11+) - After selecting a cell, a bar appears with buttons: "Cut," "Copy," "Paste," "Undo", "Cancel" - A "Select Column" button replaces the "Trash" button under each column - Restored backups automatically save the current state to the Local Save (sixth slot)

- Multicolored bar charts (each bar in its own cell color)

- 5 backup slots that sync with iCloud and between watches - Column names and trash icons in the default column and chart colors - Warning before clearing a column after tapping the trash - Other minor design changes

- New features: Median: med(a0:g99) Standard deviation: std(a0:g99) Remainder from a division: mod(x/y) Absolute value: abs(x) Signum: sgn(x) - Protection against invalid formulas that overload memory and cause the application to hang or fail to launch; now, after a critical error, the last edited cell is deleted - Other fixes and improvements

- Local and iCloud backup, data syncing between watches - New formulas: =bin() converts a decimal number from -65535 to 65535 to binary =dec() converts a binary number from -111111111111111 to 111111111111111 to decimal =up() returns an integer rounded up =do() returns an integer rounded down =()! returns the factorial of an integer from 0 to 170 - Now each empty column has a button at the bottom with a different example formula for filling the column - Charts now support very large numbers - Other changes and fixes

- 100 rows instead of 99 (+ row 0) - 7 columns instead of 6 (+ column G) - changed column numbering in the =col formula: now a=0 b=1 c=2 d=3 e=4 f=5 g=6

- Row numbers are always visible - Six columns instead of five - Each column is a different color (default) - Return to the furthest saved cell in a column after leaving the chart - New widgets (Inline) - New formulas colors: =si() gray (silver), =bl() blue - Formulas change font color: =off() formula to gray, other formulas to yellow - Removed the chart close button; now just tap the screen - Fixed chart display in smaller watches - Other minor changes and fixes

- Cell color formulas: =gr() green, =re() red, =or() orange, =vi() purple - Chart color: default blue or the first numeric cell in the column with the color formula - Rounding formulas 1-9 to decimal places: =ro1(x) … =ro9(x) - Commenting after a number after a space does not change the character of a numeric cell - Redesigned widgets and compilations in chart colors - New corner compilation with the content of the last non-empty cell in the column - Chart widget caption is the last non-empty cell in the column (text, formula result, or number with comment) - Other minor improvements and fixes

New formulas: =cou() returns the number of numeric cells in the area (ignores itself) =off() disables the numeric value (in parentheses) for the chart and other cells, highlighting the disabled cell in red Example: =off(cou(d1:d99)/2) displays the formula result with a red background, but the chart treats the cell as empty or text; other formulas (cou, min, max, sum, ave) ignore it

- Now above chart widgets: value of the last point with the cell name. - Changed appearance for the AppIntent (circular) widget, improved visibility in monochromatic faces. - When filling with a formula from row 99 (blue arrow), the referenced cells of the column remain unchanged (those from other columns remain relevant). Example: formula in d99 =a98/d9 after filling (blue arrow) in d98 will be =a97/d9 … in d2 will be =a1/d9 (then enter the value in d9 instead of ERR or select cell d9 before filling to bypass filling). - If a reference to non-existent cells (e.g., a0) is created during filling, it now leaves the cells empty instead of returning ERR.

- New functions: per() for percentages and pro() for per mille. Examples: =per(pi) returns 314.16%, =pro(pi) returns 3141.59‰ - Now, if the formula in a cell in row 99 refers to a cell in any row (not just its own), after filling in (blue arrow) in the remaining cells, the reference will be accurate. This means that if I enter the formula from b98 in cell b99 and fill in (blue arrow), cell b98 will contain the formula from b97, cell b97 will contain the formula from b96… - Minor changes to cell and button sizes

- minor appearance changes - now full-screen spreadsheet also in watchOS 10 (appearance standardization)

- Redesigned cells without formulas, now displaying more characters on two lines (similar to cells with formulas) - Cells without formulas can now also be selected (the "trash" button won't delete them; you'll need to deselect them later) - The first tap on each cell now selects it, and the second tap enters edit mode (unification)

- added compilations and widgets, now the preview of your favorite chart is always visible on the watch face

- now when there are >50 numbers in a column, the full-screen chart is always linear (blue when there are no negative numbers, red when there are negative numbers) - lighter icon background to maintain the round shape on watchOS 10 and 11

- New functions: Row number as a number: row or row() Column number (a=1 ... e=5) as a number: col or col() - "Random number from 0 to 1" function, now: rnd or rnd() Example formula: =rnd*row+col

The "chart" button above a column displays a thumbnail of the chart (if the column contains numbers). Fixed a bug that could cause the application to crash.

- Ability to calculate odd roots of negative numbers, e.g. =(-27)^(1/3) - The button under the column changes appearance and color depending on the function (delete, fill with row numbers, fill with the function from row 99) - The color of the button "chart" above the column matches the color of the chart (blue bar, red linear, white for no chart)

99 rows instead of 12, Charts ignore empty cells, The "trash" button has new functions: - it still deletes data in the entire column (except for previously selected cells with a function entered, when they display =... instead of the formula result) - if the column is empty, the "trash" button will fill it with numbers corresponding to the row numbers (1,2,3 ... 99) - if the column is empty, when you enter a formula in row 99, the "trash" button fills the entire column with that formula (if the formula contains a reference to a cell in row 99, e.g., a99, the copied formula will adjust to the corresponding row, so row 98 will reference a98 ... and row 1 will reference a1)