[IMP] functions: add SEQUENCE function

LucasLefevre commented 1 month ago

Task:

Description:

This commit adds the SEQUENCE function to generate a sequence of numbers.

It can useful, among other things, to create array versions (vectorized) of ODOO.LIST or positional (#) pivot

=ODOO.LIST(1,SEQUENCE(15),"email_from") =PIVOT.VALUE(1,"expected_revenue:sum","#team_id",SEQUENCE(10))

Vectorized formulas are best for performance because it requires way less cells to achieve the same thing.

Task: : 4129396

[ ] 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

robodoo commented 1 month ago

rrahir commented 1 month ago

@robodoo r+