Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - Launch Pad - Problem Copying and Pasting from BO exported Excel spreadsheet to another spreadsheet - Formatting distorted

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.

When exporting a Excel spreadsheet from Business Objects using the 'Save ... to my computer', 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 in the new spreadsheet's theme and usually becomes distorted or difficult to read.

To avoid this, use 'Paste Special' instead of 'Paste'. Then, depending on the prompt that comes up (and the version of Excel) you can either select:

  • Values - pasting only the cell values discarding all formatting
  • All using source theme - This pastes the data along with the formatting (fill colors, fonts, etc...), but not 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 10:41 CSTUpdated:2016-08-02 10:43 CST
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0