Setting SetIsBold method to true on a CellSelection, resets the font size of those cells to 11 points.
See the generated file of the attached program.
Cells C1:F1 have font size 11 instead of expected 9.
PS: Is it really necessary to have a support plan to report bugs?
string themeName = "Office";
ThemeFontScheme themeFontScheme = PredefinedThemeSchemes.FontSchemes.FirstOrDefault(x => x.Name == themeName);
ThemeColorScheme themeColors = PredefinedThemeSchemes.ColorSchemes.FirstOrDefault(x => x.Name == themeName);
DocumentTheme theme = new DocumentTheme(themeName, themeColors, themeFontScheme);
Hi Telerik,
I would like to request 1 feature to be added in Current RADGRID control which is to exporting grid data to into Excel 2016 version.
We need this feature because one of our supporting application will work only with Excel 2016 version, where as the current RADGRID conversion only able to export to EXCEL 2007 (excel 12) format.
Thank you.
NullReferenceException when the FindOptions does not contain start cell
Workaround:
Set StatCell like this:
FindOptions options = new FindOptions()Handle the case where the formula starts with "=+". Detailed information: https://professor-excel.com/equal-plus-excel-formulas/
Workaround: replace the "=+" with "="
CellRange usedCellRange = workbook.Worksheets[0].UsedCellRange;
for (int rowIndex = usedCellRange.FromIndex.RowIndex; rowIndex <= usedCellRange.ToIndex.RowIndex; rowIndex++)
{
for (int columnIndex = usedCellRange.FromIndex.ColumnIndex; columnIndex <= usedCellRange.ToIndex.ColumnIndex; columnIndex++)
{
CellSelection cell = workbook.Worksheets[0].Cells[rowIndex, columnIndex];
FormulaCellValue formulaCellValue =cell.GetValue().Value as FormulaCellValue;
if (formulaCellValue == null)
{
continue;
}
CellValueFormat format = cell.GetFormat().Value;
string resultValueAsString = formulaCellValue.GetValueAsString(format);
Console.WriteLine(resultValueAsString);
if (resultValueAsString.StartsWith("=+"))
{
resultValueAsString = resultValueAsString.Remove(1, 1);
cell.SetValue(resultValueAsString);
}
}
}
radSpreadsheet.Workbook = workbook;