Metadata-Version: 2.1
Name: odoo-addon-spreadsheet_oca
Version: 16.0.1.2.6.1
Summary: Allow to edit spreadsheets
Home-page: https://github.com/OCA/spreadsheet
Author: CreuBlanca,Odoo Community Association (OCA)
Author-email: support@odoo-community.org
License: AGPL-3
Classifier: Programming Language :: Python
Classifier: Framework :: Odoo
Classifier: Framework :: Odoo :: 16.0
Classifier: License :: OSI Approved :: GNU Affero General Public License v3
Requires-Python: >=3.10
Requires-Dist: odoo <16.1dev,>=16.0a

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

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

.. |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/licence-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/16.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-16-0/spreadsheet-16-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=16.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

.. figure:: https://raw.githubusercontent.com/OCA/spreadsheet/16.0/spreadsheet_oca/static/description/spreadsheet_create.png

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

.. figure:: https://raw.githubusercontent.com/OCA/spreadsheet/16.0/spreadsheet_oca/static/description/spreadsheet_edit.png

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

.. figure:: https://raw.githubusercontent.com/OCA/spreadsheet/16.0/spreadsheet_oca/static/description/o-spreadsheet.png

* 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 <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:%2016.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

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/16.0/spreadsheet_oca>`_ project on GitHub.

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