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.

CssImport when using Component Exporter by Mikhail Shabarov, 1 month ago
Recent Posts
Vaadin Forum1. Vaadin Flow - Java

Spreadsheet component + data validity

Sebastiaan Blommers
7 years ago Jul 30, 2015 9:38pm

Hi there,

XSLX and Apache POI support checking validity of input (for example A2=ABS(ROUND(A2,2)) to check if positive number and 2 decimals rounding). Is this going to be implemented into the spreadsheets component?

Thanks!
Sebastiaan

Guillermo Alvarez
7 years ago Jul 31, 2015 12:37pm

Hi Sebastiaan,

I'm afraid DataValidation constraints aren't considered right now. 

You can create a new enhancement request in https://dev.vaadin.com
 

Sebastiaan Blommers
7 years ago Jul 31, 2015 12:40pm

I understand why, when you copy a cell on a cell with data validation in Excel or LibreOffice the data validation get's lost on that cell. Setting a custom SpreadsheetComponentFactory might be the best solution for now.

Thank you for looking into it.

Greg Woolsey
5 years ago Feb 14, 2017 5:01pm

I just committed support for evaluating data validation constraints to POI trunk yesterday.  See class org.apache.poi.ss.formula.DataValidationEvaluator.  That has methods that could be used with a custom SpreadsheetComponentFactory to help you write your own validating input fields, including drop-downs.