1. Is it hard to understand the version numbers of our releases? If yes, what makes them hard to understand them?

2. Would semantic versioning (SemVer) of our releases make it easier to understand our version numbers and what's behind them?

3. If we go with SemVer, we might need to start with version 3000.0.0 as we currently use 2022.x.x. Please share your thoughts about this approach and ideas for what number versioning would work best for you.

Hi,

Actually two questions.

(1)If a user imports their excell spreadsheet with formulas, styles and values, is it converted into JSON and viewable by access the sheets property of the Spreadsheet?  Does the spreadsheet control convert the excell properties into the sheets property (in JSON)? Is it converted like this:

Ideally, we would have one sheet with all the styles and formulas (really just references to other sheets with actual values) and the data would be referred to as a formula in the first sheet like this:

The value for cell A3 is in the formula, it is just referring to a cell in Sheet1; Sheet1!A1.

Is there any way to grab the multi sheet spreadsheet (sheets property I guess) as a JSON object and send it to an API? I see most of the examples have the sheet statically defined in the initialization of the of the component, then the data is bound from a separate dataSource.

I already did an experiment with swapping sheets, and this was somewhat successful, but the next step is to actually grab that sheets property from an API and somehow use the fromJSON() function to place the spreadsheet into the control, in addition to saving it off using JSON to an API.

I understand that it is easier to define the sheets statically when initializing the spreadsheet component, but I need a way to dynamically change the styles and save them off to an API.

Thanks,

George

I've got a kendo bar chart that I'm applying a font to but when I do, the labels are no longer aligned. using the default for the chart renders fine. How do I fix this? 

Hi Team,

Is there any way to set the pattern color and pattern style of a cell before exporting to excel using jQuery?

Thanks,

Julian A

Can someone tell me how I can align my last element to the right while the others stay to the left please? i am working with asp.net mvc core 8 

Hello
I have a question while using saveChanges on grid
I want to generate sync for created, updated, and destroyed, is there a way?

Hello

I want to use the REST settings to do the updates. So I have a question while using saveChanges on grid
I want to each submit for created, updated, and destroyed, is there a way?

Hi,

Need to figure out the proper way to attach a new sheet. to the kendoSpreadsheet's option: sheets. I tried the below code:

$(document).ready(function () {
   //render and initialize kendoSpreadsheet:
   $("#spreadsheet").kendoSpreadsheet({
        columns: 20,
        rows: 200,
        toolbar: true,
        sheetsbar: true,
        sheets: mySheets,
        width: "100%"
   });
    
   //render and initialize kendoButton:
   $("#load-new-sheet-btn").kendoButton({
                icon: "forward",
                themeColor: "primary",
                click: swapSheets // want to render new set of sheets. Is this possible?
    });
 });

 //assign a different JavaScript object to the sheets: option parameter (this doesn't seem to refresh the spreadsheet component/control:
 function swapSheets() 
 {
     var currSpreadSheet = $("#spreadsheet").data("kendoSpreadsheet");

     console.log("BEFORE clearing sheets: currentSpreadSheet contents: ",  currSpreadSheet.options.sheets)
     currSpreadSheet.options.sheets = mySheetsTwo;

     console.log("AFTER clearing  sheets: currentSpreadSheet contents: ", currSpreadSheet.options.sheets);
     currSpreadSheet.refresh();
 }

You can see the whole code in action here in the Dojo:

Spreadsheet Demo Swapping Sheets | Kendo UI Dojo (telerik.com)

Also, my requirements want to load a stylized formatted sheet (ergo probably a sheet object), and X number of sheets with raw data…with a different dataSource associated to those raw data sheets.

The ultimate goal is to load data into a sheet object in from an API without rerendering the entire page or destroying the current spreadsheet component (and creating a new one).  Most importantly, or we can constrain the question to how to point sheets: to a new JSON sheet structure.

Here is a screen shot of what is happening:

It seems like I can re-assign the sheets object, but refreshing or binding the new sheets object is not being done successfully.

Hope this all makes sense,

George