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.




Keywords:BO, IRF, AURA, SDW, GEMS, Financial, Payroll, Report, Export, GEMS   Doc ID:33535
Owner:James I.Group:University of Chicago
Created:2013-09-18 11:41 CDTUpdated:2017-03-06 14:19 CDT
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0