Unplanned
Last Updated: 03 Dec 2024 13:25 by Gal
Implement validation for IEnumerable properties for reading part of the document, preventing reading them twice.
Completed
Last Updated: 13 Nov 2024 08:50 by ADMIN
Release 2024.4.1106 (Q4 2024)
Add support for importing files with absolute relationship target paths.
Completed
Last Updated: 13 Nov 2024 08:50 by ADMIN
Release 2024.4.1106 (Q4 2024)
Hi, I have a spreadstreamprocessing project, in which I read excel files to import data into my database based on some criteria. I copied code from sample and made changes, but I am facing a problem in reading whole file. If there is a cell with Error, rowImporter stops working after it.  It does not throw any exception or error, just ends reading further from sheet. Is there any way to ignore cells with ERROR and read remaining cells?
Unplanned
Last Updated: 09 Sep 2024 08:23 by Waldemar
Created by: Waldemar
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
1
Add support for XLSM format files.
Completed
Last Updated: 15 May 2024 06:28 by ADMIN
Release 2024.2.426 (2024 Q2)

If  row has a property set on it (for example "hidden" or a style), but it does not otherwise have any cells in it, the application might run into an infinite loop. The xml will look like this:

	<sheetData>
		<row r="1" spans="1:2" x14ac:dyDescent="0.35">
			<c r="A1"><v>1</v></c>
			<c r="B1"><v>2</v></c>
		</row>
		<row r="2" spans="1:2" s="1" customFormat="1" x14ac:dyDescent="0.35"/>
	</sheetData>

The last row has formatting applied, so it is present as an element, but has no cells. This file (when the xml is not formatted) will cause an infinite loop on import.

Unplanned
Last Updated: 06 Mar 2024 12:47 by Kevin
Currently, it is possible to specify the color for each cell explicitly, not the entire column
Unplanned
Last Updated: 26 Jan 2024 12:32 by ADMIN

Exception Message: "Stream does not support seeking."

I was trying to stream an XLSX document directly to a write-only stream when I noticed the XlsxWorkbookExporter implementation (or more precisely the custom ZipArchive implementation) requires the stream to be seekable.

Unplanned
Last Updated: 20 Oct 2023 09:42 by Mattia
Created by: Mattia
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
1
Add API for setting custom document properties (metadata). Such are visualized by the common editors, e.g. in MS Excel in the File menu.

Example properties that can be set through the document properties are:

- Title
- Subject
- Author
- Last Author
- Creation Date
- Category
- Manager
- Company
Unplanned
Last Updated: 22 Aug 2023 12:31 by Arifullah
KeyNotFoundException: 'The given key was not present in the dictionary.' when reading a document,
due to incorrect "borderId" in "bordersList".
Unplanned
Last Updated: 08 Aug 2023 06:50 by Stefan
KeyNotFoundException: 'The given key was not present in the dictionary.' when reading a document,
due to incorrect "fontId" in "cellStyleXfs".
Completed
Last Updated: 06 Jul 2023 08:12 by ADMIN
Release R3 2021
Created by: Gil
Comments: 3
Category: SpreadStreamProcessing
Type: Feature Request
0
Some of the required properties are Orientation and Page size.
Duplicated
Last Updated: 05 May 2023 09:05 by ADMIN
Created by: Diego
Comments: 1
Category: SpreadStreamProcessing
Type: Feature Request
2
Please, implement the filtering feature for the RadSpreadStreamProcessing library.
Unplanned
Last Updated: 28 Apr 2023 06:16 by James

I'd like to have the following style property available in the SpreadStreamProcessing library:

TextRotation

Unplanned
Last Updated: 20 Mar 2023 14:32 by Rekha

SpreadProcessing has a method,  cellValue.GetValueAsString(format), which allows the user to apply excel format on a value and get the result. While in SpreadStreamProcessing one could get the format and the value, there is no way to get their result and this is very inconvenient when the values in question are dates.

Workaround:

foreach (ICellImporter cell in rowImporter.Cells)
{
    string value = cell.Value;
    var format = cell.Format.NumberFormat;

    var cellValueFormat = new CellValueFormat(format);
   
    ICellValue cellValue;
    CellValueFormat valueFormat;

    CellValueFactory.Create(
        value,
        worksheet,
        new CellIndex(0, 0),
        cellValueFormat,
        out cellValue,
        out valueFormat);

    var formattedValue = cellValue.GetResultValueAsString(cellValueFormat);
}
Unplanned
Last Updated: 09 Mar 2023 08:06 by Satish
Created by: Satish
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
1
Add support for hyperlinks export.
Completed
Last Updated: 27 Feb 2023 11:24 by ADMIN
Release R1 2023 SP1
Rows import stops after reading a formula cell.
Unplanned
Last Updated: 24 Feb 2023 10:39 by son
Created by: son
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
0
Add support for Rich Text.
Completed
Last Updated: 14 Feb 2023 11:20 by ADMIN
Release R1 2023 SP1
Provide API that allows retrieving of the cached formula value
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R1 2023
While reading the content, the ReadCellValue method throws NotSupportedException: "The RichText value type is not supported". Although the rich text in the cells is not supported, the library could parse the text content and avoid throwing errors.
Completed
Last Updated: 19 Jan 2023 14:56 by ADMIN
Release R3 2022 SP1
When importing a document containing more than one Number Formats (numFmts) with the same format code (formatCode) an exception is thrown: System.InvalidOperationException: 'Same item with different index exists.'

1 2 3 4