The content of some rows which contain new lines can be clipped when a fixed-width column is wrapped.
This can be observed in the following images.
Before the export:
After the export:
The vertical grid lines are not visible in a scatter chart. The grid lines are visible when opened in Excel.
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.
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)