Automatic data update

[lauraruggerilinea]

Module

spreadsheet_oca

Describe the bug

When I create a pivot by grouping, for example, by month, it does not automatically insert any rows when new month values ​​are added.
Example I have grouped sales by months and they are in July. When I get to August I can't find the new row opening the spredsheet but I have to delete and recreate it.

[pedrobaeza]

This is the same as #8

@etobella you told that is handled. How?

[etobella]

In order to add a new line, you need to reinsert the table (it is added as an option), it cannot be done automatically. Sorry
The same happens with Odoo EE Spreadsheet

[legalsylvain]

if it's a recurring question, we could ask a section that mentions that limitation in the ROADMAP.rst section ?

[etobella]

Yes, we probably need to do this 😞

[lauraruggerilinea]

In order to add a new line, you need to reinsert the table (it is added as an option), it cannot be done automatically. Sorry The same happens with Odoo EE Spreadsheet

But in Odoo EE there is the Re-Insert pivot key

[etobella]

The same here. Click on data. You will see the pivots. Click on the one you want to reinsert. On the right, a menu will appear with the table info and the option to reinsert is there

[lauraruggerilinea]

The same here. Click on data. You will see the pivots. Click on the one you want to reinsert. On the right, a menu will appear with the table info and the option to reinsert is there

Under data menu I have only "Add filter" and "Sort range"

[etobella]

Are you using the last version? Did you try on runboat?

[lauraruggerilinea]

ok :) i updated the repo and now it works