search

jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.73k stars 825 forks source link

Jexcel CE v5 #1112

Closed pphod closed 4 years ago

pphod commented 4 years ago

Hi Everyone,

We started planning how the new Jexcel CE v5 would look like. Which features do you think should be brought to the new version?

Regards,

whyJoe commented 4 years ago

I hope add a function that the selected cells can be automatically summed!!!

gargri commented 4 years ago

add new function that from one cell change we are able to change other cells

mhstreta commented 4 years ago

add new function to allow adding styles by row number or row index and also by column number or column index. This way it will be much easier to set styles programatically for specific rows or specific columns.

mhstreta commented 4 years ago

add options to hide row and column headers on initialization but context menu and formulas still should work

pphod commented 4 years ago

add new function that from one cell change we are able to change other cells

This already exists by using the onchange or onafterchanges events.

pphod commented 4 years ago

I hope add a function that the selected cells can be automatically summed!!!

Have you tried to use formulas on footers? https://bossanova.uk/jexcel/v4/examples/footers

whyJoe commented 4 years ago

I hope add a function that the selected cells can be automatically summed!!!

Have you tried to use formulas on footers? https://bossanova.uk/jexcel/v4/examples/footers

I mean the cell are selected by user,just sum the selected cell,not a column.

krosoftware commented 4 years ago

Option to move right after Enter is pressed.

yuricaldasr93 commented 4 years ago

Hi everyone. I hope the CE v5 has the events onfilter and onbeforefilter and filter by conditions like below image. Reference link image

flywalt commented 4 years ago

better input for other languages. #935 the scorll bar becomes wider when focused

GBonnaire commented 4 years ago

Add support of plugins like JExcel Pro 😊

GBonnaire commented 4 years ago

add new function to allow adding styles by row number or row index and also by column number or column index. This way it will be much easier to set styles programatically for specific rows or specific columns.

Already available on Pro version with my plugin : https://github.com/Guillaume-Bo/jexcel-plugins-and-editors/tree/master/plugins/conditional_style

pphod commented 4 years ago

Thanks for the feedback. We would consider all requests in the next CE distribution.

Alex-Monahan commented 4 years ago

I think the biggest feature that would help us is cascading filters! It would require multi-column filtering, as well as recalculating the available filter options for all other columns based on what is already filtered.

Alex-Monahan commented 4 years ago

One other small thing would be an option for the scroll bar to show a larger remaining space when using lazy loading instead of going all the way to the bottom before adding new rows (just to indicate to the user that there are still many more rows)

ghost commented 3 years ago

我希望添加一个功能，可以自动将所选单元格加起来！！！

You can do this by selecting the event to get the first and last cell selected, combined with the formula.

muelleRw commented 3 years ago

Being able to select cells not next to each other using ctrl

SamHz commented 10 months ago

dropdown can you add tree type ?