Spreadsheet Oca
by CreuBlanca https://github.com/OCA/spreadsheet , Odoo Community Association (OCA) https://github.com/OCA/spreadsheet| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 2067 |
| Technical Name |
spreadsheet_oca |
| License | AGPL-3 |
| Website | https://github.com/OCA/spreadsheet |
Spreadsheet Oca
This module adds a functionality for adding and editing Spreadsheets using Odoo CE.
It is an alternative to the proprietary module spreadsheet_edition of Odoo Enterprise Edition.
Table of contents
Usage
Create a new spreadsheet
- Go to ‘Spreadsheet’ menu
- Click on ‘Create’
- Put a name, then click on the “Edit” button
- At this point you switch to spreadsheet editing mode. The editor is named o-spreadsheet and looks like another common spreadsheet web editors. (OnlyOffice, Ethercalc, Google Sheets (non-free)).
- You can use common functions SUM(), AVERAGE(), etc. in the cells. For a complete list of functions and their syntax, Refer to the documentation https://github.com/odoo/o-spreadsheet/ or go to https://odoo.github.io/o-spreadsheet/ and click on “Insert > Function”.
Note: Business Odoo module can add “business functions”. This is currently the case for the accounting module, which adds the following features:
- ODOO.CREDIT(account_codes, date_range): Get the total credit for the specified account(s) and period.
- ODOO.DEBIT(account_codes, date_range): Get the total debit for the specified account(s) and period.
- ODOO.BALANCE(account_codes, date_range): Get the total balance for the specified account(s) and period.
- ODOO.FISCALYEAR.START(day): Returns the starting date of the fiscal year encompassing the provided date.
- ODOO.FISCALYEAR.END(day): Returns the ending date of the fiscal year encompassing the provided date.
- ODOO.ACCOUNT.GROUP(type): Returns the account ids of a given group where type should be a value of the account_type field of account.account model. (income, asset_receivable, etc.)
Development
If you want to develop custom business functions, you can add others, based on the file https://github.com/odoo/odoo/blob/16.0/addons/spreadsheet_account/static/src/accounting_functions.js
Known issues / Roadmap
Adding new lines on pivot tables
When we add a pivot table, the number of rows is predefined according to the current data.
In order to add new rows, we need to reinsert the pivot table.
Bug Tracker
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Credits
Authors
- CreuBlanca
Contributors
- Enric Tobella
Maintainers
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.
This module is part of the OCA/spreadsheet project on GitHub.
You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.
Please log in to comment on this module