Get started
Loading...
Important Notice - Forums is archived

To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Product icon
TUTORIAL

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

Where to include a web components css file when integrating a third party w by Martin Vyšný, 1 week ago
Recent Posts
Vaadin Forum3. Vaadin 6, 7, 8

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

George Hatzisymeon
5 years ago Nov 03, 2016 2:43pm

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
5 years ago Nov 07, 2016 11:47am

You could try adding this to your theme:

.add-new-tab {
    display:none !important;
  }
George Hatzisymeon
5 years ago Nov 07, 2016 12:28pm

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
5 years ago Nov 07, 2016 12:40pm

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
3 years ago May 04, 2018 7:28am

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.