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.

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

TextRotation

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);
}

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

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.