Features of the new Spreadsheet component

UI Components for JSF
Post Reply
JavaFlint
Posts: 13
Joined: 21 May 2015, 18:56

02 Jun 2017, 21:38

As per 6.2 release notes:
"6.2 is planned for end of year and it will contain the new Spreadsheet component that brings excel like functionality to JSF applications."

Can someone give more details about functionality of that "new Spreadsheet component" ?
I'm particularly interested in the frozen columns and vertical/horizontal scrolling.

My issue with current DataTable is what frozen columns these built as a separate table, so when table is scrolled vertically, rows in frozen and non-frozen parts became misaligned for short period of time, which looks bad visually. We are having complains from customers, but nothing can be done really.
This happens in PF 5.3, and 6.0 on IE and Chrome.

BTW, ExtendedDataTable in RichFaces did not have this side-effect (but it had other issues).

Thank you.
PrimeFaces 5.3 community, JBoss EAP6.3, JSF 2.1, JDK 1.7, IE11

Melloware
Posts: 3717
Joined: 22 Apr 2013, 15:48

10 Jun 2017, 15:17

If you need this functionality right now we have written the JSF Sheet: https://github.com/marklcg/jsf-sheet

A JSF Sheet wrapper component around the HandsonTable JS library. You can run a whole demo app for yourself to see the functionality: https://github.com/marklcg/sheetdemo
PrimeFaces Developer | PrimeFaces Extensions Developer
GitHub Profile: https://github.com/melloware
PrimeFaces Elite 13.0.0 / PF Extensions 13.0.0
PrimeReact 9.6.1

jersonaj
Posts: 1
Joined: 25 Oct 2017, 17:16

25 Oct 2017, 17:38

The component is very good, but it does not allow to create columns of dynamic form only statics.

Let's hope that in PF 6.2 comes out the spreadsheet, because in version 6.1 they had thought to present it and in the roadmap of 6.2 they do not mention anything about the spreadsheet.

Melloware
Posts: 3717
Joined: 22 Apr 2013, 15:48

20 Mar 2018, 16:09

PFE Spreadsheet is released and it does allow Dynamic Columns. See this example: https://www.primefaces.org/showcase-ext ... olumns.jsf
PrimeFaces Developer | PrimeFaces Extensions Developer
GitHub Profile: https://github.com/melloware
PrimeFaces Elite 13.0.0 / PF Extensions 13.0.0
PrimeReact 9.6.1

Post Reply

Return to “PrimeFaces”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 30 guests