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: 18 May 2023 07:54 by ADMIN
Release R2 2023
Completed
Last Updated: 17 May 2023 11:34 by ADMIN
Release R2 2023
 Importing an XLS file causes NullReferenceException due to fill color.
Completed
Last Updated: 15 May 2023 07:03 by ADMIN
Release R1 2023
Wrong color scheme colors leads to wrong cell coloring on export.
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: 28 Apr 2023 13:45 by ADMIN
SpreadProcessing: Copying a cell with a LessThan conditional formatting rule throws a Null reference exception
Unplanned
Last Updated: 17 Apr 2023 10:46 by Dimitar
Implement Copy/Paste functionality of conditional formatting between sheets.
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: 02 Mar 2023 07:40 by ADMIN
Created by: Lee
Comments: 2
Category: SpreadProcessing
Type: Feature Request
1
Currently, adding hyperlinks to images is not supported.
Completed
Last Updated: 21 Feb 2023 14:27 by Ivan
Release R1 2023 SP1
InvalidCastException on import when a drawing in a document contains the "ext" tag 
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: 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: 02 Feb 2023 08:40 by ADMIN
Release LIB 2023.1.206 (6 Feb 2023)
When a file with a format string of the type "\m\:0.#;\m\:0.#;\m\:0.#;\m\:\ @" is imported, argument exception is thrown.
Completed
Last Updated: 24 Jan 2023 10:29 by ADMIN
Release R3 2022 SP1
Text is cut off in Net Standard with a specific document.
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023
The relationship ID is needed to parse the hyperlink target and is mandatory by the specification. However, XlsxFormatProvider throws an exception while reading that hyperlink and cannot open the document.
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023

When a file uses shared formulas, if the cell references are not explicitly written in the cell element, the formulas will not be shown correctly. This will manifest like a file that has a succession of slightly differing formulas in Excel and in RadSpreadsheet or RadSpreadProcessing they will be a succession of the same formula instead.