Unplanned
Last Updated: 06 Jul 2021 08:20 by ADMIN
One of the options grouped under alignment is Shrink to Fit. Shrink to fit will automatically reduce the font size until text fits in a cell.
Unplanned
Last Updated: 08 Jun 2021 06:09 by ADMIN

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

Unplanned
Last Updated: 06 May 2021 12:43 by ADMIN
Charts: Add support for data rows or separate axes with values  on the chart (see attached) 
Unplanned
Last Updated: 23 Feb 2021 07:08 by ADMIN
Created by: Dennis
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
MS Excel supports dragging cells and thus moving the value to a new cell. 
Completed
Last Updated: 19 Feb 2021 09:45 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)
Unplanned
Last Updated: 18 Nov 2019 11:03 by ADMIN
Created by: mali
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Currently if radSpreadsheet RightToLeft property is set to Yes, only the Formula Bar is affected; RadSpreadSheet and Status Bar are not.
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: 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?

Unplanned
Last Updated: 01 Mar 2019 14:41 by Tom
If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.
Unplanned
Last Updated: 06 Jul 2018 08:21 by ADMIN
ADMIN
Created by: Dess | Tech Support Engineer, Principal
Comments: 0
Category: Spreadsheet
Type: Feature Request
2

			
Completed
Last Updated: 18 Apr 2018 08:26 by Dimitar
Ideally we should expose the events in the RadPrintDocument object.

Workaround handling the PrintPreview method:
private void button1_Click(object sender, EventArgs e)
{
    RadPrintDocument printDocument = new RadPrintDocument();
    IPrintable printManager = typeof(RadSpreadsheetElement).GetProperty("PrintManager", BindingFlags.Instance | BindingFlags.NonPublic).GetValue(this.radSpreadsheet1.SpreadsheetElement) as IPrintable;
    printDocument.AssociatedObject = printManager;

    printDocument.BeginPrint += PrintDocument_BeginPrint;
    printDocument.PrintPage += PrintDocument_PrintPage;
    printDocument.EndPrint += PrintDocument_EndPrint;
    printDocument.QueryPageSettings += PrintDocument_QueryPageSettings;
    SpreadsheetPrintPreviewDialog printPreviewDialog = new SpreadsheetPrintPreviewDialog(printDocument);
    printPreviewDialog.ThemeName = this.radSpreadsheet1.ThemeName;
    printPreviewDialog.ShowDialog();
}

private void PrintDocument_QueryPageSettings(object sender, System.Drawing.Printing.QueryPageSettingsEventArgs e)
{
    
}

private void PrintDocument_EndPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
    
}

private void PrintDocument_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
    
}

private void PrintDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
}

Unplanned
Last Updated: 20 Nov 2017 12:03 by ADMIN
1 2