Hello,
the spreadsheet component triggers no change event if the width of a column changes. Is it possible to track a change of the width of a column?
Can be reproduced with your event demo of the spreadsheet component (https://demos.telerik.com/kendo-ui/spreadsheet/events)
When there is formatting and decimals are rounded negative numbers that round to zero show a negative sign. In Excel those are shown without the negative sign.
Dojo example: https://dojo.telerik.com/@iankodj/azEMIRUv/21
Hi there,
When a spreadsheet is linked to a datasource, if you leave a gap between previously entered rows and your new data, each cell edit creates a new item in the datasource with only the cell modified.
Here is the record after adding one cell.
and after adding another cell:
This is the state of the spreadsheet:
I managed to replicate this in dojo here: https://dojo.telerik.com/eRiHocar
With Excel when you use a custom number format of #,##0.00 and you enter (10) into the cell it will be displayed as -10. With the Spreadsheet control the same example yields (10). How can we get the same behavior as Excel with the Spreadsheet control?
dojo example: https://dojo.telerik.com/@843335b6-427b-4127-af09-fbe9957bfec6/uGaVAVat
Thanks,
Ron
Hi admin,
I have a problem when I do with the Spreadsheet.
Bug only appear on mobile deice that run iOS operation system. You need prepare a device as iPhone or iPad
** Prerequisite step.
1. Your device must install Japanese keyboard percussion. You can refer to this below link
https://www.youtube.com/watch?v=2_ImIkZ5Kis&ab_channel=TaraNico
2. You visit to
https://demos.telerik.com/kendo-ui/spreadsheet/index by your device
** Step to reproduce this bug
Because having may steps to reproduce this bug, I records a video. Please check video attached.
**
When you switch to Japanese keyboard percussion, you select a cell and enter a formula excel on 'fx' input
Ex: =sum
** Phenomenon:
You enter "=" and then continue entering 'u' character. But cells lose focus and can't enter any character.
You must click again on 'fx' input, it focus again. But only enter a character. And then continue losing focus
Please confirm and help me this problem
We have clients with large spreadsheets that print out across multiple pages, which can mean losing track of which column refers to what on new pages after a page break, so they want to be able to assign a row of column headers to be printed on new pages above each column to keep track
Hi Team,
I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please
check the URL
The Excel file downloaded from Spreadsheet does not maintain leading spaces. In other words, the internal sharedString.xml should use <t xml:space="preserve"> when necessary.
Allowing custom editors to be inline would be very helpful. In particular, inline editors using other Kendo controls (e.g. masked textbox, numeric textbox) should be possible.
In the scpreadsheet you can use controls like dropdowns & datepicker , but should be helpful if user could to customize the design and behavior. For example, the dropdown and any other control needs be opened since an icon at right that is displayed over the next column, As user i would like to choose how i want to be displayed the control: Open clicking on it, set expand direction, styles, etc.
E.g. italian culture uses ";" as parameter separator in formulae. Our client will adopt spreadsheet component on a global basis and users need to be able to e.g. copy/paste from excel to spreadsheet component using their culture
Currently if I set column border width large, it has multiple problems: 1. it will overlay on columns next to it; 2. when copy the cell with thick border and paste somewhere else, the thick border get copied as well; 3. when select cell with thick border, the border will block part of editor;
When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget
The horizontal scrollbar should be adjusted to the bottom of the widget.
As a possible workaround, when hiding the Sheetsbar add the following styling:
<style>
.k-spreadsheet-sheets-bar {
padding: 0;
border-style: none;
}
</style>
Presently in Spreadsheet tooltip is not working for filter applied range so tooltip should display for each cell in which the range of filter is applied
The spreadsheet currently relies on the <v> tag and doesn't accept cell type "inlineStr". Here is an article with more info regarding the inlineStr type:
https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_c_topic_ID0E1XM4.html
A cell of type "inlineStr" which is currently not accepted in SpredSheet
<c r="F2" s="4" t="inlineStr">
<is>
<t>1005131528</t>
</is>
</c>
while the format saved from excel is accepted:
<c r="F2" s="2" t="s">
<v>12</v>
</c>
Ticket ID: 1517963
Scrolling to a column that is not visible initially and using the Freeze Panes tool, makes the scrollbar of the Spreadsheet unusable. This valid for both horizontal and vertical scrolling. It is observable in the demos: https://demos.telerik.com/kendo-ui/spreadsheet/index
Scroll right to the "R" column. Select it and click on the the "Freeze panes" tool in the toolbar.
Alternatively, scroll down to row 30. Select a cell and click on the the "Freeze panes" tool.
As a result, scrolling the columns (respectively the rows) becomes impossible.
Consider a way to enhance the Freeze panes functionality, so that is is usable in these scenarios.
Describe the bug
To reproduce
Steps to reproduce the behavior:
Expected behavior
The panes are frozen without breaking the layout of the Spreadsheet and without cells/column duplication.
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Build system information (please remove the unneeded items)
Additional context
Add any other context about the bug.
Hi Team,
When I add comments to enabled columns(product)it is allowing me to add and after reopening the comments it is retained. But when I add comments to disabled columns(ID) it is not adding to it and no messages are added like it is disabled and comments are not allowed.
demo: https://dojo.telerik.com/ISIvATiN
thanks.
Hi ,
we have a requirement to disable comment option on click of few cells (which are disabled) or to show a toastr message on click of comment that user can't add comment on specific cell. Do you have any such feature or event to track this requirement .
It should be possible to define cell types (or types that are valid for the entire column) like: - Booleans (which will result in showing check boxes inside the cells)