Unplanned
Last Updated: 20 Feb 2024 09:07 by Lleonard
Empty cell of an unprotected column remains protected if it has a format set to it.
Unplanned
Last Updated: 13 Feb 2024 11:50 by G
XlsFormatProvider: Introduce support for Import/Export documents containing 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

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: 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"
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"

Unplanned
Last Updated: 22 Jul 2024 15:56 by ADMIN

Exception "Format string is not in the correct format" is thrown when importing a file with the following format string: "US$"#,##0.0"m";($#,##0.0)

The exception is thrown in the ValidateDateTimeFormatDescriptor method. 

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.
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'.
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: 28 Nov 2023 14:52 by ADMIN
Introduce support for Implicit Intersection Operator '@'.
Completed
Last Updated: 31 Oct 2023 07:48 by ADMIN
Release R3 2023 SP1
FormulaParseException when importing XLS document containing #REF error in formula.
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.

Completed
Last Updated: 27 Sep 2023 11:17 by ADMIN
An exception is thrown if a conditional formatting rule is resolved for a cell with a row index greater than the max column index.
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.
Unplanned
Last Updated: 11 Sep 2023 11:01 by Darren
Created by: Darren
Comments: 0
Category: SpreadProcessing
Type: Feature Request
5
Introduce support for PDF export of charts.
Unplanned
Last Updated: 05 Sep 2023 11:36 by NKT
Icon sets 'ThreeTriangles', 'ThreeStars', 'FiveBoxes', and 'Custom' are set as a 'ThreeTrafficLightsUnrimmed' when setting a rule.
Unplanned
Last Updated: 09 Aug 2023 06:56 by ADMIN
Created by: Brian
Comments: 2
Category: SpreadProcessing
Type: Feature Request
1
Add support for NOW function. NOW returns the serial number of the current date and time. If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings.

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/CustomFunctions
Unplanned
Last Updated: 06 Jun 2024 14:29 by ADMIN
Created by: Brian
Comments: 4
Category: SpreadProcessing
Type: Feature Request
2
Add support for TEXT function. TEXT lets you change the way a number appears by applying formatting to it with format codes.

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/CustomFunctions