RPAS Classic Client: Why Is Export Feature Using Space Separator in the Export File? (Doc ID 2251067.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Retail Predictive Application Server - Version 15.0.1 and later
Information in this document applies to any platform.

Goal

In Classic Client, why does the Export sheet utility under File Tab, export values with spaces (e.g. 123456 78) if the format used in the worksheet uses space as a separator?

When enabling 'Use separator' in Format Options under Types Tab, measures are shown with spaces separating thousands from hundreds for e.g. 123 456,78. When using the Export sheet utility under File Tab, the values are exported with these spaces (e.g. 123 456,78) retained, but the spaces are not recognized as numbers in Excel.

Steps to reproduce:
1. Create a workbook.
2. Select a measure.
3. Right click and choose Format > Measure.
4. Under Types Tab, enable 'Use separator'.
5. Under File Tab, select 'Export sheet'.
6. Values are exported to the xls file with space between hundreds and thousands such as 123 456,78 rather than the expected 123456,78 format.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms