Unplanned
Last Updated: 29 Jun 2023 14:05 by David
Auto-fit exported table to page.
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 Jun 2023 13:30 by Bhavya
Created by: Bhavya
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Implement import of PDF to Workbook, using PdfFormatProvider. This would require text recognition and table recognition.

This will allow the conversion of PDF documents to XLSX and CSV.
Unplanned
Last Updated: 26 Jun 2023 11:01 by Murphy
Named range's naming convention is ignored on import for Xlsx and Xlsm formats, but respected in Xls.
Unplanned
Last Updated: 14 Jun 2023 05:54 by Akesh Gupta
Created by: Akesh Gupta
Comments: 0
Category: SpreadProcessing
Type: Feature Request
1
SpreadProcessing: feature request to add IEnumerable<T> Interface(LINQ) implementation with CellSelection
Unplanned
Last Updated: 16 Jun 2023 10:22 by ADMIN

When opening an Xlsx file with conditional formatting I get an Exception:

"System.ArgumentNullException: 'Value cannot be null. (Parameter 'formatting')'

at Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings.ConditionalFormattingDxfRule..ctor(DifferentialFormatting formatting)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.ConditionalFormattingRuleElement.GetRule(DifferentialFormatting formatting)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.ConditionalFormattingRuleElement.OnAfterRead(IXlsxWorksheetImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.OpenXmlImporter`1.ImportPartFromArchive(ZipArchiveEntry zipEntry, PartBase part, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.OpenXmlImporter`1.Import(Stream input, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider.ImportOverride(Stream input)
   at WpfApp1.MainWindow.StartExcel() in C:\Users\larse\source\repos\WpfApp1\MainWindow.xaml.cs:line 49"

To quote my colleage: "After dissecting the Excel template file, I have isolated what is causing the issue. If conditional formatting is used to disable cell boarders it results in the error, if the conditional formatting is updated to turn the necessary borders white, instead of disabling the report exports correctly, the following screenshot also explains."

Unplanned
Last Updated: 26 May 2023 10:40 by Bernie
If a column has a number format set and has a 'Total' cell at the bottom with the SUM of all the cells above, the 'Total' cell should be exported as a number as well.
Unplanned
Last Updated: 23 May 2023 14:05 by ADMIN

If a rule is added with no formatting (for example, in the case when we want to add a rule which preserves the default formatting in some cases) the exported document is corrupted.

DifferentialFormatting formatting2 = new DifferentialFormatting();

ContainsBlanksRule rule2 = new ContainsBlanksRule(formatting2);
rule2.Formatting = formatting2;

ConditionalFormatting conditionalFormatting2 = new ConditionalFormatting(rule2);
worksheet.Cells[1, 2, 12, 2].AddConditionalFormatting(conditionalFormatting2);

A possible workaround is to add formatting to the rule, which copies the default:

DifferentialFormatting formatting2 = new DifferentialFormatting();
formatting2.Fill = new PatternFill(PatternType.Solid, Colors.Transparent, Colors.Transparent);
CellBorder border = new CellBorder(CellBorderStyle.Thin, new ThemableColor(Color.FromRgb(212, 212, 212)));
formatting2.LeftBorder = border;
formatting2.TopBorder = border;
formatting2.RightBorder = border;
formatting2.BottomBorder = border;
Completed
Last Updated: 04 Jul 2023 12:30 by ADMIN
Release R2 2023 SP1
If a workbook with data validation makes use of a formula which has a string in it, on import and export, the data validation will become invalid.
Completed
Last Updated: 17 May 2023 11:34 by ADMIN
Release R2 2023
 Importing an XLS file causes NullReferenceException due to fill color.
Unplanned
Last Updated: 05 May 2023 13:00 by Dan
Documents with many shared formulas import slow.
Completed
Last Updated: 04 Jul 2023 12:11 by ADMIN
Release R2 2023 SP1
If the column has a text format set and has a mixture of text and numbers, the numbers should be exported as text as well.
Completed
Last Updated: 08 May 2023 13:06 by ADMIN
Release R2 2023

Applying text format to a column also sets the format to the next column.

This happens when the columns have a size different from the default and two consecutive columns with different format also have the same size. This can be worked around with a slight change in the column sizes:

int columnCount = worksheet.UsedCellRange.ColumnCount;

for(int i = 1; i < columnCount; i++)
{
    ColumnWidth colWidth = worksheet.Columns[i].GetWidth().Value;
    if(colWidth.Value != SpreadsheetDefaultValues.DefaultColumnWidth)
    {
        ColumnWidth previousColWidth = worksheet.Columns[i - 1].GetWidth().Value;

        if(colWidth.Equals(previousColWidth))
        {
            worksheet.Columns[i].SetWidth(new ColumnWidth(colWidth.Value + 1, colWidth.IsCustom));
        }
    }
}

Unplanned
Last Updated: 17 Apr 2023 10:46 by Dimitar
Implement Copy/Paste functionality of conditional formatting between sheets.
Completed
Last Updated: 18 May 2023 07:54 by ADMIN
Release R2 2023
Unplanned
Last Updated: 13 Mar 2023 08:04 by Rich
Created by: Rich
Comments: 0
Category: SpreadProcessing
Type: Feature Request
2
Add support for structured references in tables.
Unplanned
Last Updated: 03 Mar 2023 06:17 by Trevor
NullReferenceException when trying to get and index from a compressed list 
Unplanned
Last Updated: 13 Feb 2023 14:21 by Maik

The Value property of DefinedName (implementing ISpreadsheetName) always returns a result with a General format, which is very impractical when the value is for example a date. There should be an option to get a formatted result as well.

A possible workaround for this missing functionality would be to parse the RefersTo value and find where it points in order to grab the format:

Workbook workbook = new Workbook();
Worksheet ws = workbook.Worksheets.Add();
ws.Cells[0, 1].SetValue("2/1/2013");

ws.Names.Add("MyField", "=Sheet1!$B$1", new CellIndex(0, 0), "My Field");

string value = ws.Names["MyField"].Value;

CellRange range;
bool success = NameConverter.TryConvertCellRangeNameToCellRange(ws.Names["MyField"].RefersTo, out range);

CellValueFormat format = ws.Cells[range].GetFormat().Value;
string result = ws.Cells[range].GetValue().Value.GetResultValueAsString(format);

Unplanned
Last Updated: 03 Feb 2023 13:15 by Michael Nikolai
The firstSheet attribute of the workbookView element is missing causing Excel to not scroll the sheets in the sheet selector.
Completed
Last Updated: 14 Feb 2023 11:34 by ADMIN
Release R1 2023 SP1
If a conditional formatting rule with formula is set to "B1=True" and the cell B1 has value "false", the formatting will still be applied.