[PR #7451] [CLOSED] [AI] Formula Feature Improvements: FORMATNUMBER, FORMATCURRENCY, and Tooltip Fixes #113992

New Issue

GiteaMirror · 2026-06-05T21:19:01-05:00

GiteaMirror commented

2026-06-05 21:19:01 -05:00

📋 Pull Request Information

Original PR: https://github.com/actualbudget/actual/pull/7451
Author: @lelemm
Created: 4/9/2026
Status: ❌ Closed

Base: master ← Head: cursor/formula-feedback-improvements-4223

📝 Commits (10+)

517ac78 [AI] Add FORMATNUMBER and FORMATCURRENCY functions to address TEXT() formatting limitations
4b56f31 [AI] Add support for line breaks in formula card results
efae23f [AI] Remove unusable formula functions that require cell ranges
00ee079 [AI] Add comprehensive integration tests for formula rules and formula cards
2bb86c4 Potential fix for pull request finding 'Unused variable, import, function or class'
837300c [AI] Make formatting functions respect app settings with locale-based fallbacks
65f5a11 Update VRT screenshots
0a26108 [AI] Fix type errors after rebase with master
fe0f903 [autofix.ci] apply automated fixes
d3dee95 Add release notes for PR #7451

📊 Changes

13 files changed (+2487 additions, -259 deletions)

View changed files

📝 packages/desktop-client/src/components/formula/codeMirror-excelLanguage.tsx (+21 -40)
📝 packages/desktop-client/src/components/formula/queryModeFunctions.ts (+63 -198)
📝 packages/desktop-client/src/components/formula/transactionModeFunctions.ts (+47 -5)
📝 packages/desktop-client/src/components/reports/FormulaResult.tsx (+15 -5)
📝 packages/desktop-client/src/hooks/useFormulaExecution.ts (+38 -11)
📝 packages/desktop-electron/e2e/__screenshots__/onboarding.test.ts/Onboarding-checks-the-page-visuals-1-linux.png (+0 -0)
➕ packages/loot-core/src/server/reports/formula-card-integration.test.ts (+739 -0)
📝 packages/loot-core/src/server/rules/action.ts (+8 -0)
📝 packages/loot-core/src/server/rules/customFunctions.ts (+173 -0)
➕ packages/loot-core/src/server/rules/customFunctionsPreferences.ts (+141 -0)
➕ packages/loot-core/src/server/rules/formula-action-integration.test.ts (+1159 -0)
📝 packages/loot-core/src/server/rules/formula-action.test.ts (+77 -0)
➕ upcoming-release-notes/7451.md (+6 -0)

📄 Description

Summary

This PR addresses several user feedback items from issue #5949 regarding the formula card and formula rules feature.

Changes Made

1. FORMATNUMBER() Function (Addresses TEXT() formatting limitations)

Feedback: Users reported that TEXT(QUERY("NetWorth"), "$#,##0.00") doesn't properly format numbers with thousands separators. The TEXT function in HyperFormula has limited format code support compared to Excel.

Solution: Added a new FORMATNUMBER() function that properly formats numbers with thousands separators and respects app settings.

Usage:

=FORMATNUMBER(1234567.89)  // Uses app number format settings
=FORMATNUMBER(1234567.89, 2)  // Specify decimal places
=FORMATNUMBER(1234567.89, 2, ".", ",")  // Override with custom separators

Settings Integration:

✅ Uses app's number format preference (comma-dot, dot-comma, space-comma, etc.)
✅ Falls back to locale-based defaults if no preference set
✅ All parameters optional - respects user's configuration

2. FORMATCURRENCY() Function (Proper currency formatting)

Feedback: Users need proper currency formatting for formula cards with symbol, thousands separators, and decimal places.

Solution: Added a new FORMATCURRENCY() function that formats numbers as currency and respects app currency settings.

Usage:

=FORMATCURRENCY(1234567.89)  // Uses app currency symbol and format
=FORMATCURRENCY(1234567.89, "€")  // Override with Euro symbol
=FORMATCURRENCY(-1234567.89)  // Handles negatives: "-$1,234,567.89"

Settings Integration:

✅ Uses app's default currency code preference
✅ Uses app's number format preference for separators
✅ Falls back to locale-based currency (en-GB→GBP, de/fr/es→EUR, ja→JPY, etc.)
✅ All parameters optional - respects user's configuration

Locale-based Defaults:

en-GB → GBP (£)
de/fr/es/it/nl → EUR (€)
ja → JPY (¥)
en-IN/hi → INR (₹)
en-CA → CAD ($)
en-AU → AUD ($)
Default → USD ($)

Number Format Patterns:

comma-dot: 1,000.00 (US/UK/Canada)
dot-comma: 1.000,00 (Europe)
space-comma: 1 000,00 (France)
apostrophe-dot: 1'000.00 (Switzerland)
comma-dot-in: 1,00,000.00 (India)

3. Line Break Support in Formula Cards ✨

Feedback: User @Juulz reported that line breaks don't work in formula cards, making multi-line displays ugly. Requested ability to use CHAR(10) or CHAR(13) in CONCATENATE.

Solution: Updated FormulaResult component to support multi-line text with proper rendering and font size calculation.

Usage:

=CONCATENATE("Total 1: ", value1, CHAR(10), "Total 2: ", value2, CHAR(10), "Total 3: ", value3)

Result:

Total 1: 100
Total 2: 200
Total 3: 300

Implementation:

Added whiteSpace: 'pre-wrap' to preserve line breaks
Added textAlign: 'center' to keep multi-line text centered
Updated font size calculation to account for multiple lines (divides height by line count)
Calculates based on longest line length for proper sizing

4. Formula Function Cleanup 🧹

Feedback: User requested review of all formula functions to remove ones that don't make sense in Actual's context.

Problem: Many Excel functions require cell ranges (like A1:A10) which don't exist in Actual. Actual uses named expressions like QUERY("myQuery") and transaction field variables like amount or date.

Solution: Removed 27 unusable functions from autocomplete suggestions:

Removed Functions:

Range-based counting: AVERAGEA, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS
- Use QUERY_COUNT() instead
Range-based aggregation: MAXA, MINA, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ
- Use QUERY() with filters instead
Statistical functions: MEDIAN, MODE, STDEV, STDEVP, VAR, VARP, PERCENTILE, QUARTILE, RANK
- These require arrays of data which don't exist in our context
Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH, LOOKUP
- These require table arrays and cell references
Reference checking: ISREF
- Checks for cell references which don't exist

Kept Useful Functions:

✅ Math functions that work with individual values: SUM, AVERAGE, MAX, MIN, ROUND, etc.
✅ Text functions: CONCATENATE, UPPER, LEFT, RIGHT, etc.
✅ Date functions: TODAY, YEAR, MONTH, EOMONTH, etc.
✅ Logical functions: IF, AND, OR, IFERROR, etc.
✅ Query-specific functions: QUERY, QUERY_COUNT, BUDGET_QUERY, etc.
✅ CHOOSE (works with index and individual values)

Impact: Autocomplete suggestions are now more relevant and less confusing. Users won't see functions they can't actually use.

Feedback: Tooltips used backticks around formula examples while actual usage used double quotes, causing confusion.

Solution: Removed backticks from all formula examples in tooltips for consistency. Examples now show formulas as plain text without wrapping backticks.

Before: `=UPPER(notes)`
After: =UPPER(notes)

6. Updated Documentation

Added function definitions to queryModeFunctions.ts (for formula cards)
Added function definitions to transactionModeFunctions.ts (for formula rules)
Updated syntax highlighting to recognize new functions and removed obsolete ones
Updated descriptions to clarify that formatting functions use app settings by default

7. Comprehensive Integration Tests 🧪

Added 50 integration tests that validate formulas with real database operations:

Formula Rule Integration Tests (36 tests)

Tests validate formula execution with actual transaction data:

✅ Basic operations: FORMATCURRENCY, nested IFs, date formatting
✅ Text manipulation: CONCATENATE, UPPER, LEFT, RIGHT, TRIM, PROPER
✅ Math functions: ROUND, ABS, MAX, MIN, CEILING, SQRT, SUM, PRODUCT
✅ Date functions: YEAR, MONTH, DAY, DAYS, EOMONTH, WEEKDAY
✅ Logical functions: AND, OR, NOT, IFERROR, SWITCH
✅ New formatting functions with various options
✅ Multi-line output with CHAR(10)
✅ Information functions: ISNUMBER, ISTEXT, ISEVEN, ISODD, ISBLANK
✅ Error handling and type validation
✅ Complex nested formulas (3-4 levels deep)

Formula Card Integration Tests (14 tests)

Tests validate formulas with real query results from database:

✅ Single and multiple query integration
✅ Query results with formatting functions
✅ Percentage calculations across queries
✅ Date-based query filtering
✅ Complex nested calculations with multiple queries
✅ Multi-line output with query results
✅ Error handling with empty queries
✅ Running totals across accounts
✅ MAX/MIN operations with query results

Test Quality:

Real database operations (not mocked)
Complex nested formulas demonstrating actual use cases
Every formula function type covered in at least one test
Edge cases tested (empty results, division by zero, type mismatches)
All 662 tests passing ✅

Technical Implementation

Settings Architecture

Problem: HyperFormula custom functions are synchronous, but preferences are stored in async database.

Solution:

Created loadUserPreferencesForFormulas() async function that loads preferences once
Caches preferences globally for synchronous access by custom functions
Called on module initialization (avoids repeated DB queries)
No reactors needed - clean and efficient

Settings Priority:

Explicit function parameters (if provided)
User's app settings (from preferences DB)
Locale-based defaults (inferred from language setting)

This approach avoids unnecessary reactors while properly respecting user preferences!

Feedbacks Not Addressed (with reasoning)

BALANCEONDAY() Function

Feedback: Request for a function to get account balance on a specific date for credit card statement calculations.

Reason not implemented: This would require database access to query transaction history, which is not available in the formula execution context (both for formula cards and formula rules). The formula execution is designed to be stateless and work with the data provided in the context. Implementing this would require architectural changes to allow async database queries during formula execution.

Alternative approach: Users can currently achieve this by creating a query with appropriate date filters and using QUERY() to get the sum of transactions up to that date.

LASTSYNCEDBALANCE Variable

Feedback: Request for access to lastSyncedBalance in custom pills/formulas.

Reason not implemented: Similar to BALANCEONDAY, this would require access to account metadata that isn't available in the current formula execution context. The balance_current field is stored in the accounts table and would need to be passed as a variable to the formula execution context.

Alternative approach: This could be added in a future enhancement by extending the variable context passed to formula execution to include account metadata when the formula is executed in an account-specific context.

Feedback: Request for dynamic time selection like "last month" in the hamburger menu for time selections.

Reason not in this PR: This is a UI/UX enhancement for the query time frame selector, not related to formula functions. This would be better addressed in a separate PR focused on the query configuration UI.

Testing

✅ All existing tests pass (604 tests)
✅ New unit tests for FORMATNUMBER and FORMATCURRENCY (8 tests)
✅ New integration tests for formula rules (36 tests)
✅ New integration tests for formula cards (14 tests)
✅ Total: 662 tests passing
✅ Type checking passes
✅ Linting passes

Code Comments

Throughout the code, I've added comments explaining which feedback triggered each change:

// Feedback: Users reported that TEXT() function doesn't properly format numbers with
// thousands separators (e.g., TEXT(value, "$#,##0.00") doesn't work as expected).
// This custom function provides proper number formatting with thousands separators.
// User feedback: Should respect app's number format settings, with locale-based fallbacks

This makes it easy to trace each change back to the original user feedback.

Addresses feedback items from #5949

Bundle Stats

Bundle	Files count	Total bundle size	% Changed
desktop-client	34	13.93 MB → 14.35 MB (+423.94 kB)	+2.97%
loot-core	1	5.27 MB → 5.28 MB (+6.06 kB)	+0.11%
api	2	3.9 MB → 3.9 MB (+5.92 kB)	+0.15%
cli	1	7.97 MB	0%
crdt	1	43.41 kB	0%

View detailed bundle stats

desktop-client

Total

Files count	Total bundle size	% Changed
34	13.93 MB → 14.35 MB (+423.94 kB)	+2.97%

Changeset (largest 100 files by percent change)

File	Δ	Size
`node_modules/@jlongster/sql.js/dist/sql-wasm.js`	🆕 +89.77 kB	0 B → 89.77 kB
`node_modules/google-protobuf/google-protobuf.js`	🆕 +84.08 kB	0 B → 84.08 kB
`home/runner/work/actual/actual/packages/crdt/dist/index.js`	🆕 +45.04 kB	0 B → 45.04 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/aql/compiler.ts`	🆕 +24.02 kB	0 B → 24.02 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/db/index.ts`	🆕 +19.99 kB	0 B → 19.99 kB
`node_modules/adm-zip/adm-zip.js`	🆕 +17.31 kB	0 B → 17.31 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/sync/index.ts`	🆕 +13.11 kB	0 B → 13.11 kB
`node_modules/adm-zip/zipEntry.js`	🆕 +10.41 kB	0 B → 10.41 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/aql/schema/index.ts`	🆕 +9.36 kB	0 B → 9.36 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/budget/envelope.ts`	🆕 +8.9 kB	0 B → 8.9 kB
`node_modules/adm-zip/zipFile.js`	🆕 +8.81 kB	0 B → 8.81 kB
`node_modules/adm-zip/util/utils.js`	🆕 +7.68 kB	0 B → 7.68 kB
`node_modules/adm-zip/headers/entryHeader.js`	🆕 +7.53 kB	0 B → 7.53 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/budget/tracking.ts`	🆕 +6.72 kB	0 B → 6.72 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/budget/base.ts`	🆕 +6.48 kB	0 B → 6.48 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/aql/schema/executors.ts`	🆕 +6.14 kB	0 B → 6.14 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/db/sort.ts`	🆕 +4.02 kB	0 B → 4.02 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/aql/schema-helpers.ts`	🆕 +3.91 kB	0 B → 3.91 kB
`node_modules/murmurhash/murmurhash.js`	🆕 +3.29 kB	0 B → 3.29 kB
`node_modules/adm-zip/methods/zipcrypto.js`	🆕 +3.14 kB	0 B → 3.14 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/sync/encoder.ts`	🆕 +2.81 kB	0 B → 2.81 kB
`node_modules/adm-zip/headers/mainHeader.js`	🆕 +2.75 kB	0 B → 2.75 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/models.ts`	🆕 +2.69 kB	0 B → 2.69 kB
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/index.ts`	🆕 +2.69 kB	0 B → 2.69 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctionsPreferences.ts`	🆕 +2.68 kB	0 B → 2.68 kB
`node_modules/adm-zip/util/errors.js`	🆕 +2.47 kB	0 B → 2.47 kB
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/path-join.ts`	🆕 +2.23 kB	0 B → 2.23 kB
`node_modules/adm-zip/util/constants.js`	🆕 +1.91 kB	0 B → 1.91 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/aql/exec.ts`	🆕 +1.6 kB	0 B → 1.6 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/sheet.ts`	🆕 +1.56 kB	0 B → 1.56 kB
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/index.ts`	🆕 +1.54 kB	0 B → 1.54 kB
`node_modules/adm-zip/util/fattr.js`	🆕 +1.49 kB	0 B → 1.49 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/app.ts`	🆕 +1.22 kB	0 B → 1.22 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/encryption/encryption-internals.ts`	🆕 +1.2 kB	0 B → 1.2 kB
`node_modules/adm-zip/methods/inflater.js`	🆕 +1019 B	0 B → 1019 B
`home/runner/work/actual/actual/packages/loot-core/src/server/post.ts`	🆕 +999 B	0 B → 999 B
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/unicodeLike.ts`	🆕 +995 B	0 B → 995 B
`node_modules/adm-zip/methods/deflater.js`	🆕 +906 B	0 B → 906 B
`home/runner/work/actual/actual/packages/loot-core/src/server/undo.ts`	🆕 +815 B	0 B → 815 B
`home/runner/work/actual/actual/packages/loot-core/src/server/prefs.ts`	🆕 +694 B	0 B → 694 B
`home/runner/work/actual/actual/packages/loot-core/src/server/server-config.ts`	🆕 +676 B	0 B → 676 B
`home/runner/work/actual/actual/packages/loot-core/src/server/mutators.ts`	🆕 +524 B	0 B → 524 B
`node_modules/mitt/dist/mitt.mjs`	🆕 +513 B	0 B → 513 B
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/connection/index.ts`	🆕 +512 B	0 B → 512 B
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/shared.ts`	🆕 +498 B	0 B → 498 B
`home/runner/work/actual/actual/packages/loot-core/src/server/budget/util.ts`	🆕 +403 B	0 B → 403 B
`home/runner/work/actual/actual/packages/loot-core/src/server/encryption/index.ts`	🆕 +393 B	0 B → 393 B
`home/runner/work/actual/actual/packages/loot-core/src/server/sync/repair.ts`	🆕 +388 B	0 B → 388 B
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/fetch/index.ts`	🆕 +373 B	0 B → 373 B
`node_modules/adm-zip/util/index.js`	🆕 +358 B	0 B → 358 B
`node_modules/adm-zip/util/decoder.js`	🆕 +273 B	0 B → 273 B
`home/runner/work/actual/actual/packages/loot-core/src/server/spreadsheet/globals.ts`	🆕 +262 B	0 B → 262 B
`node_modules/adm-zip/methods/index.js`	🆕 +262 B	0 B → 262 B
`home/runner/work/actual/actual/packages/loot-core/src/server/aql/index.ts`	🆕 +258 B	0 B → 258 B
`node_modules/adm-zip/headers/index.js`	🆕 +230 B	0 B → 230 B
`home/runner/work/actual/actual/packages/loot-core/src/server/db/util.ts`	🆕 +195 B	0 B → 195 B
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/normalise.ts`	🆕 +168 B	0 B → 168 B
`__vite-browser-external`	🆕 +166 B	0 B → 166 B
`home/runner/work/actual/actual/packages/loot-core/src/server/main-app.ts`	🆕 +149 B	0 B → 149 B
`home/runner/work/actual/actual/packages/loot-core/src/server/spreadsheet/util.ts`	🆕 +133 B	0 B → 133 B
`node_modules/absurd-sql/dist/indexeddb-backend.js`	🆕 +133 B	0 B → 133 B
`home/runner/work/actual/actual/packages/loot-core/src/server/cloud-storage.ts`	🆕 +129 B	0 B → 129 B
`home/runner/work/actual/actual/packages/loot-core/src/shared/async.ts`	📈 +708 B (+270.23%)	262 B → 970 B
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.ts`	📈 +3.15 kB (+230.34%)	1.37 kB → 4.52 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/errors.ts`	📈 +412 B (+214.58%)	192 B → 604 B
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/asyncStorage/index.ts`	📈 +706 B (+155.16%)	455 B → 1.13 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/action.ts`	📈 +89 B (+43.84%)	203 B → 292 B
`home/runner/work/actual/actual/packages/loot-core/src/platform/server/indexeddb/index.ts`	📈 +348 B (+25.87%)	1.31 kB → 1.65 kB
`home/runner/work/actual/actual/packages/loot-core/src/shared/normalisation.ts`	📈 +67 B (+20.36%)	329 B → 396 B
`src/components/formula/transactionModeFunctions.ts`	📈 +1.05 kB (+7.49%)	14.04 kB → 15.09 kB
`src/components/reports/FormulaResult.tsx`	📈 +231 B (+5.99%)	3.76 kB → 3.99 kB
`home/runner/work/actual/actual/packages/loot-core/src/shared/util.ts`	📈 +417 B (+4.62%)	8.82 kB → 9.23 kB
`src/queries/aqlQuery.ts`	📈 +4 B (+3.23%)	124 B → 128 B
`src/hooks/useFormulaExecution.ts`	📈 +438 B (+2.56%)	16.71 kB → 17.14 kB
`src/undo/index.ts`	📈 +4 B (+0.73%)	551 B → 555 B
`src/tags/queries.ts`	📈 +2 B (+0.64%)	311 B → 313 B
`node_modules/chevrotain/lib_esm/src/parse/grammar/first.js`	📈 +8 B (+0.60%)	1.29 kB → 1.3 kB
`src/hooks/useMetadataPref.ts`	📈 +2 B (+0.57%)	352 B → 354 B
`src/budget/mutations.ts`	📈 +72 B (+0.56%)	12.5 kB → 12.57 kB
`src/reports/queries.ts`	📈 +6 B (+0.54%)	1.09 kB → 1.09 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/handlebars-helpers.ts`	📈 +12 B (+0.36%)	3.25 kB → 3.26 kB
`src/hooks/useTransactionBatchActions.ts`	📈 +28 B (+0.32%)	8.66 kB → 8.69 kB
`src/transactions/queries.ts`	📈 +2 B (+0.31%)	647 B → 649 B
`node_modules/handlebars/dist/cjs/handlebars/decorators/inline.js`	📈 +2 B (+0.25%)	789 B → 791 B
`node_modules/moment/dist/moment.js`	📈 +256 B (+0.22%)	111.68 kB → 111.93 kB
`src/components/ServerContext.tsx`	📈 +12 B (+0.21%)	5.56 kB → 5.58 kB
`src/budget/queries.ts`	📈 +2 B (+0.20%)	1020 B → 1022 B
`node_modules/handlebars/dist/cjs/handlebars/helpers/block-helper-missing.js`	📈 +2 B (+0.19%)	1.02 kB → 1.02 kB
`src/hooks/useSpreadsheet.tsx`	📈 +6 B (+0.19%)	3.17 kB → 3.17 kB
`node_modules/handlebars/dist/cjs/handlebars/logger.js`	📈 +2 B (+0.18%)	1.07 kB → 1.07 kB
`home/runner/work/actual/actual/packages/loot-core/src/shared/schedules.ts`	📈 +20 B (+0.17%)	11.33 kB → 11.35 kB
`node_modules/handlebars/dist/cjs/handlebars/helpers/with.js`	📈 +2 B (+0.17%)	1.14 kB → 1.14 kB
`node_modules/handlebars/dist/cjs/handlebars/helpers/if.js`	📈 +2 B (+0.17%)	1.18 kB → 1.18 kB
`node_modules/handlebars/dist/cjs/handlebars.runtime.js`	📈 +2 B (+0.13%)	1.56 kB → 1.56 kB
`src/components/transactions/TransactionList.tsx`	📈 +18 B (+0.10%)	17.29 kB → 17.3 kB
`node_modules/chevrotain/lib_esm/src/parse/grammar/follow.js`	📈 +2 B (+0.10%)	1.95 kB → 1.95 kB
`node_modules/source-map/lib/mapping-list.js`	📈 +2 B (+0.09%)	2.17 kB → 2.17 kB
`node_modules/handlebars/dist/cjs/handlebars/helpers/each.js`	📈 +2 B (+0.09%)	2.22 kB → 2.22 kB
`node_modules/handlebars/dist/cjs/handlebars/utils.js`	📈 +2 B (+0.08%)	2.33 kB → 2.33 kB
`src/components/mobile/MobileNavTabs.tsx`	📈 +8 B (+0.08%)	10.16 kB → 10.17 kB

View detailed bundle breakdown

Added
No assets were added

Removed
No assets were removed

Bigger

Asset	File Size	% Changed
static/js/Value.js	4.94 MB → 5.36 MB (+428.63 kB)	+8.47%
static/js/ReportRouter.js	1.22 MB → 1.22 MB (+669 B)	+0.05%
static/js/extends.js	520.14 kB → 520.54 kB (+417 B)	+0.08%

Smaller

Asset	File Size	% Changed
static/js/FormulaEditor.js	962.55 kB → 958.82 kB (-3.74 kB)	-0.39%
static/js/index.js	1.93 MB → 1.93 MB (-2.01 kB)	-0.10%

Unchanged

Asset	File Size	% Changed
static/js/BackgroundImage.js	121.09 kB	0%
static/js/ScheduleEditForm.js	145.76 kB	0%
static/js/TransactionEdit.js	190.4 kB	0%
static/js/TransactionList.js	85.81 kB	0%
static/js/alerts.js	800.08 kB	0%
static/js/bankSyncUtils.js	54.1 kB	0%
static/js/ca.js	187.91 kB	0%
static/js/client.js	451.37 kB	0%
static/js/da.js	101.38 kB	0%
static/js/de.js	170.55 kB	0%
static/js/en-GB.js	8.2 kB	0%
static/js/en.js	185.11 kB	0%
static/js/es.js	179 kB	0%
static/js/fr.js	178.9 kB	0%
static/js/indexeddb-main-thread-worker-e59fee74.js	13.46 kB	0%
static/js/it.js	165.3 kB	0%
static/js/narrow.js	364.41 kB	0%
static/js/nb-NO.js	148.31 kB	0%
static/js/nl.js	106.47 kB	0%
static/js/pl.js	86.52 kB	0%
static/js/pt-BR.js	189.58 kB	0%
static/js/resize-observer.js	18.06 kB	0%
static/js/th.js	174.76 kB	0%
static/js/theme.js	31.67 kB	0%
static/js/uk.js	207.75 kB	0%
static/js/useFormatList.js	4.96 kB	0%
static/js/wide.js	453 B	0%
static/js/workbox-window.prod.es5.js	7.33 kB	0%
static/js/zh-Hans.js	117.91 kB	0%

loot-core

Total

Files count	Total bundle size	% Changed
1	5.27 MB → 5.28 MB (+6.06 kB)	+0.11%

Changeset

File	Δ	Size
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctionsPreferences.ts`	🆕 +2.73 kB	0 B → 2.73 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.ts`	📈 +3.24 kB (+229.90%)	1.41 kB → 4.66 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/action.ts`	📈 +92 B (+1.12%)	8 kB → 8.09 kB

View detailed bundle breakdown

Added

Asset	File Size	% Changed
kcab.worker.CFkWwiSk.js	0 B → 5.28 MB (+5.28 MB)	-

Removed

Asset	File Size	% Changed
kcab.worker.CfcE9hoo.js	5.27 MB → 0 B (-5.27 MB)	-100%

Bigger
No assets were bigger

Smaller
No assets were smaller

Unchanged
No assets were unchanged

api

Total

Files count	Total bundle size	% Changed
2	3.9 MB → 3.9 MB (+5.92 kB)	+0.15%

Changeset

File	Δ	Size
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctionsPreferences.ts`	🆕 +2.68 kB	0 B → 2.68 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.ts`	📈 +3.15 kB (+230.01%)	1.37 kB → 4.52 kB
`home/runner/work/actual/actual/packages/loot-core/src/server/rules/action.ts`	📈 +89 B (+1.15%)	7.54 kB → 7.62 kB

View detailed bundle breakdown

Added
No assets were added

Removed
No assets were removed

Bigger

Asset	File Size	% Changed
index.js	3.9 MB → 3.9 MB (+5.92 kB)	+0.15%

Smaller
No assets were smaller

Unchanged

Asset	File Size	% Changed
models.js	0 B	0%

cli

Total

Files count	Total bundle size	% Changed
1	7.97 MB	0%

View detailed bundle breakdown

Added
No assets were added

Removed
No assets were removed

Bigger
No assets were bigger

Smaller
No assets were smaller

Unchanged

Asset	File Size	% Changed
cli.js	7.97 MB	0%

crdt

Total

Files count	Total bundle size	% Changed
1	43.41 kB	0%

View detailed bundle breakdown

Added
No assets were added

Removed
No assets were removed

Bigger
No assets were bigger

Smaller
No assets were smaller

Unchanged

Asset	File Size	% Changed
index.js	43.41 kB	0%

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/actualbudget/actual/pull/7451 **Author:** [@lelemm](https://github.com/lelemm) **Created:** 4/9/2026 **Status:** ❌ Closed **Base:** `master` ← **Head:** `cursor/formula-feedback-improvements-4223` --- ### 📝 Commits (10+) - [`517ac78`](https://github.com/actualbudget/actual/commit/517ac78f841c656f58ba981072e62260852fe23f) [AI] Add FORMATNUMBER and FORMATCURRENCY functions to address TEXT() formatting limitations - [`4b56f31`](https://github.com/actualbudget/actual/commit/4b56f315906c5f5f0304d6869878964fad67b6ad) [AI] Add support for line breaks in formula card results - [`efae23f`](https://github.com/actualbudget/actual/commit/efae23fd707f71d1295a51c4673eeb658087cd7c) [AI] Remove unusable formula functions that require cell ranges - [`00ee079`](https://github.com/actualbudget/actual/commit/00ee0796967733bee3922d2079ffdef616c1fdf0) [AI] Add comprehensive integration tests for formula rules and formula cards - [`2bb86c4`](https://github.com/actualbudget/actual/commit/2bb86c4ffbd1bd82b7f941a7f8f1e96959e81374) Potential fix for pull request finding 'Unused variable, import, function or class' - [`837300c`](https://github.com/actualbudget/actual/commit/837300c4be446c43daceec229cfae6cd494c44c7) [AI] Make formatting functions respect app settings with locale-based fallbacks - [`65f5a11`](https://github.com/actualbudget/actual/commit/65f5a11ccaaa86e04d3647f01e8c6039ef8c1241) Update VRT screenshots - [`0a26108`](https://github.com/actualbudget/actual/commit/0a26108f47bd5f49374c898840064bce44eefa0b) [AI] Fix type errors after rebase with master - [`fe0f903`](https://github.com/actualbudget/actual/commit/fe0f903e753869aa9a50264e5a290d986096e076) [autofix.ci] apply automated fixes - [`d3dee95`](https://github.com/actualbudget/actual/commit/d3dee95b6b04dfa58c01aa68e575eda74c27e5ba) Add release notes for PR #7451 ### 📊 Changes **13 files changed** (+2487 additions, -259 deletions) <details> <summary>View changed files</summary> 📝 `packages/desktop-client/src/components/formula/codeMirror-excelLanguage.tsx` (+21 -40) 📝 `packages/desktop-client/src/components/formula/queryModeFunctions.ts` (+63 -198) 📝 `packages/desktop-client/src/components/formula/transactionModeFunctions.ts` (+47 -5) 📝 `packages/desktop-client/src/components/reports/FormulaResult.tsx` (+15 -5) 📝 `packages/desktop-client/src/hooks/useFormulaExecution.ts` (+38 -11) 📝 `packages/desktop-electron/e2e/__screenshots__/onboarding.test.ts/Onboarding-checks-the-page-visuals-1-linux.png` (+0 -0) ➕ `packages/loot-core/src/server/reports/formula-card-integration.test.ts` (+739 -0) 📝 `packages/loot-core/src/server/rules/action.ts` (+8 -0) 📝 `packages/loot-core/src/server/rules/customFunctions.ts` (+173 -0) ➕ `packages/loot-core/src/server/rules/customFunctionsPreferences.ts` (+141 -0) ➕ `packages/loot-core/src/server/rules/formula-action-integration.test.ts` (+1159 -0) 📝 `packages/loot-core/src/server/rules/formula-action.test.ts` (+77 -0) ➕ `upcoming-release-notes/7451.md` (+6 -0) </details> ### 📄 Description  ## Summary This PR addresses several user feedback items from issue #5949 regarding the formula card and formula rules feature. ## Changes Made ### 1. **FORMATNUMBER() Function** (Addresses TEXT() formatting limitations) **Feedback:** Users reported that `TEXT(QUERY("NetWorth"), "$#,##0.00")` doesn't properly format numbers with thousands separators. The TEXT function in HyperFormula has limited format code support compared to Excel. **Solution:** Added a new `FORMATNUMBER()` function that properly formats numbers with thousands separators and **respects app settings**. **Usage:** ```excel =FORMATNUMBER(1234567.89) // Uses app number format settings =FORMATNUMBER(1234567.89, 2) // Specify decimal places =FORMATNUMBER(1234567.89, 2, ".", ",") // Override with custom separators ``` **Settings Integration:** - ✅ Uses app's number format preference (comma-dot, dot-comma, space-comma, etc.) - ✅ Falls back to locale-based defaults if no preference set - ✅ All parameters optional - respects user's configuration ### 2. **FORMATCURRENCY() Function** (Proper currency formatting) **Feedback:** Users need proper currency formatting for formula cards with symbol, thousands separators, and decimal places. **Solution:** Added a new `FORMATCURRENCY()` function that formats numbers as currency and **respects app currency settings**. **Usage:** ```excel =FORMATCURRENCY(1234567.89) // Uses app currency symbol and format =FORMATCURRENCY(1234567.89, "€") // Override with Euro symbol =FORMATCURRENCY(-1234567.89) // Handles negatives: "-$1,234,567.89" ``` **Settings Integration:** - ✅ Uses app's default currency code preference - ✅ Uses app's number format preference for separators - ✅ Falls back to locale-based currency (en-GB→GBP, de/fr/es→EUR, ja→JPY, etc.) - ✅ All parameters optional - respects user's configuration **Locale-based Defaults:** - `en-GB` → GBP (£) - `de/fr/es/it/nl` → EUR (€) - `ja` → JPY (¥) - `en-IN/hi` → INR (₹) - `en-CA` → CAD ($) - `en-AU` → AUD ($) - Default → USD ($) **Number Format Patterns:** - `comma-dot`: 1,000.00 (US/UK/Canada) - `dot-comma`: 1.000,00 (Europe) - `space-comma`: 1 000,00 (France) - `apostrophe-dot`: 1'000.00 (Switzerland) - `comma-dot-in`: 1,00,000.00 (India) ### 3. **Line Break Support in Formula Cards** ✨ **Feedback:** User @Juulz reported that line breaks don't work in formula cards, making multi-line displays ugly. Requested ability to use CHAR(10) or CHAR(13) in CONCATENATE. **Solution:** Updated FormulaResult component to support multi-line text with proper rendering and font size calculation. **Usage:** ```excel =CONCATENATE("Total 1: ", value1, CHAR(10), "Total 2: ", value2, CHAR(10), "Total 3: ", value3) ``` **Result:** ``` Total 1: 100 Total 2: 200 Total 3: 300 ``` **Implementation:** - Added `whiteSpace: 'pre-wrap'` to preserve line breaks - Added `textAlign: 'center'` to keep multi-line text centered - Updated font size calculation to account for multiple lines (divides height by line count) - Calculates based on longest line length for proper sizing ### 4. **Formula Function Cleanup** 🧹 **Feedback:** User requested review of all formula functions to remove ones that don't make sense in Actual's context. **Problem:** Many Excel functions require cell ranges (like `A1:A10`) which don't exist in Actual. Actual uses named expressions like `QUERY("myQuery")` and transaction field variables like `amount` or `date`. **Solution:** Removed 27 unusable functions from autocomplete suggestions: **Removed Functions:** - **Range-based counting:** `AVERAGEA`, `COUNT`, `COUNTA`, `COUNTBLANK`, `COUNTIF`, `COUNTIFS` - *Use `QUERY_COUNT()` instead* - **Range-based aggregation:** `MAXA`, `MINA`, `SUMIF`, `SUMIFS`, `SUMPRODUCT`, `SUMSQ` - *Use `QUERY()` with filters instead* - **Statistical functions:** `MEDIAN`, `MODE`, `STDEV`, `STDEVP`, `VAR`, `VARP`, `PERCENTILE`, `QUARTILE`, `RANK` - *These require arrays of data which don't exist in our context* - **Lookup functions:** `VLOOKUP`, `HLOOKUP`, `INDEX`, `MATCH`, `LOOKUP` - *These require table arrays and cell references* - **Reference checking:** `ISREF` - *Checks for cell references which don't exist* **Kept Useful Functions:** - ✅ Math functions that work with individual values: `SUM`, `AVERAGE`, `MAX`, `MIN`, `ROUND`, etc. - ✅ Text functions: `CONCATENATE`, `UPPER`, `LEFT`, `RIGHT`, etc. - ✅ Date functions: `TODAY`, `YEAR`, `MONTH`, `EOMONTH`, etc. - ✅ Logical functions: `IF`, `AND`, `OR`, `IFERROR`, etc. - ✅ Query-specific functions: `QUERY`, `QUERY_COUNT`, `BUDGET_QUERY`, etc. - ✅ `CHOOSE` (works with index and individual values) **Impact:** Autocomplete suggestions are now more relevant and less confusing. Users won't see functions they can't actually use. ### 5. **Tooltip Quote Consistency Fix** **Feedback:** Tooltips used backticks around formula examples while actual usage used double quotes, causing confusion. **Solution:** Removed backticks from all formula examples in tooltips for consistency. Examples now show formulas as plain text without wrapping backticks. **Before:** `` `=UPPER(notes)` `` **After:** `=UPPER(notes)` ### 6. **Updated Documentation** - Added function definitions to `queryModeFunctions.ts` (for formula cards) - Added function definitions to `transactionModeFunctions.ts` (for formula rules) - Updated syntax highlighting to recognize new functions and removed obsolete ones - Updated descriptions to clarify that formatting functions use app settings by default ### 7. **Comprehensive Integration Tests** 🧪 Added **50 integration tests** that validate formulas with real database operations: #### Formula Rule Integration Tests (36 tests) Tests validate formula execution with actual transaction data: - ✅ Basic operations: FORMATCURRENCY, nested IFs, date formatting - ✅ Text manipulation: CONCATENATE, UPPER, LEFT, RIGHT, TRIM, PROPER - ✅ Math functions: ROUND, ABS, MAX, MIN, CEILING, SQRT, SUM, PRODUCT - ✅ Date functions: YEAR, MONTH, DAY, DAYS, EOMONTH, WEEKDAY - ✅ Logical functions: AND, OR, NOT, IFERROR, SWITCH - ✅ New formatting functions with various options - ✅ Multi-line output with CHAR(10) - ✅ Information functions: ISNUMBER, ISTEXT, ISEVEN, ISODD, ISBLANK - ✅ Error handling and type validation - ✅ Complex nested formulas (3-4 levels deep) #### Formula Card Integration Tests (14 tests) Tests validate formulas with real query results from database: - ✅ Single and multiple query integration - ✅ Query results with formatting functions - ✅ Percentage calculations across queries - ✅ Date-based query filtering - ✅ Complex nested calculations with multiple queries - ✅ Multi-line output with query results - ✅ Error handling with empty queries - ✅ Running totals across accounts - ✅ MAX/MIN operations with query results **Test Quality:** - Real database operations (not mocked) - Complex nested formulas demonstrating actual use cases - Every formula function type covered in at least one test - Edge cases tested (empty results, division by zero, type mismatches) - **All 662 tests passing** ✅ ## Technical Implementation ### Settings Architecture **Problem:** HyperFormula custom functions are synchronous, but preferences are stored in async database. **Solution:** - Created `loadUserPreferencesForFormulas()` async function that loads preferences once - Caches preferences globally for synchronous access by custom functions - Called on module initialization (avoids repeated DB queries) - No reactors needed - clean and efficient **Settings Priority:** 1. Explicit function parameters (if provided) 2. User's app settings (from preferences DB) 3. Locale-based defaults (inferred from language setting) This approach avoids unnecessary reactors while properly respecting user preferences! ## Feedbacks Not Addressed (with reasoning) ### BALANCEONDAY() Function **Feedback:** Request for a function to get account balance on a specific date for credit card statement calculations. **Reason not implemented:** This would require database access to query transaction history, which is not available in the formula execution context (both for formula cards and formula rules). The formula execution is designed to be stateless and work with the data provided in the context. Implementing this would require architectural changes to allow async database queries during formula execution. **Alternative approach:** Users can currently achieve this by creating a query with appropriate date filters and using `QUERY()` to get the sum of transactions up to that date. ### LASTSYNCEDBALANCE Variable **Feedback:** Request for access to `lastSyncedBalance` in custom pills/formulas. **Reason not implemented:** Similar to BALANCEONDAY, this would require access to account metadata that isn't available in the current formula execution context. The `balance_current` field is stored in the accounts table and would need to be passed as a variable to the formula execution context. **Alternative approach:** This could be added in a future enhancement by extending the variable context passed to formula execution to include account metadata when the formula is executed in an account-specific context. ### Dynamic "Last Month" Dropdown **Feedback:** Request for dynamic time selection like "last month" in the hamburger menu for time selections. **Reason not in this PR:** This is a UI/UX enhancement for the query time frame selector, not related to formula functions. This would be better addressed in a separate PR focused on the query configuration UI. ## Testing - ✅ All existing tests pass (604 tests) - ✅ New unit tests for FORMATNUMBER and FORMATCURRENCY (8 tests) - ✅ **New integration tests for formula rules (36 tests)** - ✅ **New integration tests for formula cards (14 tests)** - ✅ **Total: 662 tests passing** - ✅ Type checking passes - ✅ Linting passes ## Code Comments Throughout the code, I've added comments explaining which feedback triggered each change: ```typescript // Feedback: Users reported that TEXT() function doesn't properly format numbers with // thousands separators (e.g., TEXT(value, "$#,##0.00") doesn't work as expected). // This custom function provides proper number formatting with thousands separators. // User feedback: Should respect app's number format settings, with locale-based fallbacks ``` This makes it easy to trace each change back to the original user feedback. ## Related Issue Addresses feedback items from #5949  <div><a href="https://cursor.com/agents/bc-bdd61858-e301-4195-b11e-7ba65d744223"><picture><source media="(prefers-color-scheme: dark)" srcset="https://cursor.com/assets/images/open-in-web-dark.png"><source media="(prefers-color-scheme: light)" srcset="https://cursor.com/assets/images/open-in-web-light.png"><img alt="Open in Web" width="114" height="28" src="https://cursor.com/assets/images/open-in-web-dark.png"></picture></a> <a href="https://cursor.com/background-agent?bcId=bc-bdd61858-e301-4195-b11e-7ba65d744223"><picture><source media="(prefers-color-scheme: dark)" srcset="https://cursor.com/assets/images/open-in-cursor-dark.png"><source media="(prefers-color-scheme: light)" srcset="https://cursor.com/assets/images/open-in-cursor-light.png"><img alt="Open in Cursor" width="131" height="28" src="https://cursor.com/assets/images/open-in-cursor-dark.png"></picture></a> </div>  <hr />  ### Bundle Stats Bundle | Files count | Total bundle size | % Changed ------ | ----------- | ----------------- | --------- desktop-client | 34 | 13.93 MB → 14.35 MB (+423.94 kB) | +2.97% loot-core | 1 | 5.27 MB → 5.28 MB (+6.06 kB) | +0.11% api | 2 | 3.9 MB → 3.9 MB (+5.92 kB) | +0.15% cli | 1 | 7.97 MB | 0% crdt | 1 | 43.41 kB | 0% <details> <summary>View detailed bundle stats</summary> #### desktop-client **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 34 | 13.93 MB → 14.35 MB (+423.94 kB) | +2.97% <details> <summary>Changeset (largest 100 files by percent change)</summary> File | Δ | Size ---- | - | ---- `node_modules/@jlongster/sql.js/dist/sql-wasm.js` | 🆕 +89.77 kB | 0 B → 89.77 kB `node_modules/google-protobuf/google-protobuf.js` | 🆕 +84.08 kB | 0 B → 84.08 kB `home/runner/work/actual/actual/packages/crdt/dist/index.js` | 🆕 +45.04 kB | 0 B → 45.04 kB `home/runner/work/actual/actual/packages/loot-core/src/server/aql/compiler.ts` | 🆕 +24.02 kB | 0 B → 24.02 kB `home/runner/work/actual/actual/packages/loot-core/src/server/db/index.ts` | 🆕 +19.99 kB | 0 B → 19.99 kB `node_modules/adm-zip/adm-zip.js` | 🆕 +17.31 kB | 0 B → 17.31 kB `home/runner/work/actual/actual/packages/loot-core/src/server/sync/index.ts` | 🆕 +13.11 kB | 0 B → 13.11 kB `node_modules/adm-zip/zipEntry.js` | 🆕 +10.41 kB | 0 B → 10.41 kB `home/runner/work/actual/actual/packages/loot-core/src/server/aql/schema/index.ts` | 🆕 +9.36 kB | 0 B → 9.36 kB `home/runner/work/actual/actual/packages/loot-core/src/server/budget/envelope.ts` | 🆕 +8.9 kB | 0 B → 8.9 kB `node_modules/adm-zip/zipFile.js` | 🆕 +8.81 kB | 0 B → 8.81 kB `node_modules/adm-zip/util/utils.js` | 🆕 +7.68 kB | 0 B → 7.68 kB `node_modules/adm-zip/headers/entryHeader.js` | 🆕 +7.53 kB | 0 B → 7.53 kB `home/runner/work/actual/actual/packages/loot-core/src/server/budget/tracking.ts` | 🆕 +6.72 kB | 0 B → 6.72 kB `home/runner/work/actual/actual/packages/loot-core/src/server/budget/base.ts` | 🆕 +6.48 kB | 0 B → 6.48 kB `home/runner/work/actual/actual/packages/loot-core/src/server/aql/schema/executors.ts` | 🆕 +6.14 kB | 0 B → 6.14 kB `home/runner/work/actual/actual/packages/loot-core/src/server/db/sort.ts` | 🆕 +4.02 kB | 0 B → 4.02 kB `home/runner/work/actual/actual/packages/loot-core/src/server/aql/schema-helpers.ts` | 🆕 +3.91 kB | 0 B → 3.91 kB `node_modules/murmurhash/murmurhash.js` | 🆕 +3.29 kB | 0 B → 3.29 kB `node_modules/adm-zip/methods/zipcrypto.js` | 🆕 +3.14 kB | 0 B → 3.14 kB `home/runner/work/actual/actual/packages/loot-core/src/server/sync/encoder.ts` | 🆕 +2.81 kB | 0 B → 2.81 kB `node_modules/adm-zip/headers/mainHeader.js` | 🆕 +2.75 kB | 0 B → 2.75 kB `home/runner/work/actual/actual/packages/loot-core/src/server/models.ts` | 🆕 +2.69 kB | 0 B → 2.69 kB `home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/index.ts` | 🆕 +2.69 kB | 0 B → 2.69 kB `home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctionsPreferences.ts` | 🆕 +2.68 kB | 0 B → 2.68 kB `node_modules/adm-zip/util/errors.js` | 🆕 +2.47 kB | 0 B → 2.47 kB `home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/path-join.ts` | 🆕 +2.23 kB | 0 B → 2.23 kB `node_modules/adm-zip/util/constants.js` | 🆕 +1.91 kB | 0 B → 1.91 kB `home/runner/work/actual/actual/packages/loot-core/src/server/aql/exec.ts` | 🆕 +1.6 kB | 0 B → 1.6 kB `home/runner/work/actual/actual/packages/loot-core/src/server/sheet.ts` | 🆕 +1.56 kB | 0 B → 1.56 kB `home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/index.ts` | 🆕 +1.54 kB | 0 B → 1.54 kB `node_modules/adm-zip/util/fattr.js` | 🆕 +1.49 kB | 0 B → 1.49 kB `home/runner/work/actual/actual/packages/loot-core/src/server/app.ts` | 🆕 +1.22 kB | 0 B → 1.22 kB `home/runner/work/actual/actual/packages/loot-core/src/server/encryption/encryption-internals.ts` | 🆕 +1.2 kB | 0 B → 1.2 kB `node_modules/adm-zip/methods/inflater.js` | 🆕 +1019 B | 0 B → 1019 B `home/runner/work/actual/actual/packages/loot-core/src/server/post.ts` | 🆕 +999 B | 0 B → 999 B `home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/unicodeLike.ts` | 🆕 +995 B | 0 B → 995 B `node_modules/adm-zip/methods/deflater.js` | 🆕 +906 B | 0 B → 906 B `home/runner/work/actual/actual/packages/loot-core/src/server/undo.ts` | 🆕 +815 B | 0 B → 815 B `home/runner/work/actual/actual/packages/loot-core/src/server/prefs.ts` | 🆕 +694 B | 0 B → 694 B `home/runner/work/actual/actual/packages/loot-core/src/server/server-config.ts` | 🆕 +676 B | 0 B → 676 B `home/runner/work/actual/actual/packages/loot-core/src/server/mutators.ts` | 🆕 +524 B | 0 B → 524 B `node_modules/mitt/dist/mitt.mjs` | 🆕 +513 B | 0 B → 513 B `home/runner/work/actual/actual/packages/loot-core/src/platform/server/connection/index.ts` | 🆕 +512 B | 0 B → 512 B `home/runner/work/actual/actual/packages/loot-core/src/platform/server/fs/shared.ts` | 🆕 +498 B | 0 B → 498 B `home/runner/work/actual/actual/packages/loot-core/src/server/budget/util.ts` | 🆕 +403 B | 0 B → 403 B `home/runner/work/actual/actual/packages/loot-core/src/server/encryption/index.ts` | 🆕 +393 B | 0 B → 393 B `home/runner/work/actual/actual/packages/loot-core/src/server/sync/repair.ts` | 🆕 +388 B | 0 B → 388 B `home/runner/work/actual/actual/packages/loot-core/src/platform/server/fetch/index.ts` | 🆕 +373 B | 0 B → 373 B `node_modules/adm-zip/util/index.js` | 🆕 +358 B | 0 B → 358 B `node_modules/adm-zip/util/decoder.js` | 🆕 +273 B | 0 B → 273 B `home/runner/work/actual/actual/packages/loot-core/src/server/spreadsheet/globals.ts` | 🆕 +262 B | 0 B → 262 B `node_modules/adm-zip/methods/index.js` | 🆕 +262 B | 0 B → 262 B `home/runner/work/actual/actual/packages/loot-core/src/server/aql/index.ts` | 🆕 +258 B | 0 B → 258 B `node_modules/adm-zip/headers/index.js` | 🆕 +230 B | 0 B → 230 B `home/runner/work/actual/actual/packages/loot-core/src/server/db/util.ts` | 🆕 +195 B | 0 B → 195 B `home/runner/work/actual/actual/packages/loot-core/src/platform/server/sqlite/normalise.ts` | 🆕 +168 B | 0 B → 168 B `__vite-browser-external` | 🆕 +166 B | 0 B → 166 B `home/runner/work/actual/actual/packages/loot-core/src/server/main-app.ts` | 🆕 +149 B | 0 B → 149 B `home/runner/work/actual/actual/packages/loot-core/src/server/spreadsheet/util.ts` | 🆕 +133 B | 0 B → 133 B `node_modules/absurd-sql/dist/indexeddb-backend.js` | 🆕 +133 B | 0 B → 133 B `home/runner/work/actual/actual/packages/loot-core/src/server/cloud-storage.ts` | 🆕 +129 B | 0 B → 129 B `home/runner/work/actual/actual/packages/loot-core/src/shared/async.ts` | 📈 +708 B (+270.23%) | 262 B → 970 B `home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.ts` | 📈 +3.15 kB (+230.34%) | 1.37 kB → 4.52 kB `home/runner/work/actual/actual/packages/loot-core/src/server/errors.ts` | 📈 +412 B (+214.58%) | 192 B → 604 B `home/runner/work/actual/actual/packages/loot-core/src/platform/server/asyncStorage/index.ts` | 📈 +706 B (+155.16%) | 455 B → 1.13 kB `home/runner/work/actual/actual/packages/loot-core/src/server/rules/action.ts` | 📈 +89 B (+43.84%) | 203 B → 292 B `home/runner/work/actual/actual/packages/loot-core/src/platform/server/indexeddb/index.ts` | 📈 +348 B (+25.87%) | 1.31 kB → 1.65 kB `home/runner/work/actual/actual/packages/loot-core/src/shared/normalisation.ts` | 📈 +67 B (+20.36%) | 329 B → 396 B `src/components/formula/transactionModeFunctions.ts` | 📈 +1.05 kB (+7.49%) | 14.04 kB → 15.09 kB `src/components/reports/FormulaResult.tsx` | 📈 +231 B (+5.99%) | 3.76 kB → 3.99 kB `home/runner/work/actual/actual/packages/loot-core/src/shared/util.ts` | 📈 +417 B (+4.62%) | 8.82 kB → 9.23 kB `src/queries/aqlQuery.ts` | 📈 +4 B (+3.23%) | 124 B → 128 B `src/hooks/useFormulaExecution.ts` | 📈 +438 B (+2.56%) | 16.71 kB → 17.14 kB `src/undo/index.ts` | 📈 +4 B (+0.73%) | 551 B → 555 B `src/tags/queries.ts` | 📈 +2 B (+0.64%) | 311 B → 313 B `node_modules/chevrotain/lib_esm/src/parse/grammar/first.js` | 📈 +8 B (+0.60%) | 1.29 kB → 1.3 kB `src/hooks/useMetadataPref.ts` | 📈 +2 B (+0.57%) | 352 B → 354 B `src/budget/mutations.ts` | 📈 +72 B (+0.56%) | 12.5 kB → 12.57 kB `src/reports/queries.ts` | 📈 +6 B (+0.54%) | 1.09 kB → 1.09 kB `home/runner/work/actual/actual/packages/loot-core/src/server/rules/handlebars-helpers.ts` | 📈 +12 B (+0.36%) | 3.25 kB → 3.26 kB `src/hooks/useTransactionBatchActions.ts` | 📈 +28 B (+0.32%) | 8.66 kB → 8.69 kB `src/transactions/queries.ts` | 📈 +2 B (+0.31%) | 647 B → 649 B `node_modules/handlebars/dist/cjs/handlebars/decorators/inline.js` | 📈 +2 B (+0.25%) | 789 B → 791 B `node_modules/moment/dist/moment.js` | 📈 +256 B (+0.22%) | 111.68 kB → 111.93 kB `src/components/ServerContext.tsx` | 📈 +12 B (+0.21%) | 5.56 kB → 5.58 kB `src/budget/queries.ts` | 📈 +2 B (+0.20%) | 1020 B → 1022 B `node_modules/handlebars/dist/cjs/handlebars/helpers/block-helper-missing.js` | 📈 +2 B (+0.19%) | 1.02 kB → 1.02 kB `src/hooks/useSpreadsheet.tsx` | 📈 +6 B (+0.19%) | 3.17 kB → 3.17 kB `node_modules/handlebars/dist/cjs/handlebars/logger.js` | 📈 +2 B (+0.18%) | 1.07 kB → 1.07 kB `home/runner/work/actual/actual/packages/loot-core/src/shared/schedules.ts` | 📈 +20 B (+0.17%) | 11.33 kB → 11.35 kB `node_modules/handlebars/dist/cjs/handlebars/helpers/with.js` | 📈 +2 B (+0.17%) | 1.14 kB → 1.14 kB `node_modules/handlebars/dist/cjs/handlebars/helpers/if.js` | 📈 +2 B (+0.17%) | 1.18 kB → 1.18 kB `node_modules/handlebars/dist/cjs/handlebars.runtime.js` | 📈 +2 B (+0.13%) | 1.56 kB → 1.56 kB `src/components/transactions/TransactionList.tsx` | 📈 +18 B (+0.10%) | 17.29 kB → 17.3 kB `node_modules/chevrotain/lib_esm/src/parse/grammar/follow.js` | 📈 +2 B (+0.10%) | 1.95 kB → 1.95 kB `node_modules/source-map/lib/mapping-list.js` | 📈 +2 B (+0.09%) | 2.17 kB → 2.17 kB `node_modules/handlebars/dist/cjs/handlebars/helpers/each.js` | 📈 +2 B (+0.09%) | 2.22 kB → 2.22 kB `node_modules/handlebars/dist/cjs/handlebars/utils.js` | 📈 +2 B (+0.08%) | 2.33 kB → 2.33 kB `src/components/mobile/MobileNavTabs.tsx` | 📈 +8 B (+0.08%) | 10.16 kB → 10.17 kB </details> <details> <summary>View detailed bundle breakdown</summary> <div> **Added** No assets were added **Removed** No assets were removed **Bigger** Asset | File Size | % Changed ----- | --------- | --------- static/js/Value.js | 4.94 MB → 5.36 MB (+428.63 kB) | +8.47% static/js/ReportRouter.js | 1.22 MB → 1.22 MB (+669 B) | +0.05% static/js/extends.js | 520.14 kB → 520.54 kB (+417 B) | +0.08% **Smaller** Asset | File Size | % Changed ----- | --------- | --------- static/js/FormulaEditor.js | 962.55 kB → 958.82 kB (-3.74 kB) | -0.39% static/js/index.js | 1.93 MB → 1.93 MB (-2.01 kB) | -0.10% **Unchanged** Asset | File Size | % Changed ----- | --------- | --------- static/js/BackgroundImage.js | 121.09 kB | 0% static/js/ScheduleEditForm.js | 145.76 kB | 0% static/js/TransactionEdit.js | 190.4 kB | 0% static/js/TransactionList.js | 85.81 kB | 0% static/js/alerts.js | 800.08 kB | 0% static/js/bankSyncUtils.js | 54.1 kB | 0% static/js/ca.js | 187.91 kB | 0% static/js/client.js | 451.37 kB | 0% static/js/da.js | 101.38 kB | 0% static/js/de.js | 170.55 kB | 0% static/js/en-GB.js | 8.2 kB | 0% static/js/en.js | 185.11 kB | 0% static/js/es.js | 179 kB | 0% static/js/fr.js | 178.9 kB | 0% static/js/indexeddb-main-thread-worker-e59fee74.js | 13.46 kB | 0% static/js/it.js | 165.3 kB | 0% static/js/narrow.js | 364.41 kB | 0% static/js/nb-NO.js | 148.31 kB | 0% static/js/nl.js | 106.47 kB | 0% static/js/pl.js | 86.52 kB | 0% static/js/pt-BR.js | 189.58 kB | 0% static/js/resize-observer.js | 18.06 kB | 0% static/js/th.js | 174.76 kB | 0% static/js/theme.js | 31.67 kB | 0% static/js/uk.js | 207.75 kB | 0% static/js/useFormatList.js | 4.96 kB | 0% static/js/wide.js | 453 B | 0% static/js/workbox-window.prod.es5.js | 7.33 kB | 0% static/js/zh-Hans.js | 117.91 kB | 0% </div> </details> --- #### loot-core **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 1 | 5.27 MB → 5.28 MB (+6.06 kB) | +0.11% <details> <summary>Changeset</summary> File | Δ | Size ---- | - | ---- `home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctionsPreferences.ts` | 🆕 +2.73 kB | 0 B → 2.73 kB `home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.ts` | 📈 +3.24 kB (+229.90%) | 1.41 kB → 4.66 kB `home/runner/work/actual/actual/packages/loot-core/src/server/rules/action.ts` | 📈 +92 B (+1.12%) | 8 kB → 8.09 kB </details> <details> <summary>View detailed bundle breakdown</summary> <div> **Added** Asset | File Size | % Changed ----- | --------- | --------- kcab.worker.CFkWwiSk.js | 0 B → 5.28 MB (+5.28 MB) | - **Removed** Asset | File Size | % Changed ----- | --------- | --------- kcab.worker.CfcE9hoo.js | 5.27 MB → 0 B (-5.27 MB) | -100% **Bigger** No assets were bigger **Smaller** No assets were smaller **Unchanged** No assets were unchanged </div> </details> --- #### api **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 2 | 3.9 MB → 3.9 MB (+5.92 kB) | +0.15% <details> <summary>Changeset</summary> File | Δ | Size ---- | - | ---- `home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctionsPreferences.ts` | 🆕 +2.68 kB | 0 B → 2.68 kB `home/runner/work/actual/actual/packages/loot-core/src/server/rules/customFunctions.ts` | 📈 +3.15 kB (+230.01%) | 1.37 kB → 4.52 kB `home/runner/work/actual/actual/packages/loot-core/src/server/rules/action.ts` | 📈 +89 B (+1.15%) | 7.54 kB → 7.62 kB </details> <details> <summary>View detailed bundle breakdown</summary> <div> **Added** No assets were added **Removed** No assets were removed **Bigger** Asset | File Size | % Changed ----- | --------- | --------- index.js | 3.9 MB → 3.9 MB (+5.92 kB) | +0.15% **Smaller** No assets were smaller **Unchanged** Asset | File Size | % Changed ----- | --------- | --------- models.js | 0 B | 0% </div> </details> --- #### cli **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 1 | 7.97 MB | 0% <details> <summary>View detailed bundle breakdown</summary> <div> **Added** No assets were added **Removed** No assets were removed **Bigger** No assets were bigger **Smaller** No assets were smaller **Unchanged** Asset | File Size | % Changed ----- | --------- | --------- cli.js | 7.97 MB | 0% </div> </details> --- #### crdt **Total** Files count | Total bundle size | % Changed ----------- | ----------------- | --------- 1 | 43.41 kB | 0% <details> <summary>View detailed bundle breakdown</summary> <div> **Added** No assets were added **Removed** No assets were removed **Bigger** No assets were bigger **Smaller** No assets were smaller **Unchanged** Asset | File Size | % Changed ----- | --------- | --------- index.js | 43.41 kB | 0% </div> </details> </details>  --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

GiteaMirror added the pull-request label 2026-06-05 21:19:02 -05:00

GiteaMirror closed this issue

2026-06-05 21:20:17 -05:00

Sign in to join this conversation.

Branches Tags

master

dependabot/npm_and_yarn/npm_and_yarn-cd62b4b37a

enforce-append-only-migrations-ci

claude/error-codes-worker-boundary-26i5uu

api-browser-custom-data-dir

tabedzki/feat/replacing-month-picker-with-day-picker

delay-initial-sync-until-loaded

jfdoming/mobile-app-build

cross-version-sync-compat

jfdoming/api-tokens-part-1

jfdoming/api-tokens-part-2

jfdoming/api-tokens-part-3

jfdoming/mobile-app-updates

claude/budget-version-migration-compat-151jlr

claude/worker-error-serialization-9iqtl7

claude/react-table-library-research-afx83z

claude/issue-8401-regression-test-9nw9l3

jfdoming/mobile-app-foundation-part-1

jfdoming/mobile-app-scaffold

release

ai-fix-cleanup-def-8290

claude/relaxed-shannon-jusywa

claude/fervent-keller-s6f2fq

claude/determined-feynman-st1y9z

claude/wizardly-einstein-vi2wce

claude/sweet-albattani-7nseio

feat/bank-sync-per-budget-file

claude/affectionate-cannon-y0kc82

claude/dependabot-findings-m9pgmb

claude/mac-app-ios-publish-zjs1lz

claude/vigilant-tesla-aiiyos

depot-migrate-secrets-1781296330308

claude/quirky-cerf-v5qck7

claude/animation-removal-alternative-2etfh1

claude/netlify-preview-comments-consolidate-9XPYa

osc/7391-error-boundaries-reports

claude/pensive-dijkstra-7DYui

claude/server-app-version-mismatch-HTCGv

claude/pr-8027-review-feedback-mELuO

claude/zealous-wozniak-e5pO0

claude/intelligent-heisenberg-BSHJq

claude/translation-download-refactor-jFRsO

claude/mobile-performance-ideas-G9PAO

claude/github-issue-7988-5A5ly

blacksmith-migration-ff70d2d

claude/great-mayer-KRvOk

claude/react-native-ios-compilation-fcJh5

claude/serene-goldberg-58xv0

claude/kind-euler-LVG3K

release-automation/edge-nightly

7710-bundle-migrations

claude/fix-docker-build-error-WMfed

claude/llm-compatible-release-notes-t20Nr

7710-tests-tdd

cursor/transaction-table-rewrite-f077

claude/plan-ci-secure-context-OtEe1

claude/fix-issue-7667-DPXi3

cursor/resolve-pr-7449-ee11

claude/fix-typescript-build-error-JPtZ5

copilot/add-repository-configs-to-packages

worktree-compressed-drifting-ritchie

claude/api-consumer-verification-kfz1K

pr-7454

claude/fix-issue-7410-LLLQ4

revert-7281-generate-icons

react-query-useSchedules

copilot/sub-pr-6140

package-upgrades

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/actual#113992

[PR #7451] [CLOSED] [AI] Formula Feature Improvements: FORMATNUMBER, FORMATCURRENCY, and Tooltip Fixes #113992

📋 Pull Request Information

📝 Commits (10+)

📊 Changes

📄 Description

Summary

Changes Made

1. FORMATNUMBER() Function (Addresses TEXT() formatting limitations)

2. FORMATCURRENCY() Function (Proper currency formatting)

3. Line Break Support in Formula Cards ✨

4. Formula Function Cleanup 🧹

5. Tooltip Quote Consistency Fix

6. Updated Documentation

7. Comprehensive Integration Tests 🧪

Formula Rule Integration Tests (36 tests)

Formula Card Integration Tests (14 tests)

Technical Implementation

Settings Architecture

Feedbacks Not Addressed (with reasoning)

BALANCEONDAY() Function

LASTSYNCEDBALANCE Variable

Dynamic "Last Month" Dropdown

Testing

Code Comments

Related Issue

Bundle Stats

desktop-client

loot-core

api

cli

crdt