jbishop
(Jbishop)
March 25, 2020, 3:05pm
1
Hello,
I am trying to add custom classes to certain rows and group them together based on the value in column in “Job Number”
If multiple rows have a “Job Number” equal to each other, than all rows with that job number are grouped together. I have made a static mock up of the data being “grouped” together (but just by making a static JSON structure).
Here are some screenshots of the data…https://imgur.com/a/0HmCwTu
I would like to add a custom class to add to them as well like “job_group” so that I can add padding or an additional blank row between each job group.
Is something like this possible?
jbishop
(Jbishop)
March 25, 2020, 3:29pm
2
Actually, I think nested rows will accomplish most of what I want. Can you style nested rows based on classes that are assigned to them?
Also, nested rows is listed in experimental features? Is this going to become an official feature soon? I’m concerned if I build a system that uses this (and buy a license) that the feature could be taken away in the future. It is a pretty critical feature that I need.
I’ve got the nestedRows feature working mostly…but it renders weird…
Before…https://imgur.com/3RRyqhd
After clicking the +…https://imgur.com/lRE6mbq
Any idea why it is rendering like this?
Hi @jbishop
here’s a demo for parent styling Handsontable example - JSFiddle - Code Playground
Also, nested rows is listed in experimental features? Is this going to become an official feature soon?
It is experimental as it does not support some other features like sorting. Now, when you sort a column the children will change their parents. Nevertheless, in version 8.0.0 (next one) all the indexing issues that relate to this plugin should be fixed.
I recommend checking the following example with those resources
https://cdn.jsdelivr.net/gh/handsontable/handsontable@release/8.0.0-beta.1/dist/handsontable.full.css
https://cdn.jsdelivr.net/gh/handsontable/handsontable@release/8.0.0-beta.1/dist/handsontable.full.js
It’s the beta version of the next version we’ll publish. It fixed more than 130 issues
opened 06:19PM - 13 Nov 19 UTC
closed 12:29PM - 31 Aug 20 UTC
Epic
### Description
Various tasks that we want to address before releasing v8.0.0… .
* [x] handsontable/handsontable#5751 indexMappers without hiddenIndexes
* [x] handsontable/handsontable#6178 Extend indexMapper with hiddenCollection
* [x] handsontable/handsontable#6178 hiddenColumns plugin refactor to use IndexMapper
* [x] handsontable/handsontable#6204 Remove the connection between collapsibleColumns and hiddenColumns plugins
* [x] handsontable/handsontable#6177 hiddenRows plugin refactor to use IndexMapper
* [x] handsontable/techwrite#4 Update documentation and examples
* [x] remove `beforeChangeResult` as a function check and warning (Handsontable v0.12 was a very long time ago)
* [ ] [#4-PR](https://github.com/handsontable/techwrite/pull/4) Prepare migration guide for breaking changes
* [x] [#6541-PR](https://github.com/handsontable/handsontable/pull/6541) Remove "experimental" tag from `ganttChart`, `formulas` and `nestedRows`
* [x] Deprecate IE support. Remove IE from the documentation.
* [x] [#6541-PR](https://github.com/handsontable/handsontable/pull/6541) Deprecate `observeChanges` plugin. Add a console warning when the plugin is enabled.
* [x] [#6541-PR](https://github.com/handsontable/handsontable/pull/6541) Deprecate `ganttChart` plugin. Add a console warning when the plugin is enabled.
* [x] Remove `post-install` warning about v7.0.0 MIT license change. handsontable/handsontable#6608
* [x] Update README.md logo and screenshot for HiDPI screens (Retina) handsontable/handsontable#6609
* [x] Add a warning messege for removed hooks:
`Plugin hook "modifyRow" was removed in Handsontable 8.0.0. Please consult release notes <link> to learn about the migration path` handsontable/handsontable#6613
* [x] Update deps handsontable/handsontable#5159, handsontable/handsontable#6610
* `moment.js` to `2.24.0`5674
* `pikaday` to `1.18.0`
* `numbro` to `2.1.2` (check minified build handsontable/handsontable#5790)
* [x] handsontable/handsontable#6525 Remove helpers that cover IE8 or not needed anymore
### After code freeze
* [ ] Check performance and compare with 7.x.x branch
### Checklist
1. * [x] handsontable/handsontable#2685 `columnSorting` should work without `observeChanges`
1. * [x] handsontable/handsontable#3328 beforeColumnResize and beforeRowResize first argument is column width
1. * [x] handsontable/handsontable#3568 `manualMoveRow` don't work after `loadData`
1. * [x] handsontable/handsontable#3726 Cannot Navigate Past Hidden Column Using Keyboard if hot.updateSettings is Called in AfterSelection
1. * [x] handsontable/handsontable#3770 Rendering issue on column udpate with updateSettings
1. * [x] handsontable/handsontable#3809 CRUD operations should work with `columnSorting` and `loadData`
1. * [x] handsontable/handsontable#3914 & handsontable/handsontable#5133`nestedRows` should work with `InsertRow`, `RemoveRow` operations,
1. * [x] handsontable/handsontable#3924 сolumnSummary does not work with columnSorting and context menu
1. * [x] handsontable/handsontable#3937 `Blank Rows in Middle of Grid [PRO]`
1. * [x] handsontable/handsontable#3958 DataSource.countColumns returns invalid number of columns for nested objects.
1. * [x] handsontable/handsontable#3978 afterOnCellMouseDown returns coords (0,0) after click on the topleft corner
1. * [x] handsontable/handsontable#4121 `hiddenColumns` settings are reseted after `updateSettings`
1. * [x] handsontable/handsontable#4154 formulas not init with nestedRows
1. * [x] handsontable/handsontable#4176 Headers doesn’t export with exportToFile in the specific case
1. * [x] handsontable/handsontable#4181 using 'hiddenColumns' and 'stretchH' shows a unnecessary horizontal scrollbar when there is enough space
1. * [x] handsontable/handsontable#4204 Using loadData on an object data doesn't work
1. * [x] handsontable/handsontable#4233 Drag down: can't return back to the original cell
1. * [x] handsontable/handsontable#4360 When changing cell type, cell editor does not dynamically change
1. * [x] handsontable/handsontable#4370 If the last column is a hidden column and stretchH is enabled, last column is being displayed
1. * [x] handsontable/handsontable#4381 `updateSettings` performance is very low because of `hiddenColumns`
1. * [x] handsontable/handsontable#4441 Allow cancelling of autofill in the beforeAutofill hook
1. * [x] handsontable/handsontable#4442 Filtering is using wrong indexes
1. * [x] handsontable/handsontable#4470 Wrong value after column move
1. * [x] handsontable/handsontable#4480 `updateSettings` in `afterColumnMove`
1. * [x] handsontable/handsontable#4501 afterRowMove hook returns improper target parameter
1. * [x] handsontable/handsontable#4553 `manualColumnFreeze` should work without `manualColumnMove`
1. * [x] handsontable/handsontable#4567 `recordTranslator` shouldn't return `null` - need more test
1. * [x] handsontable/handsontable#4576 \[0.27.0+\] Data not render when use manualRowMove and minSpareRows
1. * [x] handsontable/handsontable#4601 `manualColumnFreeze` should work with `columnSorting`
1. * [x] handsontable/handsontable#4666 Manual column width doesn't follow column if we insert / remove column
1. * [x] handsontable/handsontable#4713 Row moving doesn't work with column sorting when PersistentState is enabled
1. * [x] handsontable/handsontable#4716 Collapse not working correctly when using custom cell rendrers
1. * [x] handsontable/handsontable#4793 Cell type cannot be changed via setCellMeta
1. * [x] handsontable/handsontable#4897 Improper selection after insert column/row when mergeCells is enabled.
1. * [x] handsontable/handsontable#4926 `manualColumnMove` doesn't work when `data` object is empty
1. * [x] handsontable/handsontable#4999 `collapsibleColumns` doesn't work with `columnSorting`
1. * [x] handsontable/handsontable#5000 Incorrect data is returned after undoing the remove column option
1. * [x] handsontable/handsontable#5065 Common rowsMapper for `columnSorting` `manualRowMove` and `trimRows` - nothing to test
1. * [x] handsontable/handsontable#5068 Refactor `manualRowMove` - nothing to test
1. * [x] handsontable/handsontable#5112 Global index mapper (EPIC, nothing to do here)
1. * [x] handsontable/handsontable#5159 Update deps
1. * [x] handsontable/handsontable#5173 problem with afterColumnMove
1. * [x] handsontable/handsontable#5178 `manualRowMove` should work with `filters`
1. * [x] handsontable/handsontable#5200 `manualColumnMove` doesn't modify the `columns` in `updateSettings`
1. * [x] handsontable/handsontable#5207 Persisted manualColumnMove not restored when using loadData()
1. * [x] handsontable/handsontable#5208 Filtering results in blank rows
1. * [x] handsontable/handsontable#5244 loadData() breaks column filters
1. * [x] handsontable/handsontable#5328 Update data doesn't work with collapsed/trimmed rows?
1. * [x] handsontable/handsontable#5369 Handsontable colHeaders gets NaN on loadData
1. * [x] handsontable/handsontable#5388 Add `beforeSetCellMeta` hook with an ability to cancel the changes
1. * [x] handsontable/handsontable#5571 `hiddenColumns` doesn't work with `columnSorting`
1. * [x] handsontable/handsontable#5591 The "manualColumnMove" operation affects the column order of data loaded by "loadData".
1. * [x] handsontable/handsontable#5598 \[8.0.0.-rc1\] `manualColumnMove` should work with `hiddenColumns`
1. * [x] handsontable/handsontable#5704 hiddenColumns option interferes with keyboard movement.
1. * [x] handsontable/handsontable#5707 Filter causes Minsparerows to have problems
1. * [x] handsontable/handsontable#5753 Nested rows bad state after changing data
1. * [x] handsontable/handsontable#5771 getSourceData functions return wrong data for nested rows
1. * [x] handsontable/handsontable#5792 Expand collapsed column, is expanding also 'child' collapsed columns, except the first child
1. * [x] handsontable/handsontable#5794 ColumnSummary: Extra row + unchangeable values
1. * [x] handsontable/handsontable#5817 Hiding first rows bug
1. * [x] handsontable/handsontable#5824 `skipColumnOnPaste` is broken with `columnSorting` enabled
1. * [x] handsontable/handsontable#5849 [2.0.0+] Scrolls to the end when columns are updated such that the selected column is removed
1. * [x] handsontable/handsontable#5860 `trimRows` should work with `moveRow`
1. * [x] handsontable/handsontable#5861 currentColClassName doesn't work properly with nestedHeaders
1. * [x] handsontable/handsontable#5862 `trimRows` does not work with `minSpareRows`
1. * [x] handsontable/handsontable#5871 Hiding columns affect selection of hidden columns
1. * [x] handsontable/handsontable#5874 nestedRows does not allow to keep rowHeaders after collapsing
1. * [x] handsontable/handsontable#5875 `collapsibleColumns` should work without `hiddenColumns`
1. * [x] handsontable/handsontable#5877 hiddenColumns doesn't work properly with autoWrapRow/autoWrapCol
1. * [x] handsontable/handsontable#5881 When we hide first column on IE we get double border for top left corner
1. * [x] handsontable/handsontable#5882 Indexes of `nestedHeaders` are not recalculating after remove/add column
1. * [x] handsontable/handsontable#5883 `hiddenColumns` plugin unsets cell's `renderer`
1. * [x] handsontable/handsontable#5889 `nestedRows` should work with `filters`
1. * [x] handsontable/handsontable#5890 `filters` should work with `columnSorting`
1. * [x] handsontable/handsontable#5900 Wrong position of buttons in nestedRows after use detach from parent
1. * [x] handsontable/handsontable#5906 Selection of a whole row does not happen consequently after selecting a row header.
1. * [x] handsontable/handsontable#5909 `hiddenColumns` stores visual indexes, should use physical
1. * [x] handsontable/handsontable#5915 `trimRows` should work with `filters`
1. * [x] handsontable/handsontable#5931 `manualColumnMove` doesn't work when `columns` count is different from array of objects properties count
1. * [x] handsontable/handsontable#5953 `trimRows` should work with `startRows`
1. * [x] handsontable/handsontable#5956 `columnSorting` is not working correctly with `loadData`
1. * [x] handsontable/handsontable#5999 handsontable 7.0.2 context menu issue with multiple selected rows in case of 1st column hidden
1. * [x] handsontable/handsontable#6005 afterColumnMove/beforeColumnMove doesn't tell you where the columns move to
1. * [x] handsontable/handsontable#6035 The function loadManualRowHeights is return a array, but in the typescript .d.ts file it is defined as void
1. * [x] handsontable/handsontable#6051 Wrong cell meta removed when deleting rows
1. * [x] handsontable/handsontable#6058 getSourceData functions return wrong data for `nestedRows`
1. * [x] handsontable/handsontable#6066 move multiple rows with `nestedRows`
1. * [x] handsontable/handsontable#6086 Once we enable columnSorting we cannot run the merge() method
1. * [x] handsontable/handsontable#6088 Duplicated rows while using `manualRowMove` with improper index
1. * [x] handsontable/handsontable#6113 We can show columns/row when they're all hidden
1. * [x] handsontable/handsontable#6186 Bug with scrollbar and dimension calculation in Firefox
1. * [x] handsontable/handsontable#6193 Add hooks to collapsibleColumns plugin
1. * [x] handsontable/handsontable#6167 JSON data with empty value will lose some double quotes when pasted into a cell
1. * [x] handsontable/handsontable#6177 Adjust HiddenRows to new IndexMapper architecture
1. * [x] handsontable/handsontable#6181 Row selection ignores columns that are hidden at the end
1. * [x] handsontable/handsontable#6204 CollapsibleColumns should no longer use HiddenColumns plugin
1. * [x] handsontable/handsontable#6218 When we again on the same cell with RMB we get a browser menu
1. * [x] handsontable/handsontable#6224 Can't hide rows and merge cells at the same time
1. * [x] handsontable/handsontable#6278 Filters and `minSpareRows` problems at the same time - additional error fixed
1. * [x] handsontable/handsontable#6295 updateSettings can not update tableClassName
1. * [x] handsontable/handsontable#6300 doesn't work with columnSummary when plugin tries to create a row
1. * [x] handsontable/handsontable#6309 Set data at *physical* row instead of visual. **setSourceDataAtCell was added**
1. * [x] handsontable/handsontable#6310 Visual indexes are wrong when using trimRows and columnSorting
1. * [x] handsontable/handsontable#6332 Lost readonly property if I ask confirm in beforeRemoveCol or beforeRemoverow
1. * [x] handsontable/handsontable#6334 Inconsistent selection using the right mouse button for first row/column
1. * [x] handsontable/handsontable#6346 Missing typings for `instance.undoRedo`
1. * [x] handsontable/handsontable#6347 Typing mismatch for `Handsontable.plugins.ContextMenu`
1. * [x] handsontable/handsontable#6355 We're not able to move column when all columns are selected by ctrl + a
1. * [x] handsontable/handsontable#6363 minSpareCols with undo adds too many columns
1. * [x] handsontable/handsontable#6371 Some classes for table are missing if one of them is empty
1. * [x] handsontable/handsontable#6376 Hiding rows while there is a merged area involved causes data shifting and
1. * [x] handsontable/handsontable#6381`walkontable.css` and `handsontable.css` stylesheets are not in sync
1. * [x] handsontable/handsontable#6386 Wrong selection area after sorting with hidden rows
1. * [x] handsontable/handsontable#6412 After removing column rowHeaders stay improperly
1. * [x] handsontable/handsontable#6413 colHeaders order is not updated after manual move with empty object data source
1. * [x] handsontable/handsontable#6426 When we define data with more data than used in `columns` we cannot `show column` once it's hidden
1. * [x] handsontable/handsontable#6430 The `afterRowResize` hook shares unbelievable results in the 2nd parameter
1. * [x] handsontable/handsontable#6432 Can't detach from parent
1. * [x] handsontable/handsontable#6433 Undoing removing nested row doesn't work
1. * [x] handsontable/handsontable#6435 Manual row resize handler throws an error when bottom rows overlay is enabled
1. * [x] handsontable/handsontable#6463 colHeader is truncated after moving hiddenColumn
1. * [x] handsontable/handsontable#6477 customBorders plugin is missing in the definition file
1. * [x] handsontable/handsontable#6514 PreventOverflow feature doesn't work if multiColumnSorting plugin is enabled
1. * [x] handsontable/handsontable#6539 beforeRowMove args have wrong types
1. * [x] handsontable/handsontable#6548 `getByRange` for sourceData doesn't work properly with nested object data.
1. * [x] handsontable/handsontable#6557 Hidden (last) column is visible upon resizing Columns
1. * [x] handsontable/handsontable#6559 readOnly for column is erased (does not apply) if we use filters
1. * [x] handsontable/handsontable#6575 Old CSS classes are not removed after updateSettings
1. * [x] handsontable/handsontable#6595 [8.0.0] Hidden Indexes refactor
1. * [x] handsontable/handsontable#6600 We're not able to align cells if the selection is made upward
1. * [x] handsontable/handsontable#6664 Add modifySourceData hook and setSourceDataAtRowProp, setSourceDataAtCell methods
1. * [x] handsontable/handsontable#6668 Column hiding issue after columns moved manually
1. * [x] handsontable/handsontable#6670 Headers are deselected after undoing removing
1. * [x] handsontable/handsontable#6672 Remove `debug` key (key, css, docs)
1. * [x] handsontable/handsontable#6695 columnSummary, Filters and spare rows are causing 'RangeError: Maximum call stack size exceeded'
1. * [x] handsontable/handsontable#6699 [5.0.2] EDGE Dropdown menu onMouseOut event causes critical errors when hovering over vertical scrollbar
1. * [x] handsontable/handsontable#6703 The cell meta is being retrieved using the wrong coordinates
1. * [x] handsontable/handsontable#6755 Double click on the column resize handle does not adjust size correctly
1. * [x] handsontable/handsontable#6756 After enabling false to `beforeAutofill` we should add an additional test.
1. * [x] handsontable/handsontable#6770 Selection skips the highest parent
1. * [x] handsontable/handsontable#6792 Remove old warning
1. * [x] handsontable/handsontable#6831 Incorrect selection after hiding first row
1. * [x] handsontable/handsontable#6840 Wrong union type for `startPosition`
1. * [x] handsontable/handsontable#6842 Backspace in filter by value option does not work initially
1. * [x] handsontable/handsontable#6843 Calling updateSettings changes the index of frozen columns via freezeColumn method
1. * [x] handsontable/handsontable#6881 Bug: Nested headers and hidden columns highlight the next column
1. * [x] handsontable/handsontable#6888 The wrong data in merge cells after the hidden column and additionally an error occurs.
1. * [x] handsontable/handsontable#6904 trimRows and hiddenRows with certain settings break borders
1. * [x] handsontable/handsontable#6928 nestedRows blocks table from loading if data is not provided
1. * [x] handsontable/handsontable#6965 After moving row from bottom to top the row indexes changes if the first row is hiding.
1. * [x] handsontable/handsontable#6973 Keyboard navigation with selection does not work on merged cells
1. * [x] handsontable/handsontable#6974 It’s possible to select hidden column/row.
1. * [x] handsontable/handsontable#6975 Cannot selectAll when the first row is hidden
1. * [x] handsontable/handsontable#6976 Hiding first row causes column headers selection to lack blue highlight
1. * [x] handsontable/handsontable#6977 Hiding first row causes 2nd row to lack a top border
1. * [x] handsontable/handsontable#6978 Incorrect column header highlight when merged cells are unmerged and hiddenColumns are used
1. * [x] handsontable/handsontable#6982 [7.0.0] The editor is moved by 1px when the first row / column is hidden
1. * [x] handsontable/handsontable#6990 ReadOnly state for some cells is lost when we remove rows with trimRows turned on
1. * [x] handsontable/dev-handsontable#376 Undoing column removal causes column headers to lack a header
1. * [x] handsontable/handsontable#7005 We cannot set focus to a column to open context menu after applying a filter
1. * [x] handsontable/handsontable#7020 mergedCells with hidden causes issues with rendering
1. * [x] handsontable/handsontable#7022 Remove GanttChart plugin
1. * [x] handsontable/handsontable#7023 Deprecate HeaderTooltips plugin
1. * [x] handsontable/handsontable#7028 [1.18.0] Too many layers of highlight with noncontinuous selection on merged cells
1. * [x] handsontable/handsontable#7035 NestedHeaders does not allow to define header level as an empty array
1. * [x] handsontable/handsontable#7036 Passing nestedHeaders as a single empty array stops the table from painting
1. * [x] handsontable/handsontable#7043 When we copy and paste a header we get a new empty row when data is hidden
1. * [x] handsontable/handsontable#7045 afterSelectionEnd returns incorrect data when clicking on a column when we have all the rows hidden
1. * [x] handsontable/handsontable#7050 Opening a context menu for a column when its hidden data is selected does not block adding of rows via menu
1. * [x] handsontable/handsontable#7061 Problems with adding rows from the corner when all rows are trimmed
1. * [x] handsontable/handsontable#7074 The row/column resize hooks should not return `null`.
1. * [x] handsontable/handsontable#7076 [2.0.0] Loss of selection after merging from headers
1. * [x] handsontable/handsontable#7095 We are not able to unmerge cells if part of it is hidden
1. * [x] handsontable/handsontable#7097 Clear() method does not work for hidden data
1. * [x] handsontable/handsontable#7099 calling clear() method removes the focus from the table
1. * [x] handsontable/handsontable#7114 Using read-only and alignment from the context menu when all columns are selected is disabled
1. * [x] handsontable/handsontable#6232 trimWhitespace=false and wordWrapping
1. * [x] handsontable/handsontable#7103 Additional, native for macOS editor selection in Firefox 78
1. * [x] handsontable/handsontable#6955 Safari draws different borders than Chrome and FF, when editor is opened
1. * [x] handsontable/handsontable#6788 "Hide" property missing in CustomBorders typings
1. * [x] handsontable/handsontable#6869 Undo: Add support for fixing columns
1. * [x] handsontable/handsontable#6149 Rows cannot be resized to less than rowHeights
#### TODO
* [ ] handsontable/handsontable#7031 Methods `colToProp` and `propToCol` should work properly
* [x] https://github.com/handsontable/angular-handsontable/issues/197 Update Angular wrapper to support v8
* [x] https://github.com/handsontable/vue-handsontable-official/issues/165 Update Vue wrapper to support v8
* [x] https://github.com/handsontable/react-handsontable/issues/189 Update React wrapper to support v8
#### Issues that will NOT be fixed by v8
* ~#4631 Broken height header when use column height and hidden column setting~
* ~#3919 `nestedRows` should work with `ColumnSorting`~
* ~#5525 afterRemoveRow, afterInserRow, afterRemoveCol, afterInsertCol are called before cellMeta is updated~
* ~#5856`nestedRows` should work with `moveRow`~
* ~#6905 We cannot auto fill using db-click if hiddenRows is used~
* ~#6001 Freezing columns do not work with nestedHeaders~
* ~#5125 AutoFill not works will there is a mergedCell in the target area~
* ~#6794 When nestedHeaders are enabled wrong column is removed~
* ~#6787 nestedHeaders blocks rendering of rows if the first row exceeds the viewport~
* ~#6669 Undoing removing hidden rows makes rows exposed~
* ~#5543 Error after update settings rendering twice and picking wrong renderer functions~
* ~#6004 ManualColumnMove dragging breaks after updateSettings()~
* ~#6934 Trimming rows causes the newly added rows by paste to remain~
* ~#6327 Inconsistency with context menu 'Remove columns' option~
* ~#1501 Sorting passing logical index through afterChange event~
* ~#6728 Copy doesn't work when selected hidden column~
* ~#6742 Paste off-by-one after show/hide column~
* ~#6743 Too many values pasted when column is hidden~
* ~#6833 skipColumnOnPaste and skipRowOnPaste when added to table settings hang the browser down after pasting~
* ~#5961 Additional row added during copy/paste operations and with hidden rows/columns enabled~
* ~#6395 Some headers are gone if we hide and show them again~
* ~#6397 Sorting indicator moves incorrectly when adding a column~
* ~#6518 [8.0.0] Moving data isn't working properly, when there are skipped indexes~
* ~#6067 [7.1.0.+] We cannot move nested row to become the last one in the table (related to handsontable/dev-handsontable#165 ?)~
* ~#7062 Idea of highlighting trimmed headers with blue color (active header)~
* ~#6832 Second column selection is misaligned 2 px right~
* ~#6960 When there's only one row of data clicking on a header shortens selection by 1px~
jbishop
(Jbishop)
March 26, 2020, 12:36pm
4
Awesome…any idea when V8 will be released?
If all goes well in April. I will keep you updated.