Vaadin Spreadsheet for Flow 1.0.0.alpha1

This is the initial pre-release of the Spreadsheet component to be used from the Java server side with Vaadin Flow.

Vaadin Spreadsheet enables you to easily integrate your Excel files into your web applications. Read, write and edit XLSX files, with support for Excel formulas, protected cells, freeze panes, simple conditional formatting, and much much more.

Install vaadin-spreadsheet-flow by adding the dependency to the project (here as a Maven dependency in pom.xml):

<dependency>
    <groupId>com.vaadin</groupId>
    <artifactId>vaadin-spreadsheet-flow</artifactId>
    <version>1.0.0.alpha1</version>
</dependency>

Compatibility

• Tested with Vaadin Platform 19.0.8 and Vaadin Flow version 6.0.9

Currently out of scope

Embedded components including charts.

Known issues

• Possible memory leak in client-side to be investigated
• Component sizing issue in flex container, as a workaround you can wrap the component in a full sized Div

@Route("spreadsheet")
public class SpreadsheetView extends VerticalLayout {
    public SpreadsheetView() {
        setSizeFull();
        Spreadsheet spreadsheet = new Spreadsheet();
        Div container = new Div(spreadsheet);
        container.setSizeFull();
        add(container);
    }
}

Changes since 3.0.0.alpha1

• Delay and avoid expensive createCellDataForCell (#714)
• Explicity import org.apache.poi.ss.formula #645 (#703)
• Move CopyPasteHandler registration to method (#707)
• Misc. updates/fixes/enhancements for extensibility and useability (#699)
• Allow CSS styling of tabs by name (#700)
• fix cell width calculation to account for merged cells (#696)

This version brings some bug fix and small improvements:

• c232239 Fix Copy/Paste behaviour on some layout configurations
• 05fef99 Explicitly import org.apache.poi.ss.formula

Changes since 2.1.0

• #692 Update to POI 4.0.1

Changes since 2.1.0.beta1

• #693 NPE on widget clean

Check detailed list of fixes and enhancements in each pre-release release notes:

• 2.1.0.beta1
• 2.1.0.alpha2
• 2.1.0.alpha1

• Fix for #664
  • Fix scroll when navigating to a cell (#686)

• Updated POI to 3.17 (#678)
• Fix for #384:
  • In CopyPasteTextBox first save HandlerRegistration from addNativePreviewHandler() and then call removeHandler() on the saved registration in the method onDestroy()
  • In SheetWidget simply call copyPasteBox.onDestroy()
  • In SpreadsheetConnector something similar than in CopyPasteTextBox: saving contextMenuHandler and then calling removeHandler() in the method onUnregister()
• Prevent duplicates of dynamic styles on sheets with overlays (#639)
• Update testbench version (#638)
• Fix the issue when click on a hyperlink did not select the target cell (#633)
• Show in the formula bar only those named ranges that can be selected (#627)
• Fix mvn dependency snippet (#616)
• Allows arrow keys to leave cell value editor
• Fix a number of performance issues (mainly with IE11)
  • only measureValueWidth if column width is greater than 0
  • Consider hidden rows and cols in getRealEventTargetCell
  • Prevent NPE with links without address
• Correctly update cells in grouped columns after expanding
• Fix an NPE in Spreadsheet.createCell() when the cell value is null (#607)

This release updates to POI 3.17, fixing issue #667. Framework version is updated to 7.7.14.

POI 3.17 introduced API changes and caused a regression with some cases of conditional formatting, 61761 and 61764. Those issues are only fixed in POI 4.0.0, which requires Java 8+. Therefore this version allows Vaadin Framework 7 users to upgrade to the last POI version that supports Java 6.

Vaadin Spreadsheet 1.4.1 is a maintenance release including only bug fixes

• #642 Prevent NPE if ConditionalFormattingRule has no background color
• #636 Fix unable to open spreadsheet containing a multilevel chart referring to an area with grouped columns

Changes since 1.4.0.beta1

• #553 Fixed performance issue in files with image or charts overlays

Check detailed list of fixes and enhancements in each pre-release release notes:

• 1.4.0.beta1
• 1.4.0.alpha2
• 1.4.0.alpha1