Can you add feature or set option to allow text to run into adjacent cells to right?
(example in ticket 1500102)
Reproducible in the demos. The attached video demonstrates the issue.
Recording49.zip
As shown in the video, the F column completely disappears. The column letter remains visible within the next column (G). F column's resize handle remains hidden, and it cannot be made visible.
There should be a minimum column width that should be respected on resizing. Its value should always allow the column to be resized. No column overlapping should occur.
when the color of the borderBottom is commented
"borderBottom": {
//"color": "black",
js error when color is not applied a cell of the Spreadsheet
kendo.all.js:61278 Uncaught TypeError: e.transform is not a function
https://dojo.telerik.com/@zdravkov/iVoJuxAZ
export to pdf
js error
the data is exported correctly
Related To: #5500
When there are merged cells and the SUM formula is used for the merged cells the result is wrong (it depends on the count of the merged cells)
The result in the D1 cell is 20. ( value of cell * count of cells in merged range)
The result should be 5. In the same scenario, the result in Excel will be 5.
When importing from Excel in Spreadsheet if a date is entered, but the date format is not set explicitly, the imported date always has the following format: "mm-dd-yy". The issue is observed even if a culture is set.
The value in Excel is "15.6.2020" , but the imported date in the Spreadsheet is "05-15-20" screencast
The format of the dates should be the same as in the imported file.
Values that are copied from Spreadsheet are duplicated when pasted in Excel if before that the copied cells have been cut and pasted inside the Spreadsheet.
In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied
The pasted in Excel content should contain 2 rows instead of 3
Dojo example.
The text in B2 is not unwrapped.
The merged cell prevents the unwrap. If there is no merged cell, or if the tool is used over the cell itself, wrapping/unwrapping works as expected.
The text in B2 is unwrapped.
Hi Team,
I'd like to request a built in method for finding the intersection of ranges for the Kendo UI Spreadsheet.
Thank you
Hi Team,
I would like to request the ability to set an autoFit for the rows/columns(specific or all). This would not just related to wrapping.
For example, in the following Progress Kendo UI Dojo, the user can create 3 lines by button press. But if the user replaces the contents with 1 line of text, it will keep the height of when the 3 lines were in cell.
I know I could use the rowHeight method, but it would be great if there was a way for it to resize automatically.
Thank you for your consideration.
Hi Team,
I'd like to request a way to manipulate a large amount of cell groups in the Kendo UI Spreadsheet without decreasing performance. For example, I'd like to be able to merge/unmerge and change font size to multiple specific cell groups. I understand changing multiple DOM elements at the same time can cause sluggishness, but maybe there's a way to reduce the time. Currently, it's taking a long time to completely load.
Thank you for investigating.
When multiple cells are merged in the Spreadsheet the DatePicker is not always rendered at the correct position.
The DatePicker is not always entirely visible (screencast)
DatePicker should be visible
Hello,
I have some problems with setting up correct Cell Validation for my use-case. I want to create a list validation which is going to have a numeric options instead of typical string values.
So in order to achieve that I created a following cell validation:
{
dataType: "list",
showButton: true,
comparerType: "list",
from: '{1,2,3,4,5}',
allowNulls: true,
type: "reject"
}
Everything works fine in the widget, but the problems starts when I want to Export the following spreadsheet to Excel format. I'm getting the following message when trying to open such file:
In the past I had a similar problem with the list validation (but for string values) (https://www.telerik.com/account/support-tickets/view-ticket/1381434)
There you suggested to create a validation using different format for "from" property. So I decided to change it from:
from: '{1,2,3,4,5}',
to
from: '"1,2,3,4,5"',
After that I can freely export the spreadsheet without any problems, but then my list is inserting string values instead of numeric ones, therefore this solution is not suitable for my use-case.
And my question is: Is there a possibility to create a Cell validation where I can put numeric values as a possible options without breaking the export process?
Here's a example spreadsheet, which I used to reproduce this behavior: https://dojo.telerik.com/IfuMIbic
Best regards,
Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:
let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();
If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).
let dataURL = new kendo.ooxml.Workbook(data).toDataURL();
Dojo example.
The generated Excel file is corrupted
The generated Excel file is not corrupted
Working with numbers like 0.000001056 in a Spreadsheet that is bound to a dataSource, after saving the dataSource, the mentioned number will be converted to an exponential format.
The current feature request is about preventing the format changing after saving decimal numbers.
It will be very useful if we can use the Spreadsheet with dataSource binding but keep the decimal numbers as such, not converting them to exponential expressions.
In the Spreadsheet control for jQuery it is possible to set cells as read-only through the use of the Enable property.
However, on calling saveAsExcel() these cells are editable. This means as a developer it is then necessary to create both the spreadsheet JSON (for Kendo Spreadsheet) as well as another spreadsheet class to export to Excel.
Could you please map the Cell.Enable property to the setting of Excel cells as disabled/read-only. Thanks 👍
Use the Events demo to reproduce, since the events are logged in the console: https://demos.telerik.com/kendo-ui/spreadsheet/events
The Invoice sheet is selected but the selectSheet event does not fire.
The selectSheet event fires
Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.
Memory usage increased and slower sheet change.
Memory usage should not be increased and sheet navigation should not be slow.
When I use this formula
=HYPERLINK("mailto:"&B4&"?subject=“& B5 & “&body=“ & B6,", "test")
in the excel, I am able to click on the link which opens up my mail client with compose new email window and also populates To, Subject and Body of the email from cells B4, B5, B6 respectively.
But currently, HYPERLINK formula does not support "mailto:" functionality in Kendo UI spreadsheet. I would love to see this with kendo UI spreadsheet.
For more details you can see the discussion on the forums here.