Issue(s):
- Exported cell using 'As shown when printed' mode is cropped or is missing borders
- Exported cell's borders using 'As shown on screen' mode are irregular
What are 'As shown when printed' and 'As shown on screen' ?
When exporting using 'As shown when printed', the text can be cropped or some borders might completely disappear.
Exported using 'As shown when printed' - the first row looks wrong
This happens because the 'As shown when printed' mode requires more margins towards the cropped part of the text.
Note that the border is not affected when the text is centered, but the text might still be cropped.
When exporting a cell from Excel using 'As shown on screen', some borders might look thinner than they were in Excel.
Exported using 'As shown on screen' - some borders are thinner
This is because the selection in Excel does not completely count the top and left borders when using thick borders.
You could solve this by also selecting the cells adjacent to the top and left borders, but they will appear on the export and most importantly, the export won't have the right dimensions.
Fix:
- In 'As shown when printed' mode, keep some margins between the text and the edge of the cell and / or use centered text.
- In 'As shown on screen' mode, avoid defining borders that are larger than 1 pixel.