Completed
Last Updated: 07 Aug 2024 15:11 by ADMIN
Release 2024.3.806 (2024 Q3)
ADMIN
Created by: Hristo
Comments: 0
Category: Spreadsheet
Type: Feature Request
2

			
Completed
Last Updated: 10 Jul 2024 11:20 by ADMIN
Release R1 2021 SP2

I have implemented the ListDataValidationRule code to add a dropdownlist to the spreadsheet. Based on the code I can find and the searching I have conducted, it seems to be correct, however the dropdown does not appear in the control.

The dropdown list does appear in Excel when I export the file.

 

Dim Context As ListDataValidationRuleContext = New ListDataValidationRuleContext(CurrentWorksheet, CurrentCellIndex)

Context.InputMessageTitle = "Restricted input"
Context.InputMessageContent = "The input is restricted to the week days."
Context.ErrorStyle = ErrorStyle.Stop
Context.ErrorAlertTitle = "Invalid Bedroom Type"
Context.ErrorAlertContent = "The entered value is not valid."
Context.InCellDropdown = True

Context.Argument1 = String.Join(",", _Data.ArchitectCert_UnitBedrooms.AsEnumerable().Select(Function(x) x.Field(Of Integer)("UnitBedroomNumber").ToString()).ToArray())


Dim Rule As ListDataValidationRule = New ListDataValidationRule(Context)

CurrentWorksheet.Cells(CurrentCellIndex).SetDataValidationRule(Rule)
Completed
Last Updated: 31 Jan 2024 11:39 by ADMIN
Release 2024 Q1 (2024.1.130)
NullReferenceException is raised when loading document with charts.
Completed
Last Updated: 08 May 2023 14:41 by ADMIN
Release R2 2023
Exception in the ValueContextResolver when importing a document that contains conditional formatting.
Completed
Last Updated: 27 Apr 2023 06:55 by ADMIN
Release R2 2023 (LIB 2023.1.427)

Create an empty project with a RadSpreadsheet. Hide column A and B and try to scroll:

System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at Telerik.Windows.Documents.Spreadsheet.Layout.RadWorksheetLayout.GetColumnWidth(Int32 columnIndex)
   at Telerik.WinForms.Controls.Spreadsheet.Worksheets.RadWorksheetEditorPresenterBase.SetHorizontalOffsetInternal(ScrollEventType scrollType, Double value)
   at Telerik.WinForms.Controls.Spreadsheet.Worksheets.RadWorksheetEditor.SetHorizontalOffsetInternal(ScrollEventType scrollType, Double value)
   at Telerik.WinControls.UI.RadSpreadsheetElement.ScrollBar_Scroll(Object sender, ScrollEventArgs e)
   at System.Windows.Forms.ScrollEventHandler.Invoke(Object sender, ScrollEventArgs e)
   at Telerik.WinControls.UI.RadScrollBarElement.OnScroll(ScrollEventArgs args)
   at Telerik.WinControls.UI.RadScrollBarElement.CallOnScroll(ScrollEventType scrollType, Int32 oldValue, Int32 newValue)
   at Telerik.WinControls.UI.RadScrollBarElement.ScrollWith(Int32 step, ScrollEventType scrollType)
   at Telerik.WinControls.UI.RadScrollBarElement.OnScrollTimer(Object sender, EventArgs e)
   at Telerik.WinControls.UI.RadScrollBarElement.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadElement.OnCLREventsRise(RoutedEventArgs args)
   at Telerik.WinControls.RadElement.OnBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadItem.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadItem.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseRoutedEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.DoMouseDown(MouseEventArgs e)
   at Telerik.WinControls.ComponentInputBehavior.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.Spreadsheet.UI.RadSpreadsheetComponentInputBehavior.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadControl.OnMouseDown(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at Telerik.WinControls.RadControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Completed
Last Updated: 02 Feb 2023 09:35 by ADMIN
Release R1 2023

Import the attached sample file, right-click on the first cell and select Format Cell:

Expected result: correct cell style should be loaded as it is MS Excel:

Completed
Last Updated: 02 Feb 2023 09:35 by ADMIN
Release R1 2023

Import the attached document:

Expected result: the cell B1 should be rendered with bold text as in MS Excel:

Completed
Last Updated: 02 Nov 2022 15:23 by ADMIN
Release R3 2022 SP2

When the HorizontalAxisStroke is not specified, an error occurs during the document's loading.

 

Completed
Last Updated: 23 Sep 2022 13:07 by ADMIN
Release R3 2022
Created by: RTA
Comments: 0
Category: Spreadsheet
Type: Feature Request
6
Add support for visualizing and editing charts.
Completed
Last Updated: 23 Sep 2022 13:07 by ADMIN
Release R3 2022
The wrap text feature does not work as expected when not in edit mode
Completed
Last Updated: 21 Sep 2022 12:57 by ADMIN
Release R3 2022 SP1
ArgumentNullException is thrown when writing in a cell and focus another cell.
Completed
Last Updated: 09 Jun 2022 08:39 by ADMIN
Release R2 2022 SP1
Exception when setting transparent texbox editor background
Completed
Last Updated: 03 Jun 2022 13:06 by ADMIN
Release R2 2022 SP1

Filter buttons are not hidden when a column is hidden

Workaround in the attached project. 

Completed
Last Updated: 18 Feb 2022 15:16 by ADMIN
Release R1 2022 SP1
The FilteringUILayer contains an internal collection of FilteringPopupControls for the different cells in RadSpreadsheet. It would be good to provide a convenient API for accessing these FilteringPopupControls and allowing any customizations over its menu items.
Completed
Last Updated: 18 Feb 2022 15:14 by ADMIN
Release R1 2022 SP1
The filtering popup layout is not correct when a cell contains a very long text.
Completed
Last Updated: 04 Jan 2022 16:55 by ADMIN
Release R1 2022
Created by: Christopher
Comments: 1
Category: Spreadsheet
Type: Bug Report
0
If I type a lowercase letter, the cell accepts the text and is placed in edit mode. If I type an upper case letter (holding Shift), nothing happens (no edit mode, no text displays in the cell). 
Completed
Last Updated: 04 Jan 2022 10:09 by ADMIN
Release R1 2022
When importing a document containing a hyperlink formula (e.g. "=HYPERLINK(B2,A2)") an exception is thrown: System.Collections.Generic.KeyNotFoundException: 'The given key was not present in the dictionary.'
Completed
Last Updated: 03 Aug 2021 16:38 by ADMIN
Release R3 2021
For example, going at a slow pace when clicking the right zoom arrow, a user can switch from 50% to 55% to 60% to 65% to 70% to 75% to 80%, and so-forth. The user properly progresses through (let's say) 10 increments, eventually arriving at 100%.    However, if the user clicks the arrow the same 10 times, but at a faster pace, many of the increments are skipped over.  In one test, 10 rapid clicks brought me from 50% up to 250%.  
Completed
Last Updated: 03 Aug 2021 13:40 by ADMIN
Release R3 2021
Double-Clicking the fx button in the formula bar allows modifications to protected worksheet
Completed
Last Updated: 02 Aug 2021 08:33 by ADMIN
Release R3 2021 (LIB 2021_2_802)
Created by: Dennis
Comments: 0
Category: Spreadsheet
Type: Bug Report
3
Hi,

I am using the Spreadsheet control and noticed that when I move to the right by clicking on the horizontal scroll arrow, the scroll does not seem to work as expected. I have to click on the scroll arrow 4 times for it to work correctly. 
1 2 3