Unplanned
Last Updated: 06 Nov 2020 09:47 by ADMIN
Created by: Matthias
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Currently, it takes around 5 seconds to load the RadSpreadsheetRibbonBar.

Please run the project and compare the load time when clicking the two buttons in the main form.

Completed
Last Updated: 07 Oct 2020 11:46 by ADMIN
Release R3 2020 SP1 (LIB 2020.3.1007)

I have a RadSpreadsheet control on a form. It has a good number of cells protected though this behavior is independent of the protection status.

If I click on a cell, move to the cell using the keyboard (up arrow, etc), and then push the delete key the cell formatting is cleared. When the spreadsheet is protected and I hit delete in the same circumstance on an unlocked cell the formatting is cleared and the cell is then locked.

Is there something I am missing or have not set?

Duplicated
Last Updated: 26 May 2020 07:56 by ADMIN

To reproduce: 

Add the rule from this article and observe the result: Data Validation

Unplanned
Last Updated: 08 Apr 2020 10:23 by ADMIN
Exception when setting transparent texbox editor background
Completed
Last Updated: 20 Jan 2020 14:11 by ADMIN
Release R1 2020 SP1 (LIB 2020_1_120)

Hi,

Using the last release of RadSpreadsheet, I get an exception when the first row is hidden when scrolling with the mousewheel. Attached is a demo.

Thanks,

Megan

Completed
Last Updated: 06 Jan 2020 11:14 by ADMIN
Release R1 2020

Please follow the steps:

1. Run the attached sample project. 

2. Move the form to a monitor with 125% DPI scaling.

3. Resize the form to make the spreadsheet bigger. You will notice that the column/row headers are missing for the last column/row headers. 

Unplanned
Last Updated: 02 Dec 2019 06:38 by ADMIN
Created by: n/a
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

The UI behaivor of drag selection shows inconsistent behavior between WinForm vs WPF/Excel.

When you drag some cells for selection and keep dragging to the right (getting the out scope), the control scrolls to the right.

This behavior is common in Winform/WPF/Excel.

When you drag backward (to the left), WPF controls scroll back and so is Excel, while Winform controls does not scroll

Same thing for top and bottom scroll. Winform Spreadsheet control does not scroll. It may scrolls only to the right.

Another Caveat I see meanwhile is that when you scroll backwards until the row area, the pointer become row-resize pointer, or so

If you keep mouse moving around, it sometimes makes a horizontal line (possibly a guide for row resize?)

The issue in this case is that, it does not remove itself. the horizontal line stays there. It is not very annoying (as it is thin horizontal line) but is still a bug.

 

To reproduce,

create a empty Winform app, with the RadSpreadsheet Control, and Run

Drag from row C3 and to the right (around the scrollbar) the control scrolls to the right (this is not quite smooth though..)

Scroll right to AZ3 say, and drag backward back to C3, this now does not scroll back.

Same for top and bottom.

Do the same for WPF, it now works as expected

Do the same for MS Excel, it now works as expected.

Unplanned
Last Updated: 21 Nov 2019 12:44 by ADMIN

Hi Support,

 

please try set the WorkBook to RadSpreadsheet.

Best regards

Fritz

Unplanned
Last Updated: 18 Nov 2019 11:03 by ADMIN
Created by: mali
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently if radSpreadsheet RightToLeft property is set to Yes, only the Formula Bar is affected; RadSpreadSheet and Status Bar are not.
Completed
Last Updated: 07 Nov 2019 14:06 by ADMIN
Release R1 2020 (LIB 2019.3.1111)

Add a RadSpreadsheet on the form and try resizing it at design time. You will notice that the control is resized after a considerable delay.

If you Dock the control to Fill and try resizing the form at run you will notice that the layout is incorrect. The attached gif file illustrates the obtained behavior.

Workaround: update the layout after resizing:

        public RadForm1()
        {
            InitializeComponent();
            this.radSpreadsheet1.SizeChanged+=radSpreadsheet1_SizeChanged;
        }

        private void radSpreadsheet1_SizeChanged(object sender, EventArgs e)
        {
            this.radSpreadsheet1.SpreadsheetElement.InvalidateMeasure(true);
            this.radSpreadsheet1.SpreadsheetElement.UpdateLayout();
        }

Unplanned
Last Updated: 06 Nov 2019 07:34 by ADMIN

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: 09 Oct 2019 08:16 by ADMIN
Release R3 2019 SP1
Created by: n/a
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

When you set the AutoSize property to true, the control becomes enormous - Size (5002, 5002).

There is no specific logic for auto-sizing the control. We should either remove the AutoSize property or size the control according to the rows/columns it uses.

Completed
Last Updated: 15 Aug 2019 13:26 by ADMIN
Release R3 2019 (LIB 2019.2.819)
Please run the attached sample and move the spreadsheet on a monitor with 125% DPI scaling. Then, enter some text in the first cell that exceeds the column's width and double-click the header to best-fit the column. You will notice that RadSpreadsheet hangs and it is not possible to proceed with the further execution of the form.
Unplanned
Last Updated: 06 Aug 2019 04:49 by ADMIN
The scale factor is not imported from documents with no information about the selection state.
Unplanned
Last Updated: 02 Jul 2019 11:06 by ADMIN
Created by: Dimitar
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
Add support for creating Tables and applying tables styles (predefined ones or custom).
Completed
Last Updated: 21 Jun 2019 13:15 by ADMIN
Release R3 2019
Row heights with missing CustomHeight attributes in the document are ignored.
Completed
Last Updated: 17 Jun 2019 14:15 by ADMIN
Release R2 2019 SP1
The data validation rule should have values for formula1 and formula2 elements, which define the start and end values for a range to validate between. When such values are missing, a NullReferenceException is thrown on import and the document cannot be imported. As a workaround, the document can be modified by deleting the AlternateContent attribute.
Completed
Last Updated: 16 May 2019 06:05 by ADMIN
Created by: Stephen
Comments: 3
Category: Spreadsheet
Type: Feature Request
0

I have loaded an excel file into the spreadsheet control from our document database. When a user makes changes and clicks the save button I would like to handle a save process back to our document database of the file.

If a save function can be raised I can save to the document database

If a SavAs fucntion can be raised I can prompt the user to create a new version

 

Can the control have these two features added please?

Completed
Last Updated: 26 Mar 2019 14:17 by Dimitar
For some reason the last letters are dropping from headers and data.

Declined
Last Updated: 18 Mar 2019 14:33 by ADMIN
If the lookup_value parameter and lookup_vector parameters refer cells containing text values, the function returns a Not available error ("#N/A").
1 2 3