Unplanned
Last Updated: 03 Oct 2018 15:51 by ADMIN
When the workbook contains multiple styles (e.g. 50000), the import is extremely slow. MS Excel loads this document instantaneously.
Unplanned
Last Updated: 24 Oct 2018 12:51 by ADMIN
ADMIN
Created by: Anna
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
The row declaration is the following:

<row r="8" spans="1:18" ht="15.75" x14ac:dyDescent="0.25">

The dyDescent attribute is described as follows:

The dyDescent attribute is a double attribute, as specified in [XMLSCHEMA2/2] section 3.2.5, that specifies the vertical distance in pixels from the bottom of the cells in the current row to the typographical baseline of the cell content if, hypothetically, the zoom level for the sheet containing this row is 100 percent and the cell has bottom-alignment formatting. See section 2.2.4.12 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2016]. The dyDescent attribute has a side effect; it sets the customHeight attribute to true even if the customHeight attribute is explicitly set to false. 

Note: Since the dyDescent attribute is not implemented, the height is not recognized to be custom and therefore it is not imported at all. The row has the default height.
Unplanned
Last Updated: 17 Oct 2018 12:47 by ADMIN
When the worksheet contains fraction numbers with fractional parts > 0.5 and < 0.5 and both these numbers have fraction format applied, the number with fractional part < 0.5 will have incorrect whole part.
Unplanned
Last Updated: 05 Aug 2024 08:26 by McDavid

In Excel this can be achieved by right click on the axis, then from the context menu select "Format Axis".  Go to the "Text Options" tab and "Text Box" group and then in the "Custom angle" field insert the desired value.

Unplanned
Last Updated: 06 Jun 2024 12:52 by Development

Currently, these are the supported image formats:

If we try to import an Excel document containing an image with another format, the following error occurs:

System.Collections.Generic.KeyNotFoundException: 'The given key was not present in the dictionary.'

Unplanned
Last Updated: 06 Mar 2024 16:52 by Naveen
Created by: Naveen
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0

XIRR function returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function.

https://support.microsoft.com/en-gb/office/xirr-function-de1242ec-6477-445b-b11b-a303ad9adc9d