Unplanned
Last Updated: 30 Jun 2025 14:58 by ADMIN
ADMIN
Created by: Tanya
Comments: 3
Category: SpreadProcessing
Type: Feature Request
10

Provide the ability to work with images in headers/footers of a worksheet. Note that large images put in headers are visualized as watermarks on printing/exporting to PDF.

Watermark in Excel: https://support.office.com/en-us/article/add-a-watermark-in-excel-a372182a-d733-484e-825c-18ddf3edf009

 

Unplanned
Last Updated: 12 Jun 2025 08:44 by Lorenzo
Created by: Lorenzo
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for Stock charts (StockChart).
Unplanned
Last Updated: 06 Jun 2025 14:56 by ADMIN
ADMIN
Created by: Deyan
Comments: 10
Category: SpreadProcessing
Type: Feature Request
33
Add support for pivot tables.
Unplanned
Last Updated: 05 Jun 2025 11:46 by ADMIN
Add API that allows one to manipulate the macros inside a Workbook.
Unplanned
Last Updated: 04 Jun 2025 12:33 by Sailaja
Stacktrace: 
   at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
   at System.Collections.Generic.Dictionary`2.FindValue(TKey key)
   at System.Collections.Generic.Dictionary`2.ContainsKey(TKey key)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.ConditionalFormattingRuleElementX14.OnAfterRead(IXlsxWorksheetImportContext context) in C:\Work\document-processing\Documents\Spreadsheet\FormatProviders\OpenXml\Xlsx\Model\Elements\Worksheets\ConditionalFormatting\x14\ConditionalFormattingRuleElementX14.cs:line 62
Unplanned
Last Updated: 20 May 2025 15:13 by Christopher
Add support for documents with unexpected text between child elements (e.g. ZWNBSP).
Unplanned
Last Updated: 15 Apr 2025 09:58 by Stefano
Created by: Stefano
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1

The COUNTA function counts cells containing any type of information, including error values and empty text ("")

https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509 

Unplanned
Last Updated: 15 Apr 2025 08:22 by Jonas
Expose the argument values of existing conditional formatting rules. Currently, the argument values from the SingleArgumentConditionalFormattingRule and DoubleArgumentConditionalFormattingRule classes are internal.
Unplanned
Last Updated: 28 Mar 2025 10:03 by Pablo
Exporting XLS file with filters results in a corrupted document.
Unplanned
Last Updated: 21 Mar 2025 15:14 by Piotr
Unplanned
Last Updated: 25 Feb 2025 14:53 by David
Chart with missing shape properties (shPr) is corrupted with black background after PDF export.
Unplanned
Last Updated: 17 Feb 2025 15:34 by Sandy
Unplanned
Last Updated: 06 Feb 2025 12:00 by Sandy
ConditionalFormattingRange' s Formattings collection is not correctly enumerated when there are rules with intermittent ranges.
Unplanned
Last Updated: 05 Feb 2025 12:02 by ADMIN
ADMIN
Created by: Deyan
Comments: 11
Category: SpreadProcessing
Type: Feature Request
76
Add support for creating Tables and applying tables styles (predefined ones or custom).
Unplanned
Last Updated: 29 Jan 2025 14:18 by Lava
Created by: Lava
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
Introduce import/export of a single sheet.
Unplanned
Last Updated: 27 Jan 2025 15:00 by ADMIN
Created by: Christopher
Comments: 2
Category: SpreadProcessing
Type: Feature Request
2
Unplanned
Last Updated: 24 Jan 2025 08:12 by Christopher

Use the following code to create the document: 

            Workbook workbook = new Workbook();
            Worksheet graphWorksheet = workbook.Worksheets.Add();
            FloatingChartShape chartShape = new FloatingChartShape(graphWorksheet,
                                         new CellIndex(0, 0),
                                         new CellRange(0, 0, 0, 0), ChartType.Column)
            {
                Width = 500,
                Height = 500,
            };

            graphWorksheet.Charts.Add(chartShape);
            DocumentChart chart = new DocumentChart();
            BarSeriesGroup barSeriesGroup = new BarSeriesGroup();
            barSeriesGroup.BarDirection = BarDirection.Column;
            StringChartData barCategoryData = new StringChartData(new List<string>() { "1.1", "1.2", "1.3", "1.4", "2.1", "3.1", "4.1", "4.2", "4.3" });
            IEnumerable<double> percentEvidentList = new List<double>() { Math.Round((double)0.9914 * 100, 4) , Math.Round((double)0.7719 * 100, 4), Math.Round((double)1 * 100, 4)   };
            NumericChartData barValues = new NumericChartData(percentEvidentList);
            BarSeries series = new BarSeries();
            series.Categories = barCategoryData;
            series.Values = barValues;
            ThemableColor themableColor = ThemableColor.FromArgb(255, 125, 0, 125);

            series.Fill = new SolidFill(themableColor);
            series.Title = new TextTitle("FY 20");
            barSeriesGroup.Series.Add(series);
            chart.SeriesGroups.Add(barSeriesGroup);
            ValueAxis valueAxis = new ValueAxis();
            valueAxis.Min = 0;
            valueAxis.Max = 100;
            valueAxis.NumberFormat = "0%";
            CategoryAxis categoryAxis = new CategoryAxis(); 
            chart.PrimaryAxes = new AxisGroup(categoryAxis, valueAxis);

            chart.Legend = new Legend();
            chart.Legend.Position = LegendPosition.Left;

            chartShape.Chart = chart;
            valueAxis.NumberFormat = "0%";
            string outputFilePath = "SampleFile.xlsx";
            File.Delete(outputFilePath);
            IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();

            using (Stream output = new FileStream(outputFilePath, FileMode.Create))
            {
                formatProvider.Export(workbook, output, TimeSpan.FromSeconds(10));
            }
            Process.Start(new ProcessStartInfo() { FileName = outputFilePath, UseShellExecute = true });
Unplanned
Last Updated: 21 Jan 2025 15:42 by Adrian
Created by: Adrian
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for "Of Pie" charts (ofPieChart).
Unplanned
Last Updated: 21 Jan 2025 15:35 by Adrian
Import-export of a document with unsupported charts results in an invalid document.
Unplanned
Last Updated: 10 Jan 2025 12:45 by Chris
Handle import of documents containing XLSX-incompatible names.
1 2 3 4 5 6