How to remove Vaadin Spreadsheets add new sheet (+) button

George Hatzisymeon

Is there a way to remove the (+) button on the bottom left corner of Vaadin Spreadsheets.

I want to implement a Report like functionality with tabs enabled but I dont want the user adding sheets.

Any ideas?

Anna Koskinen

You could try adding this to your theme:

.add-new-tab {
    display:none !important;
  }

George Hatzisymeon

Hi Anna,

That did the trick, but I think it would be better to manage from the server side as well.
Also there is very big space until the first tab starts, this is because sheet-tabsheet-options is always visible even if there is no requirement from scrolling. Shouldn't that be visible only when tab scrolling is required?

Anna Koskinen

If you want to remove the options altogether, try:

.v-spreadsheet .sheet-tabsheet .sheet-tabsheet-options {
    display:none;
  }
  .v-spreadsheet .sheet-tabsheet .sheet-tabsheet-container {
    left: 0;
  }

I don't think it's possible to make the hiding optional with css alone, though. You could perhaps add a feature request for that in GitHub.

Masafumi Hanada

Hi, this works fine for me.

first, create a XSSFWorkbook workbook
set workbook lockStructure
add some sheets
create spreadsheet with this workbook

for example:

XSSFWorkbook workbook = new XSSFWorkbook();
workbook.lockStructure();
// you could set password if you need
// workbook.setWorkbookPassword("pass", null);  
Sheet sheet1 = workbook.createSheet("My Sheet1");
Sheet sheet2 = workbook.createSheet("My Sheet2");
spreadsheet = new Spreadsheet(workbook);

This is very helpful for me.

How to make sheetname tab in vaadin spreadsheet readonly

2018-05-04_16h20_27.png (5.2 kB)

Important Notice - Forums is archived

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.

How to remove Vaadin Spreadsheets add new sheet (+) button

Important Notice - Forums is archived

Vaadin lets you build secure, UX-first PWAs entirely in Java.Free ebook & tutorial.

How to remove Vaadin Spreadsheets add new sheet (+) button

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.