Originally by @tepi

Dragging the resize handle of a column or row past the minimum moves the indicator with the mouse even though it is impossible to resize to < 0 px wide.

The indicator should stop at the minimum size.

Imported from https://dev.vaadin.com/ issue #15518

Originally by @tmattsso

If a cell is of type numerical, and we input text into it, something strips away the text and we are left with just the number. Excel allows text as well, rendering the text as normal but keeping the cell type as is (entering a number again displays correct formatting).

Imported from https://dev.vaadin.com/ issue #16216

Originally by @tmattsso

Using the attached test file, the vertical border is rendered under the sheet and isn't visible. The horizontal border is rendered, but is too short when window is resized so that you can scroll to the right.

Imported from https://dev.vaadin.com/ issue #15542

Originally by @tmattsso

The image is always rendered in the bottom-left container, even though they should be somewhere else. See included test file

Imported from https://dev.vaadin.com/ issue #15543

Originally by @tepi

See attachment.

To reproduce:

1. Add a really long string to A1
2. Add a short string to B1
   => Overflow from A1 continues from C1 onwards

Imported from https://dev.vaadin.com/ issue #15517

Originally by @tepi

Steps to reproduce:

1. Change CellStyle of some cell
2. Call markCellAsUpdated for the cell
3. Call updateMarkedCells();

Result: styles not updated

Even calling reloadVisibleCellContents() or reloadActiveSheetStyles() does nothing.

Only resetSpreadsheetFromData() works.

Imported from https://dev.vaadin.com/ issue #16253

Originally by @tepi

If I have cells with values 1,2,3 and select these and drag to fill more cells, the fill should detect the pattern and continue like 4,5,6,… Instead it fills 1,2,3,1,2,3,1,2,3,…

Imported from https://dev.vaadin.com/ issue #15530

Originally by @alvarezguille

Happens in latest snapshot.

1. double click on cell with value and press esc
2. double click on empty cell and press esc
3. value of previous cell will be set in the empty cell and it shouldn't (previous cell value is shown in the second cell, but value is not set)

Originally by @tmattsso

Part of a bigger issue; Spreadsheet does not support touch events very well.

Cell selection should be fixable without too much effort.

Imported from https://dev.vaadin.com/ issue #15224

Originally by @alvarezguille

When selection is done with a range then selectedCell is in the range and the reference will be added twice to the result

Imported from https://dev.vaadin.com/ issue #16274

Originally by @tmattsso

Current version does not work properly with vertical alignment; the setting is read but the CSS rules applied are incorrect.

Imported from https://dev.vaadin.com/ issue #15221

Originally by @zch

To reproduce:

1. Click column header to select the whole column.
2. Double click column header.

An input will be shown to edit first cell of column, also, the value of the input is initialized with the column name and not the cell value.

The expected behavior is to not edit anything, only select the column.

Originally by @tepi

I expect Cmd-a to select contents of all cells. Now it selects all content in the UI, then deselects everything, then inputs ‘a’ into the cell that was selected prior to pressing Cmd-a

Imported from https://dev.vaadin.com/ issue #15525

Originally by @tepi

Things to check:

• resulting ZIP is a valid Directory pacakage
• contents are correct
• license checker metadata is valid
• all files have CVALv3 headers

Imported from https://dev.vaadin.com/ issue #16213

Originally by @tmattsso

when resizing the spreadsheet, sheet tabs might become invisible. In this case we need to show the scroll buttons.

Imported from https://dev.vaadin.com/ issue #15250

Originally by @tepi

Wrong cursors (resize) are used when hovering over cell/row caption

Imported from https://dev.vaadin.com/ issue #15532

Originally by @tepi

Cursor should be normal when just hovering over cells, crosshair when hovering over/dragging the small square in the bottom-right corner.

Currently the cursor is always crosshair.

Imported from https://dev.vaadin.com/ issue #15522

Originally by @tmattsso

The top and left borders render in adjacent cells. If that cell is merged, however, the cell has a border that is too large; see attached test file.

The original cells actually exist under the merged ones, and do have the correct styles. the problem is that the merged cell is positioned above, and has the same style names as the original.

This is an issue both for normal cell styling as well as conditional formatting.

Originally by @tepi

We have the following cells on top of each other:

foo1
foo2
foo3

Selecting these and expanding the selection from the handle should produce results like foo4, foo5, ...

Currently this does not work.

Imported from https://dev.vaadin.com/ issue #16365

Originally by @tmattsso

If you call spreadsheet.setWrokbook(spreadsheet.getWorkbook()), all merged cells are rendered wrongly. Probably a bug in the updated state handling.

Imported from https://dev.vaadin.com/ issue #15249

Originally by @tepi

Changes are outlined in https://github.com/zch/spreadsheet-api-test

Imported from https://dev.vaadin.com/ issue #16224

Originally by @tepi

Use the xlsx file from #15543 to test. The file has an image on the first sheet and nothing on sheets 2 and 3.

If you open this file with spreadsheet, the image is shown at the correct location on sheet 1. If you switch to sheet 2 or 3, the image is still shown at the top-left corner even though it should not be there.

Imported from https://dev.vaadin.com/ issue #16285

Originally by @tepi

It seems that in various methods the row/col parameters might be in differing order.

Check that these parameters are in the following order everywhere:

• 2 params (=coordinate): column, row
• 4 params (=area): column1, row1, column2, row2

Imported from https://dev.vaadin.com/ issue #16400

Originally by @tepi

I expect F2 to enable editing of a cell value when a cell has been selected. This is practically standard in all spreadsheet apps.

Imported from https://dev.vaadin.com/ issue #15526

Originally by @tmattsso

Text indentation is not supported. Add support by adding a padding of 1 em for every character that text is indented.

Imported from https://dev.vaadin.com/ issue #15222

Originally by @tepi

If you select one cell, depress Shift and then keep the down arrow pressed for a while, the whole UI locks up even on Chrome. After a frustratingly long time the selection finally finalizes.

Imported from https://dev.vaadin.com/ issue #15527

Originally by @tepi

To reproduce:

• Firefox 35 on OSX (latest)
• Use the demo application
• Upload the attached excel file
• Initial render on my 2011 MBP takes nearly 9 seconds
• Scrolling is extreme slow as well

Basically the whole component is unusable on Firefox.

Imported from https://dev.vaadin.com/ issue #16406

Originally by @alvarezguille

The rest of the CellStyle info seems to be updated. But colors need a Spreadsheet.reload() to work.
This code reproduces it

                CellReference cellRef = spreadsheet.getSelectedCellReference();
                CellStyle style = spreadsheet.getWorkbook().createCellStyle();
                Cell cell = spreadsheet.getCell(cellRef.getRow(), cellRef.getCol());
                style.cloneStyleFrom(cell.getCellStyle());
                Font font = spreadsheet.getWorkbook().createFont();
                font.setColor(IndexedColors.RED.getIndex());
                style.setFont(font);
                cell.setCellStyle(style);
                spreadsheet.refreshCells(cell);

Imported from https://dev.vaadin.com/ issue #16318

Originally by @alvarezguille

Looks like the input position is relative to the first not frozen cell.

Imported from https://dev.vaadin.com/ issue #16254

Originally by @tepi

Scrolling a spreadsheet in a modal window on top of another spreadsheet scrolls the bottom-most spreadsheet as well as the one in the window.

Imported from https://dev.vaadin.com/ issue #15520

Originally by @tepi

See how google sheets works.

Imported from https://dev.vaadin.com/ issue #15524

Originally by @alvarezguille

First case drag down:
-I have a formula '=A1+A2' when dragging down I get '=A3+A3' expected value would be '=A2+A3'
Second case drag right:
-I have a formula '=A1+B1' when dragging right I get '=C1+B1' expected value would be '=B1+C1' (as it could be more confusing with complex formulas)

Imported from https://dev.vaadin.com/ issue #16186

Originally by @tmattsso

Support basic conditional formatting for spreadsheets. Support the following:

• font styles (color, size, bold, italics)
• background colors

Imported from https://dev.vaadin.com/ issue #15429

Originally by @tmattsso

When adding e.g. a Button, the bottom of the button is cut off since it won't fit into a cell. Should we automatically resize those rows that contain components? The issue is present with both Rows and Editors.

Imported from https://dev.vaadin.com/ issue #16467

Originally by @tepi

Scrolling is quite slow on Firefox

Imported from https://dev.vaadin.com/ issue #15529

Originally by @tepi

Selecting a sheet makes the “sheet selector” jump so that either sheet 1 is the first visible one or the selected sheet is the last visible one. The selector should not jump.

Imported from https://dev.vaadin.com/ issue #15519

Originally by @tepi

To reproduce:

1. Add PopupButton to any cell
2. Select only that cell in the UI
3. Click the popup opener arrow

Result: nothing appens
Expected: popup opens normally

Imported from https://dev.vaadin.com/ issue #16251

Originally by @alvarezguille

Value and format are set this way:

        cell = spreadsheet.getCell(13, 4);
        cell.setCellValue(new Date());
        short df = spreadsheet.getWorkbook().createDataFormat()
                .getFormat("m/d/yy h:mm");
        CellStyle style = spreadsheet.getWorkbook().createCellStyle();
        style.setDataFormat(df);
        cell.setCellStyle(style);

To reproduce double click on the border of the column header to automatically adjust the width.
The new width will fit the numeric value and not the formatted value.

Imported from https://dev.vaadin.com/ issue #16257

Originally by @tmattsso

While copying and pasting to other apps is tricky, we should start by enabling copypaste inside the spreadsheet. Using a simple HTML model might be the simplest, we should be able to reuse this when implementing excel pasting too.

feature wishlist

• cell formatting
• cell alignment
• cell formulas

Imported from https://dev.vaadin.com/ issue #15252

Originally by @tmattsso

Editing is already disabled, but it would be good if developers could e.g. show a warning to the user. Add generic event for when user tries to edit locked cell.

Imported from https://dev.vaadin.com/ issue #15223

Originally by @tmattsso

If a row is hidden, values are rendered as they would if the row was normal (so next row). Row index is hidden correctly.

Might need checks in selection, navigation, etc.

Imported from https://dev.vaadin.com/ issue #15455

Originally by @tmattsso

Current spreadsheet doesn't have a place where to display info about the sheet, eg sum total of the selected cells. Add a label to the bottom right corner.

Imported from https://dev.vaadin.com/ issue #15292

Originally by @tmattsso

The other visual elements make the triangle very hard to see. Reconsider CSS, or simply move the triangle above?

In excel, selecting the cell makes it a bit difficult to see the triangle too.

Imported from https://dev.vaadin.com/ issue #16466

Originally by @tepi

IE11: when the input is stopped by clicking to another cell it is no longer possible to enter values anywhere

Imported from https://dev.vaadin.com/ issue #15531

Originally by @tepi

If you select one cell, depress Shift and then keep the down arrow pressed for a while, the scroll position jumps between start and end of selection range once the selection becomes larger than can fit on one screen height.

Imported from https://dev.vaadin.com/ issue #15528

Originally by @alvarezguille

when dragging a formula cell it's needed to enter and exit edit mode of the cell content in order to see the calculated value

Imported from https://dev.vaadin.com/ issue #16185

Originally by @tepi

Currently an exception is thrown.

Imported from https://dev.vaadin.com/ issue #15523

Originally by @tmattsso

Currently Spreadsheet only support font and color settings, customer needs borders as well. Go through current border formatting and see if it can be used for dual purposes.

Imported from https://dev.vaadin.com/ issue #15541

Originally by @tepi

Imported from https://dev.vaadin.com/ issue #16344

Originally by @tepi

PopupButtons should open their menus with the top-right corner at the cell’s bottom-right corner

Imported from https://dev.vaadin.com/ issue #15521