Friday, November 17, 2023
2 changes · 17.0
Enhancements to existing features
Spreadsheet pivot and list helpers now reuse formula information that is already available instead of recalculating it. This reduces unnecessary processing and should make spreadsheet interactions a little more efficient without changing user-visible behavior.
Original PR description
The pivot/list helpers were tokenizing the cell's content when trying to find list/pivot formulas. But we can skip the tokenize call as we already have the tokens in the cell's compiledFormula. Task: [3584306](https://www.odoo.com/web#id=3584306&menu_id=4720&cids=1&action=333&active_id=2328&model=project.task&view_type=form) --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
This update improves the performance of spreadsheet pivot and list features by removing unnecessary processing steps. The system was redundantly converting cell formulas twice; this change eliminates that duplication, making spreadsheet operations faster and more efficient.
Original PR description
The pivot/list helpers were tokenizing the cell's content when trying to find list/pivot formulas. But we can skip the tokenize call as we already have the tokens in the cell's compiledFormula. Task: [3584306](https://www.odoo.com/web#id=3584306&cids=1&menu_id=4720&action=333&active_id=2328&model=project.task&view_type=form)