If you load the attached document in RadSpreadsheet and select the first cell A1, the yellow popup doesn't occur even though it is defined in the document:
Expected result:
Like in WPF RadSpreadsheet:
Like in MS Excel:
Import the attached document and zoom in/out:
Expected result: the whole text should be fully visible like in MS Excel:
Import the attached document in RadSpreadsheet:
Expected result: centered text like in MS Excel:
In Excel, the cursor changes to look like <-I-> when it is in the correct position to start resizing (column or row), and stays the same when the user is doing the resize - good visual feedback.
In RadSpreadsheet, we get a similar <-I-> cursor when in position to re-size, but this goes away (back to the normal pointer) whilst the user is re-sizing. The re-size operation works just fine, but I don't get the feedback whilst doing it.
Please refer to the two gif files illustrating the behavior in MS Excel and in RadSpreadsheet.
Steps to reproduce:
1. Handle the MessageShowing event like this:
private void SpreadsheetElement_MessageShowing(object sender, Telerik.WinForms.Controls.Spreadsheet.MessageShowingEventArgs e)
{
e.IsHandled = true;
}
2. Protect the Workbook
3. Start the app and paste with the context menu
Actual: A dialog is shown
Hi,
if you add a Style to a cell containing a "\n" (which I am forced to use, since text wrap does not work either) the style won't apply.
To reproduce just add a radspreadsheet to a form
public Form1()
{
InitializeComponent();
Workbook workbook = new Workbook();
radSpreadsheet1.Workbook = workbook;
Worksheet worksheet = workbook.ActiveWorksheet;
CellStyle style = workbook.Styles.Add("HeaderStyle");
style.IsBold = true;
worksheet.Cells[0, 0].SetValue("first\ncell");
worksheet.Cells[0, 1].SetValue("second cell");
worksheet.Cells[0, 0, 0, 1].SetStyleName("HeaderStyle");
}
Regards,
Markus
One cannot reference another sheet in a formula by using the UI.
To replicate,
1. Open your spreadsheet demonstration app.
2. Create two work pages.
3. Enter some information on the first page.
4 .go to the second page, select any cell, and press =
5. navigate to the first page and select a cell with data in it.
6. Check the second page again, there is no reference link.
Workaround: manually type the sheet name in the formula
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.
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.