At this point, only the styling is preserved without the hyperlink itself. Implement logic to add the hyperlink to the generated PDF document.
Workaround: check the attached project.
Add support for the EDATE function.
Use the attached custom function as a workaround.
The exception is thrown when importing a document that contains an empty stylesheet tag in its styles.xml part.
Add API for setting custom document properties (metadata). Such are visualized by the common editors, e.g. in MS Excel in the File menu. Example properties that can be set through the document properties are: - Title - Subject - Author - Keywords - Comments - Last Author - Creation Date - Category - Manager - Company
To reproduce:
- Add the following formula to a cell: "=A1=FALSE"
Actual: the result is always false
Expected: the result should be true when the cell is empty
Workaround: Use the ISBLANK function.
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;