odoo / o-spreadsheet Goto Github PK

Merge A1 and A2, put full border on it, the bottom is not displayed

• Use offsetX instead of clientX
• Select an entire row
• Select the entire sheet
• Row resizing
• Multi-selection with CTRL
• Boundaries for resizing
• Multi-selection resizing
• Multi-selection with drag
• Double click on to resize
• Multi-selection with shift

In A1:

• =WAIT(
• Select A2
• Press right arrow
• Press 3 times backspace
  => A2 is still highlighted

0.33 - 0.24 

maybe we need some smarter way of handling numbers...

when entering a formula, it would be nice to point & click at cells/ranges to fill the parts of the formula.
this means that the formula needs to be parsed as the user types to know if he is entering a cell reference at the caret position (I didn't check if it was the case already)

• mouse
• keyboard
• Select entire column/row

when writing on the rightmost cell of the screen, if the user writes more than the space available in the current cell, the scrollbar gets offset by the size of the input that is extended.

• color of token
• color referenced cells in the same color as the token
• color the ranges
• color know types (bools, strings, functions)

when adding a new sheet, the focus should be put on the new sheet, otherwise we cannot interact with the keyboard

https://stackoverflow.com/questions/34931732/height-limitations-for-browser-vertical-scroll-bar

after X pixels, we should use a ratio instead of the exact value

Scenario:

1. edit a cell, enter =Sum(
2. select a range with the mouse
3. press enter

Result: bad expression

Expected: a closing parenthesis is added. Note: it works in Google Sheets

To reproduce:

1. have a long text in a cell (larger than the cell)
2. select the cell, press enter (input is correct size)
3. unselect the cell, reselect, then type something: input has incorrect size

Select A1
Press CTRL
Select A2
=> OK
Select A1
=> A1 is still selected

1. add large number in cell, it goes out of its cell, in right cell. Then write something in right cell, it overlaps

2. same with text, if right cell is right aligned

Scenario:

1. edit a cell, enter =
2. select with mouse another cell, let's say A1
3. the text A1 is now selected! this is wrong
4. press +, this removes A1

Expected: pressing + should add + after A1.

Note: this works in Google Sheets

remove hardcoding of default style for the cells, take defaults from a style (ex. style 0)

This will allow to change the default look for all cells

that little caret you can drag to create new values