FormulaBase - Releases

Fixed

• Fixed a bug where clicking outside a dialog while entering data made the dialog disappear and discarded what you had typed. It affected the data-entry dialogs — the collection editor, the formula editor, Settings, and the "Download all data" (backup) and "Restore from backup" dialogs: clicking the surrounding area no longer closes them, so nothing you were entering is lost; close them with ✕, Cancel or Save. The view-only and picker dialogs (the template browser, a formula's version history, the export options and the file picker) keep closing on an outside click, since they hold nothing you can lose. （データ入力中にダイアログの外側をクリックすると、ダイアログが消えて入力が失われてしまうバグを 修正した。対象＝コレクション編集・数式編集・設定・「全データのダウンロード」（バックアップ）・ 「バックアップから復元」の各ダイアログ。外側クリックでは閉じなくなり、✕・キャンセル・保存で閉じる。 閲覧/選択系のダイアログ（テンプレート一覧・数式の版履歴・書き出し設定・ファイル選択）は失う入力が ないため従来どおり外側クリックで閉じる。）

New: per-formula version history

• Every edit to a formula now keeps the version before it beside the formula itself — numbered #01 (newest) upward, with the oldest falling off past a configurable limit (default 10, up to 99, or 0 to turn it off).
• Configurable in Settings: how many versions to keep per formula, and whether one is taken automatically on every edit or only when you ask for one (the "Versions" button in the formula editor).
• Open "Versions" on any formula to see the list and put an earlier one back; restoring a version keeps the current content as a version of its own first, so a restore can itself be undone the same way.
• This is separate from the existing per-formula calculation history (record / restore / delete a calculation) — that log is untouched.

Fixed: a formula added from a template could re-translate itself when you changed the display language

• Adding a formula from a template bakes its name, description, variable labels and notes into the language you were viewing at that moment — by design, so the formula becomes fully your own and can be edited like anything you typed yourself.
• The card display was re-running that text through the translator on every render. For a formula added while viewing in English, its text happened to still match the original English lookup key, so it kept getting re-translated on every later language switch — while the same formula added under any other language stayed correctly frozen. Now the stored text is shown as-is, so a formula's language stays whatever it was at the moment it was added or last saved, regardless of later language switches. Opening "Edit" still lets you re-save a formula in the current language on purpose, same as before.

New: brand-new logo

• Replaced the old placeholder icon everywhere it appeared — the Nextcloud app icon (top navigation bar and Settings > Apps), the in-app header, the welcome screen, and the loading screen — with FormulaBase's new two-color mark.
• Fixed the logo's on-screen size and proportions: cropped the icon artwork to its actual visible bounds (removing built-in empty margin) and corrected the CSS so the logo scales by its own aspect ratio instead of being forced into a square, which had been shrinking it inside its own space.

Fixed: ODS/ODT export — broken formula results and missing images

• ODS "Result" cell showed a formula error ("Err:510") instead of the computed value. The generated table:formula attribute used an of:= dialect prefix without declaring its XML namespace, which real LibreOffice rejects. Formulas are now written as plain =..., and the Result cell recalculates correctly when opened.
• The embedded formula image didn't appear at all in ODS or ODT exports, despite the file looking structurally correct (valid manifest, correct image bytes, well-formed XML). Verified against real LibreOffice (headless rendering, not just XML inspection): an image anchored inside a spreadsheet cell's paragraph is silently dropped by Calc. Images are now embedded as a table-level floating shape (<table:shapes>) — the same structure Calc itself writes when you paste a picture into a sheet — which renders correctly.
• Fixed a follow-on bug the image fix introduced: the blank rows reserved above the image shifted the variable/result rows down, so the Result formula's cell references (B4, B5, …) pointed at the wrong rows and evaluated to 0. Row numbering is now computed from the image's actual height instead of a fixed offset.

Changed: Copy is now two explicit choices, not one ambiguous button

• The Output dialog's single "Copy" button (which wrote text and image together, letting the paste target guess which one to use) is now two buttons: Copy as text (Markdown trace only) and Copy as image (the rendered formula picture only) — so pasting into a chat, a document, or an image field reliably gets the type you meant, not whichever a mixed clipboard write happened to prefer.
• The small "Copy result" button next to a live calculation result now shows visible Copy text (and Copied when clicked) instead of a bare, unlabeled clipboard icon.

New: resizable calculation-steps panel

• The boundary between the formula list and the "🧭 Calculation steps" / history panel can now be dragged to resize it.
• A new Settings field, Calculation steps panel width, sets it precisely with a slider (20%–50%, default 30%) instead of dragging. Both the drag and the slider save to the same per-user setting, so the width you left it at — however you set it — is restored the next time you open FormulaBase.

Export to a real, calculable spreadsheet

• The Markdown export from 0.4.18 no longer downloads through the browser — it now writes straight into a folder you pick in your own Nextcloud Files, via a small built-in folder picker.
• New: Save as ODS. Exports a formula as a genuine OpenDocument Spreadsheet — variable values land in editable cells, the result cell holds a real spreadsheet formula (compiled from the expression, not just its text) that recalculates when you change a value, and the formula's rendered math is embedded above it as an image.

Copy and export the calculation trace

• The "Calculation steps" panel now has Copy and Download as Markdown (.md) buttons — export the formula, its input values, and the full substitution/reduction trace as plain Markdown text, ready to paste into a report or hand to a student/colleague.

Compatibility

• Declared support for Nextcloud 34 (verified on Nextcloud 34.0.2 with PHP 8.5 — install, migrations and the collection/formula views all pass). No code changes.

Fixed

• Fixed a bug where clicking outside a dialog while entering data made the dialog disappear and discarded what you had typed. It affected the data-entry dialogs — the collection editor, the formula editor, Settings, and the "Download all data" (backup) and "Restore from backup" dialogs: clicking the surrounding area no longer closes them, so nothing you were entering is lost; close them with ✕, Cancel or Save. The view-only and picker dialogs (the template browser, a formula's version history, the export options and the file picker) keep closing on an outside click, since they hold nothing you can lose. （データ入力中にダイアログの外側をクリックすると、ダイアログが消えて入力が失われてしまうバグを 修正した。対象＝コレクション編集・数式編集・設定・「全データのダウンロード」（バックアップ）・ 「バックアップから復元」の各ダイアログ。外側クリックでは閉じなくなり、✕・キャンセル・保存で閉じる。 閲覧/選択系のダイアログ（テンプレート一覧・数式の版履歴・書き出し設定・ファイル選択）は失う入力が ないため従来どおり外側クリックで閉じる。）

New: per-formula version history

• Every edit to a formula now keeps the version before it beside the formula itself — numbered #01 (newest) upward, with the oldest falling off past a configurable limit (default 10, up to 99, or 0 to turn it off).
• Configurable in Settings: how many versions to keep per formula, and whether one is taken automatically on every edit or only when you ask for one (the "Versions" button in the formula editor).
• Open "Versions" on any formula to see the list and put an earlier one back; restoring a version keeps the current content as a version of its own first, so a restore can itself be undone the same way.
• This is separate from the existing per-formula calculation history (record / restore / delete a calculation) — that log is untouched.

Fixed: a formula added from a template could re-translate itself when you changed the display language

• Adding a formula from a template bakes its name, description, variable labels and notes into the language you were viewing at that moment — by design, so the formula becomes fully your own and can be edited like anything you typed yourself.
• The card display was re-running that text through the translator on every render. For a formula added while viewing in English, its text happened to still match the original English lookup key, so it kept getting re-translated on every later language switch — while the same formula added under any other language stayed correctly frozen. Now the stored text is shown as-is, so a formula's language stays whatever it was at the moment it was added or last saved, regardless of later language switches. Opening "Edit" still lets you re-save a formula in the current language on purpose, same as before.

New: brand-new logo

• Replaced the old placeholder icon everywhere it appeared — the Nextcloud app icon (top navigation bar and Settings > Apps), the in-app header, the welcome screen, and the loading screen — with FormulaBase's new two-color mark.
• Fixed the logo's on-screen size and proportions: cropped the icon artwork to its actual visible bounds (removing built-in empty margin) and corrected the CSS so the logo scales by its own aspect ratio instead of being forced into a square, which had been shrinking it inside its own space.

Fixed: ODS/ODT export — broken formula results and missing images

• ODS "Result" cell showed a formula error ("Err:510") instead of the computed value. The generated table:formula attribute used an of:= dialect prefix without declaring its XML namespace, which real LibreOffice rejects. Formulas are now written as plain =..., and the Result cell recalculates correctly when opened.
• The embedded formula image didn't appear at all in ODS or ODT exports, despite the file looking structurally correct (valid manifest, correct image bytes, well-formed XML). Verified against real LibreOffice (headless rendering, not just XML inspection): an image anchored inside a spreadsheet cell's paragraph is silently dropped by Calc. Images are now embedded as a table-level floating shape (<table:shapes>) — the same structure Calc itself writes when you paste a picture into a sheet — which renders correctly.
• Fixed a follow-on bug the image fix introduced: the blank rows reserved above the image shifted the variable/result rows down, so the Result formula's cell references (B4, B5, …) pointed at the wrong rows and evaluated to 0. Row numbering is now computed from the image's actual height instead of a fixed offset.

Changed: Copy is now two explicit choices, not one ambiguous button

• The Output dialog's single "Copy" button (which wrote text and image together, letting the paste target guess which one to use) is now two buttons: Copy as text (Markdown trace only) and Copy as image (the rendered formula picture only) — so pasting into a chat, a document, or an image field reliably gets the type you meant, not whichever a mixed clipboard write happened to prefer.
• The small "Copy result" button next to a live calculation result now shows visible Copy text (and Copied when clicked) instead of a bare, unlabeled clipboard icon.

New: resizable calculation-steps panel

• The boundary between the formula list and the "🧭 Calculation steps" / history panel can now be dragged to resize it.
• A new Settings field, Calculation steps panel width, sets it precisely with a slider (20%–50%, default 30%) instead of dragging. Both the drag and the slider save to the same per-user setting, so the width you left it at — however you set it — is restored the next time you open FormulaBase.

Export to a real, calculable spreadsheet

• The Markdown export from 0.4.18 no longer downloads through the browser — it now writes straight into a folder you pick in your own Nextcloud Files, via a small built-in folder picker.
• New: Save as ODS. Exports a formula as a genuine OpenDocument Spreadsheet — variable values land in editable cells, the result cell holds a real spreadsheet formula (compiled from the expression, not just its text) that recalculates when you change a value, and the formula's rendered math is embedded above it as an image.

Copy and export the calculation trace

• The "Calculation steps" panel now has Copy and Download as Markdown (.md) buttons — export the formula, its input values, and the full substitution/reduction trace as plain Markdown text, ready to paste into a report or hand to a student/colleague.

Compatibility

• Declared support for Nextcloud 34 (verified on Nextcloud 34.0.2 with PHP 8.5 — install, migrations and the collection/formula views all pass). No code changes.

Fixed

• Fixed a bug where clicking outside a dialog while entering data made the dialog disappear and discarded what you had typed. It affected the data-entry dialogs — the collection editor, the formula editor, Settings, and the "Download all data" (backup) and "Restore from backup" dialogs: clicking the surrounding area no longer closes them, so nothing you were entering is lost; close them with ✕, Cancel or Save. The view-only and picker dialogs (the template browser, a formula's version history, the export options and the file picker) keep closing on an outside click, since they hold nothing you can lose. （データ入力中にダイアログの外側をクリックすると、ダイアログが消えて入力が失われてしまうバグを 修正した。対象＝コレクション編集・数式編集・設定・「全データのダウンロード」（バックアップ）・ 「バックアップから復元」の各ダイアログ。外側クリックでは閉じなくなり、✕・キャンセル・保存で閉じる。 閲覧/選択系のダイアログ（テンプレート一覧・数式の版履歴・書き出し設定・ファイル選択）は失う入力が ないため従来どおり外側クリックで閉じる。）

New: per-formula version history

• Every edit to a formula now keeps the version before it beside the formula itself — numbered #01 (newest) upward, with the oldest falling off past a configurable limit (default 10, up to 99, or 0 to turn it off).
• Configurable in Settings: how many versions to keep per formula, and whether one is taken automatically on every edit or only when you ask for one (the "Versions" button in the formula editor).
• Open "Versions" on any formula to see the list and put an earlier one back; restoring a version keeps the current content as a version of its own first, so a restore can itself be undone the same way.
• This is separate from the existing per-formula calculation history (record / restore / delete a calculation) — that log is untouched.

Fixed: a formula added from a template could re-translate itself when you changed the display language

• Adding a formula from a template bakes its name, description, variable labels and notes into the language you were viewing at that moment — by design, so the formula becomes fully your own and can be edited like anything you typed yourself.
• The card display was re-running that text through the translator on every render. For a formula added while viewing in English, its text happened to still match the original English lookup key, so it kept getting re-translated on every later language switch — while the same formula added under any other language stayed correctly frozen. Now the stored text is shown as-is, so a formula's language stays whatever it was at the moment it was added or last saved, regardless of later language switches. Opening "Edit" still lets you re-save a formula in the current language on purpose, same as before.

New: brand-new logo

• Replaced the old placeholder icon everywhere it appeared — the Nextcloud app icon (top navigation bar and Settings > Apps), the in-app header, the welcome screen, and the loading screen — with FormulaBase's new two-color mark.
• Fixed the logo's on-screen size and proportions: cropped the icon artwork to its actual visible bounds (removing built-in empty margin) and corrected the CSS so the logo scales by its own aspect ratio instead of being forced into a square, which had been shrinking it inside its own space.

Fixed: ODS/ODT export — broken formula results and missing images

• ODS "Result" cell showed a formula error ("Err:510") instead of the computed value. The generated table:formula attribute used an of:= dialect prefix without declaring its XML namespace, which real LibreOffice rejects. Formulas are now written as plain =..., and the Result cell recalculates correctly when opened.
• The embedded formula image didn't appear at all in ODS or ODT exports, despite the file looking structurally correct (valid manifest, correct image bytes, well-formed XML). Verified against real LibreOffice (headless rendering, not just XML inspection): an image anchored inside a spreadsheet cell's paragraph is silently dropped by Calc. Images are now embedded as a table-level floating shape (<table:shapes>) — the same structure Calc itself writes when you paste a picture into a sheet — which renders correctly.
• Fixed a follow-on bug the image fix introduced: the blank rows reserved above the image shifted the variable/result rows down, so the Result formula's cell references (B4, B5, …) pointed at the wrong rows and evaluated to 0. Row numbering is now computed from the image's actual height instead of a fixed offset.

Changed: Copy is now two explicit choices, not one ambiguous button

• The Output dialog's single "Copy" button (which wrote text and image together, letting the paste target guess which one to use) is now two buttons: Copy as text (Markdown trace only) and Copy as image (the rendered formula picture only) — so pasting into a chat, a document, or an image field reliably gets the type you meant, not whichever a mixed clipboard write happened to prefer.
• The small "Copy result" button next to a live calculation result now shows visible Copy text (and Copied when clicked) instead of a bare, unlabeled clipboard icon.

New: resizable calculation-steps panel

• The boundary between the formula list and the "🧭 Calculation steps" / history panel can now be dragged to resize it.
• A new Settings field, Calculation steps panel width, sets it precisely with a slider (20%–50%, default 30%) instead of dragging. Both the drag and the slider save to the same per-user setting, so the width you left it at — however you set it — is restored the next time you open FormulaBase.

Export to a real, calculable spreadsheet

• The Markdown export from 0.4.18 no longer downloads through the browser — it now writes straight into a folder you pick in your own Nextcloud Files, via a small built-in folder picker.
• New: Save as ODS. Exports a formula as a genuine OpenDocument Spreadsheet — variable values land in editable cells, the result cell holds a real spreadsheet formula (compiled from the expression, not just its text) that recalculates when you change a value, and the formula's rendered math is embedded above it as an image.

Copy and export the calculation trace

• The "Calculation steps" panel now has Copy and Download as Markdown (.md) buttons — export the formula, its input values, and the full substitution/reduction trace as plain Markdown text, ready to paste into a report or hand to a student/colleague.

Compatibility

• Declared support for Nextcloud 34 (verified on Nextcloud 34.0.2 with PHP 8.5 — install, migrations and the collection/formula views all pass). No code changes.

Emoji are drawn by the app, not by the viewer's device

0.4.14 bundled the full emoji set but kept it as a fallback behind the device's own font. That does not fix flags, and the reason is worth writing down: Segoe UI Emoji has glyphs for the regional indicator letters. It reports 🇯 and 🇵 as covered and simply draws them as two boxed letters instead of forming 🇯🇵 — so nothing is "missing", the browser never falls through, and the bundled font was never even downloaded. Taking only the flag code points away from the device font does not work either: U+200D has to travel with them or 🏳️‍🌈 🏳️‍⚧️ 🏴‍☠️ split into a bare flag, and once U+200D belongs to a different font than the base character, every ZWJ emoji comes apart — families, couples, professions, hair colours.

• All 1,849 emoji are now rendered from the bundled Noto Color Emoji subset (SIL OFL 1.1), on every platform. A device's own emoji font is kept behind it only as a safety net for a failed download.
• Verified on three simulated devices — a complete emoji font, a Windows-like one (has the regional indicator glyphs but cannot form flags), and none at all: all 1,849 render identically in each, flags and ZWJ sequences included.
• The font applies only to the elements that display an icon, so the app's own UI keeps the platform look and body text is untouched — characters such as © ® ™ ↔ stay plain text.
• Cost: one cached 1.7 MB download. Collections are shared, so consistent rendering is the point — everyone now sees the icon the person who picked it saw.

Emoji no longer depend on the viewer's device

0.4.13 shipped a flag-only font, which treated the symptom. The cause is that the app was letting whatever emoji font a device happens to ship decide whether an icon is readable — and flags are simply where that shows up first, because Windows has no flag glyphs on any version (Segoe UI Emoji draws 🇯🇵 as a boxed "JP" and 🏴󠁧󠁢󠁷󠁬󠁳󠁿 as an empty box, a deliberate omission that updates will not fix). The same gap hits anything newer than the device's font: Segoe UI Emoji only gained the Unicode 13/14 additions (🫠 🫰 🫡 …) in Windows 11 22H2. Collections get shared, so an icon has to survive being viewed on someone else's screen.

• FormulaBase now carries all 1,849 emoji it offers, as a subset of Noto Color Emoji (SIL OFL 1.1) — the vector COLRv1 build, 1.7 MB where the bitmap build of the same coverage would be 4.4 MB.
• It is a fallback, not a replacement: the first @font-face is local() only and names the platform emoji fonts, so a device with a complete font uses its own and downloads nothing. Font fallback reaches the bundled file only for the glyphs the platform font turned out to be missing, and the browser caches it from then on.
• Measured on three simulated devices — complete emoji font: never fetched; Windows-like (emoji font present, no flags): fetched the first time a flag is drawn, not on app start; no emoji font at all: fetched on load, and every one of the 1,849 renders.
• The font pair applies only to the elements that display an icon, never to body text, so characters such as © ® ™ ↔ stay plain text everywhere else.

Flags now render on Windows

• Windows ships no flag glyphs: Segoe UI Emoji draws 🇯🇵 as a boxed "JP" letter pair and 🏴󠁧󠁢󠁷󠁬󠁳󠁿 as an empty box, so the 269 flags in the icon picker were unusable there. FormulaBase now carries a flag-only subset of Noto Color Emoji (SIL OFL 1.1) and declares it with a unicode-range limited to the flag code points: the browser fetches the file the first time a flag is actually drawn — not on app start — and then caches it. Every other emoji still comes from the system font, so nothing else changes.

The icon picker now holds every Unicode emoji

• The collection icon picker used to offer a hand-picked 404 emoji. It now contains the complete Unicode 14.0 set — 1,849 emoji, in the nine official Unicode groups (Smileys & Emotion, People & Body, Animals & Nature, Food & Drink, Travel & Places, Activities, Objects, Symbols, Flags), in the official emoji-ordering sequence. The curated Calculation set stays as the first tab.
• Search box: type to filter across all 1,849 by name or keyword, in your own language (CLDR names for all 12 UI languages). Japanese search is kana-insensitive, so "ねこ" finds ネコの顔.
• Group tabs replace one long scroll, and hovering an emoji shows its name.
• The emoji set is fetched only when the picker is first opened, so the app starts just as fast as before.
• The icon input accepts longer sequences (16 units instead of 8), so multi-codepoint emoji such as 🏴󠁧󠁢󠁷󠁬󠁳󠁿 or 👩‍❤️‍💋‍👩 can be typed or pasted without being cut off.
• The emoji category names are now translated into all 12 languages.

Fixed: the Nextcloud user-status menu was broken on FormulaBase pages

• FormulaBase loads the "global" build of the Vue 3 runtime, which publishes window.Vue. A third-party library bundled into Nextcloud core (vue-resize) auto-installs into that global with the Vue 2 API — window.Vue.use(...) — which throws on a Vue 3 namespace and aborted the script that renders the user-status menu. FormulaBase now keeps its Vue copy private and leaves window.Vue untouched.

• App Store screenshots added (8, in Japanese): formula list, live calculation with step-by-step working, several results in one collection, reverse solve (target result), the template picker (2,971 templates / 64 categories), the formula editor, settings, and collection settings.

Fixed

• Fixed a bug where clicking outside a dialog while entering data made the dialog disappear and discarded what you had typed. It affected the data-entry dialogs — the collection editor, the formula editor, Settings, and the "Download all data" (backup) and "Restore from backup" dialogs: clicking the surrounding area no longer closes them, so nothing you were entering is lost; close them with ✕, Cancel or Save. The view-only and picker dialogs (the template browser, a formula's version history, the export options and the file picker) keep closing on an outside click, since they hold nothing you can lose. （データ入力中にダイアログの外側をクリックすると、ダイアログが消えて入力が失われてしまうバグを 修正した。対象＝コレクション編集・数式編集・設定・「全データのダウンロード」（バックアップ）・ 「バックアップから復元」の各ダイアログ。外側クリックでは閉じなくなり、✕・キャンセル・保存で閉じる。 閲覧/選択系のダイアログ（テンプレート一覧・数式の版履歴・書き出し設定・ファイル選択）は失う入力が ないため従来どおり外側クリックで閉じる。）

New: per-formula version history

• Every edit to a formula now keeps the version before it beside the formula itself — numbered #01 (newest) upward, with the oldest falling off past a configurable limit (default 10, up to 99, or 0 to turn it off).
• Configurable in Settings: how many versions to keep per formula, and whether one is taken automatically on every edit or only when you ask for one (the "Versions" button in the formula editor).
• Open "Versions" on any formula to see the list and put an earlier one back; restoring a version keeps the current content as a version of its own first, so a restore can itself be undone the same way.
• This is separate from the existing per-formula calculation history (record / restore / delete a calculation) — that log is untouched.

Fixed: a formula added from a template could re-translate itself when you changed the display language

• Adding a formula from a template bakes its name, description, variable labels and notes into the language you were viewing at that moment — by design, so the formula becomes fully your own and can be edited like anything you typed yourself.
• The card display was re-running that text through the translator on every render. For a formula added while viewing in English, its text happened to still match the original English lookup key, so it kept getting re-translated on every later language switch — while the same formula added under any other language stayed correctly frozen. Now the stored text is shown as-is, so a formula's language stays whatever it was at the moment it was added or last saved, regardless of later language switches. Opening "Edit" still lets you re-save a formula in the current language on purpose, same as before.

New: brand-new logo

• Replaced the old placeholder icon everywhere it appeared — the Nextcloud app icon (top navigation bar and Settings > Apps), the in-app header, the welcome screen, and the loading screen — with FormulaBase's new two-color mark.
• Fixed the logo's on-screen size and proportions: cropped the icon artwork to its actual visible bounds (removing built-in empty margin) and corrected the CSS so the logo scales by its own aspect ratio instead of being forced into a square, which had been shrinking it inside its own space.

Fixed: ODS/ODT export — broken formula results and missing images

• ODS "Result" cell showed a formula error ("Err:510") instead of the computed value. The generated table:formula attribute used an of:= dialect prefix without declaring its XML namespace, which real LibreOffice rejects. Formulas are now written as plain =..., and the Result cell recalculates correctly when opened.
• The embedded formula image didn't appear at all in ODS or ODT exports, despite the file looking structurally correct (valid manifest, correct image bytes, well-formed XML). Verified against real LibreOffice (headless rendering, not just XML inspection): an image anchored inside a spreadsheet cell's paragraph is silently dropped by Calc. Images are now embedded as a table-level floating shape (<table:shapes>) — the same structure Calc itself writes when you paste a picture into a sheet — which renders correctly.
• Fixed a follow-on bug the image fix introduced: the blank rows reserved above the image shifted the variable/result rows down, so the Result formula's cell references (B4, B5, …) pointed at the wrong rows and evaluated to 0. Row numbering is now computed from the image's actual height instead of a fixed offset.

Changed: Copy is now two explicit choices, not one ambiguous button

• The Output dialog's single "Copy" button (which wrote text and image together, letting the paste target guess which one to use) is now two buttons: Copy as text (Markdown trace only) and Copy as image (the rendered formula picture only) — so pasting into a chat, a document, or an image field reliably gets the type you meant, not whichever a mixed clipboard write happened to prefer.
• The small "Copy result" button next to a live calculation result now shows visible Copy text (and Copied when clicked) instead of a bare, unlabeled clipboard icon.

New: resizable calculation-steps panel

• The boundary between the formula list and the "🧭 Calculation steps" / history panel can now be dragged to resize it.
• A new Settings field, Calculation steps panel width, sets it precisely with a slider (20%–50%, default 30%) instead of dragging. Both the drag and the slider save to the same per-user setting, so the width you left it at — however you set it — is restored the next time you open FormulaBase.

Export to a real, calculable spreadsheet

• The Markdown export from 0.4.18 no longer downloads through the browser — it now writes straight into a folder you pick in your own Nextcloud Files, via a small built-in folder picker.
• New: Save as ODS. Exports a formula as a genuine OpenDocument Spreadsheet — variable values land in editable cells, the result cell holds a real spreadsheet formula (compiled from the expression, not just its text) that recalculates when you change a value, and the formula's rendered math is embedded above it as an image.

Copy and export the calculation trace

• The "Calculation steps" panel now has Copy and Download as Markdown (.md) buttons — export the formula, its input values, and the full substitution/reduction trace as plain Markdown text, ready to paste into a report or hand to a student/colleague.

Compatibility

• Declared support for Nextcloud 34 (verified on Nextcloud 34.0.2 with PHP 8.5 — install, migrations and the collection/formula views all pass). No code changes.

Emoji are drawn by the app, not by the viewer's device

0.4.14 bundled the full emoji set but kept it as a fallback behind the device's own font. That does not fix flags, and the reason is worth writing down: Segoe UI Emoji has glyphs for the regional indicator letters. It reports 🇯 and 🇵 as covered and simply draws them as two boxed letters instead of forming 🇯🇵 — so nothing is "missing", the browser never falls through, and the bundled font was never even downloaded. Taking only the flag code points away from the device font does not work either: U+200D has to travel with them or 🏳️‍🌈 🏳️‍⚧️ 🏴‍☠️ split into a bare flag, and once U+200D belongs to a different font than the base character, every ZWJ emoji comes apart — families, couples, professions, hair colours.

• All 1,849 emoji are now rendered from the bundled Noto Color Emoji subset (SIL OFL 1.1), on every platform. A device's own emoji font is kept behind it only as a safety net for a failed download.
• Verified on three simulated devices — a complete emoji font, a Windows-like one (has the regional indicator glyphs but cannot form flags), and none at all: all 1,849 render identically in each, flags and ZWJ sequences included.
• The font applies only to the elements that display an icon, so the app's own UI keeps the platform look and body text is untouched — characters such as © ® ™ ↔ stay plain text.
• Cost: one cached 1.7 MB download. Collections are shared, so consistent rendering is the point — everyone now sees the icon the person who picked it saw.

Emoji no longer depend on the viewer's device

0.4.13 shipped a flag-only font, which treated the symptom. The cause is that the app was letting whatever emoji font a device happens to ship decide whether an icon is readable — and flags are simply where that shows up first, because Windows has no flag glyphs on any version (Segoe UI Emoji draws 🇯🇵 as a boxed "JP" and 🏴󠁧󠁢󠁷󠁬󠁳󠁿 as an empty box, a deliberate omission that updates will not fix). The same gap hits anything newer than the device's font: Segoe UI Emoji only gained the Unicode 13/14 additions (🫠 🫰 🫡 …) in Windows 11 22H2. Collections get shared, so an icon has to survive being viewed on someone else's screen.

• FormulaBase now carries all 1,849 emoji it offers, as a subset of Noto Color Emoji (SIL OFL 1.1) — the vector COLRv1 build, 1.7 MB where the bitmap build of the same coverage would be 4.4 MB.
• It is a fallback, not a replacement: the first @font-face is local() only and names the platform emoji fonts, so a device with a complete font uses its own and downloads nothing. Font fallback reaches the bundled file only for the glyphs the platform font turned out to be missing, and the browser caches it from then on.
• Measured on three simulated devices — complete emoji font: never fetched; Windows-like (emoji font present, no flags): fetched the first time a flag is drawn, not on app start; no emoji font at all: fetched on load, and every one of the 1,849 renders.
• The font pair applies only to the elements that display an icon, never to body text, so characters such as © ® ™ ↔ stay plain text everywhere else.

Flags now render on Windows

• Windows ships no flag glyphs: Segoe UI Emoji draws 🇯🇵 as a boxed "JP" letter pair and 🏴󠁧󠁢󠁷󠁬󠁳󠁿 as an empty box, so the 269 flags in the icon picker were unusable there. FormulaBase now carries a flag-only subset of Noto Color Emoji (SIL OFL 1.1) and declares it with a unicode-range limited to the flag code points: the browser fetches the file the first time a flag is actually drawn — not on app start — and then caches it. Every other emoji still comes from the system font, so nothing else changes.

The icon picker now holds every Unicode emoji

• The collection icon picker used to offer a hand-picked 404 emoji. It now contains the complete Unicode 14.0 set — 1,849 emoji, in the nine official Unicode groups (Smileys & Emotion, People & Body, Animals & Nature, Food & Drink, Travel & Places, Activities, Objects, Symbols, Flags), in the official emoji-ordering sequence. The curated Calculation set stays as the first tab.
• Search box: type to filter across all 1,849 by name or keyword, in your own language (CLDR names for all 12 UI languages). Japanese search is kana-insensitive, so "ねこ" finds ネコの顔.
• Group tabs replace one long scroll, and hovering an emoji shows its name.
• The emoji set is fetched only when the picker is first opened, so the app starts just as fast as before.
• The icon input accepts longer sequences (16 units instead of 8), so multi-codepoint emoji such as 🏴󠁧󠁢󠁷󠁬󠁳󠁿 or 👩‍❤️‍💋‍👩 can be typed or pasted without being cut off.
• The emoji category names are now translated into all 12 languages.

Fixed: the Nextcloud user-status menu was broken on FormulaBase pages

• FormulaBase loads the "global" build of the Vue 3 runtime, which publishes window.Vue. A third-party library bundled into Nextcloud core (vue-resize) auto-installs into that global with the Vue 2 API — window.Vue.use(...) — which throws on a Vue 3 namespace and aborted the script that renders the user-status menu. FormulaBase now keeps its Vue copy private and leaves window.Vue untouched.

• App Store screenshots added (8, in Japanese): formula list, live calculation with step-by-step working, several results in one collection, reverse solve (target result), the template picker (2,971 templates / 64 categories), the formula editor, settings, and collection settings.