Last Updated: 13 Mar 2017 09:04 by ADMIN
Formulas like =0.0001/10 or formulas that produce small values results in 0 instead of exponential numbers.

Available in LIB version: 2017.1.313
Last Updated: 11 Dec 2018 15:22 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:

Although the escaped strings are not supported (see ), 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:

Fix available in R3 2018 SP1 release.
Last Updated: 20 Feb 2018 09:24 by ADMIN
When a workbook (xlsx) contains a worksheet where some of the columns have width, bigger than the value written in the SpreadsheetDefaultValues (2000) an exception during the import is thrown.
Last Updated: 22 Feb 2017 11:55 by ADMIN
CellSelection.SetValue method causes memory leak of CellReferenceRangeExpression objects in some cases when cell value is referenced by formulas. The memory leak is small, but the remaining CellReferenceRangeExpression continue to listen to some events, causing performance issues when their number become large - the time to set the value increases with each set.
Last Updated: 06 Aug 2019 12:51 by ADMIN
Created by: Brittany
Comments: 0
Category: SpreadProcessing
Type: Bug Report
It takes ~42 seconds to remove each 100th row from a document with 50000 rows and 100 columns.
Last Updated: 05 Sep 2018 14:44 by ADMIN
When the scale factor of a document is smaller, the borders don't seem to scale correctly when exported to PDF. They appear much thicker than they would when exported from Excel.
Last Updated: 21 Sep 2018 13:02 by ADMIN
When inserting cells a check is performed for data loss. This check should take into account the value property, but should not take into account properties like cell value format and data validation. 

Workaround: clear the values at the end of the worksheet before inserting cells.
worksheet.Cells[1048575, 0, 1048575, 16383].ClearDataValidationRule();
Last Updated: 21 Aug 2018 10:56 by ADMIN
Having cell with custom format string set to "MMM" does not apply correctly. Instead of showing the date in the defined format (for instance "Aug"), what actually is displayed is "MMM".
Last Updated: 10 Apr 2019 14:35 by ADMIN
Exporting empty workbook without any worksheet is not allowed according to the specification and such documents cannot be opened in Excel. Ensure the customers cannot create such documents using the API of SpreadProcessing.
Last Updated: 09 May 2017 06:59 by ADMIN
Comparison operators (equal '=', not equal '<>') doesn't work as expected with references to empty cells. For example, expressions of type '=IF(A1="", TRUE, FALSE)' are evaluated to false when A1 cell is empty. 

In MS Excel, such expression is evaluated to TRUE if the cell is empty - i.e. empty cell value is considered equal to an empty string "".

Workaround: Use ISBLANK function if possible. Its results are consistent with MS Excel.
Last Updated: 11 Mar 2020 10:05 by ADMIN
Some of the leftmost borders are omitted when exported to PDF.
Last Updated: 05 Oct 2016 07:04 by ADMIN
If shape extent is declared, the two cell anchor points for the drawing element are ignored. For example if the TwoCellAnchorElement's from and two points declare that the image should be anchored starting from cell A1to F10 and further in the drawing declaration there is defined extents element with image size values, anchor element's points are ignored. 
Last Updated: 13 Sep 2018 12:11 by ADMIN
Generating document which consists of merged cells in a row and some values then inserting a row on the top and then exporting the document or setting it to the RadSpreadsheet causes wrong merged cells.

If the generation is done on a workbook which is already set to the RadSpreadsheet everything is OK.

Workaround: The document can be exported and then imported again before the row is inserted.
Last Updated: 31 May 2016 17:18 by ADMIN
Last Updated: 17 Jan 2017 15:35 by ADMIN
When the column width is not an integer number, but a decimal fraction one, the width which is exported is not calculated correctly. 

For example, if there is a cell with some text and its column's width is autofit, it's exported with different actual width.

In addition, if the exported xlsx file is imported back in the Spreadsheet, the column width is a bit different from the one which was exported (only for the first export-import roundtrip).
Last Updated: 11 Jan 2019 12:35 by ADMIN
When a chart is inserted in a document, generated by SpreadProcessing or WordsProcessing, the chart seems to lack any bars. The reason is that some theme information is missing, which effectively makes shapes take their default color, which is transparent. The same applies for shapes inserted in any Document Processing-generated OOXML documents - docx, xlsx.

Workaround: (applicable for Excel) Manually change the theme for the document in MS Excel:
- Choose Page Layout -> Themes -> Themes dropdown -> Office.
Last Updated: 18 Jan 2017 07:35 by ADMIN
When importing and exporting xlsx document with email address hyperlink the exported document shows invalid document message when opened in Excel: "We found a problem with some content in 'file.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of thes workbook, click Yes.". The document can be only partially recovered and information is lost.
Last Updated: 12 Dec 2016 14:47 by ADMIN
Steps to reproduce: 

1. Enter in a cell =Today()
2. Show Format Cells dialog and set Custom format "d"

Expected: The value is the day of the month.
Actual: The date is formatted as short date but has to be day of the month.
Last Updated: 13 Feb 2018 14:47 by ADMIN
Excel exports shapes as TwoCellAnchor elements, which specifies the top left and the bottom right location of a shape. The size of the shape is recorded in the extents element (a:ext), cx and cy attributes. At the moment, the spreadsheet import first looks at the extents element and if it doesn't find the size there, calculates it from the TwoCellAnchor element. 

However, if an XLSX document has a shape with incorrect size indicated in the extents element, Excel will still be able to open it correctly, probably because it looks at the TwoCellAnchor element. RadSpreadsheet/SpreadProcessing, on the other hand, will show the image with an incorrect size.
Last Updated: 17 May 2018 08:04 by ADMIN
KeyNotFoundException is thrown on import. The number formats with id 5, 6, 7 and 8 are missing in the built-in number formats.

Available in R2 2018 Official Release version.
1 2 3