SpreadProcessing: Upon export, sheet reference in formulas such as VLOOKUP is lost when using whole row/column references.
For example the formula
=VLOOKUP("test",Sheet1!A:C,1,0) is exported as
=VLOOKUP("test",A:C,1,0)
The format applied to the first value of the range of the chart determines the format of the value (vertical) axis. If the format of this value is changed, the model attempts to set a new format to the axis. If the chart does not support axes, the value of its PrimaryAxes property is null, which causes NullReferenceException.
When a worksheet contains a cell with longer text, which is right aligned and this text happens to be in the last column of the page, the worksheet is incorrectly split into pages and the last column gets transferred on the next page.
Workaround: Set explicitly the print area you would like to print.
worksheet.WorksheetPageSetup.PrintArea.SetPrintArea(new CellRange(0, 0, 38, 14));
LayoutHelper is not calculating Height properly in net standard.
Workaround: use SpreadFixedTextMeasurer
Provide the following options for the image: