o-spreadsheet
o-spreadsheet copied to clipboard
[FIX] evaluation: handle throwing error on each vectorized position
Before this commit, if an error was throw when evaluating a vectorized formula, then the evaluation stopped and only the cell with the formula was marked as an error. No other values were spread.
This behavior is functionally false, because depending on the arguments passed, it is possible that on this vector position, the evaluation does not return an error.
This commit changes that by making sure to try for each vector position if the evaluation works. Even though it only spreads errors in certain cases.
Task: : 4091276
review checklist
- [ ] feature is organized in plugin, or UI components
- [ ] support of duplicate sheet (deep copy)
- [ ] in model/core: ranges are Range object, and can be adapted (adaptRanges)
- [ ] in model/UI: ranges are strings (to show the user)
- [ ] undo-able commands (uses this.history.update)
- [ ] multiuser-able commands (has inverse commands and transformations where needed)
- [ ] new/updated/removed commands are documented
- [ ] exportable in excel
- [ ] translations (_t("qmsdf %s", abc))
- [ ] unit tested
- [ ] clean commented code
- [ ] track breaking changes
- [ ] doc is rebuild (npm run doc)
- [ ] status is correct in Odoo