Unplanned
Last Updated: 28 Nov 2022 06:34 by Ralf

 Provide the following options for the image:

  • Move and size with cells
  • Move but don't size with the cells
  • Don't move or size with the cells
Unplanned
Last Updated: 07 Dec 2022 10:50 by n/a
Memory leaks when importing large documents with formulas consecutively. So weak events still remain in the memory. 
Unplanned
Last Updated: 08 Dec 2022 09:53 by Joe
XlsFormatProvider: LeftoverDataException when importing a specific document. 'Initialisation of record 0x55(DefaultColWidthRecord) left 2 bytes remaining still to be read.'
Unplanned
Last Updated: 22 Dec 2022 09:58 by Kheng Aik

LayoutHelper is not calculating Height properly in net standard.

Workaround: use SpreadFixedTextMeasurer

Unplanned
Last Updated: 05 Jan 2023 13:49 by Eljay

When a worksheet contains a cell with longer text, which is right aligned and this text happens to be in the last column of the page, the worksheet is incorrectly split into pages and the last column gets transferred on the next page.

Workaround: Set explicitly the print area you would like to print.

worksheet.WorksheetPageSetup.PrintArea.SetPrintArea(new CellRange(0, 0, 38, 14));

Unplanned
Last Updated: 10 Jan 2023 11:06 by Dmytro
Provide an API for changing the position of the chart axes
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.
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.
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 Mar 2023 06:17 by Trevor
NullReferenceException when trying to get and index from a compressed list 
Unplanned
Last Updated: 17 Apr 2023 10:46 by Dimitar
Implement Copy/Paste functionality of conditional formatting between sheets.
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: 05 May 2023 13:00 by Dan
Documents with many shared formulas import slow.
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.
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;
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: 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: 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.
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: 29 Jun 2023 14:05 by David
Auto-fit exported table to page.