Bug report

When defaultCellStyle is used the configured font is applied to the cells in the Spreadsheet. However, the font is not applied when adding new rows.

Reproduction of the problem

1. Open the Dojo.
2. Enter some text in the cells
3. Insert a new row
4. Enter text in the newly inserted row.

Current behavior

The configured font in the defaultCellStyle is not taken into account. The font in the newly inserted row is Arial 12, while in the example it should be 'Courier New' 18.

Expected/desired behavior

The font configured by using the defaultCellStyle option should be applied to all cells in the Spreadsheet, even if inserted after initialization.

Environment

• Kendo UI version: 2022.1.412
• Browser: [all ]

Bug report

When pasting content to a Spreadsheet that has only one column(columns: 1), the data is not pasted in the targeted cell and a JS error appears in the browser's console.

The issue appears only in scenarios where the columns configuration is set to 1.

• The reported behavior is a regression bug introduced in 2021 R1 SP1 - version 2021.1.224
  Here is a Dojo example with 2021 R1 in which the described above issue is not replicable.

Reproduction of the problem

1. Open this project and run it
2. Copy random text
3. Select a random cell(do not double click the cell) and press Ctrl + V to paste the copied content

Current behavior

No data is pasted in the selected cell and the below error appears in the console:

Expected/desired behavior

The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.

Environment

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

Hi Admin,

 I made the DIV where I had the Spreadsheet widget in full screen mode by: document.fullscreenElement.  I have some validations configured in the spreadsheet.  Apparently, in full screen mode, the prompt opens behind it.  Is there a way I can do an "appendTo" to the validation prompt?

Please advise.

Thank you very much.

Best Regards,

Jenny

Hello

When we have filtered rows in a spreadsheet (some rows are hidden) and we copy a single cell and paste into a range containing the hidden rows....

The spreadsheet copies the value into all cells in the range including those that are hidden.  This is not the same functionality as Excel.

That said, is the any way to skip hidden cells in the paste range?

Is there a way to override the Kendo past function to do this?  Can you provide an example?

Thank you

Jeffrey Suffet

Bug report

Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/UwexICot/4

Current behavior

The value of the B1:B2 merged cell is not displayed.

Expected/desired behavior

The value of the B1:B2 merged cell should be displayed.

Environment

• Kendo UI version: 2022.1.119
• Browser: [all]

Bug report

When trying to select multiple cells in Spreadsheet, an error "n._ref.height is not a function" occurs.

Regression introduced with R3 2021.

Reproduction of the problem

1. Open this demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Try to select multiple cells using CTRL.

Current behavior

An error "n._ref.height is not a function" occurs and cells are not selected.

Expected/desired behavior

No error should occur and cells should be selected.

Environment

• Kendo UI version: 2022.1.119
• Browser: [all]

Hi there,

I'd love the ability to specify regex validation for the spreadsheet component. I saw a forum post (https://www.telerik.com/forums/spreadsheet-regex-validation) someone else had made relating to this, but couldn't find a feature request made based off of it.

(taken from the post) Ideally it'd look something like this:

var columnSens = spreadsheet.activeSheet().range("A2:A10");

columnSens.validation({
  dataType: "custom",
  from: 'REGEX("^(()|((?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[^\da-zA-Z]).{8,60}))$")',
  type: "warning",
  allowNulls: true,
  titleTemplate: "Invalid Password",
  messageTemplate: "Passwords must be between 8 - 60 characters long and contain the following: 1 number, 1 uppercase letter, 1 lowercase letter, and 1 special (non letter or number) character."
});

Hi Team,

I'd like to request the functionality to be able to filter null and whitespace items more easily with the built-in API for the Kendo UI Spreadsheet. 

Thank you!

Describe the bug
When the Spreadsheet has locked columns and columnWidth is set, but the width of the locked exceed the width of the Spreadsheet, the widget is not rendered correctly.

To reproduce
Steps to reproduce the behavior:

1. Run the Dojo - https://dojo.telerik.com/@NeliKondova/aXUvAKeB

The columns of the Spreadsheet are visible even outside of the component.

Expected behavior
The columns should be limited to the Spreadsheet width

Affected package (please remove the unneeded items)

• theme-default
• theme-bootstrap
• theme-material

Affected suites (please remove the unneeded items)

• Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

• All

Currently, the Spreadsheet does not appear and does not function properly when the 'k-rtl' class is applied.

Dojo

Please provide Right-To-Left support for the Spreadsheet widget. 

Hi Team,

I would like to request the Kendo UI Grid to improve performance when evaluating multiple formulas.  At this point, if I use a formula on multiple rows(over 1500 rows), the page slows and eventually crashes.  This happens when I use the fromFile method too.  

Thank you for the consideration!

In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell.  Next I name the single cell D5, and call it MyAnswer.  I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.

Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.

Can you please advise when this issue will be fixed in Telerik.

I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".

Thank you so much.

Hello,

When spreadsheet cells are merged and have comment, it's shown only when hovering over first cell and not shown when hovering over other cells of the merged group of cells

Example to reproduce on dojo - https://dojo.telerik.com/@Andrii/uHINuvIh

On the cell A1 there is a comment, merged cells are A1:G1, comment is shown only when hover over cell A1.

Hi

We have noticed that spreadsheet filter box (click on filter down arrow) didnt appear when clicked on certain environment (win10, surface pro 7), but works on others.

What happens is you click the down arrow, a scroll bar appears on rhs, which i think is suggesting the popup has positioned soemwhere off visible area.

This happens in each browser - edge (94.0.992.50 ), chrome (95.0.4638.54 ) and firefox (93.0). Plug ins disabled.   Windows 10.0.19043

Wondered if about high res screens or display settings?

Recreated with kendo demo 

https://dojo.telerik.com/aruPOzEx

then tried each kendo version going back in time, and basically version 2020 R2 SP1 it worked (see attached working.. shot), and anything since it fails. 

In the shots i am clicking on company filter arrow.   the failversion-before is before i click, failversion-after is after click - where you can see extra vertical scrollbar

Regards

Chris

### Bug report

When the property "useCultureDecimals" is enabled in a culture where the decimal separator is the comma, the function Text() does not format numbers correctly.

### Reproduction of the problem

1. Set a culture where the decimal separator is the comma (i.e. "da-DK");

2. Create a Spreadsheet and enable the property "useCultureDecimals";

3. Enter a number with a decimal separator comma (i.e. "0,1141");

4. Format the cell by using the Text() function ( =TEXT(A1; "##0,00%") );

5. The number is not formatted properly - "011%"

A Dojo sample for reproduction: https://dojo.telerik.com/AsiLiKil/12

### Expected/desired behavior
"0,1141" should be formatted as "11,41%" as in Excel.

### Environment

* **Kendo UI version: 2021.3.914
* **jQuery version: 1.12.4
* **Browser: [all]

Hi,

There are multiple formats for date and time in kendo and in different cultures the count increases. Is there a function in which i pass spreadsheet cell value and format and it returns that it is a date format or number format. I just want to know the type of format so i can parse the dates on my own from json on server side.

Regards,
Faraz

Bug report

When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.

Reproduction of the problem

1. Go to the Basic Usage example - https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Enter "SS0012" as value in a random cell.
3. Grab the handle at the bottom right of the cell and drag down.

Current behavior

The value entered for the cells below is SS13, SS14 etc.

Expected/desired behavior

The value entered for the cells should be SS0012, SS0013 etc.

Environment

• Kendo UI version: 2021.3.914
• Browser: [all]

In my application I am using the following. 

kendo.ns="kendo-";

Dojo example: https://dojo.telerik.com/@iankodj/aKIyEwUv 

The spreadsheet component works well with the namespace, however any dialogs that the component opens do not function correctly.

For example, I am using Edge browser. If I copy a cell and they try and past the value via the context menu, a dialog appears telling me to use the keyboard.

The "ok" button of the dialog does not work. Looking at the html source that is added to the DOM, it appears that the button is trying to bind to the click event via a "data-bind" attribute rather than a "data-kendo-bind" attribute as specified via the namespace.

The attached file show the behavior with the Basic demo example having the kendo namespace set.

Thanks,

Darin