Spreadsheet issues

16 posts, 0 answers
  1. Oproma
    Oproma avatar
    11 posts
    Member since:
    Oct 2012

    Posted 02 Oct 2015 Link to this post

    Hi there,

     

    First off, I wanted to say that I really like this new component. However, I've been having a couple of issues with it and was wondering if I was doing something wrong or if those features were not implemented yet as the component is still in beta.

     

    I cannot get the component to work at all when importing it using require.js. It loads all the listed dependencies but when I instantiate it, I get an error in the console saying "s is not a function". If I import kendo.all.min.js instead the component works without any issues but greatly increases load time.

     

    Is it possible to localize the component? I've tried looking into kendo.ui.Spreadsheet.prototype.options.messages but unlike many other components, there is no messages object in the options.

     

    Finally, Is it possible to dynamically resize the component? I know you can set the size before you instantiate by setting a width on the ​div that will become the spreadsheet however any resizing operation done afterwards breaks the layout.

     

    Thank you

  2. Alexander Valchev
    Admin
    Alexander Valchev avatar
    2877 posts

    Posted 06 Oct 2015 Link to this post

    Hi,

    Thank you for your interest in Kendo Spreadsheet.

    I cannot get the component to work at all when importing it using require.js. It loads all the listed dependencies but when I instantiate it, I get an error in the console saying "s is not a function". If I import kendo.all.min.js instead the component works without any issues but greatly increases load time.

    I was able to reproduce the issue and will log it in our internal bug tracker.

    Is it possible to localize the component? I've tried looking into kendo.ui.Spreadsheet.prototype.options.messages but unlike many other components, there is no messages object in the options.

    The Spreadsheet and its components are designed to be localize-able but currently the messages are not listed in the options configuration object and are not documented. They are also missing from the messages/ files. We will do our best to fix this in next version.

    Finally, Is it possible to dynamically resize the component? I know you can set the size before you instantiate by setting a width on the ​div that will become the spreadsheet however any resizing operation done afterwards breaks the layout.

    This should be working. Is the issue reproduce-able at our demo pages or can you provide Dojo test page that isolates it? In this way I will be able to examine the case in details and assist you further.

    Regards,
    Alexander Valchev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
  4. Oproma
    Oproma avatar
    11 posts
    Member since:
    Oct 2012

    Posted 07 Oct 2015 Link to this post

    Hi Alexander,

     

    I was able to get the dynamical re size working by setting relative sizes instead of setting a pixel size and then resizing it by changing the values.

     

    Thanks for your time.

  5. Kori
    Kori avatar
    2 posts
    Member since:
    Sep 2013

    Posted 19 Oct 2015 in reply to Oproma Link to this post

    Can you please describe what elements you are resizing? 

    I  am setting the container and the k-spreadsheet-view, but I am missing another element to get the layout to display correctly.

     

     

    Cheers,

     

    Kori

     

  6. Kori
    Kori avatar
    2 posts
    Member since:
    Sep 2013

    Posted 19 Oct 2015 in reply to Kori Link to this post

    Nevermind.  I have the spreadsheet in a splitter.  If i resize/trigger the splitter the spreadsheet layout sorts itself out.
  7. Pankaj
    Pankaj avatar
    16 posts
    Member since:
    Mar 2015

    Posted 02 Feb Link to this post

     0x800a138f - JavaScript runtime error: Unable to get property '_grid' of undefined or null reference.

    when loading spreadsheet. 

     

     

  8. Alexander Valchev
    Admin
    Alexander Valchev avatar
    2877 posts

    Posted 04 Feb Link to this post

    Hi Pankaj,

    Please open a new thread with example and more details for the issue so we can reproduce it and assist you further.

    Regards,
    Alexander Valchev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  9. Pankaj
    Pankaj avatar
    16 posts
    Member since:
    Mar 2015

    Posted 04 Feb in reply to Alexander Valchev Link to this post

    hello Alexander,

                              I am trying to import excel file to kendo spreadsheet.

    public ActionResult Upload(HttpPostedFileBase file)
    {
    var workbook = Workbook.Load(file.InputStream, Path.GetExtension(file.FileName));
    return Content(workbook.ToJson(), Telerik.Web.Spreadsheet.MimeTypes.JSON);
    }

     

    this function is returning count 27 sheets and everything good.

     But when I am trying to write in 

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

    success: function (e) {
    spreadsheet.fromJSON(e.response);
    }

    I am getting error in

    kendo.all.min.js:74

    Uncaught TypeError: Cannot read property 'end' of undefined.

    Please help me regarding that. why this error is happening and what I need to take action regarding that. 

     

     

     

     

     

                           

  10. Pankaj
    Pankaj avatar
    16 posts
    Member since:
    Mar 2015

    Posted 04 Feb in reply to Pankaj Link to this post

    also I spreadsheet is giving error.

      $(function () {
    //$("#divExcelGrid").hide(1000);
    //$("#divExcelGrid").fadeOut("slow");

     

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    var ALLOWED_EXTENSIONS = [".xlsx",".csv", ".txt", ".json"];
    $("#upload").kendoUpload({
    async: {
    saveUrl: UploadActionUrl,
    autoUpload: true
    },
    multiple: false,
    localization: {
    "select": "Select file to import..."
    },
    select: function (e) {
    var extension = e.files[0].extension.toLowerCase();
    if (ALLOWED_EXTENSIONS.indexOf(extension) == -1) {
    alert("Please, select a supported file format");
    e.preventDefault();
    }
    },
    success: function (e) {
    e.response.sheets.splice(10, e.response.sheets.length -1);
    spreadsheet.fromJSON(e.response);
    //$("#divExcelGrid").show(1000);
    //$("#divExcelGrid").fadeIn("slow");
    }
    });
    });

     

    if I am trying to uncomment hide and show part. I am just showing the result slowly but it is giving error.

     

    Regards

    Pankaj

  11. Alexander Valchev
    Admin
    Alexander Valchev avatar
    2877 posts

    Posted 08 Feb Link to this post

    Hi Pankaj,

    Please open a new thread with example and more details for the issue so we can reproduce it and assist you further. This thread was opened by another client for another issue.

    Regards,
    Alexander Valchev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  12. NEELAKANTAN
    NEELAKANTAN avatar
    2 posts
    Member since:
    Nov 2015

    Posted 21 Jul in reply to Alexander Valchev Link to this post

    Hi there,

                   I am using Kendo UI v2015.1.408 in my application. I am trying to use KendoSpreadSheet control and have imported require.js just like the above thread. I am also getting an exception "$(...).kendoSpreadsheet is not a function". When I use your demo sample in simple htm file (without using require.js), I am seeing the spreadsheet. I need to use require.js & kendo.spreadsheet together . Any workaround or option available to resolve this? is it fixed in the latest release? Please reply back with sample. Any help is greatly appreciated.

     

    Regards,

    R.Saranya.

  13. Pankaj
    Pankaj avatar
    16 posts
    Member since:
    Mar 2015

    Posted 22 Jul Link to this post

    I am putting spreedsheet is div . and hide that div on load. and on button click show the div . but spredsheet giving error like _grid is undefined and no rows and column are coming.

     

    even if i put grid in boot strap modelpopup its also giving same error. Please help.

  14. Pankaj
    Pankaj avatar
    16 posts
    Member since:
    Mar 2015

    Posted 22 Jul Link to this post

    I am also trying to put Kendo spreadsheet UI in kendo window UI ..then it is also giving same error i.e _grid is undefined or null.

    here is code . please help.

    @(Html.Kendo().Window().Name("Window")
        .Modal(false)
        .Resizable().Visible(false).Height(450).Width(1120)
        .Title("Window")
        .Content(
            Html.Kendo().Spreadsheet()
                        .Name("spreadsheet3")
                       .HtmlAttributes(new { style = "width:100%; margin-top:5px;" })
             .ToHtmlString()
             )
        ).Render();

     

     

     

     

     

     

     

     

     

  15. Alexander Valchev
    Admin
    Alexander Valchev avatar
    2877 posts

    Posted 25 Jul Link to this post

    Hello guys,

    @Pankaj I logged this in Kendo UI Core bug tracker. We will do our best to address the issue as soon as possible, you may follow the issue status here.

    @R.Saranya please upgrade the Kendo UI version that you use.

    Regards,
    Alexander Valchev
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  16. NEELAKANTAN
    NEELAKANTAN avatar
    2 posts
    Member since:
    Nov 2015

    Posted 25 Jul in reply to Alexander Valchev Link to this post

    Hi Alexander,

                            What version of Kendo should i need to update to make Kendo SpreadSheet work along with require.js?

     

    Regards,

    R.Saranya.

  17. Alexander Valchev
    Admin
    Alexander Valchev avatar
    2877 posts

    Posted 27 Jul Link to this post

    Hi NEELAKANTAN,

    Please try Kendo UI version higher than 2016.1.118.

    Regards,
    Alexander Valchev
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
Back to Top
Kendo UI is VS 2017 Ready