My Oracle Support Banner

Colour And Number Formatting Is Lost When Exporting The Plan Output Table View To Excel (Doc ID 2543017.1)

Last updated on DECEMBER 13, 2019

Applies to:

Oracle Sales and Operations Planning Cloud Service - Version 11.13.18.05.0 and later
Oracle Supply Planning Cloud Service - Version 11.13.18.05.0 and later
Oracle Demand Management Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Goal

When we export the configured table to excel, in case any color formatting is there to highlight exceptions or change value, no color is visible in excel. This is required in case excel is shared to various stakeholders for review.

Also the number like 455,555,000 gets exported in format of 455555000 . Expectation is to have format as 455,555,000

Since item units can vary from 1 to 100million and financial values are in yen which may extend long.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.