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.
Under Review
Last Updated: 22 Oct 2020 20:28 by Georges

I open an xlsx file thant i create with Excel and edit it with RadSpreadProcessing.

But then I can't display it in a RadSpreadsheet control. An error is displayed during execution on localhost.

Here is the error message:

Exception non gérée à la ligne 48298, colonne 17 dans http://localhost:53844/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=;;System.Web.Extensions,+Version=4.0.0.0,+Culture=neutral,+PublicKeyToken=31bf3856ad364e35:fr-CA:bc17b1ef-7a1b-49cb-a795-5f1c64597a53:ea597d4b:b25378d2;Telerik.Web.UI:fr-CA:b87b3d5b-f055-4852-bdaf-fef1991116e3:16e4e7cd:f7645509:22a6274a:33715776:8674cba1:7c926187:88144a7a:b7778d6c:c08e9f8a:59462f1:a51ee93e:24ee1bba:6d43f6d9:e330518b:1e771326:8e6f0d33:864068a5:6a6d718d:58366029:874f8ea2:4cd1fec6:71188da4:487c8be1:670fdf23:d944e0f6:c442ac3f:ec7335e:2e4adfe5:b4bec146:77613e24:69667591:a4c22f0d:e0037459:2f872eeb:75e7b247:b9057478:e8e3832e:728f182a:c4143936:5f88c545:6ed7f76e:32b48b51:935ec1c6:f0c58c30:16dc2978:1611ddf4:1bfaef2a:26e91122:c128760b:a7e79140:185812c5:f46195d3:6b3f73b3:2003d0b8:aa288e2d:b092aa46:a44b89c4:c8618e41:e4f8f289:1a73651d:16d8629e:2bef5fcc:a9b7ace7:e085fe68:52af31a4:5fa37e7e

0x800a139e - Erreur d’exécution JavaScript: Expected op «,» but found punc «;» (input: IF(D8<>0;E8/D8;0))

If a workbook was created with Excel, an error prevents it from being opened programmatically in a RadSpreadsheet control. Although it can be displayed there using the open button of the RadSpreadsheet. This error does not occur if you copy the contents of this workbook into the RadSpreadsheet and then save it with the save button on the RadSpreadsheet.

Thank you

Unplanned
Last Updated: 18 Sep 2020 08:45 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 15
Category: SpreadProcessing
Type: Feature Request
18
Add support for preserving and exporting the macros in a macro-enabled workbook.

Macros are pieces of code written in Visual Basic for Applications (VBA) which are used to automate repetitive tasks in excel. The macros are part of the excel file. When a file contains a macro its extension becomes xlsm.

SpreadProcessing should be able to import and export xlsm files and edit the macros in them.
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: 15 Sep 2020 10:14 by ADMIN
The chart size is not correctly set when the TwoCellAnchor contains similar elements
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: 03 Sep 2020 09:33 by ADMIN
ADMIN
Created by: Deyan
Comments: 8
Category: SpreadProcessing
Type: Feature Request
28
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: 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 12:08 by ADMIN
Release R3 2020
ADMIN
Created by: Deyan
Comments: 8
Category: SpreadProcessing
Type: Feature Request
12
Implement functionality to rotate the content of a cell.
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.
Unplanned
Last Updated: 15 Jul 2020 16:37 by ADMIN

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.

 

 

Unplanned
Last Updated: 13 Jul 2020 12:20 by ADMIN
According to the Open XML documentation, the possible max value for this attribute is an unsignedInt or 4294967295.
Unplanned
Last Updated: 09 Jul 2020 06:22 by ADMIN
Created by: George
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
Microsoft Excel supports 2 types of date. Date is the number of days starting from 1/1/1900 or 1/1/1904. The first one is the default the second one has been added cause Macintosh supports it. The Microsoft library supports both of them and you can choose programmatically which one you prefer (https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel._workbook.date1904?view=excel-pia). Expose such an option in SpreadProcessing as well.
Completed
Last Updated: 03 Jul 2020 10:28 by ADMIN
Release R3 2020
The Office Open XML model doesn't support the transparency of the colors inside a document. Even if an alpha channel is used for the colors, this should not be respected by SpreadProcessing and the colors should be without any opacity.
Completed
Last Updated: 03 Jul 2020 09:55 by ADMIN
Release R3 2020
Created by: Luke
Comments: 1
Category: SpreadProcessing
Type: Feature Request
0
When importing a spreadsheet document whose cells use a style that is not defined in the document stylesheet, a KeyNotFoundException is thrown. The style can be just skipped so that the document can be imported without errors.
1 2 3 4 5 6