Unplanned
Last Updated: 20 May 2020 15:00 by ADMIN

The Workbook.FromDocument() method freezes the panes based on the coordinates of the TopLeftCellIndex of the pane instead of the XSplit and YSplit properties of the pane. Reproduced with the attached Excel file

var pane = documentWorksheet.ViewState.Pane;
if (pane != null && pane.State == PaneState.Frozen)
{
    sheet.FrozenRows = pane.TopLeftCellIndex.RowIndex;
    sheet.FrozenColumns = pane.TopLeftCellIndex.ColumnIndex;
}

Solution:

var pane = documentWorksheet.ViewState.Pane;
if (pane != null && pane.State == PaneState.Frozen)
{
    sheet.FrozenRows = pane.YSplit;
    sheet.FrozenColumns = pane.XSplit;
}

WORKAROUND: Loading the Excel file with DocumentProcessingLibrary API and change the pane

var fileName = <YourFilePathHere...>;
if (!File.Exists(fileName))
{
    throw new FileNotFoundException(String.Format("File {0} was not found!", fileName));
}

Telerik.Windows.Documents.Spreadsheet.Model.Workbook workbook;
IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();

using (Stream input = new FileStream(fileName, FileMode.Open))
{
    workbook = formatProvider.Import(input);
    foreach (var sheet in workbook.Worksheets)
    {
        if (sheet.ViewState.Pane != null && sheet.ViewState.Pane.State == Telerik.Windows.Documents.Spreadsheet.Model.PaneState.Frozen)
        {

            var originalPane = sheet.ViewState.Pane;
            var pane = new Pane(new CellIndex(originalPane.YSplit, originalPane.XSplit), originalPane.XSplit, originalPane.YSplit, originalPane.ActivePane);
            sheet.ViewState.Pane = pane;
        }
    }
}
var sheets = Telerik.Web.Spreadsheet.Workbook.FromDocument(workbook).Sheets;

 

 

 

Planned
Last Updated: 19 May 2020 11:15 by ADMIN
Created by: Bo Yuan
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

Calling insertRow multiple times over many sheet data causes a slower performance since 2020.1.219.

Reproduction of the problem

http://dojo.telerik.com/EBEtaFOj (2020.1.114)

  1. Click the Add Rows button and wait for the alert.

Current behavior

http://dojo.telerik.com/UJAGUgAl

Planned
Last Updated: 14 Apr 2020 12:48 by Mandar

Bug report

This is a regression introduced in R2 2019.
Textboxes and charts currently are not supported in the Spreadsheet, however, if the loaded excel file contains such, saving the file should not throw a js exception.

Reproduction of the problem

  1. In Excel add a textbox and/or a chart to a workbook. Save the workbook. Alternatively, use the attached file:
    sample-new-chart-textbox.zip
  2. Load the .xlsx file in the Spreadsheet
  3. Save the file

Current behavior

On saving the file the following exception is thrown:
kendo.all.js:12938 Uncaught TypeError: Cannot read property 'target' of undefined

Expected/desired behavior

No js exceptions on saving the file.

Environment

  • Kendo UI version: 2020.1.406
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 12 Feb 2020 12:45 by Gary
Created by: Gary
Comments: 0
Category: Spreadsheet
Type: Bug Report
3

Bug report

If there is a Spreadsheet on a given page and we scroll the page down using the mouse wheel, once the scrolling stops over the Spreadsheet and we try to continue it, we cannot do it. If the Spreadsheet has defined rows that are not currently visible when the mouse wheel is moved, then Spreadsheet is being scrolled, not the current page.

If the Spreadsheet has a lower number of pre-defined rows that are all displayed on the component's initialization the scrolling is again not applying to the page. Instead, moving the mouse wheel doesn't do anything until the mouse cursor is moved outside the Spreadsheet.

Reproduction of the problem

  1. Open this Dojo example and run it
  2. Move the mouse cursor in the middle of the pane displaying the compiled code.
  3. Use the mouse wheel to scroll down the page and stop the scrolling once the cursor is in the zone of the Spreadsheet
  4. Scroll down again

Current behavior

Because the cursor is inside the Spreadsheet the page cannot be scrolled. If the rows configuration is commented, when the scrolling is started again, the Spreadsheet data will be scrolled.

Expected/desired behavior

If all the data in the Spreadsheet is displayed, moving the mouse wheel over the component should result in page scrolling. If there is data in the Spreadsheet, there should be some way to prevent the scrolling inside the component.

Environment

  • Kendo UI version: 2020.1.114
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 06 Feb 2020 13:07 by ADMIN
Created by: Bharathy
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

Hi Team,

I am using a kendospreadsheet. I want to find the rownumber of last non blank cell for column C.

When i try the =SUMPRODUCT(MAX(($C$1:$C100<>"")*(ROW($C$1:$C100)))) in excel it works.

The same formula does not work in kendospreadsheet.

 

Please suggest if this is a bug or if formula needs any change to fit the kendospreadsheet.

 

Regards

Bharathy B

Unplanned
Last Updated: 23 Jan 2020 17:11 by ADMIN
Created by: Karthick
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug Report

When importing a XLSX file with a frozen pane using server implementation(using the Document Processing Library), the dimensions of the frozen pane are missed.  

Reproduction of the problem

  1. Visit the Spreadsheet Server Import/Export live demo.
  2. Import the attached example(FrozenPaneExample.zip).

Current Behavior

The imported xlsx file appears to overflow the Kendo UI Spreadsheet component.  See screencast(SpreadhsheetOverflowFrozenPane.zip)

Expected Behavior

When importing a file using server implementation, the file should be contained within the Kendo UI Spreadsheet component's view.

Workaround

Reduce the amount of frozen rows/columns to fit into the widget.  

Environment

  • Kendo UI version: 2020.1.114
  • Browser: all

 

Unplanned
Last Updated: 04 Oct 2019 12:31 by ADMIN
Scheduled for 2019.R3.SP.next
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

Regression introduced in R3 2019.

Reproduction of the problem

Open this Spreadsheet demo. Even though the Toolbar configuration is set to false, it is not hidden. This applies only for ASP.Net Core and ASP.Net MVC.

Current behavior

The Toolbar is visible when set to false.

Expected/desired behavior

The Toolbar should be hidden.

Environment

  • Kendo UI version: 2019.3.917
  • Browser: [all]
Unplanned
Last Updated: 16 Sep 2019 15:30 by ADMIN

Bug report

When we want to add a formula in a given cell in the Spreadsheet, we double-click it and enter the "=" in it as an identifier that a formula definition will follow. If we want to include in the formula a cell that is not inside the visible range of the Spreadsheet, we scroll to that cell and select it. In Internet Explorer, if we scroll to a given cell using the arrows of the Spreadsheet's scrollbar the "double-clicked" cell becomes just a selected one and the "=" sign is converted to a string value.

Reproduction of the problem

  1. Open this Dojo example in Internet Explorer 11
  2. Select the A1 cell and enter "=" in it.
  3. Press the "down" direction arrow of the Spreadsheet trying to reach cell A50.
  4. With the first click on the arrow, the A1 cell is no more "double-clicked" and the "=" inside it is converted to a string

Current behavior

When building a formula in a given cell and trying to navigate to a cell using the scrollbar, this usage stops the formula building and converts the "=" into a string.

Expected/desired behavior

When a user creates a formula for a given cell, they should be able to navigate through the Spreadsheet using its scrollbars.

Environment

  • Kendo UI version: 2019.2.619
  • jQuery version: x.y
  • Browser: IE 11.950.17134.0