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
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
Contributors
Enric Tobella
-
Carlos Roca
-
Chris Mann
-
Florent THOMAS
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.
1 maintainer
Release files for odoo-addon-spreadsheet-oca 18.0.1.3.2
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| odoo_addon_spreadsheet_oca-18.0.1.3.2-py3-none-any.whl | Python 3 | none | any | Details |
Release files / odoo_addon_spreadsheet_oca-18.0.1.3.2-py3-none-any.whl
| Download URL | odoo_addon_spreadsheet_oca-18.0.1.3.2-py3-none-any.whl |
|---|---|
| Size | 954.4 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
a75845487c3f035e29160d2d33e303ceafcad69aa3c0e89b437a339936bc9601
|
|
BLAKE2b-256 checksum How to use checksums |
344d2d80c86ff7c79260ddf63ec18a15fa749c57861769561d4a6961241b9465
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.12.3
|
