MS Excel has this splitter functionality:
When the HorizontalAxisStroke is not specified, an error occurs during the document's loading.
In Material(Pink,Teal,BlueGrey) themes, the row heading numbers are truncated.
When the text is set using the following code, the text in a wrapped cell is overlapping.
radSpreadSheet1.ActiveWorksheet.Cells[0, 0].SetValue(@"Blocked flow; potential increase in level in (BLANK); potential to overfill equipment; potential spill or overflow to (BLANK)
Blocked flow; potential increase in level in (BLANK);
potential to overfill equipment; potential spill or overflow to(BLANK)");
radSpreadSheet1.ActiveWorksheet.Columns[0].SetWidth(new ColumnWidth(300, true));
Worksheet worksheet = radSpreadSheet1.ActiveWorksheet as Worksheet;
CellStyle cellStyle = worksheet.Workbook.Styles.Add("Wrap Style", CellStyleCategory.Custom);
cellStyle.IsWrapped = true;
CellRange cr = new CellRange(0, 0, 10, 10);
worksheet.Cells[cr].SetStyleName("Wrap Style");
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.
Import the attached document in RadSpreadsheet:
Expected result: centered text 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:
Expected result: the cell B1 should be rendered with bold text as in MS Excel:
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:
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:
1.Make the sheet protected
2. Paste using Ctrl+V
The first message shows:
Then:
Filter buttons are not hidden when a column is hidden
Workaround in the attached project.
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