Duplicated
Last Updated: 12 Feb 2024 16:36 by ADMIN
Created by: Abhishek
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Introduce support for evaluating macros.
Declined
Last Updated: 26 Jan 2024 12:10 by ADMIN

In WorksheetPageSetup, you can only get the PageSize, but not set it. The only way is through setting a PaperType.

 

This is because in Telerik.Windows.Documents.Spreadsheet.Model.Printing.SheetPageSetupBase, the only way to set the pageSize property is by setting a PaperType, then it uses PaperTypeConverter.ToSize(PaperType) to convert it to the pageSize. I cannot see any other way to set this to a custom size set by the user.

 

Please allow custom page sizing by adding a setter for the PageSize if possible. Thank you!

 


WorksheetPageSetup pageSetup = worksheet.WorksheetPageSetup;
Size pageSize = new Size(50, 80)
pageSetup.PageSize = pageSize; // produces cs0200
pageSetup.PageSize.Width = pageSize.Width; // produces cs1612
pageSetup.PageSize.Height = pageSize.Height; // produces cs1612

Completed
Last Updated: 15 Jan 2024 11:02 by ADMIN
Release 2024 Q1
When a document containing charts is imported sometimes an exception is thrown: "The axes are incorrectly paired"
Unplanned
Last Updated: 11 Jan 2024 13:59 by Dev

Use the code to import a sample txt file containing a "+" sign in a cell value:

 Workbook workbook;
 Telerik.Windows.Documents.Spreadsheet.FormatProviders.IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.TextBased.Txt.TxtFormatProvider();

 using (Stream input = new FileStream(@"sample.txt", FileMode.Open))
 {
     workbook = formatProvider.Import(input);
 }

Expected behavior: the file is imported successfully

Actual behavior: an error is thrown

 

Completed
Last Updated: 11 Jan 2024 08:24 by ADMIN
Release 2024 Q1
Some of the leftmost borders are omitted when exported to PDF.
Completed
Last Updated: 09 Jan 2024 09:38 by ADMIN

ArgumentException  at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.Theme.SystemColorElement.GetColor(IOpenXmlImportContext context)

The problematic value is val="windowText"

Completed
Last Updated: 14 Dec 2023 14:02 by ADMIN
Release Q1 2024
The alignment of cells with custom formatting is not respected after PDF export.
Unplanned
Last Updated: 28 Nov 2023 14:52 by ADMIN
Introduce support for Implicit Intersection Operator '@'.
Unplanned
Last Updated: 03 Nov 2023 10:46 by ADMIN
Created by: CTI
Comments: 0
Category: SpreadProcessing
Type: Bug Report
1

In some cases when cells are merged the cell borders are not correctly imported.

Completed
Last Updated: 03 Nov 2023 08:19 by ADMIN
Release R3 2023 SP1
The chart size is not correctly set when the TwoCellAnchor contains similar elements
Completed
Last Updated: 02 Nov 2023 15:50 by ADMIN
Release R3 2023 SP1
Value is treated as a number when the ampersand operator is used.
Unplanned
Last Updated: 31 Oct 2023 16:08 by ADMIN
Created by: Dimitar
Comments: 0
Category: SpreadProcessing
Type: Bug Report
1
The MATCH function does not work as expected. Should work exactly like in Excel. 
Unplanned
Last Updated: 31 Oct 2023 15:52 by ADMIN
When a cell contains a lot of empty lines the last line is not rendered correctly.
Completed
Last Updated: 31 Oct 2023 15:33 by ADMIN
Release R3 2023 SP1
Created by: shashidhar
Comments: 0
Category: SpreadProcessing
Type: Bug Report
1

Filter Selection dialog appears on the screen. 

Workaround: Open the file with Excel and save it as a new document.

Completed
Last Updated: 31 Oct 2023 07:48 by ADMIN
Release R3 2023 SP1
FormulaParseException when importing XLS document containing #REF error in formula.
Completed
Last Updated: 31 Oct 2023 06:17 by ADMIN
Release R3 2023 SP1
When a sheet is protected in an asynchronous scenario an exception is thrown: System.ArgumentException: 'An item with the same key has already been added. Key: RIPEMD-160'.
Completed
Last Updated: 30 Oct 2023 13:22 by ADMIN
Release R3 2023 SP1
InvalidOperationException is thrown in files where the Comments part is imported after the ThreadedComments part.
Unplanned
Last Updated: 20 Oct 2023 08:26 by Michael
Created by: Michael
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2

Implement a GoalSeek functionality.

 

Unplanned
Last Updated: 04 Oct 2023 08:14 by Cyril

Sometimes leading minus sign in a cell with text is treated as a formula.

A possible workaround is to remove the minus sign or to replace it with some other symbol.

Unplanned
Last Updated: 04 Oct 2023 08:12 by Cyril

When there are unclosed quotes (") several cells/rows are imported as one.

A possible workaround is to replace all the quote (") symbols with single quote (') symbols.