Unplanned
Last Updated: 09 Oct 2020 09:27 by ADMIN
Number formats like this: #,##0.0,,;(#.##0.0..) can not be applied, because the trailing commas in the first part of the format "#,##0.0,," are not supported.
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: 16 Jul 2020 08:31 by ADMIN
ADMIN
Created by: Anna
Comments: 2
Category: SpreadStreamProcessing
Type: Feature Request
20
In addition to the fast document generation, the SpreadStreamProcessing can be adapted to import documents significantly faster than SpreadProcessing.
Unplanned
Last Updated: 20 Dec 2019 07:39 by ADMIN
Created by: Dimitar
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
0
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
2
Add support for exporting content with strikethrough font effect.
Completed
Last Updated: 13 Dec 2018 15:23 by ADMIN
ArgumentException with clarification similar to  "'\u001f', hexadecimal value 0x1F, is an invalid character." is thrown when trying to export document containing characters which are not supported in XML document - such as some control characters like 0x00, 0x1F, 0x1B, etc. Such characters are described in the XML specification here: https://www.w3.org/TR/xml/#charsets.
Although the escaped strings are not supported (see related 181318), the library could prevent the exception and export the document successfully by skipping such characters.
Workaround: remove such characters before the export. Check the following StackOverflow answer for some ideas on code for replacing the characters: http://stackoverflow.com/a/14323524/259206


Declined
Last Updated: 12 Dec 2018 09:21 by ADMIN

ArgumentException with clarification similar to "'\u001f', hexadecimal value 0x1F, is an invalid character." is thrown when trying to export document containing characters which are not supported in XML document - such as some control characters like 0x00, 0x1F, 0x1B, etc.

Such characters are described in the XML specification here: https://www.w3.org/TR/xml/#charsets.


Code to reproduce 
using (var stream = File.OpenWrite("sample.xlsx"))
using (var workbook = SpreadExporter.CreateWorkbookExporter(SpreadDocumentFormat.Xlsx, stream))
using (var worksheet = workbook.CreateWorksheetExporter("My sheet"))
using (var row = worksheet.CreateRowExporter())
using (var cell = row.CreateCellExporter())
{
      cell.SetValue(string.Format("Error Value: {0} ", Encoding.ASCII.GetString(new byte[] { 8 })));
}

Unplanned
Last Updated: 27 Nov 2018 13:46 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 3
Category: SpreadStreamProcessing
Type: Feature Request
5
Provide a way to export filters.
Completed
Last Updated: 27 Nov 2018 11:29 by ADMIN
At this point, CsvWorkbookExporter flushes the data to the underlying stream each time a new data is added. This leads to decreased performance. Ensure the best possible performance by flushing the stream at the end of the content generation.

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.
			
Unplanned
Last Updated: 26 Apr 2018 15:29 by ADMIN
When setting a date in a cell using SetValue(DateTime), the value should be converted to its numerical representation before adding it to the XML. However, it is currently written as a string. This causes issues when opening the generated file with Google Sheets - the dates are not visible in the file.

A customer also reported that this is causing issues when the file is opened with MS Excel in specific cultures, but we were unable to reproduce that locally.

Workaround: Convert the DateTime value to a number before setting it to the cell:
cell.SetValue(DateTime.Now.Date.ToOADate());
Unplanned
Last Updated: 28 Mar 2018 13:05 by ADMIN
The customers should have the ability to change the symbol used as a delimiter and the symbol used as a quote for a CSV document.
Unplanned
Last Updated: 24 Jan 2018 08:59 by ADMIN
ADMIN
Created by: Anna
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
1
At the moment only the XLSX and CSV formats are supported. It would be a good idea to add the TXT format as well.
Unplanned
Last Updated: 07 Nov 2017 08:24 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
2
Expose an option to overwrite a sheet if it already exists in the workbook.
Unplanned
Last Updated: 28 Aug 2017 09:33 by ADMIN
Provide a way to measure text on different platforms so the user can pass the cell value and SpreadCellFormat and get the size of the text in pixels. This way we will be able to implement auto-fit to width functionality (AutoFitWidth), at least for the .NET Framework implementation. It will be able to measure the width of all cells in a column and set the value as column width in pixels.
Unplanned
Last Updated: 17 Aug 2017 10:13 by ADMIN
ADMIN
Created by: Tanya
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
2
Add ability to export charts.
Unplanned
Last Updated: 17 Aug 2017 10:10 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
7

			
Unplanned
Last Updated: 17 Aug 2017 10:07 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
7

			
Unplanned
Last Updated: 17 Aug 2017 10:05 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 0
Category: SpreadStreamProcessing
Type: Feature Request
7

			
1 2