Skip to content
back to search

OCA/spreadsheet · 18.0

Spreadsheet Oca

spreadsheet_oca

AGPL-3v18.0.1.3.281updated 2 days ago
search codeOCA runboatGitHubgithub

Odoo Community Association

Spreadsheet Oca

Beta License: AGPL-3 OCA/spreadsheet Translate me on Weblate Try me on Runboat

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

image1

  • 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)).

image2

  • 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".

image3

  • 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

Authors

  • CreuBlanca

Contributors

Maintainers

This module is maintained by the OCA.

Odoo Community Association

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>.