Hi

Does the kendo spreadsheet support conditional formatting / data bars (which are the background bar charts on a cell)...

See example below - and attached simple xlsx (in zip)

which in excel you add like

If not currently supported as standard, any suggested workarounds?

Thanks

Chris

The images inside the editor Widget are resizable only when using Firefox. It would be great if the resize option for images is also available for other "big" browsers like Chrome, Safari and IE. I'm aware of the thread that says that only Firefox supports image resizing by default. This could be implemented independent of supporting it by browsers. Many other (opensource) editors like tinymce support that feature by default, that could be implement by Javascript instead of waiting for other browsers supporting it.

Add 'Select All' checkbox on top of the column list in ColumnMenu so that it is easier to select all or none of the columns of the grid.

Taken from the StackOverflow question 'Why does 'show' event on Kendo View fire twice?' https://stackoverflow.com/questions/56266538/why-does-show-event-on-kendo-view-fire-twice

If a Kendo View is rendered into a Layout (using layout.showIn()), the show event for the view fires twice. Interestingly, if the view is rendered directly into a DOM element (using view.render()) the event is only fired once, like it's supposed to.

The code is pretty well copied from the Kendo UI Dojo thingee. I wonder if can you run this :https://dojo.telerik.com/AkOwiMAZ/2

<div id="app"></div>
<script>
var foo = new kendo.View("<span>Foo</span>", { hide: function() { console.log("Foo is hidden now"); }, show: function() { console.log( "Foo is shown now"); }});

var layout = new kendo.Layout("<header>Header</header><section id='content'></section><footer></footer>");

// Creating the layout, and using the showIn method to render the view
// is where I'm having the issue (2 'show' events fire)
layout.render($("#app"));
layout.showIn("#content", foo);
//
// But this way works fine (rendering directly to a DOM element) (just // one 'show' event fires)
//foo.render('#app');
</script>

1. Navigate to: https://dojo.telerik.com/AJoVUwen/2
2. Click setOptions button multiple times.
3. Sort some column

Result: The old events handlers are not cleared(see the console).

We recently upgrade Kendo UI from version v2019.1.220 to 2019.2.619 and our user base is freaking out because they can't select the text on web pages that use the splitter. 

https://dojo.telerik.com/IbARuWod

When the Kendo UI Treelist is horizontally scrollable and a filter is applied which returns no items, the scrollbar disappears. Therefore, if the column is one of the hidden ones, it would be impossible to navigate to it in order to clear the filter. 

A Dojo sample for the reproduction of the issue:

https://dojo.telerik.com/IQuHuNej

Bug report

The Toolbar's overflowAnchor property is missing from the Kendo typing definitions. It is also not available in the Toolbar's API.

Reproduction of the problem

Current behavior

Typing definitions for overflowAnchor are missing.

Expected/desired behavior

The overflowAnchor property should be available for the Toolbar and added to the API as well.

Environment

• Kendo UI version: 2019.2.619
• jQuery version: x.y
• Browser: [all ]

The filtering on the spreadsheet component is great!!

There is however one behaviour that causes confusion for end users, and that is filtering when merged cells  are present in the selection.  
An example is available in the following dojo:
https://dojo.telerik.com/UzUMUDos

Open the dojo and filter column A on a1 and you will only see only b1 in column B, but the b1a will not be shown.

To be clear - This is also how Excel behaves...  (which is of course your prime aim so its not a bug as such)... 
Interestingly google sheets stops you putting filter on merged cells / stops you merging on filtered column.

The Excel behavior is discussed in the following threads:
https://stackoverflow.com/questions/49816515/excel-filtering-for-merged-cells
https://www.officetooltips.com/excel_2013/tips/workaround_for_sorting_and_filtering_of_merged_cells.html

Is it possible to implement something, so the end user experience would be improved? Maybe when merged cells are present :
a) if they click filter, this is detect and user is warned of this behaviour
b) if they click filter, the sheet is changed into an unmerged version (which repeats data in merged cells) as in the excel examples above.

Bug report

When exporting a diagram as a PDF, hidden shapes still visible. 

Reproduction of the problem

1. Run this dojo - https://dojo.telerik.com/oRUPUHOb/4
2. Click on "Mask" button
3. Click on "Save as PDF"
4. Open the exported PDF file

The shape State 1 must not be present on the exported PDF

When the grid is configured for InCell editing and frozen columns, it is expected the first editable cell to be opened for editing when a new record is added. 

However, when there is not an editable cell in the locked columns, it would not search in the main content. Here is an example:

https://dojo.telerik.com/ucEraQOW

A temporary workaround would be to override the editModel function and check in the second table as well:

https://dojo.telerik.com/aJEsAnud

When using IE 11 and using Ctrl+X to cut, this only works the first time. All subsequent attempts to use cut produce the following dialog:

Bug report

Reproduction of the problem

Dojo example.

Current behavior

The mobile material theme does not apply specific styles to a button that has the "km-primary" class. Compare to the Nova mobile theme, which does have specific rules that use ".km-primary" selector.

Expected/desired behavior

CSS rules that use the ".km-primary" selector should be added to the theme.

Environment

• Kendo UI version: 2019.2.619
• jQuery version: x.y
• Browser: [all]

Hi,

we found a hard to reproduce bug in the combobox control. It appears infrequently while typing in the combobox input, if the combobox has grouping and the fixed header enabled. It does not seem to have functional implications to the control but it produces a javascript error.

Stacktrace:

_firstVisibleItem: function () {
    for (var t = this.element[0], n = this.content[0], i = n.scrollTop, r = e(t.children[0]).height(), o = Math.floor(i / r) || 0, a = t.children[o] || t.lastChild, s = a.offsetTop < i; a; ) if (s) {
      if (a.offsetTop + r > i || !a.nextSibling) break;
      a = a.nextSibling
    } else {
      if (a.offsetTop <= i || !a.previousSibling) break;
      a = a.previousSibling
    }
    return this._view[e(a).data('offset-index')]
  }

It seems to be a timing problem where the list is already loading again while the scroll from the item selection is not finished.

How ironic that other controls have capability on grouping while the listbox is the solely exception. Hope you can include this on the next build.

We have a client that recently brought to our attention the fact that he found a case where he couldn't place his cursor in a certain spot of a formula, click a cell, and have it fill that cell in. It works if you try to do that for the first cell listed in the formula, but not the rest. I've outlined a sample case below.

You can enter a formula in a cell like =IF(A2+B2, 1, -(A2+B2), 2). Then, highlight a cell, like A2 below, and delete it by hitting backspace or delete.

After hitting delete, leave the cursor in the same location of the formula and click a new cell, like A4.

For this case, since it's the first cell in the formula, it will insert the cell you just clicked on in the correct location. However, next try highlighting the next cell referenced, hitting delete, and clicking on a new cell to have it insert the cell into the formula. In this case, we highlighted and deleted B2, then tried to click on B4.

You'll see that, for this one, instead of inserting B4, it gives an error message. Our client said that it significantly slows him down when he has to manually type in each change to the formula, so is there any way we could have it insert the cell you click on for all cases? It doesn't look like this is a current feature, so would you be able to add it, please? Thank you!