Skip to Content
This question has been flagged
1 Reply
2331 Views
Avatar
Peter Romão

I have just installed the spreadsheet module from OCA in order to edit some of the spreadsheets for the dashboards but after installation I am having this error when trying to edit a spreadsheet:

action_spreadsheet_oca couldn't be loaded

Any one knows why is this happening?

Thanks.

Avatar
Discard
Avatar
Mahmoud El Bouyahyaoui
Best Answer

The error "action_spreadsheet_oca couldn't be loaded" usually indicates that there is an issue with the installation of the spreadsheet module from OCA that you have just installed. This could be caused by a few different things:

  1. Dependencies: The module may have dependencies that are not installed or are not compatible with your version of Odoo. Make sure that you have all the required dependencies installed and that they are compatible with your version of Odoo.

  2. Conflicting modules: The module may be conflicting with other modules that you have installed. Try disabling other modules that may be conflicting with the spreadsheet module to see if that resolves the issue.

  3. Version incompatibility: The module version may not be compatible with your version of Odoo. Make sure that you are using the correct version of the module for your version of Odoo.

  4. Data migration: The module may have issues with data migration, which can cause errors when trying to edit a spreadsheet. You can try to uninstall the module and then reinstall it again, this time making sure that you run the data migration process.

  5. Permissions: The user that is trying to access the spreadsheet module may not have the proper permissions. Try logging in with a different user or check the user's permissions.

  6. Technical issue: It's possible that there is a technical issue with the module, in that case, you can consider reporting the issue to the module's maintainers or looking for an updated version of the module.

Try to check the above points, and if none of them resolve the issue, it's recommended to check the log files or consult with the module's maintainers for further support.

Avatar
Discard
Peter Romão
Author

Hello Mahmoud and thanks for your input.

A bit of additional information:
This is happening in a dockered odoo (the official on @ https://hub.docker.com/_/odoo)

Now what I did was install 3x odoo 16.0 CE on a Mac, a Windows 10 workstation and a Virtualboxed Ububtu 20.04. And the the apps work on all 3 machines with only the odoo S.A. purchase app installed.

So I got the database from the docker production environment and copied it into an odoo inside my Mac odoo installation and the spreadsheet apps worked fine so I conclude that it is not a database issue.

So my tests take care of your points 2, 3, 4 and 5.

Now for the rest of your points I might need some directions here if you'd be so kind (or anyone else), basically for point 1.

1. Dependencies: Any ideas on how I could go about this? All 3 installations I made I installed the linux dependencies for odoo based on the requirements.txt except on the docker version which comes functional out of the box.

6. Technical issue: I have indeed go into the code and it's the base spreadsheet module in assets throwing the error so I suspect the problem is as you put in point 1. I would only like to revert to the programers after I dealt with and exhausted point 1. Therror that is in the server log page gives me no hint as to which line of code or module is the culprit.

Thanks again for the effort.
PR