Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems
Business Objects - Launch Pad - Distorted Formatting When Copying and Pasting from Business Objects-exported Excel Spreadsheet to Another Spreadsheet
This article explains how to avoid the distorted formatting changed when pasting from an Excel spreadsheet created by Business Objects and copying to another spreadsheet.
This article explains how to avoid the distorted formatting when copying and pasting from an Excel spreadsheet created by Business Objects to another spreadsheet.
When exporting an Excel spreadsheet from Business Objects using the Save ... to my computer method, a spreadsheet is created with a custom theme for the colors used in the report. When the data is copied to another spreadsheet (with the default or a different theme) the color formatting is translated into the new spreadsheet's theme and usually becomes distorted or difficult to read.
To avoid this, use Paste Special instead of Paste. Depending on the subsequent prompt and your Excel version, you can either select:
Values: paste only the cell values and discard all formatting
All using source theme: paste the data along with the formatting (fill colors, fonts, etc...), but discard the column widths
HTML - as above
Since none of the above options set the column widths, consider doing a second Paste Special > Column widths to add that formatting if needed.