Metadata-Version: 2.1
Name: odoo-addon-spreadsheet_oca
Version: 18.0.1.3.0.6
Requires-Python: >=3.10
Requires-Dist: odoo==18.0.*
Summary: Allow to edit spreadsheets
Home-page: https://github.com/OCA/spreadsheet
License: AGPL-3
Author: CreuBlanca,Odoo Community Association (OCA)
Author-email: support@odoo-community.org
Classifier: Programming Language :: Python
Classifier: Framework :: Odoo
Classifier: Framework :: Odoo :: 18.0
Classifier: License :: OSI Approved :: GNU Affero General Public License v3
Description-Content-Type: text/x-rst

.. image:: https://odoo-community.org/readme-banner-image
   :target: https://odoo-community.org/get-involved?utm_source=readme
   :alt: Odoo Community Association

===============
Spreadsheet Oca
===============

.. 
   !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
   !! This file is generated by oca-gen-addon-readme !!
   !! changes will be overwritten.                   !!
   !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
   !! source digest: sha256:afa8556b48ef425ac88f6fa7b69a9f5d76aaef94958f9ce0e14e0efd97024dc0
   !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

.. |badge1| image:: https://img.shields.io/badge/maturity-Beta-yellow.png
    :target: https://odoo-community.org/page/development-status
    :alt: Beta
.. |badge2| image:: https://img.shields.io/badge/license-AGPL--3-blue.png
    :target: http://www.gnu.org/licenses/agpl-3.0-standalone.html
    :alt: License: AGPL-3
.. |badge3| image:: https://img.shields.io/badge/github-OCA%2Fspreadsheet-lightgray.png?logo=github
    :target: https://github.com/OCA/spreadsheet/tree/18.0/spreadsheet_oca
    :alt: OCA/spreadsheet
.. |badge4| image:: https://img.shields.io/badge/weblate-Translate%20me-F47D42.png
    :target: https://translation.odoo-community.org/projects/spreadsheet-18-0/spreadsheet-18-0-spreadsheet_oca
    :alt: Translate me on Weblate
.. |badge5| image:: https://img.shields.io/badge/runboat-Try%20me-875A7B.png
    :target: https://runboat.odoo-community.org/builds?repo=OCA/spreadsheet&target_branch=18.0
    :alt: Try me on Runboat

|badge1| |badge2| |badge3| |badge4| |badge5|

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

.. contents::
   :local:

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

.. |image1| image:: https://raw.githubusercontent.com/OCA/spreadsheet/18.0/spreadsheet_oca/static/description/spreadsheet_create.png
.. |image2| image:: https://raw.githubusercontent.com/OCA/spreadsheet/18.0/spreadsheet_oca/static/description/spreadsheet_edit.png
.. |image3| image:: https://raw.githubusercontent.com/OCA/spreadsheet/18.0/spreadsheet_oca/static/description/o-spreadsheet.png

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 <https://github.com/OCA/spreadsheet/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 <https://github.com/OCA/spreadsheet/issues/new?body=module:%20spreadsheet_oca%0Aversion:%2018.0%0A%0A**Steps%20to%20reproduce**%0A-%20...%0A%0A**Current%20behavior**%0A%0A**Expected%20behavior**>`_.

Do not contact contributors directly about support or help with technical issues.

Credits
=======

Authors
-------

* CreuBlanca

Contributors
------------

- Enric Tobella
- `Tecnativa <https://www.tecnativa.com>`__:

  - Carlos Roca

- `Open User Systems <https://www.openusersystems.com>`__:

  - Chris Mann

- `Mind And Go <https://mind-and-go.com>`__

  - Florent THOMAS

Maintainers
-----------

This module is maintained by the OCA.

.. image:: https://odoo-community.org/logo.png
   :alt: Odoo Community Association
   :target: https://odoo-community.org

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 <https://github.com/OCA/spreadsheet/tree/18.0/spreadsheet_oca>`_ project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.
