Good morning,
is there the possibility on a Telerik spreadsheet to increase the maximum limit of digits (currently 15 digits) for cells with format number?
Kind regards,
Hello,
we would like to know if there is a way to allow the users copy the full value of a number with decimals and not only the value that is visible form the front end (in the following scenarios 13 decimals as you can see from the formula bar and 3 decimals as format).
Below you can see a spreadsheet component in which the numbers displayed are declared as decimals, in the formula bar you can see the real value of the number with 13 decimals, while I've highlighted the cell of interest in the print (cell L25) that as you can see has 3 decimals.
When coping the cell L25 and trying to paste it in the same spreadsheet component (for example S15) the number pasted is formatted the same way of the original cell and in the formula bar I find the same decimals of the original cell; instead in the moment i try to copy the number in an other spreadsheet component that is in one other page, the pasted number is formatted the same way of the original one, so 3 decimals but I find also just 3 decimals visible from the formula bar instead of the original 13 decimals.
Can you please provide an explanation related to this behavior? How can we arrange that the paste action of values with decimals keep the same format of the original selection and also in the formula bar the same decimals too?
Thanks,
Hi
We have implemented the max length validation on cells in spreadsheet control following below link. It works as it stated in the demo. We have 2 questions related to that.
1. Can we suppress the validation popup when user enters more than specified characters? It's not intuitive without the popup but it will work with my 2nd question.
2. Can we stop user from typing more than specified characters in a cell?
https://demos.telerik.com/aspnet-mvc/spreadsheet/validation
Thanks.
Jocelyn
Hi,
I am using Telerik spreadsheet in my web page. I have set the toolbar option to false as it was not needed for my use. When I tried the keyboard short cuts Ctrl + b and Ctrl + i the page console shows an error. I don't know if this creates any issues in the spreadsheet. I tried the same in the Telerik demo with toolbar option set to false and the console shows error in that too. I have attached the screenshot of demo in which I checked. Please take a look at this error as I don't know if it creates any further issues in the spreadsheet.
Hi,
I am using Telerik spreadsheet in my web page and I am using the deleteRow and insertRow methods on a button click to programmatically delete and insert rows in spreadsheet. When I click the button the rows are successfully added and removed, but on Ctrl + z these actions are not undone. Is there any way to consider this actions on undoing?
When I paste rows from an excel sheet and try to sync the datasource the submit event doesn't include the pasted rows. This works fine in version 2020.2.513, but doesn't in version 2021.1.224. Any ideas?
@(Html.Kendo().Spreadsheet()
.Name("CommentsSpreadsheet")
.HtmlAttributes(new { style = "width:100%;" })
.Toolbar(false)
.Sheetsbar(false)
.Sheets(sheets =>
{
sheets
.Add()
.Name("Comments")
.DataSource<DocumentCommentSpreadsheetEntry>(ds =>
ds.Custom()
.Batch(true)
.Transport(t => t.Read("onRead").Submit("onSubmit"))
)
.Columns(columns =>
{
columns.Add().Width(100);
columns.Add().Width(100);
columns.Add().Width(100);
columns.Add().Width(200);
columns.Add().Width(200);
columns.Add().Width(200);
columns.Add().Width(200);
columns.Add().Width(300);
columns.Add().Width(300);
})
.Rows(rows =>
{
rows.Add().Height(30).Cells(cells =>
{
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
cells.Add()
.Bold(true)
.Background("#015991")
.TextAlign(SpreadsheetTextAlign.Center)
.Color("white");
});
});
})
)
<script>
function onRead(options) {
var data = [
{
Section: '',
Page: '',
Line: '',
Item: '',
Category: '',
Email: '',
Subject: '',
Comment: '',
ProposedSolution: ''
}
]
options.success(data);
}
function onSubmit(e) {
//No rows included in created or updated
console.log(e.data);
}
</script>
HI,
I am using Telerik Spreadsheet in my web page. I have given column headers and enabled filtering and sorting. I filtered a column by its value and applied it for two or more times with different values. Then I tried to undo it using ctrl + z. But then the data got disappeared like it has filtered with no value. When I opened the filter box, I noticed that all the values are unchecked. So I tried to check all the values and apply, but nothing is happening.
I also noticed the filter option getting removed from the header when I click the clear button and then undoing ctrl + z.
I have verified the same behavior in the Telerik demo. I have attached the screenshots of the demo in which I checked.
Is there any workaround or any overriding possible?
Hello,
I have a form with different text fields and dropdown lists.
after entering the information, I have a button that allows me to validate the creation of this new element.
this button must call an action of my controller which is used to generate an excel file where I must call the template of this file from my local files and display the information entered in the fields that correspond in the excel file
I am using npoi library (c #) in back and telerik ui for asp.net mvc
It would be much appreciated if you can help me on this.
Thanks for replying