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:43 by Francesco
Add support for importing files with absolute relationship target paths.
Unplanned
Last Updated: 20 Oct 2023 09:42 by Stefania
Created by: Stefania
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: 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.
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.
Unplanned
Last Updated: 16 Dec 2022 13:14 by ADMIN

Respectfully request the ability to set the text orientation of a cell. This feature was added to the SpreadProcessing library and we'd like to see it added to  the SpreadStreamProcessing library.

I operate mostly within the streaming version of the spread-processing library, so I don't have an idea of how full-featured the implementation was in SpreadProcessing. My request for the streaming library is to be provided with similar functionality as that which is provided by Excel:

Thank you,

R. J. Lewis III

Unplanned
Last Updated: 13 Dec 2022 09:16 by Rik
API that allows you to get the styles and colors from the current theme.
Unplanned
Last Updated: 15 Nov 2022 12:19 by Mark
Created by: Mark
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
6
Add support for CSV settings when exporting (delimiter, encoding). 
Unplanned
Last Updated: 01 Nov 2022 11:42 by William
Created by: William
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
1
Allow users to define sorting.
Unplanned
Last Updated: 08 Sep 2022 12:53 by Denis
This attribute is needed to ensure the text values entered by users will appear in the same way as they inserted them. However, there are customers preferring to decrease the file size and skip this attribute. Expose a setting to allow them to achieve that.
Unplanned
Last Updated: 26 Mar 2021 10:22 by ADMIN
Created by: Dmitry
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
9
Such settings are: "Summary Rows Below Detail", "Summary Columns to Right of Detail" and "Automatic styles".
Unplanned
Last Updated: 18 Dec 2020 08:23 by ADMIN
Created by: Rick
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
4
Currently, this functionality is supported by the SpreadProcessing library. More information can be found in Worksheet Protection and Workbook Protection help articles.
Unplanned
Last Updated: 06 Oct 2020 07:10 by ADMIN
Created by: Ryan
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
0
Allow the customers to specify which one of the sheets inside the workbook will be active when the document is opened.
Unplanned
Last Updated: 20 Dec 2019 07:39 by ADMIN
Created by: Dimitar
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
1
One should be able to add hyperlinks.
Unplanned
Last Updated: 30 Aug 2019 11:06 by ADMIN
Created by: Brittany
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
0
Add support for cell border thickness.
Unplanned
Last Updated: 03 Apr 2019 09:10 by ADMIN
Created by: Cédric
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
5
Add support for exporting content with strikethrough font effect.
Unplanned
Last Updated: 05 Jul 2018 08:39 by ADMIN

In some scenarios, the customers need to apply (number) formatting to the whole row or column at once. At this point, formatting can be applied only to the cells.
			
1 2