Introduction:
The following article is about image size/ratio disparities between Excel and PowerPoint/Word. These issues can arise even if the zoom level/scaling is set to 100% on all workstations. If the zoom levels in Excel or DPI scaling in Windows are not the same within your team, read this article first.
Note that Upslide's export feature is based on Excel's native function 'Copy Picture', therefore inheriting the native issues, for both export modes.
Ratio/dimensions disparities:
When copying or exporting from Excel, the size of the resulting image can be slightly different from the original table/chart. Here is an example in mode 'as shown on screen':
 |
 |
 |
| Size in Excel | Size in Powerpoint (after classic copy/paste) |
Size in Powerpoint (after UpSlide export) |
Note that:
- All the sizes are different.
- The native copy is quite far from the size in Excel
- The size of the export with UpSlide is much closer to the size in Excel than the native copy size
- The Height/Width ratios are not the same:
- In Excel: 13.41 / 11.85 = 1,1316...
- Native copy: 14.06 / 12.42 = 1,1320...
- UpSlide export: 13.4 / 11.83 = 1,1327...
In UpSlide, we do our best to correct the size difference introduced by copying and pasting an element from Excel to PowerPoint. However, the difference in technologies used for rendering by Excel and PowerPoint also introduces a small difference in ratio. We chose not to fix this ratio, so the image won't look stretched or flattened.
Fix:
Unfortunately, there is no definitive fix for this issue. These issues are related to the way Excel/Powerpoint/Word handle exports between applications.
Still, we recommend you to:
- Keep your zoom level/DPI scaling to 100%. It won't fix the problem, but it will avoid additional issues
- Use the 'as shown on screen' mode if you REALLY need to minimize disparities between applications. For the vast majority of our users, we recommend using 'as shown when printed', to keep your work consistent in your team (see here to know more)