# Step to reproduce * Create a spreadsheet with LibreOffice (desktop) * insert values in sheet 1 * create a new sheet * hide this new sheet (menu Sheet>Hide sheet) * import the spreadsheet in a Nextcloud server * edit the document with LibreOffice Online # Actual behavior * I can see the tab of the hidden sheet * when clicking on the corresponding tab, I still see the values of the sheet 1 (quite confusing) # Expected behavior * the tab of the hidden sheet should be invisible # General server configuration **Operating system:** Linux 3.10.0-514.6.2.el7.x86_64 #1 SMP Thu Feb 23 03:04:39 UTC 2017 x86_64 **Web server:** Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/7.1.5 (fpm-fcgi) **Database:** mysql 5.5.52 **PHP version:** 7.1.5 **Nextcloud version:** 12.0.4 **LibreOffice Online version:** Collabora Online 2.1.5
Confirmed with a recent master build. It should also be possible to hide/unhide sheets.
Fixed by the following commits. Thanks, Marco! The fixes have also been integrated in Collabora Online 3.1. https://cgit.freedesktop.org/libreoffice/core/commit/?id=8ffbb86b30e2c1674ba32e9e29447cbea3585d03 author Marco Cecchetti <marco.cecchetti@collabora.com> 2018-02-01 12:17:45 +0100 committer Marco Cecchetti <mrcekets@gmail.com> 2018-04-03 21:39:05 +0200 "lok - calc: add support for show/hide tabs in online" https://cgit.freedesktop.org/libreoffice/online/commit/?id=d887b08d60d4335c2de27ea043253f017701c317 author Marco Cecchetti <marco.cecchetti@collabora.com> 2018-02-01 16:36:24 +0100 committer Marco Cecchetti <mrcekets@gmail.com> 2018-04-03 21:41:22 +0200 "calc: added support for hidden sheets and validation of cell content"