Files exported with SpreadStreamProcessing cannot be read by OleDB consumers

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

API that allows you to get the styles and colors from the current theme.

Add support for CSV settings when exporting (delimiter, encoding). 

Exception when exporting a conational formatting rule with no formatting 

Allow users to define sorting.

In addition to the fast document generation, the SpreadStreamProcessing can be adapted to import documents significantly faster than SpreadProcessing.

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.

Exception when color does have a complete value.

Setting up a paper size to A1 and exporting the document actually sets the paperSize to 1. 

This leads to inappropriate values when entering the Page Setup options later in Excel.

When using the API for measuring the cell content size the results are not correct.

Expose API that allows you to get the styles colors from the current theme

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.

Such settings are: "Summary Rows Below Detail", "Summary Columns to Right of Detail" and "Automatic styles".

When calling SpreadExporter.CreateWorkbookExporter method and referencing Trial assemblies an exception is thrown: System.ArgumentException: 'An item with the same key has already been added.'

This behavior is observed both with the NuGet packages and DLLs.

It is not observed with Trial DLLs version 2020.3.1019

The space="preserve" attribute defines that the visualizing application must show all the spaces inside a string value. Without this attribute, MS Excel trims the blank spaces of the values.

Currently, this functionality is supported by the SpreadProcessing library. More information can be found in Worksheet Protection and Workbook Protection help articles.

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.

Allow the customers to specify which one of the sheets inside the workbook will be active when the document is opened.