Completed
Last Updated: 09 Feb 2021 08:42 by ADMIN
Release R1 2021 SP1
Created by: Joshua
Comments: 1
Category: SpreadProcessing
Type: Bug Report
0
Clearing an entire row is too slow.
Completed
Last Updated: 28 Jan 2021 12:07 by ADMIN
Release R1 2021 SP1
Importing XLS document containing defined name with spaces in the sheet name causes exception
Unplanned
Last Updated: 21 Jan 2021 10:04 by ADMIN
Created by: Dmitriy
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1

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.

Completed
Last Updated: 10 Dec 2020 14:37 by ADMIN
Release R1 2021
Exporting a workbook that has a data validation rule applied on a cell with hyperlink inside results in an invalid spreadsheet document. Trying to open the result in MS Excel, an error appears and letting Excel repair the content results in a missing worksheet.
Completed
Last Updated: 09 Dec 2020 15:50 by ADMIN
Release R1 2021
An InvalidOperationException is thrown when importing XLS document containing Extra Table Data record.
Unplanned
Last Updated: 03 Dec 2020 09:51 by ADMIN
Created by: Dimitar
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0

Add support for the EDATE function.

Use the attached custom function as a workaround.

Completed
Last Updated: 20 Nov 2020 12:25 by ADMIN
Release R1 2021
The exception is thrown when importing a document that contains an empty stylesheet tag in its styles.xml part.
Completed
Last Updated: 20 Nov 2020 09:37 by ADMIN
Release R1 2021
ADMIN
Created by: Deyan
Comments: 1
Category: SpreadProcessing
Type: Feature Request
13
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
Completed
Last Updated: 10 Nov 2020 11:20 by ADMIN
Release R1 2021
Exception when importing a file with missing print settings
Completed
Last Updated: 10 Nov 2020 11:16 by ADMIN
Release R1 2021
Exception when importing a file with a specific print area.
Completed
Last Updated: 23 Oct 2020 07:05 by ADMIN
Release R3 2020 SP1
Removing a row causes the last row of the sheet to copy its styling from the first row. This happens because the compressed lists translate the values of the cells up and do not take into account that its the end of the sheet.
Completed
Last Updated: 16 Sep 2020 12:44 by ADMIN
Release R3 2020
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
41

			
Completed
Last Updated: 16 Sep 2020 12:41 by ADMIN
Release R3 2020
Created by: Dimitar
Comments: 2
Category: SpreadProcessing
Type: Bug Report
1

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.

Unplanned
Last Updated: 04 Sep 2020 06:04 by ADMIN
Exporting a sheet in a workbook, results in clearly narrower column widths, this doesn't appear to be a scaling issue as letters that extend outside of a cell are occluded differently from the Excel document. Also worth noting, borders adjacent to the margin area are clipped (not an issue when exporting the same PDF from excel), text padding in the cell is not the same as the Excel document, and borders disappear unexpectedly on some text cells 
Unplanned
Last Updated: 31 Aug 2020 06:14 by ADMIN

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;

 

Completed
Last Updated: 21 Aug 2020 10:19 by ADMIN
Release R3 2020
Exception when the sheet name contains a single letter 
Unplanned
Last Updated: 20 Aug 2020 06:45 by ADMIN
The filter icon is shown in merged cells after import export
Unplanned
Last Updated: 19 Aug 2020 13:51 by ADMIN
Currently, the text orientation for cell content is not exported when exporting to PDF format.
Completed
Last Updated: 29 Jul 2020 14:41 by ADMIN
Release R3 2020
Wrongly exported image size when the size of the image is different than the original image size in .NET Standard.
Unplanned
Last Updated: 24 Jul 2020 11:25 by ADMIN
Currently, if there is an unsupported feature in the imported document it is stripped and not preserved in the document model (the Workbook). When exporting the Workbook the resulting document contains only the supported features.