Numara ทุกเวอร์ชันและเวอร์ชันเก่า

• Fixed an issue where long page names did not truncate with an ellipsis when wider than the sidebar.

### Bug Fixes & Enhancements
• Fixed editor focus and cursor restoration when switching pages so the cursor is immediately active and ready to type on the last remembered line.
• Persisted the active editor cursor position alongside calculation results and flushed pending cursor updates before switching pages.
• Prevented initial page load from overwriting saved cursor positions.

## What's New in v7.6.0

Numara 7.6.0 is a major release introducing **Cross-Page Imports**, **Full Offline PWA Support**, **Mobile Ergonomics**, calculation engine improvements, and security hardening.

---

### Highlights

• **Cross-Page Variables & Imports**：You can now reference variables and calculations from any other page using `page("PageName")` (e.g. `r = page("Rates")`, then `r.hourly * 40`). Includes full autocomplete hinting and clickable page links in results!
• **Full Offline PWA & Service Worker**：Numara on the web can now be installed as a Progressive Web App (PWA) and launched completely offline from a cold start, with smart background cache updates.
• **Mobile Ergonomics & Notch Support**：Smooth full-screen experience on phones and tablets with safe-area insets (no overlapping home bars) and disabled auto-capitalization/autocorrect on math expressions.

---

### Features & Improvements

#### Cross-Page Math & Navigation
• Reference other pages using `page("Name")` or `page("id")`.
• Auto-complete suggestions for imported page variables and object properties.
• Clickable page link tags in the results gutter to quickly navigate between related pages.

#### Progressive Web App & Offline
• **Service Worker**：Implemented network-first navigation with offline fallback and background asset revalidation.
• **Adaptive Icons**：Added dedicated Android maskable icons (`icon-maskable-192.png`, `icon-maskable-512.png`) with safe-zone margins and `apple-touch-icon.png` for iOS Home Screens.
• **PWA Enhancements**：Added app shortcuts (e.g. "New Calculation"), window controls overlay support, and device orientation flexibility.

#### Calculation Engine & Editor
• **Running Total Keyword Collisions**：Fixed an issue where variable names containing keywords (e.g. `total_amount = 500`) were excluded from running totals (`total`, `subtotal`).
• **Temporal Scope in Imports**：Cross-page expressions referencing `today` or `now` now resolve accurately in the importing page.
• **Live Search Panel**：Match positions and highlights now update in real-time as you edit text with the search panel open.
• **Bottom Answer Copying**：Fixed `Copy All Answers` and `Copy Page` when using the bottom answer position layout.
• **Formatting Crash Guards**：Added defensive fallbacks in number and currency formatting to prevent `RangeError` crashes when invalid precision settings are passed.

#### Security & Stability Hardening
• **Content Security Policy (CSP)**：Added strict CSP headers whitelisting only local assets and the Frankfurter currency API.
• **DOM XSS Protection**：Switched DOM updates across error dialogs, confirmations, plot titles, and status messages from `innerHTML` to `textContent`.
• **Sync Safety**：Cancelled pending debounced saves during page rename and deletion to eliminate race conditions in folder synchronization.
• **Electron Hardening**：Added window destruction guards and protocol restrictions (`http:`, `https:`) on external URL handlers.

#### CI/CD & Testing
• Automated multi-OS test matrix (Ubuntu, macOS, Windows) running **574 unit tests** on every push and pull request.

---

### Contributors
Special thanks to @meghprkh for the contribution to the PWA Service Worker architecture and adaptive icons in PR #300!

• fix：use resolved app theme for user-defined functions/units editor- #297 - Thanks @jolly-exe !
• Updated dependencies

• Window Sizing：Fixed an issue where the application window would grow horizontally wider on every launch when the "Page list sidebar position" was configured as "Docked". The window dimensions will now consistently restore to their correct sizes without adding the sidebar width padding on startup. (#291)
Build & Dependencies
• Bumped application version to 7.4.1.

• Window Sizing：Fixed an issue where the application window would grow horizontally wider on every launch when the "Page list sidebar position" was configured as "Docked". The window dimensions will now consistently restore to their correct sizes without adding the sidebar width padding on startup. (#291)
Build & Dependencies
• Bumped application version to 7.4.1.

- Window Sizing: Fixed an issue where the application window would grow horizontally wider on every launch when the "Page list sidebar position" was configured as "Docked". The window dimensions will now consistently restore to their correct sizes without adding the sidebar width padding on startup. (#291)
Build & Dependencies
- Bumped application version to 7.4.1.

Modern Find and Replace Panel
- Replaced CodeMirror's standard dialog prompts with a custom, persistent search panel pinned at the top of the editor.
- Added a toggle button to expand or collapse the Replace row inside the panel.
- Added support for toggling the panel with standard keyboard shortcuts:
- Ctrl+F / Cmd+F: Opens the panel in Find mode and focuses the search input.
- Ctrl+H / Cmd+Alt+F: Opens the panel in Replace mode and focuses the replace input.
Enhanced Navigation and Selection Highlights
- Hitting Enter inside the search input moves to the next match, while Shift+Enter moves to the previous match.
- Included an occurrence counter (e.g. "X of Y") next to the input to show the active match index.
- Redesigned match highlighting to make the active selection stand out. Other matches use a subtle blue background with an underline, while the active match is colored in a prominent amber/orange.
Space Alignment and Layout Fixes
- Configured the editor lines, line-number gutters, and the right-hand answer column to push down dynamically when the search panel is open. This ensures no text is covered by the search bar, keeping calculations and answers perfectly aligned.
- Designed the panel elements with fixed scaling rules (flex-shrink protection) and set a minimum width boundary for search inputs. The panel remains fully usable even on narrow windows.
Keyboard Shortcuts and Escape Key Protection
- Updated the global application Escape key handler to prevent the calculator window from accidentally closing when dismissive keypresses are intended to close the search panel.

Improved Second-Instance Activation Behavior
Refactored the application's single-instance lock handler in the Electron main process to improve window toggling when the user attempts to launch a second instance:
- Toggle Focused Window: If the application is already running, focused, and no file argument is passed, launching a new instance will now act as a toggle:
- If the system tray setting showTray is enabled, the active window is seamlessly hidden to the tray (win.hide()).
- If showTray is disabled, the window is minimized (win.minimize()).
- Restore and Focus: If the window was previously minimized or hidden, it is correctly restored (win.restore()), shown (win.show()), and focused (win.focus()).
Maintenance and Dependency Upgrades
- Version Bump: Bumped version from 7.3.0 to 7.3.1.
- Icon Library Upgrade: Upgraded lucide icons dependency from ^1.23.0 to ^1.24.0.

Configurable Escape Key Window Hiding / Minimization (#285)
- Added a new setting "Close app on Esc key" in the General settings tab (disabled by default).
- When enabled, pressing the Escape key will hide the application window to the system tray/menu bar (if the tray icon is enabled) or minimize it to the taskbar.
Focus and Input Event Propagation Safety
- Pressing the Escape key prioritizes dismissing autocomplete hints lists in the text editor first.
- Active modal dialogs, overlay panels, and the sidebar list will consume the Escape key to close themselves first.
- The application window will only be hidden/minimized when there are no active dialogs, open sidebars, or visible auto-completion lists.
Dependency Updates
- Upgraded Electron dependency to version 43.1.0.
- Upgraded @bornova/deep-diff dependency to version 1.1.0.

- Fixed Unit Conversion Precision Setting Ignore: Resolved an issue where unit conversions (e.g. 1 ft to in) would ignore the configured precision settings and output unrounded values (e.g., displaying 12.000000000000002 in instead of 12 in).
- Fixed Missing Calculation Timeout Tooltip: Added the missing help description tooltip to the "Calculation timeout (seconds)" label in the Settings panel so that hovering/focusing on it now correctly shows the configuration guidance.

- Fix header alignment regression in macOS.

- Improved symbol matching regex: Updated the letter symbol regex to use proper Unicode word boundary logic (\p{L}\p{M}_ and \p{M}\d_), preventing false matches when symbol names appear as substrings within longer identifiers.
- Handle string answers in formatAnswer: String-type answers are now returned via stripAnswer early, avoiding errors when non-numeric results are passed to formatting logic. (#280)
- Page name layout fix. Added margin-top to the .pageName class for improved visual layout.

- Fix update block when running in system tray (macOS): Resolved an issue where clicking the Install Now button failed to update the app. Previously, when the app was configured to run in the menu bar, the window close event was intercepted and prevented from closing (hiding it instead), which aborted the update process. The update flow now correctly signals that the app is quitting.
- Updated dependencies

- Fix issue where fast typing on mobile devices deletes characters unexpectedly.
- Updated dependencies

- macOS Window Restoration: Fixed an issue where clicking the app icon in the Dock would fail to reopen/restore the calculator window if the app was running in the menu bar (tray) and had been closed via the traffic light close button.
- Window Lifecycle Cleanup: Properly reset the internal window reference on close to prevent potential memory and lifecycle-related issues.

- Enhanced the macOS Dock integration by dynamically hiding the dock icon when the app starts hidden (e.g., via "Open at login" when "Keep in tray" is enabled) or when the main window is closed/hidden to the tray. The Dock icon is now automatically shown only when the application window is visible, ensuring a cleaner background experience on macOS.

Numara v7.0.0 represents a complete, ground-up rewrite and modernization of the application. This release introduces a fully asynchronous calculation architecture, a brand new file synchronization mechanism, built-in code folding, and a visual redesign featuring Google Sans typography.
Key Highlights
1. Asynchronous Calculation Engine (Web Workers)
To prevent UI freezes and typing lag during complex calculations, the core math engine has been decoupled from the renderer process.
- Worker Threads: Calculations now run in a separate background thread calc.worker.js managed by a dedicated calcManager.js.
- Non-Blocking UI: The editor remains fluid and responsive even when evaluating large math sheets, complex symbolic expressions, or recursive variables.
- Improved Performance: Debounced calculations trigger seamlessly as you type, updating outputs with minimal CPU overhead.
2. Workspace & Folder Synchronization
Numara now supports importing and syncing entire directories directly from your local filesystem.
- How it works:
- Initial Alignment & Conflict Resolution: When a folder is synced, it scans for .num files. If a file is in the folder but not local, a new page is created. If content differs between a local page and a disk file, a conflict prompt allows you to choose to Overwrite Local or Sync Local.
- Debounced Auto-Saving: Editor typing triggers an asynchronous write back to the folder file with a 500ms debounce to prevent disk activity overhead.
- Rename & Delete Propagation: Any page rename or deletion performed inside the app automatically propagates to the corresponding file on disk.
3. Editor Refactor & Code Folding
The CodeMirror editor configuration has been rewritten for modularity and functionality.
- File Format Update: The default file extension for Numara sheets has been changed to .num.
- Code Folding: You can now fold math regions and header blocks (# followed by a space or a character). The calculation engine is fully aware of folding states, evaluating sub-totals dynamically.
4. UI/UX & Google Sans Typography
The user interface has been refined to feel more consistent and modern.
- System Tray Support: Desktop apps now support running in the system tray, with platform-specific template icons (macOS/Windows) and toggle controls in settings.
- Modern Typography: Replaced Open Sans and Roboto Mono with Google Sans as the primary typeface.
- Responsive Layout: Rebuilt layout elements with flex layout for pixel-perfect alignment. Modals, grids, warning banners, and inputs now follow a consistent layout spacing.
- Dynamic Sidebar: Implemented smooth transition animations and an enhanced resizable container for the sidebar/page manager.
- Live Tooltips: Inline help and settings-related tooltips have been introduced to guide users on function parameters and units.
5. Currency & Localization Improvements
Localization settings have been overhauled to better adapt to global standards.
- Thousand Separators: Thousand and decimal separators now automatically respect the system locale with option to choose comma or period as thousands separator.
- Date format: In addition to respecting the system locale, users can also set a preferred date format in settings.
Note: Although previous settings should transfer from v6 to v7, it is highly recommended to perform an app reset or fresh install.

- Replaced @melloware/coloris dependency with refactored @bornova/colorpicker version.
- Switch to Github Pages for hosting numara.io. Removes build folder from public repo.

- Added theme colors to text entries
- Remove tinykeys dependency
- Updated dependencies

- Fixed issue where some currencies were clashing with some units.
- Updated dependencies

- Fix more UI regressions/bugs

- Minor UI fixes/improvements

- Fix currency locale bug #250
- Updated dependencies

- Added setting to choose how the page list side bar is displayed. (#244)
- Auto: Automatically choose to slide out or show docked depending on window width.
- Slide out: Always slides out from left using the open/close button.
- Docked: Always shown on the left.
- Added ability to use dynamic today and now values in custom variables such as tmrw = today + 1 day (#248)
- Updated dependencies

- Suppress new version notification and move other notifications out of editor input area. (#243)
- Minor bug fixes and improvements
- Updated dependencies

- Improved currency formatting. Fixes #241
- Minor bug fixes and improvements

- Added code signing to Windows builds
- Updated dependencies

- Fixed a copy answer regression where thousands separator would be included even when turned off in settings.

- Support for other languages and unicode characters as variable names. #230
- Minor cleanup and improvements

- Simplified and improved theme switching
- Many under the hood bug fixes and improvements
Full Changelog: v6.6.9...v6.7.0

Updated dependencies

- Fix regression #226

- Updated dependencies

- Removed duplicate total, subtotal, avg and subavg values from calculations. #222
- Assigning variables are now excluded from calculations for cleaner output. Ex. x = 2 will no longer output 2 as answer and number 2 will be assigned to variable x silently.
- Updated dependencies

- Added luxon, formulajsand nerdamer libraries to global scope to enable usage in user defined functions.
- Updated dependencies

- Version upgrade to implement new build process. No app changes from v6.6.3

- Minor bug fix
- Update dependencies

- Fixed pasting regression by reverting back to default pasting behavior until a better solution can be implemented.
- Updated dependencies

- Integrated Nerdamer library. You can now use all Nerdamer functions such as:
nerdamer.solve('x^2-4', 'x') // [2,-2]
nerdamer.integrate('2*x^2+x', 'x'). // (1/2)*x^2+(2/3)*x^3
For more information about all Nerdamer functions, please visit https://nerdamer.com/
- Improved evaluate method for better performance
- Minor bug fixes and improvements
- Updated dependencies
Breaking change:
Prefix for Formula.js functions has changed from xls to formulajs for consistency.
Old -> xls.ABS(-2)
New -> formulajs.ABS(-2)

- Fixed bug where commas (,) were being lost when pasting text containing multiple lines. #208
- Updated dependencies

- Minor bug fixes/improvements
- Updated dependencies

- Fixed bug where false or 0 values were not being calculated.
- Updated dependencies

- With currencies enabled, users can now use the following currency symbols in calculations:
{
CNY: '¥', // Chinese Yuan
GBP: '£', // British Pound
EUR: '€', // Euro
RUB: '₽', // Russian Ruble
TRY: '₺', // Turkish Lira
USD: '$' // U.S. Dollar
}
For example:
$5 + $3 // 8 USD
$ to € // 0.8641 EUR
Ref. #181
- Updated dependencies

Updated dependencies

- Introduce option to allow locale specific thousands and decimal separators in typed expressions. To enable, go to Settings > Locale and toggle on Enable for input. With this setting enabled (turned off by default), expressions such as 1,000.23 + 1,200 (or 1.000,23 + 1.200 depending on the locale) are now evaluated. (Ref. #185) Please note, this is still somewhat experimental and probably has room for improvement so please feel free to report any bugs/issues. Also, with this enabled, semicolon needs to be used as argument separator in functions such as sum(1;2).
- Hovering over settings item labels now show a tooltip with a short description of the setting.
- Minor fixes and improvements
- Updated dependencies

- Plot settings have been moved to a separate dialog and no longer part of the main settings dialog. When a plot is shown, user has the plot settings available including setting the x-axis step/precision level and adjusting XY axis visible ranges. Also, if showing derivatives is enabled, the tooltip now shows the calculated derivative value. (#193)
- Page export button has moved to the individual page item 3-dot menu.
- Minor UI changes/improvements
- Updated dependencies

Updated dependencies

- Fixes #194
- Updated dependencies

- Fixes issues #188 and #189
- Updated dependencies

- Updated dependencies

- Added user defined variables to the autocomplete hints. (#178) Thanks @colinricardo!
- Added commenting shortcut with cmd+/ or ctrl+/. (#177) Thanks @colinricardo!
- Enhanced error handling in the editor by displaying error messages for problematic lines on line numbers. (#176) Thanks @colinricardo!
- Line errors are now indicated on the line numbers by default instead of showing 'Error' message as answer to reduce clutter caused by error messages while typing. This can be re-enabled in settings (previous default).
- Minor bug fixes and improvements
- Updated dependencies

- Added feature there subtotal/total/avg keyword now can work with units. (#174) Thanks @colinricardo!
- Fixed issue where total/avg would return zero instead of correct answer.
- Fixed bug where line number would return null in error dialog
- Updated dependencies

- Updated dependencies

Even more bug fixes
- Fixed a pesky context menu bug

More bug fixes

- Bug fixes and improvements
- Updated dependencies

UI Changes
- Replaced custom window control buttons with native controls.
- Added a new option to display answers directly below expressions. (Ref #86)
This can be configured in Settings, alongside existing options to display answers either left-aligned with a divider or right-aligned without one.
- Introduced an option to start the calculator with a blank page. (Ref #155)
- If a blank page already exists on startup, it will be shown.
- If not, a new blank page will be created.
- Disabled by default. By default, the app reopens to the last active page.
- Simplified customization of the Plain theme (used when syntax highlighting is off) via the Theme Customizer in Settings.
- Moved the Print button from the side panel to the main panel for easier access.
- Main dialogs (e.g., Settings, New Page) are now draggable. Double-clicking the title resets their position to the center of the screen.
- Reorganized Settings menus for better usability.
- Replaced the “Plot” text link with an icon for a cleaner interface.
- Currencies can now be entered using lowercase letters (e.g., usd is treated the same as USD). (Ref #98)
- Implemented various subtle UI tweaks and visual improvements.
Under-the-Hood Improvements
- Switched to cached DOM elements to boost performance.
- Refactored most of the code for better performance and maintainability.
Breaking Changes
- User locale settings no longer apply to input expressions—only to answers. Commas (,) are now the only accepted separator for function variables. This change improves consistency and simplifies syntax. (Ref #112)
- The default locale is now set to “System.”
- Commas are automatically stripped from pasted answers by default. This can be disabled in Settings. (Ref #119)
Note
An app reset (from Settings > Reset App link) is recommended to make sure all new features are loaded properly. Make sure to back up all calculations and settings.

Updated dependencies

- Updated app update notifications
- Minor improvements/fixes
- Updated dependencies

- Minor UI fixes
- Updated dependencies

- Updated dependencies

- Fix Formulajs syntax highlighting and tooltips

- BREAKING CHANGE: The way Formulajs is loaded into Numara has been changed due to conflict in function names, such as N (as reported in #69). Formulajs methods now need to be prefixed with xls..
Old: SUM(1,2,3) // 6
New: xls.SUM(1,2,3) // 6
- Improved autocomplete hints.
- Reload window after saving user defined functions and units. This immediately refreshes user functions and units rather than waiting for app restart.
- Updated dependencies.

Updated dependencies

- Bug fixes and improvements

- Added option to export a function plot as svg image.
- Improved printing format. Note: Syntax highlighting for prints is no longer available.
- UI improvements and bug fixes.
- Updated dependencies.

- Fix exponential notation formatting bug (#22)
- Add -webkit-user-select: text; for compatibility
- Update dependencies

- Update dependencies
- Minor changes

- Added rpm linux distro build (#21)
- Added wiki content generation script (wiki.js) for Math.js functions and units
- Update dependencies

- Fix a bug in context menu which threw an error
- Remove app icon from Windows app